Seite 1 von 2

Intro - Portal Mod

Verfasst: 11.11.2005 18:37
von masterjule
Ich will den Intro-Portal Mod einbauen und ich habe schon die Dateien hochgeladen, aber wenn ich intro_portal_mod_db_install.php ausführe kommt folgende Felermeldung:

Code: Alles auswählen

phpBB : Kritischer Fehler

Could not connect to the database
Was kann ich machen?

Verfasst: 12.11.2005 01:13
von Markus67
Hi ...

suche in der intro_portal_mod_db_install.php

Code: Alles auswählen

include($phpbb_root_path . 'includes/db.'.$phpEx);
ersetze mit:

Code: Alles auswählen

include_once($phpbb_root_path . 'includes/db.'.$phpEx);
Dann klappts :wink:

Markus

Verfasst: 12.11.2005 11:13
von masterjule
das hab ich gemacht und jetzt kommt:

Code: Alles auswählen

Parse error: parse error, unexpected $ in /srv/www/htdocs/web115/html/intro_portal_mod_db_install.php on line 129

Verfasst: 12.11.2005 11:17
von CrYiNg
Hallo!

Führe sie doch manuell in phpMyAmdmin aus.

CrYiNg :cry:

Verfasst: 12.11.2005 11:25
von masterjule
und äh, wie geht das?

Verfasst: 12.11.2005 11:32
von CrYiNg
Hallo!

Gehe in phpMyAdmin. Ich hoffe, du weist, wie das geht.
Suche oben den Button "Sql" und klicke darauf. Dann fügst du folgendes in das Textfeld ein:

Code: Alles auswählen

"DROP TABLE " . $table_prefix . "introportalmodnav",

"UPDATE " . $table_prefix . "introportalmod SET config_value = '1.50a' WHERE config_name = 'modversion'",
"UPDATE " . $table_prefix . "introportalmod SET config_value = '1' WHERE config_name = 'navigation_active'",

"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)"
Dann auf "Ok" drücken.
Es müsste funktionieren.

CrYiNg :cry:

Verfasst: 12.11.2005 11:43
von masterjule
was muss ich denn für table_prefix einsetzen?

Verfasst: 12.11.2005 11:55
von CrYiNg
Hallo!

Nichts. Einfach so lassen. :wink:

CrYiNg :cry:

Verfasst: 12.11.2005 12:15
von masterjule
es kommt eine fehlermeldung:

Code: Alles auswählen

 MySQL 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 '"DROP TABLE " . $table_prefix . "introportalmodnav",

"UPDATE 

Verfasst: 12.11.2005 12:43
von Markus67
masterjule hat geschrieben:das hab ich gemacht und jetzt kommt:

Code: Alles auswählen

Parse error: parse error, unexpected $ in /srv/www/htdocs/web115/html/intro_portal_mod_db_install.php on line 129
verlinke mal bitte die Datei als txt-Datei ... da hast du mit Sicherheit beim Ändern irgendwas zuviel verändert.

Falls du es doch mit dem SQL-Querie machen möchtest nimm den hier ...

Code: Alles auswählen

CREATE TABLE phpbb_introportalmod ( 
  config_name varchar(255) NOT NULL default '', 
  config_value text NOT NULL, 
  PRIMARY KEY (config_name) 
) TYPE=MyISAM; 

INSERT INTO phpbb_introportalmod VALUES ('config_id', '1'); 
INSERT INTO phpbb_introportalmod VALUES ('modversion', '1.50a'); 
INSERT INTO phpbb_introportalmod VALUES ('introportalmod_disable', '0'); 
INSERT INTO phpbb_introportalmod VALUES ('intro_disable', '0'); 
INSERT INTO phpbb_introportalmod VALUES ('intro_disable_msg', 'Intro derzeit deaktiviert'); 
INSERT INTO phpbb_introportalmod VALUES ('introlasttopics_active', '1'); 
INSERT INTO phpbb_introportalmod VALUES ('introlasttopics_limit', '10'); 
INSERT INTO phpbb_introportalmod VALUES ('lasttopics_length_intro', '25'); 
INSERT INTO phpbb_introportalmod VALUES ('portal_disable', '0'); 
INSERT INTO phpbb_introportalmod VALUES ('portal_disable_msg', 'Portal derzeit deaktiviert'); 
INSERT INTO phpbb_introportalmod VALUES ('navigation_active', '1'); 
INSERT INTO phpbb_introportalmod VALUES ('navigationquote_active', '1'); 
INSERT INTO phpbb_introportalmod VALUES ('lastnewmembers_active', '1'); 
INSERT INTO phpbb_introportalmod VALUES ('lastnewmembers_limit', '5'); 
INSERT INTO phpbb_introportalmod VALUES ('topposter_active', '1'); 
INSERT INTO phpbb_introportalmod VALUES ('topposter_limit', '5'); 
INSERT INTO phpbb_introportalmod VALUES ('topposts_active', '1'); 
INSERT INTO phpbb_introportalmod VALUES ('topposts_limit', '5'); 
INSERT INTO phpbb_introportalmod VALUES ('searchtopics_active', '1'); 
INSERT INTO phpbb_introportalmod VALUES ('pollbox_active', '0'); 
INSERT INTO phpbb_introportalmod VALUES ('pollbox_forums', '1,2,3,4,5'); 
INSERT INTO phpbb_introportalmod VALUES ('forumview_active', '1'); 
INSERT INTO phpbb_introportalmod VALUES ('lasttopics_active', '1'); 
INSERT INTO phpbb_introportalmod VALUES ('lasttopics_limit', '10'); 
INSERT INTO phpbb_introportalmod VALUES ('lasttopics_length_portal', '25'); 
INSERT INTO phpbb_introportalmod VALUES ('freenet_active', '0'); 
INSERT INTO phpbb_introportalmod VALUES ('heise_active', '0'); 
INSERT INTO phpbb_introportalmod VALUES ('whoisonline_active', '1'); 
INSERT INTO phpbb_introportalmod VALUES ('webmaster_active', '1'); 
INSERT INTO phpbb_introportalmod VALUES ('partners_active', '1'); 
INSERT INTO phpbb_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 phpbb_introportalmod VALUES ('google_active', '1'); 
INSERT INTO phpbb_introportalmod VALUES ('left_active', '1'); 
INSERT INTO phpbb_introportalmod VALUES ('center_active', '1'); 
INSERT INTO phpbb_introportalmod VALUES ('right_active', '1'); 
INSERT INTO phpbb_introportalmod VALUES ('border_active', '1'); 
INSERT INTO phpbb_introportalmod VALUES ('fpost_active', '1'); 
INSERT INTO phpbb_introportalmod VALUES ('fpost_numofnews', '3'); 
INSERT INTO phpbb_introportalmod VALUES ('fpost_forums', '1,2,3,4,5'); 
INSERT INTO phpbb_introportalmod VALUES ('fpost_newslength', '250'); 
INSERT INTO phpbb_introportalmod VALUES ('loginform_active', '1'); 
INSERT INTO phpbb_introportalmod VALUES ('welcomeuser_active', '0'); 
INSERT INTO phpbb_introportalmod VALUES ('forumlegend_active', '1'); 
INSERT INTO phpbb_introportalmod VALUES ('userpostcount_active', '1'); 
INSERT INTO phpbb_introportalmod VALUES ('birthdaymod_active', '0'); 
INSERT INTO phpbb_introportalmod VALUES ('lastvisitmod_active', '0'); 
INSERT INTO phpbb_introportalmod VALUES ('chatboxmod_active', '0'); 
INSERT INTO phpbb_introportalmod VALUES ('globalannouncemod_active', '0'); 



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