ich wollte den Mod TH23 Content Managmentsystem DE in meinem Forum installieren. Dabei bekam ich folgende 2 SQL-Error:
Code: Alles auswählen
Fehler: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 'CREATE TABLE phpbb_th23_cms_categories ( id smallint(4) unsigned NOT NULL auto' at line 2
INSERT INTO phpbb_th23_cms_articles (id, title, keyword, text, bbcode_bitfield, bbcode_uid, views, time, user_id, tags, page_title, page_name, category_id, status, navigation) VALUES (1, 'Welcome to th23 CMS!', 'Welcome_to_th23_CMS', '[b:hntwfyd0]Welcome to th23 CMS![/b:hntwfyd0]\nThis modification expands the capabilities of your phpBB, making it a fully fledged content management system (CMS).\nFor further information about th23 CMS visit [url=http://technology.th23.net:hntwfyd0]th23.net[/url:hntwfyd0]\n\n[b:hntwfyd0]To access the start page of your board just call "www.yourdomain.com/index.php?cms=off"[/b:hntwfyd0] and/or change the settings of this CMS article / the settings of the page "index.php" via the ACP.', 'UA==', 'hntwfyd0', 0, 1223658000, 2, ', welcome, th23 cms, th23, cms, ', 1, 'index.php', 1, 1, 7); CREATE TABLE phpbb_th23_cms_categories ( id smallint(4) unsigned NOT NULL auto_increment, title varchar(50) collate utf8_bin NOT NULL, keyword varchar(50) collate utf8_bin NOT NULL, public tinyint(1) unsigned NOT NULL, parent_id smallint(4) unsigned NOT NULL, left_id smallint(5) unsigned NOT NULL, right_id smallint(5) unsigned NOT NULL, intro_article_id mediumint(6) unsigned NOT NULL, cat_cache text collate utf8_bin NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin
Fehler:Table 'legmbhkeg_forum.phpbb_th23_cms_categories' doesn't exist
INSERT INTO phpbb_th23_cms_categories (id, title, keyword, public, parent_id, left_id, right_id, intro_article_id, cat_cache) VALUES (1, 'Start', 'Start', 1, 0, 1, 2, 0, '')
Gruß
Plan B