hi,
ich bin mit meinem Projekt auf einen neuen Server gezogen. Allerdings macht das importieren der Datenbank Probleme. Diese ist Gzip komprimiert . Es wird folgende Fehlermeldung ausgeworfen :
Error at the line 46: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Query: CREATE TABLE `bb1_access` (
`boardid` int(11) unsigned NOT NULL default '0',
`userid` int(11) unsigned NOT NULL default '0',
`can_view_board` tinyint(1) NOT NULL default '-1',
`can_enter_board` tinyint(1) NOT NULL default '-1',
`can_read_thread` tinyint(1) NOT NULL default '-1',
`can_start_topic` tinyint(1) NOT NULL default '-1',
`can_reply_topic` tinyint(1) NOT NULL default '-1',
`can_post_poll` tinyint(1) NOT NULL default '-1',
`can_upload_attachments` tinyint(1) NOT NULL default '-1',
`can_download_attachments` tinyint(1) NOT NULL default '-1',
`can_post_without_moderation` tinyint(1) NOT NULL default '-1',
`can_close_own_topic` tinyint(1) NOT NULL default '-1',
`can_use_search` tinyint(1) NOT NULL default '-1',
`can_vote_poll` tinyint(1) NOT NULL default '-1',
`can_rate_thread` tinyint(1) NOT NULL default '-1',
`can_del_own_post` tinyint(1) NOT NULL default '-1',
`can_edit_own_post` tinyint(1) NOT NULL default '-1',
`can_del_own_topic` tinyint(1) NOT NULL default '-1',
`can_edit_own_topic` tinyint(1) NOT NULL default '-1',
`can_move_own_topic` tinyint(1) NOT NULL default '-1',
`can_use_post_html` tinyint(1) NOT NULL default '-1',
`can_use_post_bbcode` tinyint(1) NOT NULL default '-1',
`can_use_post_smilies` tinyint(1) NOT NULL default '-1',
`can_use_post_icons` tinyint(1) NOT NULL default '-1',
`can_use_post_images` tinyint(1) NOT NULL default '-1',
PRIMARY KEY (`userid`,`boardid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;MySQL: 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=latin1' at line 28
was soll ich machen?
*edit* in der DB ist ein wbb 2.3.6 ein wp 2.0.7 und 2 selfcodet scripte...
mfg