Joomla 1.0.x to 1.5 migrator

ljd · **Joined:** Fri Jan 26, 2007 1:13 pm **Posts:** 12

Error at the line 1: INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '1','Polls','','1','right','0','0000-00-00 00:00:00','0','mod_poll','0','1','1','','0','0');

Query: INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '1','Polls','','1','right','0','0000-00-00 00:00:00','0','mod_poll','0','1','1','','0','0');

MySQL: Duplicate entry '1' for key 1

Stopped on error

RC2 migrator

crippe73 · **Posted:** Mon Aug 27, 2007 10:27 am

Thanks grantmasterflash! That did it for me. I commented out the "breadcrumb" INSERT INTO, created a new install, with a clean DB, and presto! there it was - the migration succeeded.

Now I only have to get my 1.0-template and some 3rd party components to work.

pasamio · **Posted:** Mon Aug 27, 2007 11:01 am

Gianmarco Odorizzi wrote:

Thank you Sam.
A question: must the new joomla 1.5 installation be in the same DB of the 1.0?

Thank you

The Joomla! 1.5 installation doesn't have any restrictions (except for the noted migration prefix rewrite). You can put it in any database, even on a different server with a prefix like pasamioisawesome_ if you so desire. The system is designed to take the new settings with the settings from the migration and handle things from there.

lukewill · **Posted:** Mon Aug 27, 2007 11:55 am

Code:

Error at the line 15072: INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`) VALUES ( '1','mainmenu','HOME','index.php?option=com_frontpage','components','1','0','10','0','1','0','0000-00-00 00:00:00','0','0','0','3','menu_image=-1\npageclass_sfx=\npage_title=Welcome to the Frontpage\nshow_page_title=0\nback_button=0\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=1\nnum_links=4\norderby_pri=\norderby_sec=front\nshow_pagination=0\nshow_pagination_results=0\nimage=1\nshow_section=0\nsection_num_links=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=0\nshow_pdf_icon=0\nshow_print_icon=0\nshow_email_icon=0\nunpublished=0\nshow_title=1\n');

Query: INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`) VALUES ( '1','mainmenu','HOME','index.php?option=com_frontpage','components','1','0','10','0','1','0','0000-00-00 00:00:00','0','0','0','3','menu_image=-1\npageclass_sfx=\npage_title=Welcome to the Frontpage\nshow_page_title=0\nback_button=0\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=1\nnum_links=4\norderby_pri=\norderby_sec=front\nshow_pagination=0\nshow_pagination_results=0\nimage=1\nshow_section=0\nsection_num_links=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=0\nshow_pdf_icon=0\nshow_print_icon=0\nshow_email_icon=0\nunpublished=0\nshow_title=1\n');

MySQL: Duplicate entry '1' for key 1

Stopped on error

used the rev 8579 and rc2 migrator

johngrey2002 · **Joined:** Tue Feb 13, 2007 3:02 pm **Posts:** 6

Trying to upgrade my Joomla 1.0 site to 1.5 with no success. Using migrator_rc2 package ...

When running script prepared by migrator component using Joomla 1.5 installation facility - getting "Duplicate entry '1' for key 1" message.

Was able to bypass problems with "Duplicate entry '1' for key 1" by removing/commenting INSERT INTO statements for tables which shouldn't be pre-populated (on my look) from joomla.sql
Ran that script then to create "skeleton" using phpMyAdmin. Then ran script created by migrator component in the same way. Finally, got "something" as I have changed my template previously. That "something" displays menu items for mainmenu and topmenu, there are no frontpage items at all, and 4 messages on the top:
Warning: array_push() [function.array-push]: First argument should be an array in /www/joomla15_test/libraries/joomla/application/menu.php on line 296

after these four - another one saying:
Warning: Invalid argument supplied for foreach() in /www/joomla15_test/libraries/joomla/environment/request.php on line 383

Also, when trying to click on menu items, the same array_push messages appear and then :

404 - Page could not be found

You may not be able to visit this page because of:

1. an out-of-date bookmark/favourite
2. a search engine that has an out-of-date listing for this site
3. a mis-typed address
4. you have no access to this page
5. The requested resource was not found

Please try one of the following pages:

* Home Page

Component Not Found

I understand, that it might not be useful as I've tryied to hack it somehow. But I'm ready to send my data to you, Pasamio, and other guys who work on migrator component (just let me know where to send)

Everybody want a nice way of migration, so I feel I can help only by supplying you, guys, with my data. If you need more, just let the community know as this component is really really needed and highly awaited.

johngrey2002 · **Joined:** Tue Feb 13, 2007 3:02 pm **Posts:** 6

was able to complete migration after downloading the latest joomla code from SVN ! Thanks God

So, I've got working admin back-end but still getting bunch(5 to be exact) of the following warnings inside Menu Manager on back-end:

Warning: array_push() [function.array-push]: First argument should be an array in /www/JoomlaFromSVN/libraries/joomla/application/menu.php on line 292

And frontend dies after waiting for 30 sec with the same bunch of warnings.

Digged into the code and something goes wrong there, should I say, guys.
there is an endless while loop in modules/mod_mainmenu/helper.php modMainMenuHelper class, buildXml method

I'm not familiar with the new joomla code to find out why, but this array_push warnings certainly appear because of the same reason.
Can joomla developers advise? Not sure, whether it's migrator problem, but obviously there shouldn't be that endless while loop in joomla itself.

archangel519 · **Joined:** Fri Jan 06, 2006 10:47 pm **Posts:** 49

I have the array_push error as well. Haven't figured it out either. Please post a fix if you find one...

johngrey2002 · **Joined:** Tue Feb 13, 2007 3:02 pm **Posts:** 6

archangel519 wrote:

I have the array_push error as well. Haven't figured it out either. Please post a fix if you find one...

1 st of all:
I've changed line 46 of modules/mod_mainmenu/helper.php from

while ( !is_null($row = array_shift($rows)))

to
foreach ($rows as $row) {

to get rid of endless loop.So, I can see menus now.

and to suppress warnings (as it is normal behaviour of array_push function) I just put the following string into .htaccess file:

php_flag display_errors off

So, site with migrated content is up and running but image links still need to be changed manually.
I'm wondering, can migrator component and/or joomla installer do that automatically for us?
If not, is it planned to do that at all?

Thanks

bootcamp · **Posted:** Thu Aug 30, 2007 7:02 pm

Hi I seem to be getting the same migration error that most people are getting. I am migrating the content from a 1.12 site, using one of the default templates and no real 3rd party plugins/modules, so it should be quite basic. When I run the migration it comes back with the following error:

Code:

Error at the line 269: INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`) VALUES ( '1','mainmenu','Home','index.php?option=com_frontpage','components','1','0','10','0','1','0','0000-00-00 00:00:00','0','0','0','3','num_leading_articles=1\r\nnum_intro_articles=2\r\nnum_links=1\r\nimage=1\r\nshow_page_title=0\r\npage_title=Welcome to the Frontpage\r\norderby_sec=front\r\nshow_print_icon=0\r\nshow_pdf_icon=0\r\nshow_email_icon=0\r\nback_button=0\nshow_title=1\n');

Code:

Query: INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`) VALUES ( '1','mainmenu','Home','index.php?option=com_frontpage','components','1','0','10','0','1','0','0000-00-00 00:00:00','0','0','0','3','num_leading_articles=1\r\nnum_intro_articles=2\r\nnum_links=1\r\nimage=1\r\nshow_page_title=0\r\npage_title=Welcome to the Frontpage\r\norderby_sec=front\r\nshow_print_icon=0\r\nshow_pdf_icon=0\r\nshow_email_icon=0\r\nback_button=0\nshow_title=1\n');
MySQL: Duplicate entry '1' for key 1
Stopped on error

It then returns me to the previous page. On looking at the database with phpMyadmin, it appears that most of the content has populated the database, just obviously the menus are not transfering across and it is not creating the config file.

Has anyone figured a way round this problem yet.

Thanks for you help

johngrey2002 · **Joined:** Tue Feb 13, 2007 3:02 pm **Posts:** 6

bootcamp:

take the latest Joomla code from SVN and you'll be successfully migrated, I think.
You also will need to change format of your 1.0.x template if you plan to use it but that's pretty easy to do.

bootcamp · **Posted:** Fri Aug 31, 2007 2:08 pm

Hi John,

Thanks for the advise. Reinstalled completely using the nightly build (30/8/07) and am still getting exactly the same error and loop.

Am not worried about the template as I am going to use a new one once I have all the content migrated.

Thanks again for the suggestion

jahiblack · **Posted:** Sat Sep 01, 2007 2:47 am

Hello All ....

I seem to be getting errors like everyone else ...

I am migrating from 1.13 to 1.5 RC ...

I get this error:

Warning: file_put_contents() failed to open stream: Permission denied in /home/chaotic/public_html/alkhemikal-chaos/omavi/libraries/joomla/utilities/compat/php50x.php on line 66

and these

Error at the line 381: INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`) VALUES ( '1','mainmenu','Home','index.php?option=com_frontpage','components','-2','0','10','0','10','0','0000-00-00 00:00:00','0','0','0','3','num_leading_articles=1\r\nnum_intro_articles=2\r\nnum_links=1\r\nimage=1\r\nshow_page_title=0\r\npage_title=Welcome to the Frontpage\r\norderby_sec=front\r\nshow_print_icon=0\r\nshow_pdf_icon=0\r\nshow_email_icon=0\r\nback_button=0\nshow_title=1\n');

Query: INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`) VALUES ( '1','mainmenu','Home','index.php?option=com_frontpage','components','-2','0','10','0','10','0','0000-00-00 00:00:00','0','0','0','3','num_leading_articles=1\r\nnum_intro_articles=2\r\nnum_links=1\r\nimage=1\r\nshow_page_title=0\r\npage_title=Welcome to the Frontpage\r\norderby_sec=front\r\nshow_print_icon=0\r\nshow_pdf_icon=0\r\nshow_email_icon=0\r\nback_button=0\nshow_title=1\n');

MySQL: Duplicate entry '1' for key 1

Stopped on error

--------

I can still continue the install but none of my menus or sections migrated to the new site ... the articles all migrated .... this is the same problem i had with migrating to 1.5 RC1 and I have attempted the migration with three different sites ....

any help would be greatly appreciated

jahiblack · **Posted:** Sat Sep 01, 2007 3:05 am

also ....

none of my old modules came over .... none of my users ..

i am doing something wrong here .... i have a large site and I would really like not to have to rebuild it from scratch again

just a note ... i am really not a php programmer .. so i dabble a little but not enough to even hang with the big boys ...

Should I wait until a more comprehensive version of the migrator comes out?

stampie · **Posted:** Sun Sep 02, 2007 12:46 pm

When I used the migrator, I had the same error message two times:
- first, when I did not check the checkbox which marked the migrator script a 1.0 migration script
- second, when I repeated the migration without clearing the tables (by going back to the database settings step, checking the deletion of the old tables).

I'm not sure you have tried those things, but maybe it's worth a try.

jahiblack · **Posted:** Sun Sep 02, 2007 6:34 pm

stampie wrote:

When I used the migrator, I had the same error message two times:
- first, when I did not check the checkbox which marked the migrator script a 1.0 migration script
- second, when I repeated the migration without clearing the tables (by going back to the database settings step, checking the deletion of the old tables).

I'm not sure you have tried those things, but maybe it's worth a try.

Yea I tried both .... just can't seem to get away from those errors .. lol

bootcamp · **Posted:** Mon Sep 03, 2007 11:54 am

Have tried it again with the RC2 release, making sure to start with a clean empty database and ticking both the boxes.

Still getting the migration error

avagodro · **Joined:** Sat Oct 28, 2006 4:17 am **Posts:** 15

I keep receiving the below error when attempting to migrate. My old site is 1.0.13, migrating to 1.5RC2, using migrator RC2. I have tried several times and receive the same issue:

Quote:

Error at the line 334: INSERT INTO jos_users (`id`,`name`,`username`,`email`,`password`,`usertype`,`block`,`sendEmail`,`gid`,`registerDate`,`lastvisitDate`,`activation`,`params`,`enable_blog`,`enable_frontpage`,`profile_detail`,`blogmail_enable`,`blogmail_count`,`blogmail_blog_published`,`blogmail_blog_section`,`blogmail_blog_category`,`blogmail_account`,`blogmail_password`,`blogmail_server`,`blogmail_protocol`,`blogmail_ssl`,`blogmail_folder`) VALUES ( '62','Administrator','webmaster','me@test.org','283a1abb4eb5ad6615b10272ed153d07:Sw3Y4afYDxTdtdfv','Super Administrator','0','1','25','2006-10-27 11:43:04','2007-09-03 14:08:00','','editor=\nexpired=\nexpired_time=','1','0','','1','10','0','0','0','name@site.com','','site.com','110/pop3','none','images/stories');

Query: INSERT INTO jos_users (`id`,`name`,`username`,`email`,`password`,`usertype`,`block`,`sendEmail`,`gid`,`registerDate`,`lastvisitDate`,`activation`,`params`,`enable_blog`,`enable_frontpage`,`profile_detail`,`blogmail_enable`,`blogmail_count`,`blogmail_blog_published`,`blogmail_blog_section`,`blogmail_blog_category`,`blogmail_account`,`blogmail_password`,`blogmail_server`,`blogmail_protocol`,`blogmail_ssl`,`blogmail_folder`) VALUES ( '62','Administrator','webmaster','me@test.org','283a1abb4eb5ad6615b10272ed153d07:Sw3Y4afYDxTdtdfv','Super Administrator','0','1','25','2006-10-27 11:43:04','2007-09-03 14:08:00','','editor=\nexpired=\nexpired_time=','1','0','','1','10','0','0','0','name@site.com','','site.com','110/pop3','none','images/stories');

MySQL: Unknown column 'enable_blog' in 'field list'

Stopped on error

Any suggestions? (Username and site address were modified in the posted error for privacy)

trustman · **Joined:** Mon Jan 22, 2007 7:46 pm **Posts:** 1

500 error. I received the follow 50 error after run the migrator script:

•An error has occurred while processing your request.•

•Please try one of the following pages:•

* •Home Page•

•If difficulties persist, please contact the System Administrator of this site.•

????View not found [name, type, prefix]:?? content,html,contentView??

Call stack
# Function Location
1 jsite->dispatch() /home/beautifu/public_html/boceans/index.php:75
2 jcomponenthelper::rendercomponent() /home/beautifu/public_html/boceans/includes/application.php:121
3 require_once() /home/beautifu/public_html/boceans/libraries/joomla/application/component/helper.php:167
4 contentcontroller->execute() /home/beautifu/public_html/boceans/components/com_content/content.php:35
5 contentcontroller->display() /home/beautifu/public_html/boceans/libraries/joomla/application/component/controller.php:240
6 jcontroller::display() /home/beautifu/public_html/boceans/components/com_content/controller.php:42
7 contentcontroller->getview() /home/beautifu/public_html/boceans/libraries/joomla/application/component/controller.php:297
8 jerror::raiseerror() /home/beautifu/public_html/boceans/libraries/joomla/application/component/controller.php:467
9 jerror::raise() /home/beautifu/public_html/boceans/libraries/joomla/utilities/error.php:166
10 jexception->jobject() /home/beautifu/public_html/boceans/libraries/joomla/utilities/error.php:131
11 call_user_func_array() /home/beautifu/public_html/boceans/libraries/joomla/base/object.php:49
12 jexception->__construct()

Do you know where is the problem? Thanks

jahiblack · **Posted:** Tue Sep 04, 2007 12:04 am

bootcamp wrote:

Have tried it again with the RC2 release, making sure to start with a clean empty database and ticking both the boxes.

Still getting the migration error

Bootcamp,

I have tried that also ....

timothy.stiffler · **Posted:** Fri Sep 07, 2007 5:01 am

Just had a perfect migration! Thanks for this component! I just wrote up a rough step-by-step here if anyone needs it, or if you want me to rewrite it to put it in the Joomla! FAQ I can do that, too!

http://forum.joomla.org/index.php/topic ... #msg982575

jahiblack · **Posted:** Sat Sep 08, 2007 1:25 am

Can anyone please tell me why i am getting this error:

Warning: file_put_contents() failed to open stream: Permission denied in /home/chaotic/public_html/alkhemikal-chaos/omavi/libraries/joomla/utilities/compat/php50x.php on line 66

.....

This has been the only constant in my migration tries. It shows up at the top of the page right below the banner. I have tried the double install method ... i have even manually gone in and dropped all the tables from my database.

Is there any component/module/mambot that would affect the migration? I was looking at my present database and there is one table that has a mos_ prefix, would that affect the migration?

giapet · **Joined:** Thu Feb 23, 2006 9:12 pm **Posts:** 15

I, too, am having problems using the migrator.

Quote:

Error

SQL query:

DROP TABLE IF EXISTS #__migration_packages;
CREATE TABLE #__migration_packages (
'id'INT( 11 ) NOT NULL AUTO_INCREMENT ,
'name'VARCHAR( 100 ) NOT NULL ,
'url'TEXT NOT NULL ,
PRIMARY KEY ( 'id' )
);

MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE 'id' INT(11) NOT NULL AUTO_INCREMENT,
'name' VARCHAR(100) NOT NU' at line 1

I honestly don't know the first thing about SQL syntax. I appear to be using MySQL 5.0.16. Anyone have any ideas?

giapet · **Joined:** Thu Feb 23, 2006 9:12 pm **Posts:** 15

...Ignore this. Where the heck is the delete button? :'(

stampie · **Posted:** Sun Sep 09, 2007 9:53 am

jahiblack wrote:

Can anyone please tell me why i am getting this error:

Warning: file_put_contents() failed to open stream: Permission denied in /home/chaotic/public_html/alkhemikal-chaos/omavi/libraries/joomla/utilities/compat/php50x.php on line 66

.....

This has been the only constant in my migration tries. It shows up at the top of the page right below the banner. I have tried the double install method ... i have even manually gone in and dropped all the tables from my database.

Is there any component/module/mambot that would affect the migration? I was looking at my present database and there is one table that has a mos_ prefix, would that affect the migration?

Is the installation/sql/migrate folder writable by the php script? If not, try with a chmod 777 on it. (Yes, it's quite odd that the installer does not warn about the unwritable directories at all).

jahiblack · **Posted:** Sun Sep 09, 2007 6:07 pm

stampie wrote:

Is the installation/sql/migrate folder writable by the php script? If not, try with a chmod 777 on it. (Yes, it's quite odd that the installer does not warn about the unwritable directories at all).

You know .. I dont know why I didnt think of that .. lol ... Thanks

And with that I can say I have a flawless migration

giapet · **Joined:** Thu Feb 23, 2006 9:12 pm **Posts:** 15

Okay, I've managed to get past the OLD problem and on to a NEW one.

I'm using the install script, and I have the migrate.sql file uploaded in the proper place and everything.

The only problem is that it's 26mb.

I had to install a custom version of PHP so that I could increase the memory limit and whatnot:

Quote:

max_execution_time = 99999 ; Maximum execution time of each script, in seconds
max_input_time = 99999 ; Maximum amount of time each script may spend parsing request data
memory_limit = 90M ; Maximum amount of memory a script may consume (8MB)

And so now I'm getting this error:

Quote:

Fatal error: Out of memory (allocated 57933824) (tried to allocate 27167291 bytes) in /home/.tora/giapetf/yaoisuki.net/installation/installer/helper.php on line 874

My poor tech support guy says he's really not sure what to do at this point and that I should pop back in over here, soo...any ideas?

jaysunp · **Joined:** Sat Sep 16, 2006 1:59 am **Posts:** 48

jahiblack wrote:

Error at the line 381: INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`) VALUES ( '1','mainmenu','Home','index.php?option=com_frontpage','components','-2','0','10','0','10','0','0000-00-00 00:00:00','0','0','0','3','num_leading_articles=1\r\nnum_intro_articles=2\r\nnum_links=1\r\nimage=1\r\nshow_page_title=0\r\npage_title=Welcome to the Frontpage\r\norderby_sec=front\r\nshow_print_icon=0\r\nshow_pdf_icon=0\r\nshow_email_icon=0\r\nback_button=0\nshow_title=1\n');

Query: INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`) VALUES ( '1','mainmenu','Home','index.php?option=com_frontpage','components','-2','0','10','0','10','0','0000-00-00 00:00:00','0','0','0','3','num_leading_articles=1\r\nnum_intro_articles=2\r\nnum_links=1\r\nimage=1\r\nshow_page_title=0\r\npage_title=Welcome to the Frontpage\r\norderby_sec=front\r\nshow_print_icon=0\r\nshow_pdf_icon=0\r\nshow_email_icon=0\r\nback_button=0\nshow_title=1\n');

MySQL: Duplicate entry '1' for key 1

Stopped on error

--------

I can still continue the install but none of my menus or sections migrated to the new site ... the articles all migrated .... this is the same problem i had with migrating to 1.5 RC1 and I have attempted the migration with three different sites ....

any help would be greatly appreciated

I was getting this same error migrating from 1.0.13 - 1.5. Then I changed my rather complex RT template to a very simple one (simple menu functions) on my Joomla 1.0.13 site, generated a new migration sql script, and the migration went off without a hitch.

Had to rebuild my config file from scrath as it failed to generate. Now, however, I can continue to upgrade my site.

Hope this is helpful to someone.

jaysunp

AmyStephen · **Posted:** Fri Sep 14, 2007 5:20 pm

I want to copy this well described situation from drhansenjr to this thread in case others are getting a "blank screen" after the migration, as well, the previous poster is also indicating issues with mainmenu, a common theme with this situation, too.

Problem reported in Install Worked, Admin Page Somewhat Works, Front Page Blank

drhansenjr wrote:

I am having a similar problem with a twist. When I did a clean install, all was well.

Then I used the migration tool to pull over the db from an existing site. Admin works swell and all the migrated data appears to be there, but the front-end just yields a blank page.

I am running PHP 5.2.0; Apache/1.3.27 (Unix) (Red-Hat/Linux); MySQL 5.0.27.

The site is at http://stals.anacystech.com

Ideas anyone?

Description of the migration steps:

drhansenjr wrote:

What I did was:

1) Clean install; no migrated data - FE and BE both fine
2) Blew away the above install and db
3) Installed and ran the migration component on the old site to get the migrate.sql file
4) Untarred a fresh copy of J 1.5 and laced migrate.sql in the required location in the tree.
5) Ran the install script and subsequent migration steps

No errors whatsoever during this process.

Today, a report on how the exact problem was identified and resolved (love this guy's articulate detective abilities!):

drhansenjr wrote:

What was puzzling me was why a clean install works, but a site with a migrated database does not. I started to wonder why should I should worry about having "old" Apache 1.3.x when it allows a virgin site to come up. Since the only difference between the install that worked and the one that didn't was the migrated data and the loading of the migrate.sql script during installation. Ergo, one or both of those factors had to be at fault.

I disabled or unpublished things en masse or one at a time. I eventually found that when I disabled the main menu module, the site came up, but displayed an "Error Loading Modules" message.

Another thing I noticed was that it took 43 seconds for the blank page to load, vs. 3 seconds with the mainmenu module disabled.

Since disabling mainmenu allowed the site to come up, I went there and unpublished everything: no more blank page! I then went through the list publishing things one at a time, figuring that one of the menu items must have been causing the problem. However even after running through the entire list and publishing everything, the blank page problem did not recur.

I had a hunch that the migration process, when it created menu records, left them in some state that caused the blank page issue, then unpublishing followed by publishing updated something in the record that Joomla! is looking for but that did not come over in the migration. However, I opened jos_menu in phpMyAdmin and did not see any differences between mainmenu items and those in other menus, other than that the alias column was populated. I nulled these out through SQL, but the problem did not come back, so that minor difference does not appear to have been the culprit.

I'm posting this not so much as a request for "the answer" as to provide a few clues that might lead to a resolution.

Hope that is helpful to someone,
Amy

johnsingleton · **Joined:** Sun May 06, 2007 5:02 pm **Posts:** 16

Hi

I have migrated via Mambo to Joomla 1.0 and then to Joomla 1.5RC2. I have tried the suggestions in the threads and have a site that works except for many of these lines both in the front end (see http://www.eduwebsites.co.uk/Joomla-1.5RC2/) and within each of the components, menus, polls, banner, etc in the admin area.

Warning: array_push() [function.array-push]: First argument should be an array in /home/eduwebsi/public_html/Joomla-1.5RC2/libraries/joomla/application/menu.php on line 292

Any help would be appreciated.

John

Caitlain · **Joined:** Fri Oct 27, 2006 8:08 pm **Posts:** 9

Quote:

Error at the line 247: INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`) VALUES ( '1','mainmenu','Home','index.php?option=com_frontpage','components','1','0','10','0','1','0','0000-00-00 00:00:00','0','0','0','3','menu_image=-1\npageclass_sfx=\npage_title=Welcome to Common\'s Ending\nshow_page_title=0\nback_button=0\nnum_leading_articles=1\nnum_intro_articles=2\nnum_columns=2\nnum_links=1\norderby_pri=\norderby_sec=front\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_section=0\nsection_num_links=0\nshow_category=0\ncategory_num_links=1\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=0\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=0\nshow_print_icon=0\nshow_email_icon=0\nunpublished=0\nshow_title=1\n');

Query: INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`) VALUES ( '1','mainmenu','Home','index.php?option=com_frontpage','components','1','0','10','0','1','0','0000-00-00 00:00:00','0','0','0','3','menu_image=-1\npageclass_sfx=\npage_title=Welcome to Common\'s Ending\nshow_page_title=0\nback_button=0\nnum_leading_articles=1\nnum_intro_articles=2\nnum_columns=2\nnum_links=1\norderby_pri=\norderby_sec=front\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_section=0\nsection_num_links=0\nshow_category=0\ncategory_num_links=1\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=0\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=0\nshow_print_icon=0\nshow_email_icon=0\nunpublished=0\nshow_title=1\n');

MySQL: Duplicate entry '1' for key 1

Stopped on error

Any ideas on this? I am migrating from the .13 to the RC2 version, and have followed the directions through the process as outlined, and can't get around this. Thanks.

Joomla! Discussion Forums

Forum rules

Joomla 1.0.x to 1.5 migrator

Quick reply

Who is online