Search

Search for:
Language:  

No categories for selected product

[HOTFIX] After installation or upgrade I cannot log into the panel, the following error is shown: ERROR Unable to query: Table 'psa.exp_event' doesn't exist

Article ID: 890 
Last Review: Apr, 18 2012
Views:
APPLIES TO:
  • Plesk 7.5.x Reloaded

Resolution

Log into mysql with admin privileges:

# mysql -uadmin -p`cat /etc/psa/.psa.shadow`


and run the command

USE psa;
CREATE TABLE `exp_event` (
`source` enum('pa','plesk') default NULL, `event_type`enum('started','stopped','created','updated','deleted','status_changed','terminated','flushed','installed','uninstalled','siteapp_added','siteapp_removed','expired') NOT NULL default 'started',
`event_time` datetime NOT NULL default '0000-00-00 00:00:00',
`obj_class` enum('license','service','ip_address','admin_info','siteapp','client','client_limits','client_status','client_prefs','client_perms','client_ip_pool','domain','domain_limits','domain_user','domain_status','phosting','fhosting','subdomain','mailname','webuser','maillist','dns_zone','mailname_antivirus','mailname_spamfilter','mailname_mailgroup','mailname_autoresponder','mailname_attachment') NOT NULL default 'license',
`obj_id` varchar(255) default NULL,
KEY `source` (`source`,`event_type`),
KEY `source_2` (`source`,`event_type`,`obj_class`),
KEY `source_3` (`source`,`event_time`,`event_type`,`obj_class`)
) TYPE=MyISAM;
QUIT;






Email subscription for changes to this article Email subscription for changes to this article

Please provide feedback on this article

* Did this article help you solve your issue?
Yes
No
What can we do to improve this article?

PLEASE NOTE: Knowledge Base feedback is reviewed occasionally and we do not reply to most of the individual comments. Please contact us using one of the Support channels for a response to any support inquiries. We appreciate your feedback.

Subscribe me for article updates. My email
 
 
 
 
 
 
For Home
For Hosters
For SaaS
For IaaS
For Developers
For Health Care
 
Desktop Virtualization
- Parallels Desktop 7 for Mac
- Parallels Transporter
- Parallels Mobile
- Parallels Desktop Switch to Mac Edition
- Parallels Workstation
- Parallels Workstation Extreme
- Parallels Desktop for Mac Enterprise Edition
Server Virtualization
- Parallels Server for Mac 4.0
- Parallels Server for Mac 4.0 Mac mini Edition
- Parallels Server for Mac Bare Metal Edition
- Parallels Server Bare Metal
- Parallels Virtuozzo Containers
Automation
- Parallels Operations Automation
- Parallels Automation for Cloud Infrastructure
- Parallels Business Automation
- Parallels Business Automation Standard
- Parallels Virtual Automation
- Parallels Plesk Panel Suite
- Parallels Small Business Panel
- Parallels Domain/SSL Reseller Program
- Parallels Partner Storefront
More Products