update 11.09 to 11.5.30 error mysql

[3a-informatique]

hi,

***** problem report *****
ERROR while trying to execute SQL query, the query was: INSERT INTO `ServiceNodeConfiguration` (`serviceNodeId`, `section`, `name`, `value`) SELECT '1', 'webProxy', 'enabled', `value` FROM `ServiceNodeProperties` WHERE `serviceNodeId` = '1' AND `name` = 'server.nginx.enabled'

 

[IgorG]

Need more details. Do you have other errors in autoinstaller logs? Have you tried bootstrapper repair procedure?

 

[3a-informatique]

Hello,

I tried bootstrapper repair


plesk_11.5.30_repair.log

ERROR while trying to execute SQL query, the query was: INSERT INTO `ServiceNodeConfiguration` (`serviceNodeId`, `section`, `name`, `value`) SELECT '1', 'webProxy', 'enabled', `value` FROM `ServiceNodeProperties` WHERE `serviceNodeId` = '1' AND `name` = 'server.nginx.enabled'
Check the error reason(see log file: /tmp/plesk_11.5.30_repair.log), fix and try again


===> Restoring database from backup /var/lib/psa/dumps/mysql.preupgrade.11.0.9-11.5.30.20130704-232813.dump.gz


**** Product repair failed.

***** problem report *****
ERROR while trying to execute SQL query, the query was: INSERT INTO `ServiceNodeConfiguration` (`serviceNodeId`, `section`, `name`, `value`) SELECT '1', 'webProxy', 'enabled', `value` FROM `ServiceNodeProperties` WHERE `serviceNodeId` = '1' AND `name` = 'server.nginx.enabled'
Check the error reason(see log file: /tmp/plesk_11.5.30_repair.log), fix and try again
STOP Bootstrapper 11.5.30 repair AT Thu Jul 4 23:28:19 CEST 2013


START Bootstrapper 11.5.30 repair AT Thu Jul 4 23:28:13 CEST 2013
***** problem report *****
ERROR while trying to execute SQL query, the query was: INSERT INTO `ServiceNodeConfiguration` (`serviceNodeId`, `section`, `name`, `value`) SELECT '1', 'webProxy', 'enabled', `value` FROM `ServiceNodeProperties` WHERE `serviceNodeId` = '1' AND `name` = 'server.nginx.enabled'
Check the error reason(see log file: /tmp/plesk_11.5.30_repair.log), fix and try again
STOP Bootstrapper 11.5.30 repair AT Thu Jul 4 23:28:19 CEST 2013: PROBLEMS FOUND

 

[IgorG]

Looks like database inconsistency. Table ServiceNodeProperties doesn't exists in Plesk 11.5 database but exists in Plesk 11.0.9 database. I suggest you contact Support Team for fixing this inconsistency directly on your server.

 

[3a-informatique]

Ok thank's

I can not contact support I have a dedicated server 1and1.fr