Migration error: getting NOT NULL

The Profiles went fine.

 

The Custom Fields gave me this email: 

ALTER TABLE `Profiles` ADD `firstName` varchar(255) NOT NULL

Mysql error: Duplicate column name 'firstName'

Found error in the file '/home/etalents/public_html/dolphnew/modules/boonex/data_migration/classes/BxDataMigrationProfilesCustomFields.php' at line 100.
Called 'query' function with erroneous argument #0.

 

Any ideas?

Thanks

Quote · 15 Apr 2010

its just telling you that the column firstname is already in the table profiles....  so you will have to remove it from one of the two tables it is in.  i would pick the one with the least amount of records for first name...

https://dolphin-techs.com - Skype: Dolphin Techs
Quote · 16 Apr 2010

its just telling you that the column firstname is already in the table profiles....  so you will have to remove it from one of the two tables it is in.  i would pick the one with the least amount of records for first name...

The two tables are the active site and the new site, both with 2700 members. What you're saying is that the Custom Fields migration is transferring the firstName? Do you think if I delete the firstName field in the new table it's just going to fail on the lastName, address, etc?

Thank

Quote · 16 Apr 2010
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.