Post Upgrade 11.5.30 ODBC error #42S22 Unknown column '.app_id'

[J.Wick]

Help!

I've followed http://kb.parallels.com/en/116442 and I'm still not able to fix this bug.

Running the configuration query this is what has errors;

15 | domainVhost | /var/www/vhosts/somedomain.com/conf/13757345980.84601500_httpd.include | 13851881980.05008100 | domain | 11 | error | Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainVhost.php, error = Template_Exception: ODBC error #42S22: [MySQL][ODBC 3.51 Driver][mysqld-5.5.33-cll-lve]Unknown column 'T418304080.app_id' in 'on clause'
file: /usr/local/psa/admin/plib/Template/Processor.php
line: 27
code: 0
Previous error: Template_Exception: ODBC error #42S22: [MySQL][ODBC 3.51 Driver][mysqld-5.5.33-cll-lve]Unknown column 'T418304080.app_id' in 'on clause'
file: /usr/local/psa/admin/plib/Template/Processor.php
line: 27
code: 0
Previous error: Exception: ODBC error #42S22: [MySQL][ODBC 3.51 Driver][mysqld-5.5.33-cll-lve]Unknown column 'T418304080.app_id' in 'on clause'
file: /usr/share/aps_php/aps_php.php
line: 12157

I can't delete or modify that "somedomain.com" from the system.


Here are my tables:
mysql> show tables;
+------------------------------------+
| Tables_in_apsc |
+------------------------------------+
| aps_application |
| aps_application_backup |
| aps_application_resource |
| aps_log_param |
| aps_package |
| aps_package_configuration |
| aps_package_global_setting |
| aps_package_resource_configuration |
| aps_package_resource_setting |
| aps_package_series |
| aps_package_service |
| aps_registry_object |
| aps_registry_object_setting |
| aps_registry_object_tag |
| aps_resource |
| aps_resource_adjacency_list |
| aps_resource_backup |
| aps_resource_log |
| aps_resource_requirement |
| aps_resource_requirement_backup |
| aps_resource_usage_counter |
| aps_resource_usage_report |
| aps_settings_sequenses |
| meta_info |
+------------------------------------+
24 rows in set (0.00 sec)

What is the problem here?

 

[J.Wick]

Ok, I solved this the long way by installing a new plesk server and dumping the PSA and APSC database, comparing, and importing the new installs tables. It solved the app_id thing.

HOWEVER, now I have a customer that I can't remove.

Error: Unable to remove customer: Package with UID 'f8b6396c-0315-4c2c-a082-35faf8d9a5d6' not found.

Looks like I may have to remove this customer manually??? Help.

 

[IgorG]

It is database inconsistency. This article may help - http://kb.parallels.com/112733

 

[J.Wick]

IgorG, thanks for the link, that's really useful.

I did all of that by hand using phpMyAdmin and corrected the problem.