Parallels Virtualization and Automation Software

Upgrade failed from 4.0/4.1 to 4.2 version.

SYMPTOMS

Internal Sitebuilder error.
File: /usr/local/sitebuilder/include/Zend/Zend/Db/Adapter/Abstract.php; Line: 156
Message: SQLSTATE[42S02]: Base table or view not found: 1146
Table 'sitebuilder3.wysiwyg_image' doesn't exist; Code: 42S02

or

Table 'sitebuilder3.wysiwyg_crop_image' doesn't exist; Code: 42S02

CAUSE

This situation can be caused by some planned tasks in Sitebuilder which were not processed for some reasons, for example, backup or patch installing.

RESOLUTION

Following secuense of actions should be performed:

1. Create backup for current Sitebuilder database:
# mysqldump -usb_db_user_name -psb_db_user_passwd sitebuilder3 > sitebuilder3.sql

2. Update 'taks' table in Sitebuilder database:
# mysql sitebuilder3 -e "update task set id = 10 where id = 6;"

3. Run the following command if you had 4.0.0 version:
# echo "4.0.0" > <SB_ROOT>/migrate

If you had 4.1.0 version run the following command:
# echo "4.1.0" > <SB_ROOT>/migrate

4. Run migration process one more time:
# sb_config --migrate_all

5. Update modules:
# sb_config --update_modules

Additional information

<SB_ROOT> - Sitebuilder installation directory /usr/local/sitebuilder and /opt/sitebuilder on Debian/Ubuntu.