Error in last update

[gastonwagner]

Version:
psa-11.5.30-cos6.build115130819.13.x86_64

Error after last update.

=====================================
cat plesk_11.5.30_installation_problems.log

START Bootstrapper 11.5.30 post-install for BASE AT Sat Aug 17 04:09:33 ART 2013
***** problem report *****
ERROR while trying to SMB database not created
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again
STOP Bootstrapper 11.5.30 post-install for BASE AT Sat Aug 17 04:09:47 ART 2013: PROBLEMS FOUND
START Bootstrapper 11.5.30 post-install for BASE AT Fri Aug 23 04:15:08 ART 2013
***** problem report *****
ERROR while trying to SMB database not created
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again
STOP Bootstrapper 11.5.30 post-install for BASE AT Fri Aug 23 04:15:18 ART 2013: PROBLEMS FOUND

=====================================
cat plesk_11.5.30_installation.log

... more...
`/var/www/vhosts/chroot/etc/resolv.conf' => `/etc/resolv.conf'
done
Performing migration from 50 to 52
2013-08-23T04:15:15-03:00 ERR (3) [panel]: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'isNonStorefrontCommercial':
0: Connection.php:1076
Doctrine_Connection->rethrowException(object of type PDOException, object of type Doctrine_Connection_Mysql)
1: Connection.php:1024
Doctrine_Connection->execute(string 'ALTER TABLE `smb_apsPackages` ADD `isNonStorefrontCommercial` INT DEFAULT 0')
2: Export.php:620
Doctrine_Export->alterTable(string 'smb_apsPackages', array)
3: Process.php:106
Doctrine_Migration_Process->processAddedColumns(array)
4: Migration.php:340
Doctrine_Migration->doMigrate(string 'up')
5: Migration.php:316
Doctrine_Migration->doMigrateStep(string 'up', integer '51')
6: Migration.php:34
Smb_Migration->migrate(integer '52')
7: DbManager.php:44
Smb_Application_Cli_DbManager->run()
8: db_manager.php:16
ERROR: Doctrine_Connection_Mysql_Exception: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'isNonStorefrontCommercial' (Connection.php:1076)

ERROR while trying to SMB database not created
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again

***** problem report *****
ERROR while trying to SMB database not created
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again

ERROR: An error occurred during performing of installation POST actions (see log for details).
Warning! Not all packages were installed.
Please check if your system services are operable.
Please resolve this issue and try installing the packages again.
If you cannot resolve the issue on your own, contact product technical support for assistance.

=====================================

Look psa database:

mysql> desc smb_apsPackages;
+---------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(255) | NO | | NULL | |
| version | varchar(255) | YES | | NULL | |
| release | varchar(255) | YES | | NULL | |
| vendor | varchar(255) | YES | | NULL | |
| vendorHomePage | varchar(255) | YES | | NULL | |
| packager | varchar(255) | YES | | NULL | |
| packagerHomePage | varchar(255) | YES | | NULL | |
| cacheId | varchar(255) | NO | UNI | NULL | |
| installed | varchar(25) | YES | | NULL | |
| isUploaded | int(11) | YES | | 0 | |
| isVisible | int(11) | YES | | 0 | |
| registryUid | varchar(36) | YES | | NULL | |
| globalSettingsNotSet | int(11) | YES | | 0 | |
| isNonStorefrontCommercial | int(11) | YES | | 0 | |
+---------------------------+--------------+------+-----+---------+----------------+

 

[abdi]

Looks to me like a BUG in this MU as it's not checking if the field isNonStorefrontCommercial already exists before attempting to add it with

execute(string 'ALTER TABLE `smb_apsPackages` ADD `isNonStorefrontCommercial` INT DEFAULT 0')