SyncCto unter C3.2.3 DB-Problem?
Hallo!
Ich habe Contao 3.2.3 mit SyncCto 2.5.0 rc1 installiert.
Wenn ich den Client abgleichen will, bekomme ich im Abschnitt "Abgleich der Datenbank" diesen Fehler:
Code:
We got a Fatal error on client site.
Fatal error: Uncaught exception Exception with message Query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'utf8_general_ci NOT NULL default '', `alias` varchar(128) utf8_bin NOT NULL de' at line 6 (CREATE TABLE `synccto_temp_tl_article` ( `id` int(10) unsigned NOT NULL auto_increment, `pid` int(10) unsigned NOT NULL default '0', `sorting` int(10) unsigned NOT NULL default '0', `tstamp` int(10) unsigned NOT NULL default '0', `title` varchar(255) utf8_general_ci NOT NULL default '', `alias` varchar(128) utf8_bin NOT NULL default '', `author` int(10) unsigned NOT NULL default '0', `inColumn` varchar(32) utf8_general_ci NOT NULL default '', `keywords` text utf8_general_ci NULL, `showTeaser` char(1) utf8_general_ci NOT NULL default '', `teaserCssID` varchar(255) utf8_general_ci NOT NULL default '', `teaser` text utf8_general_ci NULL, `printable` varchar(255) utf8_general_ci NOT NULL default '', `protected` char(1) utf8_general_ci NOT NULL default '', `groups` blob NULL, `guests` char(1) utf8_general_ci NOT NULL default '', `cssID` varchar(255) utf8_general_ci NOT NULL default '', `space` varchar(64) utf8_general_ci NOT NULL default '', `published` char(1) utf8_general_ci NOT NULL default '', `start` varchar(10) utf8_general_ci NOT NULL default '', `stop` varchar(10) utf8_general_ci NOT NULL default '', PRIMARY KEY (`id`), KEY `pid` (`pid`), KEY `alias` (`alias`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=128 ;) thrown in system/modules/core/library/Contao/Database/Statement.php on line 282
#0 system/modules/core/library/Contao/Database.php(202): Contao\Database\Statement->query('CREATE TABLE `s...')
#1 system/modules/syncCto/SyncCtoDatabase.php(823): Contao\Database->query('CREATE TABLE `s...')
#2 system/modules/syncCto/SyncCtoDatabase.php(1098): SyncCtoDatabase->doRestoreStructure()
#3 system/modules/syncCto/SyncCtoDatabase.php(1005): SyncCtoDatabase->runRestoreFromXML('system/tmp/DB-B...')
#4 [internal function]: SyncCtoDatabase->runRestore('system/tmp/sql/...', Array)
#5 system/modules/ctoCommunication/CtoCommunication.php(1187): call_user_func_array(Array, Array)
#6 ctoCommunication.php(20): CtoCommunication->runClient()
#7 {main}
Wenn ich den Abgleich von der anderen Seite probiere (Synchronisation des Servers) sieht das ähnlich aus:
Code:
Query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'utf8_general_ci NOT NULL default '', `alias` varchar(128) utf8_bin NOT NULL de' at line 6 (CREATE TABLE `synccto_temp_tl_article` ( `id` int(10) unsigned NOT NULL auto_increment, `pid` int(10) unsigned NOT NULL default '0', `sorting` int(10) unsigned NOT NULL default '0', `tstamp` int(10) unsigned NOT NULL default '0', `title` varchar(255) utf8_general_ci NOT NULL default '', `alias` varchar(128) utf8_bin NOT NULL default '', `author` int(10) unsigned NOT NULL default '0', `inColumn` varchar(32) utf8_general_ci NOT NULL default '', `keywords` text utf8_general_ci NULL, `showTeaser` char(1) utf8_general_ci NOT NULL default '', `teaserCssID` varchar(255) utf8_general_ci NOT NULL default '', `teaser` text utf8_general_ci NULL, `printable` varchar(255) utf8_general_ci NOT NULL default '', `protected` char(1) utf8_general_ci NOT NULL default '', `groups` blob NULL, `guests` char(1) utf8_general_ci NOT NULL default '', `cssID` varchar(255) utf8_general_ci NOT NULL default '', `space` varchar(64) utf8_general_ci NOT NULL default '', `published` char(1) utf8_general_ci NOT NULL default '', `start` varchar(10) utf8_general_ci NOT NULL default '', `stop` varchar(10) utf8_general_ci NOT NULL default '', PRIMARY KEY (`id`), KEY `pid` (`pid`), KEY `alias` (`alias`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=128 ;)
Die gleiche Installation aber Contao 3.1.3 mit SyncCto 2.5.0 rc1 (auf den gleichen Servern) funktioniert.
