Hallo,
ich habe ein Datenbank Update mi PHPmyadmin gemacht und will dieses bei einem Anbieter reinspielen (von Strato zu all-inkl). Wenn ich es jetzt bei all-inkl einspielen will erscheint folgender Fehler:
PHP
CREATE TABLE IF NOT EXISTS `sswp_comments` ( `comment_ID` bigint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,
`comment_post_ID` int( 11 ) NOT NULL default '0',
`comment_author` tinytext NOT NULL ,
`comment_author_email` varchar( 100 ) NOT NULL default '',
`comment_author_url` varchar( 200 ) NOT NULL default '',
`comment_author_IP` varchar( 100 ) NOT NULL default '',
`comment_date` datetime NOT NULL default '0000-00-00 00:00:00',
`comment_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00',
`comment_content` text NOT NULL ,
`comment_karma` int( 11 ) NOT NULL default '0',
`comment_approved` varchar( 20 ) NOT NULL default '1',
`comment_agent` varchar( 255 ) NOT NULL default '',
`comment_type` varchar( 20 ) NOT NULL default '',
`comment_parent` bigint( 20 ) NOT NULL default '0',
`user_id` bigint( 20 ) NOT NULL default '0',
PRIMARY KEY ( `comment_ID` ) ,
KEY `comment_approved` ( `comment_approved` ) ,
KEY `comment_post_ID` ( `comment_post_ID` ) ,
KEY `comment_approved_date_gmt` ( `comment_approved` , `comment_date_gmt` ) ,
KEY `comment_date_gmt` ( `comment_date_gmt` )
) ENGINE = MYISAM AUTO_INCREMENT =2 DEFAULT CHARSET = utf8 AUTO_INCREMENT =2MySQL meldet:
#1064 - 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 'DEFAULT CHARSET=utf8 AUTO_INCREMENT=2' at line 22
Was kann ich machen, sodass es wieder funktioniert.
Gruß
Dwsto