probleme mit dem intro & portal mod !!!

[Supersonic]

Hab ich auch nicht. Aber brauchst Du auch nicht. Wenn Du die .zip Datei vom Mod entpackt hast, steht darin ein Ordner "IntroPortalMOD_root"

In diesem Ordner befindet sich die "intro_portal_mod_db_install.php", die benötigt wird.

[rob33]

Ja aber da kommt immernoch der selbe fehler

[Supersonic]

Dann soltest Du die Tabellen mal von Hand anlegen:

Code: Alles auswählen

"CREATE TABLE " . $table_prefix . "introportalmod (
  config_name varchar(255) NOT NULL default '',
  config_value text NOT NULL,
  PRIMARY KEY (config_name)
) TYPE=MyISAM;",

"INSERT INTO " . $table_prefix . "introportalmod VALUES ('config_id', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('modversion', '1.50a')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('introportalmod_disable', '0')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('intro_disable', '0')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('intro_disable_msg', 'Intro derzeit deaktiviert')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('introlasttopics_active', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('introlasttopics_limit', '10')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('lasttopics_length_intro', '25')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('portal_disable', '0')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('portal_disable_msg', 'Portal derzeit deaktiviert')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('navigation_active', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('navigationquote_active', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('lastnewmembers_active', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('lastnewmembers_limit', '5')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('topposter_active', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('topposter_limit', '5')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('topposts_active', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('topposts_limit', '5')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('searchtopics_active', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('pollbox_active', '0')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('pollbox_forums', '1,2,3,4,5')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('forumview_active', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('lasttopics_active', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('lasttopics_limit', '10')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('lasttopics_length_portal', '25')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('freenet_active', '0')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('heise_active', '0')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('whoisonline_active', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('webmaster_active', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('partners_active', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('Partnersitelinks', 'http://www.partner1.de\r\nhttp://www.partner2.de\r\nhttp://www.partner3.de\r\nhttp://www.partner4.de\r\nhttp://www.partner5.de')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('google_active', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('left_active', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('center_active', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('right_active', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('border_active', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('fpost_active', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('fpost_numofnews', '3')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('fpost_forums', '1,2,3,4,5')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('fpost_newslength', '250')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('loginform_active', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('welcomeuser_active', '0')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('forumlegend_active', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('userpostcount_active', '1')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('birthdaymod_active', '0')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('lastvisitmod_active', '0')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('chatboxmod_active', '0')",
"INSERT INTO " . $table_prefix . "introportalmod VALUES ('globalannouncemod_active', '0')",

"CREATE TABLE " . $table_prefix . "introportalmodnav
(link_active tinyint(1) NOT NULL default '1',
link_id mediumint(5) NOT NULL default '0',
link_cat mediumint(5) NOT NULL default '0',
link_sub mediumint(5) NOT NULL default '0',
link_name varchar(60) NOT NULL default '',
link_url varchar(100) NOT NULL default '',
link_level tinyint(1) NOT NULL default '0',
link_level_type tinyint(1) NOT NULL default '0',
KEY link_id (link_id), KEY link_cat (link_cat),
KEY link_sub (link_sub))
TYPE=MyISAM;",

"INSERT INTO " . $table_prefix . "introportalmodnav VALUES (1, 0, 0, 0, 'Navigation', '', -1, 2)",
"INSERT INTO " . $table_prefix . "introportalmodnav VALUES (1, 0, 0, 1, 'Forum', '', -1, 2)",
"INSERT INTO " . $table_prefix . "introportalmodnav VALUES (1, 1, 0, 1, '\$lang[\'IntroPortalMOD1\']', 'intro.php', -1, 2)",
"INSERT INTO " . $table_prefix . "introportalmodnav VALUES (1, 2, 0, 1, '\$lang[\'IntroPortalMOD2\']', 'portal.php', -1, 2)",
"INSERT INTO " . $table_prefix . "introportalmodnav VALUES (1, 3, 0, 1, '\$lang[\'IntroPortalMOD3\']', 'index.php', -1, 2)",
"INSERT INTO " . $table_prefix . "introportalmodnav VALUES (1, 0, 0, 2, '\$lang[\'Registered_users\']', '', -1, 2)",
"INSERT INTO " . $table_prefix . "introportalmodnav VALUES (1, 4, 0, 3, '\$lang[\'Register\']', 'profile.php?mode=register', -1, 0)",
"INSERT INTO " . $table_prefix . "introportalmodnav VALUES (1, 5, 0, 2, '\$lang[\'Profile\']', 'profile.php?mode=editprofile', 0, 2)",
"INSERT INTO " . $table_prefix . "introportalmodnav VALUES (1, 6, 0, 2, '\$lang[\'Search\']', 'search.php', 0, 2)",
"INSERT INTO " . $table_prefix . "introportalmodnav VALUES (1, 7, 0, 2, '\$lang[\'Memberlist\']', 'memberlist.php', 0, 2)",
"INSERT INTO " . $table_prefix . "introportalmodnav VALUES (1, 8, 0, 2, '\$lang[\'FAQ\']', 'faq.php', 0, 2)",
"INSERT INTO " . $table_prefix . "introportalmodnav VALUES (1, 9, 0, 2, '\$lang[\'Usergroups\']', 'groupcp.php', 0, 2)",
"INSERT INTO " . $table_prefix . "introportalmodnav VALUES (1, 10, 0, 2, '\$lang[\'Private_Messages\']', 'privmsg.php', 0, 2)",
"INSERT INTO " . $table_prefix . "introportalmodnav VALUES (1, 11, 0, 2, '\$lang[\'Who_is_Online\']', 'viewonline.php', 0, 2)",
"INSERT INTO " . $table_prefix . "introportalmodnav VALUES (1, 0, 0, 4, '\$lang[\'IntroPortalMOD6\']', '', -1, 2)",
"INSERT INTO " . $table_prefix . "introportalmodnav VALUES (1, 12, 0, 4, '\$lang[\'IntroPortalMOD4\']', 'http://www.phpbb.de', -1, 2)",
"INSERT INTO " . $table_prefix . "introportalmodnav VALUES (1, 0, 0, 3, '\$lang[\'Guest\']', '', -1, 2)"

);

[Markus67]

Hi ...

mach das ganze manuell mit KB:phpmyadmin ...
http://www.phpbb.de/viewtopic.php?p=276548#276548

Markus

[rob33]

bei mir kommt im phpmyadmin der fehler


SQL-Befehl:

"CREATE TABLE ".$table_prefix. "introportalmod ( config_name varchar(255) NOT NULL default '', config_value text NOT NULL, PRIMARY KEY (config_name) ) TYPE=MyISAM;", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('config_id', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('modversion', '1.50a')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('introportalmod_disable', '0')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('intro_disable', '0')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('intro_disable_msg', 'Intro derzeit deaktiviert')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('introlasttopics_active', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('introlasttopics_limit', '10')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('lasttopics_length_intro', '25')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('portal_disable', '0')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('portal_disable_msg', 'Portal derzeit deaktiviert')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('navigation_active', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('navigationquote_active', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('lastnewmembers_active', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('lastnewmembers_limit', '5')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('topposter_active', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('topposter_limit', '5')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('topposts_active', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('topposts_limit', '5')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('searchtopics_active', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('pollbox_active', '0')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('pollbox_forums', '1,2,3,4,5')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('forumview_active', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('lasttopics_active', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('lasttopics_limit', '10')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('lasttopics_length_portal', '25')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('freenet_active', '0')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('heise_active', '0')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('whoisonline_active', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('webmaster_active', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('partners_active', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('Partnersitelinks', 'http://www.partner1.de\r\nhttp://www.partner2.de\r\nhttp://www.partner3.de\r\nhttp://www.partner4.de\r\nhttp://www.partner5.de')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('google_active', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('left_active', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('center_active', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('right_active', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('border_active', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('fpost_active', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('fpost_numofnews', '3')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('fpost_forums', '1,2,3,4,5')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('fpost_newslength', '250')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('loginform_active', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('welcomeuser_active', '0')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('forumlegend_active', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('userpostcount_active', '1')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('birthdaymod_active', '0')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('lastvisitmod_active', '0')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('chatboxmod_active', '0')", "INSERT INTO ".$table_prefix. "introportalmod VALUES ('globalannouncemod_active', '0')", "CREATE TABLE ".$table_prefix. "introportalmodnav (link_active tinyint(1) NOT NULL default '1', link_id mediumint(5) NOT NULL default '0', link_cat mediumint(5) NOT NULL default '0', link_sub mediumint(5) NOT NULL default '0', link_name varchar(60) NOT NULL default '', link_url varchar(100) NOT NULL default '', link_level tinyint(1) NOT NULL default '0', link_level_type tinyint(1) NOT NULL default '0', KEY link_id (link_id), KEY link_cat (link_cat), KEY link_sub (link_sub)) TYPE=MyISAM;", "INSERT INTO ".$table_prefix. "introportalmodnav VALUES (1, 0, 0, 0, 'Navigation', '', -1, 2)", "INSERT INTO ".$table_prefix. "introportalmodnav VALUES (1, 0, 0, 1, 'Forum', '', -1, 2)", "INSERT INTO ".$table_prefix. "introportalmodnav VALUES (1, 1, 0, 1, '\$lang[\'IntroPortalMOD1\']', 'intro.php', -1, 2)", "INSERT INTO ".$table_prefix. "introportalmodnav VALUES (1, 2, 0, 1, '\$lang[\'IntroPortalMOD2\']', 'portal.php', -1, 2)", "INSERT INTO ".$table_prefix. "introportalmodnav VALUES (1, 3, 0, 1, '\$lang[\'IntroPortalMOD3\']', 'index.php', -1, 2)", "INSERT INTO ".$table_prefix. "introportalmodnav VALUES (1, 0, 0, 2, '\$lang[\'Registered_users\']', '', -1, 2)", "INSERT INTO ".$table_prefix. "introportalmodnav VALUES (1, 4, 0, 3, '\$lang[\'Register\']', 'profile.php?mode=register', -1, 0)", "INSERT INTO ".$table_prefix. "introportalmodnav VALUES (1, 5, 0, 2, '\$lang[\'Profile\']', 'profile.php?mode=editprofile', 0, 2)", "INSERT INTO ".$table_prefix. "introportalmodnav VALUES (1, 6, 0, 2, '\$lang[\'Search\']', 'search.php', 0, 2)", "INSERT INTO ".$table_prefix. "introportalmodnav VALUES (1, 7, 0, 2, '\$lang[\'Memberlist\']', 'memberlist.php', 0, 2)", "INSERT INTO ".$table_prefix. "introportalmodnav VALUES (1, 8, 0, 2, '\$lang[\'FAQ\']', 'faq.php', 0, 2)", "INSERT INTO ".$table_prefix. "introportalmodnav VALUES (1, 9, 0, 2, '\$lang[\'Usergroups\']', 'groupcp.php', 0, 2)", "INSERT INTO ".$table_prefix. "introportalmodnav VALUES (1, 10, 0, 2, '\$lang[\'Private_Messages\']', 'privmsg.php', 0, 2)", "INSERT INTO ".$table_prefix. "introportalmodnav VALUES (1, 11, 0, 2, '\$lang[\'Who_is_Online\']', 'viewonline.php', 0, 2)", "INSERT INTO ".$table_prefix. "introportalmodnav VALUES (1, 0, 0, 4, '\$lang[\'IntroPortalMOD6\']', '', -1, 2)", "INSERT INTO ".$table_prefix. "introportalmodnav VALUES (1, 12, 0, 4, '\$lang[\'IntroPortalMOD4\']', 'http://www.phpbb.de', -1, 2)", "INSERT INTO ".$table_prefix. "introportalmodnav VALUES (1, 0, 0, 3, '\$lang[\'Guest\']', '', -1, 2)"
)

MySQL meldet: Dokumentation
#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 '"CREATE TABLE " . $table_prefix . "introportalmod (
config_n

[rob33]

Oh hab den fehler endekt nu geht das vielen Dank für eure Hilfe^^