Intro und Portal

Isaac · Beitrag von **Isaac** » 03.02.2006 12:24

phpBB : Critical Error

Could not connect to the database

wie kann ich diesen Fehler und diese beiden:

phpBB : Critical Error

Could not query introportalmod information in admin_board

DEBUG MODE

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

SELECT * FROM phpbb_introportalmod

Line : 73
File : admin_introportalmod.php

Could not get shoutbox information

DEBUG MODE

SQL Error : 1146 Table 'yugiohgx.phpbb_introportalmodnav' doesn't exist

SELECT * FROM phpbb_introportalmodnav ORDER BY link_cat , link_sub, link_id

Line : 373
File : admin_introportalmodnav.php

beides ist beim Intro+Portal MOD

Beitrag von **Dr.Death** » 03.02.2006 12:30

Hi, du hast uns "unvollständige" Fehlermeldungen gegeben

Hier die vollständige Fehlermeldung bei deinem PORTAL.PHP

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 'yugiohgx.phpbb_introportalmod' doesn't exist

SELECT * FROM phpbb_introportalmod

Line : 47
File : portal.php

Du hast vergessen die mitgelieferte Datei
intro_portal_mod_db_install.php
hochzulagen und auszuführen.

Isaac · Beitrag von **Isaac** » 03.02.2006 12:36

nein diese Fehlermeldung habe ich so nicht. den wen ich die datei ausführe mit der DB dann steht da der erste Fehler.

phpBB : Critical Error

Could not connect to the database

Beitrag von **Dr.Death** » 03.02.2006 12:40

Dann öffne die Datei mal und ersetzte alle:

include

mit

include_once

Lade diese Datei dann hoch und führe sie erneut aus.

Isaac · Beitrag von **Isaac** » 03.02.2006 12:44

<?php
define('IN_PHPBB', 1);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'config.'.$phpEx);
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'includes/constants.'.$phpEx);
include($phpbb_root_path . 'includes/db.'.$phpEx);

// Start session management
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
// End session management

// Start Restrict to members
if( !$userdata['session_logged_in'] )
{
header("Location: " . append_sid("login.$phpEx?redirect=intro_portal_mod_db_install.$phpEx", true));
exit;
}
// End Restrict to members

// Start User is Admin ?
if ( $userdata['user_level'] == ADMIN )
{
}
else
{
message_die(GENERAL_MESSAGE, $lang['Not_Authorised'], $lang['Not_Authorised']);
exit;
}
// End User is Admin ?

echo '<html>
<head>
<title>SQL-DB-Installer - Intro + Portal MOD</title>
</head>
<body>
<h1>SQL-DB-Installer - Intro + Portal MOD</h1>
<hr />';
if (!isset($HTTP_GET_VARS['install'])) {
echo '<a href="?install=1">Please click here | Bitte hier klicken</a>';
}
else {
$queries = array(

// "DROP TABLE " . $table_prefix . "introportalmod",

"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')",

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

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

);

$success = true;
foreach($queries as $query) {
if (!$db->sql_query($query)) {
echo '<font color="red">An error occurred ! Changes have not been entered successfully !<br /><br />Es Fehler ist aufgetreten ! Änderung nicht erfolgreich eingetragen !</font><br /><br />';
echo mysql_error();
$success = false;
break;
}
}
if ($success) {
echo '<font color="green">DB-Changes have been entered successfully. You should delete this SQL-DB-Installer as soon as possible !<br /><br />DB-Änderung wurde erfolgreich ausgeführt. Du solltest diesen SQL-DB-Installer sobald wie möglich löschen !';
}
}
?>

welche include meinst du?

Beitrag von **Dr.Death** » 03.02.2006 12:46

alle

Code: Alles auswählen

include($phpbb_root_path . 'extension.inc'); 
include($phpbb_root_path . 'config.'.$phpEx); 
include($phpbb_root_path . 'common.'.$phpEx); 
include($phpbb_root_path . 'includes/constants.'.$phpEx); 
include($phpbb_root_path . 'includes/db.'.$phpEx);

--->

Code: Alles auswählen

include_once($phpbb_root_path . 'extension.inc'); 
include_once($phpbb_root_path . 'config.'.$phpEx); 
include_once($phpbb_root_path . 'common.'.$phpEx); 
include_once($phpbb_root_path . 'includes/constants.'.$phpEx); 
include_once($phpbb_root_path . 'includes/db.'.$phpEx);

Beitrag von **Dr.Death** » 03.02.2006 12:51

klappt ja, jetzt musst du nur noch die includes für dein Color Groups in die portal.php und intro.php einfügen. ( Die gleichen Includes, die du dafür inder index.php machen musstest.

Isaac · Beitrag von **Isaac** » 03.02.2006 12:51

das hat jetzt zwar funktioniert aber wenn ich jetzt bei meiner navibox auf

Portal bzw. Intro gehe erscheint folgendes:
Fatal error: Call to undefined function: color_group_colorize_name() in /usr/export/www/vhosts/funnetwork/hosting/yugiohgx/phpbb/includes/page_header.php on line 133

Beitrag von **Dr.Death** » 03.02.2006 12:52

ansonsten verlinke mal deine index.php , portal.php und intro.php als txt dateien.

Isaac · Beitrag von **Isaac** » 03.02.2006 13:01

hier die index.php
http://yugiohgx.yu.funpic.de/index.txt