6.16 to RC3 Data Migration Errors

I've attempted to upgrade from my existing 6.16 installation to the 7RC3 per the instructions.  Cron job set up properly.  Data Migration Config set up properly.  Info inported from header.inc.php file in 6.16 installation looks good (selects proper database as shown in the 7 bx_migration_config table).

When I begin profiles data migration, it begins processing.  Then I get Cron Error Reports which show that the migration tools are looking for tables in my 6.16 database which only exist in the 7 Database.  Errors such as "Database Query Error in BxTempEmailblahblahblah.php , table 616_sys_localization_languages table does not exist".

This goes on for each table it is looking for and cannot find.

I'm sure this is a minor configuration error SOMEWHERE, but for the life of me, I cannot seem to locate it.

What I find in my database Profiles table for my 6.16 version once this process begins is that all of the profile ID's have been overwritten with new ID's starting with the last ID number in the table previously.  So where I DID have IDs starting at 1 and ending at 4974, NOW I end up with IDs starting at 4975 and up.

This leads me to believe that the migration tool is attempting to both pull records from the old database AND to write the information back to the old database.

I would have to agree bigal, definitely a config problem. Just a few simple questions though:

- Is your 6.1.6 and D7 site and databases on the same server?

- Im assuming you use 2 different databases :)

So let take a moment here to see where this may be going wrong using some examples with versions 6.1.6 in the root and D7 in a subfolder called dolphin (for example purposes). Also we are going to say that your root paths is /home/mysite/public_html/

Ok, so D7 is installed, modules needed installed,  and cron job setup properly. (you can test video uploads to verify the cron)

Now, you go into the migration module. The FIRST thing you have to do is set the OLD dolphin path. So using the example above you would need to type in /home/mysite/public_html/  (trailing / must be there) and click Submit.

Click the tab next to it that says Data Migrations as choose Profiles, then click move data. Repeat for each piece you want to move.

With your errors you posted something is definitely wrong with the old path configurations by looking at the following:

616_sys_localization_languages  <-- Not a table in 6.1.6 (nothing starts with sys_ or bx_ in version 6.1.6)

If you still run into problems after verifying this, let me know.

Chris

Yes, everything set up as indicated.

6.16 version resides in /home/mysite/public_html/

7RC3 resides in /home/mysite/public_html/7/

Database for 6.16 is separate from database for 7

All modules installed correctly.

Cron job working and set up according to information provided during the installation process.  Checked to make sure it is running from the /home/mysite/public_html/7/periodic/cron.php file in the new 7RC3 folder.  (we know it's working as it is generating the error reports during the data migration)

In the data migration config table in the 7 database, all looks correct.  It's selected the proper database, the paths all refer to the original 6.16 locations.

I can be sure that for whatever reason the migration tool is attempting to pull from the 6.16 database as if I insert the missing tables it's asking for from the 7 database it will update all of my profiles and overwrite the ID's for them.

Hello can you contact with me and provide me with you ftp and mysql data access I will check everything

Sashae, I've replied with the info you requested, and I really appreciate you offering to check this out for me.  I've been scratching my head for several days now....

Thanks!

Man this is pissin me off.  I've upgraded to the 7.0 Final and still getting this same issue.  nOTHING I've changed seems to help.  Any more ideas???

I just noticed this thread.

I had the same exact problem when i tried migrating my 6.1.6.site. Well not exactly. My d6.1.6 database was not being over written, but i was getting the same cron errors about missing tables and it was looking in my 6.1.6 database for tables that clearly were d7 tables.

I ended up moving my sites onto a clean CentOS test server i setup at home and the migration went perfectly on my own server.

This leads me to believe there has to be something with the way the host has the server setup.

I am sorry, but i never bothered to see if i could track down the exact reason.

So Bigal, did you manage to migrate any profiles using the module? I have mine tried so many times with all correct settings, but still 'in process' status never changes. Anything you suggest I will attempt as all my members are still in my old db. Like you sd tho, I have tables in D6 that don't exist in D7, and vice versa.

thx

zak

-------------------------------

Ok, finally after correcting the cron, and leaving the migration overnight, it completed. However, even tho it migrated the profile info. it missed the actual pictures. Still working to figure out this issue....