• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Mysql psa problems

dommel

New Pleskian
Hi all,

Can you help me out?
I have the following error when adding a new client or login as a client/domain

DB query failed: Data truncated for column 'event_type' at row 1
---------------------- Debug Info -------------------------------
0: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:213
db_query(string 'INSERT INTO exp_event (source, event_type, event_time, obj_class, obj_id, host, `user`, flushed) VALUES ('plesk', 'guid_changed', NOW(), 'client','client2', '**ipadress**', 'client2', 'false')')
1: C:\Program Files\SWsoft\Plesk\admin\plib\api-rpc\loger.php:323
Log2Expand->Log2Expand(object of type ActionLog)
2: C:\Program Files\SWsoft\Plesk\admin\plib\class.ActionLog.php:520
ActionLog->submit()
3: C:\Program Files\SWsoft\Plesk\admin\plib\class.Client.php3:320
Client->update()
4: C:\Program Files\SWsoft\Plesk\admin\plib\cmd_loginup.php:544
createSessionClient(string 'client2', string '********', boolean false, boolean false)
5: C:\Program Files\SWsoft\Plesk\admin\plib\cmd_loginup.php:171
createSession(string 'client2', string '********')
6: C:\Program Files\SWsoft\Plesk\admin\htdocs\login_up.php3:26

Removed for this post clientname and ipadress:

> client2 is de client who is made and want to login
> **ipadress** is the client ipadress
 
Try to recreate the table 'exp_event'.
This table is needed for Plesk Expand. If your Plesk server is not added into the Plesk Expand you can recreate it.
CREATE TABLE `exp_event` (

`id` bigint(10) unsigned NOT NULL auto_increment,

`source` enum('pa','plesk') default NULL,

`event_type` enum('started','stopped','created','updated','deleted','status_ch

anged','terminated','flushed','installed','uninstalled','siteapp_added','siteapp

_removed','expired','exceeded') NOT NULL default 'started',

`event_time` timestamp NOT NULL default CURRENT_TIMESTAMP,

`obj_class` enum('license','service','ip_address','admin_info','siteapp','sess

ion_preferences','plesk_component','client','client_limits','client_status','cli

ent_prefs','client_perms','client_ip_pool','client_limit_traffic','client_limit_

size','domain','domain_limits','domain_user','domain_alias','domain_status','pho

sting','fhosting','domain_limit_traffic','domain_limit_size','db_server','subdom

ain','mailname','webuser','maillist','dns_zone','mailname_antivirus','mailname_s

pamfilter','mailname_mailgroup','mailname_autoresponder','mailname_attachment','

remote_dns','dashboard_preset','dashboard_preset_type','dashboard_preset_name')

NOT NULL default 'license',

`obj_id` varchar(255) NOT NULL default '',

`host` varchar(255) NOT NULL default '',

`user` varchar(255) NOT NULL default '',

`flushed` enum('true','false') NOT NULL default 'false',

PRIMARY KEY (`id`),

KEY `flushed` (`flushed`),

KEY `source` (`source`,`event_type`),

KEY `source_2` (`source`,`event_type`,`obj_class`),

KEY `source_3` (`source`,`event_time`,`event_type`,`obj_class`)

)
 
Solved!

To fix that error just run this SQL query under phpMyAdmin:

ALTER TABLE `exp_event` CHANGE `event_type` `event_type` ENUM( 'started', 'stopped', 'created', 'updated', 'deleted', 'status_changed', 'terminated', 'flushed', 'installed', 'uninstalled', 'siteapp_added', 'siteapp_removed', 'expired', 'exceeded', 'guid_changed' ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'started'


That error happens when MySQL has been closed abruptly.
 
Back
Top