PlugIn server konnte aus folgendem Grund nicht installiert werden: SQL error: Error while executing statement "CREATE TABLErex_project_manager_domain(idint(10) unsigned NOT NULL auto_increment,namevarchar(255) ,domainvarchar(255) ,api_keyvarchar(32) ,is_ssltinyint ,descriptiontext NOT NULL ,cmstinyint ,statustext NOT NULL ,createdatetimestamp DEFAULT '0000-00-00 00:00:00' NOT NULL default CURRENT_TIMESTAMP,updatedatetimestamp DEFAULT '0000-00-00 00:00:00' NOT NULL on update CURRENT_TIMESTAMP,logdatetimestamp DEFAULT '0000-00-00 00:00:00' NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"! SQLSTATE[HY000]: General error: 1293 Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
skerbis
commented
5 years ago
REDAXO 5.6.5 PHP 7.2.13 MySQL5.5.62 AddOn-Version: 1.1.2
PlugIn server konnte aus folgendem Grund nicht installiert werden: SQL error: Error while executing statement "CREATE TABLErex_project_manager_domain(idint(10) unsigned NOT NULL auto_increment,namevarchar(255) ,domainvarchar(255) ,api_keyvarchar(32) ,is_ssltinyint ,descriptiontext NOT NULL ,cmstinyint ,statustext NOT NULL ,createdatetimestamp DEFAULT '0000-00-00 00:00:00' NOT NULL default CURRENT_TIMESTAMP,updatedatetimestamp DEFAULT '0000-00-00 00:00:00' NOT NULL on update CURRENT_TIMESTAMP,logdatetimestamp DEFAULT '0000-00-00 00:00:00' NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"! SQLSTATE[HY000]: General error: 1293 Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause