APS Catalog error: Specified column "registryUid" is not in the row

[Matthew James]

Hi everyone,

After upgrading Plesk not long ago, when visiting the Applications I get error:

List of categories could not be loaded at the moment. Retry

The logs show:

2011-10-26T16:08:45+01:00 ERR (3): APS Catalog error: Specified column "registryUid" is not in the row

I'm guessing this relates to the smb_apsCategories table:

mysql> desc smb_apsCategories;
+-------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(255) | YES | UNI | NULL | |
+-------+--------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)

Can anybody let me know what the structure of this table should be from a working install?

Thanks
Matt

 

[IgorG]

It looks like Plesk database was not correctly upgraded. Try to fix it with bootstrapper repair.

 

[Matthew James]

Hi there,

I tried this but it gave error:

Trying to set up APS controller database... Attempting to check APS db connection via ODBC, using /usr/bin/isql (empty output is good)
done
Performing migration from 40 to 43
PHP Fatal error: Uncaught exception 'Doctrine_Connection_Mysql_Exception' with message 'SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'additionalInfo'' in /usr/local/psa/admin/smb/application/externals/Doctrine/Connection.php:1076
Stack trace:
#0 /usr/local/psa/admin/smb/application/externals/Doctrine/Connection.php(1024): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql))
#1 /usr/local/psa/admin/smb/application/externals/Doctrine/Export.php(620): Doctrine_Connection->execute('ALTER TABLE `sm...')
#2 /usr/local/psa/admin/smb/application/externals/Doctrine/Migration/Process.php(106): Doctrine_Export->alterTable('smb_users', Array)
#3 /usr/local/psa/admin/smb/application/externals/Doctrine/Migration.php(340): Doctrine_Migration_Process->processAddedColumns(Array)
#4 /usr/local/psa/admin/smb/application/externals/Doctrine/Migration.php(316): Doctrine_Migration->doMigrate('up')
#5 /usr/local/psa/admin/smb/application/library/Smb/Migration.php(33): Doctrine_Migration in /usr/local/psa/admin/smb/application/externals/Doctrine/Connection.php on line 1076

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


===> Restoring database from backup /var/lib/psa/dumps/mysql.preupgrade.10.11.0-10.12.0.20111101-082915.dump.gz


**** Product repair failed.

***** problem report *****
ERROR while trying to SMB database not created
Check the error reason(see log file: /tmp/plesk_10.3.0_installation.log), fix and try again
STOP Bootstrapper 10.12.0 repair AT Tue Nov 1 08:30:41 GMT 2011

Any further ideas?

 

[IgorG]

I think it would be better contact Support Team for fixing this database inconsistency.

 

[spid3r1987]

im having the exact same problem, please tell me how to fix this...all i did was tell plesk to upgrade...
now its bust...
websites not loading and panel not loading...

 

[duno]

For own reference

CREATE TABLE `smb_apsPackages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`version` varchar(255) DEFAULT NULL,
`release` varchar(255) DEFAULT NULL,
`vendor` varchar(255) DEFAULT NULL,
`vendorHomePage` varchar(255) DEFAULT NULL,
`packager` varchar(255) DEFAULT NULL,
`packagerHomePage` varchar(255) DEFAULT NULL,
`cacheId` varchar(255) NOT NULL,
`installed` varchar(25) DEFAULT NULL,
`isUploaded` int(11) DEFAULT '0',
`isVisible` int(11) DEFAULT '0',
`registryUid` varchar(36) DEFAULT NULL,
`globalSettingsNotSet` int(11) DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `cacheId` (`cacheId`),
UNIQUE KEY `cacheId_2` (`cacheId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8