portal mod

[chris1993]

hallo
ich wollte das portal mod machen aber wenn ich intro_portal_mod_db_install.php ausführe dann kommt das

Code: Alles auswählen

Could not query Intro + Portal configuration !

RUN intro_portal_mod_db_install.php AND DELETE IT AFTER THAT AND CHECK THE FILES TO EDIT !!!

Fehler beim Abfragen der Intro + Portal Konfiguration !

FÜHRE DIE intro_portal_mod_db_install.php AUS UND LÖSCHE SIE DANACH UND ÜBERPRÜFE DIE ZU EDITIERENDEN DATEIEN !!!

HTH AWSW

DEBUG MODE

SQL Error : 1146 Table 'russiansql1.phpbb_introportalmod' doesn't exist

SELECT * FROM phpbb_introportalmod

Line : 44
File : intro.php 
  

hier könnt ihr guckenhttp://russian.byto.de/phpBB2

[Markus67]

Hi ...

Suche benutzen und das hier finden -> KB:could_not_connect
Für dich relevant .. Abschnitt 2

Markus

[Michael Zacher]

Das Problem hatte ich desöfteren..
Wenn Du da mal reinschaust, dann siehst Du, dass da überall vor den Tabellennamen und am Ende solch Dinger sind... ' << die müssen weg.
So ging's zumindest bei mir.

[Triplex]

Diese Information sagt dir, dass die intro_portal_mod_db_install.php noch nicht ausgeführt wurde, deswegen fehlt noch die Tabelle phpbb_introportalmod.

Die Fehlermeldung kommt von der intro.php, nicht von der intro_portal_mod_db_install.php

Gruß,
triplex

[Michael Zacher]

Du brauchst die Datei nicht auszuführen...
Um's einfach zu machen reicht es auch, wenn Du phpMyAdmin das hier vor die Füße wirfst:

Code: Alles auswählen

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

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));


INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('config_id', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('modversion', '1.50a');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('introportalmod_disable', '0');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('intro_disable', '0');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('intro_disable_msg', 'Intro derzeit deaktiviert');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('introlasttopics_active', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('introlasttopics_limit', '10');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('lasttopics_length_intro', '25');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('portal_disable', '0');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('portal_disable_msg', 'Portal derzeit deaktiviert');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('navigation_active', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('navigationquote_active', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('lastnewmembers_active', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('lastnewmembers_limit', '5');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('topposter_active', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('topposter_limit', '5');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('topposts_active', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('topposts_limit', '5');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('searchtopics_active', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('pollbox_active', '0');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('pollbox_forums', '1,2,3,4,5');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('forumview_active', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('lasttopics_active', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('lasttopics_limit', '10');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('lasttopics_length_portal', '25');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('freenet_active', '0');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('heise_active', '0');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('whoisonline_active', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('webmaster_active', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('partners_active', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) 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 (config_name, config_value) VALUES ('google_active', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('left_active', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('center_active', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('right_active', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('border_active', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('fpost_active', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('fpost_numofnews', '3');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('fpost_forums', '1,2,3,4,5');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('fpost_newslength', '250');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('loginform_active', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('welcomeuser_active', '0');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('forumlegend_active', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('userpostcount_active', '1');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('birthdaymod_active', '0');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('lastvisitmod_active', '0');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('chatboxmod_active', '0');
INSERT INTO phpbb_introportalmod (config_name, config_value) VALUES ('globalannouncemod_active', '0');
INSERT INTO phpbb_introportalmodnav (link_active, link_id, link_cat, link_sub,  link_name, link_url, link_level, link_level_type) VALUES (1, 0, 0, 0, 'Navigation', '', -1, 2);
INSERT INTO phpbb_introportalmodnav (link_active, link_id, link_cat, link_sub,  link_name, link_url, link_level, link_level_type) VALUES (1, 0, 0, 1, 'Forum', '', -1, 2);
INSERT INTO phpbb_introportalmodnav (link_active, link_id, link_cat, link_sub,  link_name, link_url, link_level, link_level_type) VALUES (1, 1, 0, 1, '\$lang[\'IntroPortalMOD1\']', 'intro.php', -1, 2);
INSERT INTO phpbb_introportalmodnav (link_active, link_id, link_cat, link_sub,  link_name, link_url, link_level, link_level_type) VALUES (1, 2, 0, 1, '\$lang[\'IntroPortalMOD2\']', 'portal.php', -1, 2);
INSERT INTO phpbb_introportalmodnav (link_active, link_id, link_cat, link_sub,  link_name, link_url, link_level, link_level_type) VALUES (1, 3, 0, 1, '\$lang[\'IntroPortalMOD3\']', 'index.php', -1, 2);
INSERT INTO phpbb_introportalmodnav (link_active, link_id, link_cat, link_sub,  link_name, link_url, link_level, link_level_type) VALUES (1, 0, 0, 2, '\$lang[\'Registered_users\']', '', -1, 2);
INSERT INTO phpbb_introportalmodnav (link_active, link_id, link_cat, link_sub,  link_name, link_url, link_level, link_level_type) VALUES (1, 4, 0, 3, '\$lang[\'Register\']', 'profile.php?mode=register', -1, 0);
INSERT INTO phpbb_introportalmodnav (link_active, link_id, link_cat, link_sub,  link_name, link_url, link_level, link_level_type) VALUES (1, 5, 0, 2, '\$lang[\'Profile\']', 'profile.php?mode=editprofile', 0, 2);
INSERT INTO phpbb_introportalmodnav (link_active, link_id, link_cat, link_sub,  link_name, link_url, link_level, link_level_type) VALUES (1, 6, 0, 2, '\$lang[\'Search\']', 'search.php', 0, 2);
INSERT INTO phpbb_introportalmodnav (link_active, link_id, link_cat, link_sub,  link_name, link_url, link_level, link_level_type) VALUES (1, 7, 0, 2, '\$lang[\'Memberlist\']', 'memberlist.php', 0, 2);
INSERT INTO phpbb_introportalmodnav (link_active, link_id, link_cat, link_sub,  link_name, link_url, link_level, link_level_type) VALUES (1, 8, 0, 2, '\$lang[\'FAQ\']', 'faq.php', 0, 2);
INSERT INTO phpbb_introportalmodnav (link_active, link_id, link_cat, link_sub,  link_name, link_url, link_level, link_level_type) VALUES (1, 9, 0, 2, '\$lang[\'Usergroups\']', 'groupcp.php', 0, 2);
INSERT INTO phpbb_introportalmodnav (link_active, link_id, link_cat, link_sub,  link_name, link_url, link_level, link_level_type) VALUES (1, 10, 0, 2, '\$lang[\'Private_Messages\']', 'privmsg.php', 0, 2);
INSERT INTO phpbb_introportalmodnav (link_active, link_id, link_cat, link_sub,  link_name, link_url, link_level, link_level_type) VALUES (1, 11, 0, 2, '\$lang[\'Who_is_Online\']', 'viewonline.php', 0, 2);
INSERT INTO phpbb_introportalmodnav (link_active, link_id, link_cat, link_sub,  link_name, link_url, link_level, link_level_type) VALUES (1, 0, 0, 4, '\$lang[\'IntroPortalMOD6\']', '', -1, 2);
INSERT INTO phpbb_introportalmodnav (link_active, link_id, link_cat, link_sub,  link_name, link_url, link_level, link_level_type) VALUES (1, 12, 0, 4, '\$lang[\'IntroPortalMOD4\']', 'http://www.phpbb.de', -1, 2);
INSERT INTO phpbb_introportalmodnav (link_active, link_id, link_cat, link_sub,  link_name, link_url, link_level, link_level_type) VALUES (1, 0, 0, 3, '\$lang[\'Guest\']', '', -1, 2);

[chris1993]

und wie mache ich das vor die füße legen?

[area57]

Nach dieser Anleitung hier: KB:122

[FCM]

Oben auf SQL klicken und Code hineinkopieren.