data migration RC1

OK

   I worked with the data migration today....all going well, exept these problems :

Blogs are transfered, but not images

Same things for Groups

ACL_membership are OK

Profiles are corretly transfered, avatar too, the custom fields it's OK, BUT they are not transfered from table profile_fileds (old DB) to sys_profile_fields (new DB) then the new profile dont relect on the profile page...

Error in Video transfer got : PHP Fatal error:  Call to undefined function getConverterTmpl() in /httpdocs/v2/modules/boonex/data_migration/classes/BxDataMigrationVideos.php on line 221 i had to put the function inside the class

prevalue table are not transfred too...

that's all for now....

popy

Whats the trick to getting the Profiles to migrate??? 

 No trick, just install and start migration...

popy

hello,

here are many users which have problems to get it work.

we installed, setup cron and put in the path  to old version.

but nothing happens, all the time queued is shown but no profiles transfered.

could you please post more infos how you get it work...

 did you get email about cron with error..???

how did you setup your crontab..?\

did you install RC1 under same server like http://wwwmyoldserver.com/v2 (or any rep)

user who run cron, does it have right for running cron..?

popy

HI Popy ..I have the same issues as he does ..everything done as indicated above ....and me email ..has the following error ...

[13-Nov-2009 18:40:02] PHP Warning:  mysql_connect(): Access denied for user 'icheari'@'localhost' (using password: NO) in /home/izsocial/public_html/sdol/modules/boonex/data_migration/classes/BxDataMigrationDb.php on line 212
[13-Nov-2009 18:40:02] PHP Warning:  mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/izsocial/public_html/sdol/modules/boonex/data_migration/classes/BxDataMigrationDb.php on line 213

Any Ideas..?? Thanks ..

the rc1 is setup in a other folder but on the same folder

path rc1:

d7rc1/

path 6.1:

website/

in the db of rc1 are also all settings to my old 6.1.6. correct in the table bx_data_migration_config

id 1 and 2 are empty for config_sock and config_port , and id 28 and 29 are again these two ????

in table bx_data_migration_transfers is status = not started

the cron is setup in our cpanel the same like the old cron from 6.1.6. which works.

 the path is website/d7rc1  ..???

the path from D7 RC1 is:

xxxxx/xxxxx/d7rc1/

the path from 6.1.6. is:

xxxxx/xxxxx/website/

both on the same server

 try xxxx/xxxxx/website/d7rc1/

popy

i had this before with beta8, was the same

which permissions must periodic and cron.php have in rc1 ?

there was nothing to set in the installation like in dolphin 6...

thx for help.

 no special permission, but for your info, i seet up the crontab as root user

is there any documentation on setting up the cron jobs? i cannot see this anywhere?!?

well, check at wikipedia, or make search on this site, it have donc anout it...

Regarding blogs photos: http://www.boonex.com/trac/dolphin/ticket/1475

Regarding groups photos: http://www.boonex.com/trac/dolphin/ticket/1476

Regarding custom fields: please try to recreate custom profile fields manually before transfering them, once script can find the same fields in old and new tables - all custom data is transfered

Seriously?  How were we supposed to know this?   Is there anything else we need to do to our new site to "prepare" for the transfer?

Actually, and though not immediately apparent, this does make sense. BoonEx should provide migration for default data, so if you add custom elements to your database, the migration script will not work. So, say you created the "Favorite Color" custom field on your 6.X site, you need to create such a field on your new database before running the script. At least this is how I understand it.

ok, now i found a error in my log files from cron job my host sent me

<b>Warning</b>:  mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'dbxxxx_5'@'localhost' (using password: YES) in <b>/xxxxx/xxxxxx7/xxxx/modules/boonex/data_migration/classes/BxDataMigrationDb.php</b> on line <b>212</b><br />

@localhost

my site isn´t runing with localhost

$db['host']                = 'mysql5.xxx.com';

so where can i change in data migration this localhost ?

Hello you will can set the field filter (all fields entered in array will not transfer!) . To configure this - open the 'modules/boonex/data_migration/classes/BxDataMigrationProfilesCustomFields.php'

and enter all your needed values into array :

$this -> aFiltered = array(
'PrimPhoto', 'Picture',
); 

You not right!
Script will automatically create all custom fields from old Db

Really? So, to confirm, no need to recreate custom fields on target before running migration script as AlexT suggests?

Yes is true! All fields will transfer in automatically mode

 All custom fiels as been tranfers in the profiles table, BUT not transfers from profilefields to sys_profiles_fileds, think it''s a good idea to transfers it, before trsnfering profiles...

Please don't get mad at me for asking this, but is there anyway this could at least partially work with 6.1.4?    Say I was jus mostly concerned with the profiles and the pictures.  If I entered the custom profile fields in the new D7 site could it possible work?   I really hate to break my perfectly good 6.1.4 site for a migration script that may or may not work.

Rob

 for your info, i tested the data migration in both, 6.1.4 and 6.1.6, and it working great  like i said in the 2 versions, the 2 version have the same bugs, but the working part doinh great in 2 version

popy

Popy,  you are saying you successfully transferred a 6.1.4 site, is that correct?  Did you make your custom profile fields first, or do anything else to prepare the new site?  Thanks for your help on this.

Rob

 Caltrade, YES, i didnt make custom fields, it transfered correctly from old profile table to new profile table correctly, BUT the script does not have the function to transfer the old profilefields table  to the sys_profilesfields table on new DB, think it's just that misssing, anyway i made a table backup and iimport manualy inside the new DB with phpmysqladmin ... and when i started the migration all doing great with 6.1.4 and 6.1.6

popy

 Yes SashaE, they are transfered inside the profile tables, but what about the sys_profiles_table, ..??? it's non-sense that they are not transfered there....

popy

I'm trying to use the data migration module and my cron report states this:

Warning: mysql_connect(): Access denied for user '***_***'@'localhost' (using password: NO) in /home/***/public_html/dolphin2/modules/boonex/data_migration/classes/BxDataMigrationDb.php on line 212

Can anyone advise how I can ensure the database username and password are correct when the module tries to connect to the old Dolphin database? Where can I do this to, I assume this is all the error refers to?

 it look like you didnt provide the path of you old dolphin

popy

 gecealem for your info i had to set the cron job on the root user to got it work...

popy

Ok, I upgraded my 6.1.4 site to 6.1.6, and upgraded my RC1 site to RC2.   Now when I try to migrate I get the message:

MODULE PROFILES ALREADY TRANSFERRED

However, at the bottom it says:

Profiles: in process

Is this thing working?  How can I tell?   I have about 250 members and it has been going for more than an hour.  How long should it take?   Any advice on this?

Rob

Ok.  I didn't like that "ALREADY TRANSFERRED" message, so I did a fresh install of RC2 and am trying again.  I have "broken" all the mods on my 6.1.4 site by upgrading it to 6.1.6 - so was really hoping this would work.   The "ALREADY TRANSFERRED" message is gone, and it has said "in process" for more than two hours now.  Is anything happening?   I looked at the profiles table in phpmyadmin and there is nothing there yet.  How long, approximately, should 500 records take?   I had really hoped to complete this migration over this Thanksgiving weekend (actually, I had hoped to complete this migration over Thankgiving weekend a year ago, but that is another story).   Could anyone give me any help or advice on this?  I would really appreciate it.

Rob

Rob, remove the data migration module and then reinstall it. That will reset the queue and allow you to run the migration again.

Chris

http://www.boonex.com/trac/dolphin/wiki/6.1.6to7.0

Thanks for the information Chris - that is obviously much easier than a reinstall - very helpful!

Thanks for posting that link Alex.  I read that before but didn't notice that note that it said if you have custom profile fields you have to create them is D7 first.  Why did they do it this way?  Doesn't everyone have custom profile fields?   This is not a trivial job.  Does anyone know if you have to create a complete set?  i.e.  do you have to create "view" and "edit" for "members", "admin" and "guests"?   Do you need the complete description and all the associated controls for each profile field, or is the name and data type sufficient?

Also, as I recall the migration module required that I move profiles first.  Will it let me move the profiles before that - or does it make any difference?  I figure it would need to have those fields in there before the profiles are moved - but I could be wrong.

I'm going to take another shot at this today.  If anyone has been down this road before and can give me any more pointers I would appreciate it.

Rob

ok, I am getting frustrated.  Trying to transfer an upgrade D6 site with about 300 members to a fresh install of RC2.  Uninstalled and reinstalled the data migration tool as Zarcon recommended, and defined all custom fields in the new site that are in the original site.  Nothing happens.  The dropdown data selection list says "profiles (Queued)" and the status message says "Profiles: in process" - but it has been that way for more than two hours.  There doesn't seem to be any new data in the profiles table or in bx_data_migration_transfers - which has zero records.  The bx_data_migration_config table however, seems to be set up properly. 

It doesn't make much sense to me, but I tried it with the chron pointing at the old site, but it didn't work that way either (the instructions just say the chron must be "properly configured" but doesn't say anything about pointing it at the old site).  The "profiler" module had caused problems with my join form, so I had it uninstalled.  I reinstalled it on the off chance that it was needed, but that didn't seem to change anything.

Are most other people getting through this without issues?  I can't really think of anything else to try.  Does anyone here have any ideas on how I might make this work?

Thanks

Rob

Hello, we started some changes into 'custom fields' module, wait some of days please !
http://www.boonex.com/unity/forums/topic/custom-profile-fields-bugs-or-not-.htm#topic/custom-profile-fields-bugs-or-not-.htm

I also could not get my D6 site to migrate.

I actually made copies of both my D6 and D7 site and put them on my home local test server. The migration worked fine on my own server, but not on my hosts.

Very weird, and i cannot explain why the server change made a difference. But that is what i ended up doing.

Are most other people getting through this without issues?  I can't really think of anything else to try.  Does anyone here have any ideas on how I might make this work?

Thanks

Rob

Its painful at first but I managed to have a succesful steps to do it :

1) upload the folder upgrade the comes with RC1 into your site 6.1.6

2) remove the upgrade/.htaccess

3) run the upgrade script http://<yoursite.com>/upgrade

4) logged in to SSH backup the folder public_html to public_html_bak

cp public_html public_html_bak -R

5) upload RC2 scripts into your site 6.1.6 using FTP to preserve folder permission

6) remove the upgrade/.htaccess

7) run the upgrade script http://<yoursite.com>/upgrade

8) then just follow the instruction at the bottom

9) setup dolphin 7RC2, install modules etc...

DolphinBugFixing

@Deno - thanks for the info.  When you are stuck like this, any information at all can be helpful.  For all I knew, this was working perfectly for almost everyone.

@DolphinBugFixing.  Wow - that is pretty creative.  I don't quite get it though - wouldn't you have to overwrite the files before you run the upgrade script?  Even if you don't, this procedure would essentially destroy your D6 site without much of a "fall back position".  Still, if it works, it works.  Thanks for coming up with this.

@SashaE - As you are the developer, I think I will follow your advice and wait a few days.  I appreciate the update.

Also, someone on another thread - Zarcon I think, said if there were any modifications at all to the profile fields it wouldn't work.  Is that true?  I have a few minor mods - the one that will turn one of the profile fields into a website hyperlink for example, and one for making Skype calls.  Will there be a workaround to making the migration module work if these are there?  I don't care about transferring that functionality, but getting the data over would be nice.

Thanks for the info everyone.

Rob

http://www.boonex.com/unity/forums/#topic/custom-profile-fields-bugs-or-not-.htm

Hi AlexT,

Is there anyway to get the files/patch for these 2 fixes or do we have to wait till RC3 is released???

Thanks

Mick

It is already fixed in RC2, please upgrade from RC to RC2

Alex,  I think Mick has RC2 installed and it doesn't work for him, as it doesn't work for me.  I also have RC2 installed and it doesn't work - that is what I was posting about.  SashaE said this would be fixed "in a few days" - I think Mick was asking if we would have to wait until the next RC to get it, or if it will be released as a special patch or update.

Yeah, it worked fine. I just went from RC to RC2 and never had any such issues...sorry for the mis-understanding, I thought this was happening when going from RC to RC2..

Thanks Again AlexT :)

Ok Mick - I read where you said RC3 and thought you already had RC2.  Lots of other people having issues though, so I hope Boonex doesn't read your "no problems" post and think everything is fine.  SashaE still said something about this being fixed "in a few days".