• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Plesk 8.2.1 Db Problem

F

feel123

Guest
when I want to creat or display a domain, I get an error which is appear below

Please help..

ERROR: PleskMainDBException
MySQL query failed: Unknown column 'guid' in 'field list'

Additionally, an exception has occurred while trying to report this error: PleskMainDBException
MySQL query failed: Unknown column 'guid' in 'field list'

0: /usr/local/psa/admin/plib/common_func.php3:218
db_query(string 'select `id`,`cr_date`,`cname`,`pname`,`login`,`account_id`,`status`,`phone`,`fax`,`email`,`address`,`city`,`state`,`pcode`,`country`,`locale`,`limits_id`,`params_id`,`perm_id`,`pool_id`,`logo_id`,`tmpl_id`,`sapp_pool_id`,`guid` from clients where `id`=6')
1: /usr/local/psa/admin/plib/class.Table.php:180
Table->select()
2: /usr/local/psa/admin/plib/class.cObject.php:443
cObject->fetchAttrsFromTable_()
3: /usr/local/psa/admin/plib/class.Client.php3:69
Client->Client(integer '6')
4: /usr/local/psa/admin/plib/common_func.php3:2875
objectMaker(string 'Client', integer '6')
5: /usr/local/psa/admin/plib/class.Manager.php:679
Manager->createMainObject(integer '2')
6: /usr/local/psa/admin/plib/class.Manager.php:126
Manager->Manager(integer '3', integer '6')
7: /usr/local/psa/admin/htdocs/domains/create_domain.php:36
 
This error message menas that upgrade was not properly completed. Particularly database was not upgraded. I suggest that you do one of the following:

1) upgraded it manually with the scripts stored in /usr/local/psa/etc/db/
2) contact support and open support case
 
Back
Top