|
Sitebuilder fails to import some sitestudio sites.
|
04-12-2010 02:55 PM
|
|
|
|
Sitebuilder fails to import some sitestudio sites.
Sitebuilder fails to import some sitestudio sites.
ssh -o StrictHostKeyChecking=no -x -a root@x.x.x.x /hsphere/shared/scripts/sb-config --exec_php utils/sitestudio/migration.php -- --userId=e98a214a-9161-930e-cce9-4650ee8d4a12 --siteId=89d6b60542a9bc74d0b4a6aaeace7229 < filesavedfromerrorlog
The file saved from errorlog will have all the data for the migration in it usually very large if you view the error in hsphere logs it will have the above command with the words STDIN (then all the data) All that data after stdin you can put into filesavedfromerrorlog so you can run the command. ofcourse using the command from your errorlog as the userID and siteID above are very important.
This will result in the following being output to the screen:
[2010-03-31T23:55:45-07:00 - #1] Migration started.
[2010-03-31T23:55:45-07:00 - #2] --> Migration of site for user with id e98a214a-9161-930e-cce9-4650ee8d4a12 has been started.
[2010-03-31T23:55:45-07:00 - #3] Host web3.host.com was found with id 3.
[2010-03-31T23:55:45-07:00 - #4] Host with id 3 was found in plan with id 2.
[2010-03-31T23:55:45-07:00 - #5] Site domain.com was found with site id 89d6b60542a9bc74d0b4a6aaeace7229.
[2010-03-31T23:55:45-07:00 - #6] Site domain.com was deleted.
[2010-03-31T23:55:46-07:00 - #7] Template ss-business-009 was selected for site.
[2010-03-31T23:55:46-07:00 - #8] Color scheme blue_sky was selected.
[2010-03-31T23:55:46-07:00 - #9] Page with id 7 was migrated (type: welcome).
[2010-03-31T23:55:46-07:00 - #10] Page with id 16 was migrated (type: about).
[2010-03-31T23:55:46-07:00 - #11] Page with id 19 was migrated (type: faq).
[2010-03-31T23:55:46-07:00 - #12] Page with id 22 was migrated (type: services).
[2010-03-31T23:55:46-07:00 - #13] Page with id 8 was migrated (type: contact).
[2010-03-31T23:55:46-07:00 - #14] Subpages were found.
[2010-03-31T23:55:46-07:00 - #15] Page with id 27 was migrated (type: gpage).
[2010-03-31T23:55:46-07:00 - #16] Subpages were found.
[2010-03-31T23:55:46-07:00 - #17] Page with id 29 was migrated (type: subpage).
[2010-03-31T23:55:46-07:00 - #18] Page with id 36 was migrated (type: Splash_Screen).
[2010-03-31T23:55:46-07:00 - #19] Migration of catalog module has been started.
[2010-03-31T23:55:46-07:00 - #20] HTML page was created.
[2010-03-31T23:55:46-07:00 - #21] Migration of catalog module was finished.
[2010-03-31T23:55:46-07:00 - #22] Error (63): Zend_Db_Statement_Exception - Table 'site_page' - SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'title' cannot be null; file: /usr/local/sitebuilder/include/Base/DB/Table/Row.php; line: 42; code: 0
Temp Solution:
The fix I can provide was to login to mysql server with the database sitebuilder3 and change the column title in the table site_page to allow nulls. After that migration continues.
|
|
|
Issue Details
|
|
Category Unknown
Status Fixed by third party
Priority 5 - Medium
Affected Version 3.3 P1
Fixed Version (none)
Users able to reproduce bug
0
Users unable to reproduce bug
0
Assigned Users
(none)
Tags
(none)
|
|
|
07-01-2010 12:58 PM
|
|
|
|
Filed as TP#46785
|
All times are GMT -5. The time now is 02:17 PM.
Subscribe to this issue
