Mysql psa problems

[dommel]

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

 

[Temka]

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`)

)

 

[Paulod]

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.