GICT knowledge base
Table psa.exp_event doesn’t exist after install or upgrade
Published
ERROR:
Unable to query: Table ‘psa.exp_event’ doesn’t exist:
Fix:
Log into mysql as admin
mysql -uadmin -p`cat /etc/psa/.psa.shadow`
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;
Related guides
GDPR Compliance for Websites: A Practical Guide for Developers
This guide breaks down GDPR compliance for websites, helping you create secure, transparent sites where privacy thrives.
MiscellaneousThe Beginner’s Guide to Understanding Object Relational Mapping (ORM)
This article provides a comprehensive overview of Object Relational Mapping (ORM), explaining what it is, how it works, and why it is important in modern software...
Miscellaneous5 Best Online tools to Compress and Optimize your Images
Here is the list of the 5 best Image optimization tools available online. Use these tools to compress your images without losing quality.
MiscellaneousHow to Boot Up Your Server on an OVH Kernel
In this tutorial, we can check how to boot up your server on an OVH Kernel. A kernel is responsible for interfacing the operating system and applications
