intro_portal_mod_db_install.php

Tanja64 · Beitrag von **Tanja64** » 20.03.2006 09:10

Hallo,

wir bauen gerade unser Forum komplett neu auf.
Das Forum läuft problemlos, die Installation des Classic Style war erfolgreich, sowie die Installation des EasyMod. Nun kommen wir beim Intro und Portal nicht weiter.
Alle Tips und Hilfen, die ihr hier gegeben habt und ich gefunden habe, wurden bearbeitet.
Die intro_portal_mod_db_install entsprechend geändert, aber der Fehler bleibt.
Ich bekomme die Fehlermeldung:

phpBB : Kritischer Fehler

Could not query introportalmod information in admin_board

DEBUG MODE

SQL Error : 1146 Table 'XXXXX.INTROPORTALMOD_TABLE' doesn't exist

SELECT * FROM INTROPORTALMOD_TABLE

Line : 73
File : admin_introportalmod.php

Ich kann schon die intro_portal_mod_db_install.php nicht ausführen. Da erscheint dann:

Warning: main(): Failed opening './extension.inc' for inclusion (include_path='.:/usr/share/php:..') in /www/htdocs/w006a83e/phpBB2/admin/mods/IntroPortalMOD_V150/IntroPortalMOD_root/intro_portal_mod_db_install.php on line 4

Warning: main(./config.): failed to open stream: No such file or directory in /www/htdocs/w006a83e/phpBB2/admin/mods/IntroPortalMOD_V150/IntroPortalMOD_root/intro_portal_mod_db_install.php on line 5

Warning: main(): Failed opening './config.' for inclusion (include_path='.:/usr/share/php:..') in /www/htdocs/w006a83e/phpBB2/admin/mods/IntroPortalMOD_V150/IntroPortalMOD_root/intro_portal_mod_db_install.php on line 5

Warning: main(./common.): failed to open stream: No such file or directory in /www/htdocs/w006a83e/phpBB2/admin/mods/IntroPortalMOD_V150/IntroPortalMOD_root/intro_portal_mod_db_install.php on line 6

Warning: main(): Failed opening './common.' for inclusion (include_path='.:/usr/share/php:..') in /www/htdocs/w006a83e/phpBB2/admin/mods/IntroPortalMOD_V150/IntroPortalMOD_root/intro_portal_mod_db_install.php on line 6

Warning: main(./includes/constants.): failed to open stream: No such file or directory in /www/htdocs/w006a83e/phpBB2/admin/mods/IntroPortalMOD_V150/IntroPortalMOD_root/intro_portal_mod_db_install.php on line 7

Warning: main(): Failed opening './includes/constants.' for inclusion (include_path='.:/usr/share/php:..') in /www/htdocs/w006a83e/phpBB2/admin/mods/IntroPortalMOD_V150/IntroPortalMOD_root/intro_portal_mod_db_install.php on line 7

Warning: main(./includes/db.): failed to open stream: No such file or directory in /www/htdocs/w006a83e/phpBB2/admin/mods/IntroPortalMOD_V150/IntroPortalMOD_root/intro_portal_mod_db_install.php on line 8

Warning: main(): Failed opening './includes/db.' for inclusion (include_path='.:/usr/share/php:..') in /www/htdocs/w006a83e/phpBB2/admin/mods/IntroPortalMOD_V150/IntroPortalMOD_root/intro_portal_mod_db_install.php on line 8

Fatal error: Call to undefined function: session_pagestart() in /www/htdocs/w006a83e/phpBB2/admin/mods/IntroPortalMOD_V150/IntroPortalMOD_root/intro_portal_mod_db_install.php on line 11

Kann mir jemand helfen?

ATARI · Beitrag von **ATARI** » 20.03.2006 09:18

ersetze include mit include_once in der db_install.php

StarWolf3000 · Beitrag von **StarWolf3000** » 20.03.2006 09:19

wurde der MOD in das Root-Verzeichnis von phpBB geladen?

Tanja64 · Beitrag von **Tanja64** » 20.03.2006 09:20

Hallo Atatri,

hab ich gemacht, Fehler bleibt trotzdem.

ATARI · Beitrag von **ATARI** » 20.03.2006 09:21

hm.. verlink mal die db_install.php so wie du's jetzt probiert hättest!

Tanja64 · Beitrag von **Tanja64** » 20.03.2006 09:23

meinst du den Link?
http://frauenforum.das-weibernest.de/ph ... nstall.php

Tanja64 · Beitrag von **Tanja64** » 20.03.2006 09:27

und in der Datei ist:

<?php
define('IN_PHPBB', 1);
$phpbb_root_path = './';
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);

// 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 !';
}
}
?>

Beitrag von **Dr.Death** » 20.03.2006 09:30

Die Datei

intro_portal_mod_db_install.php

gehört ins Forum Root ( da wo die viewtopic.php liegt ),
nicht ins admin/mods/IntroPortalMOD_V150/IntroPortalMOD_root

Tanja64 · Beitrag von **Tanja64** » 20.03.2006 09:34

olla, danke, ich probiere es sofort.

Tanja64 · Beitrag von **Tanja64** » 20.03.2006 09:41

hm...ich scheine irgendwo einen Gedankenfehler zu haben.
Ich habe die Datei nun ins Forum Root geladen. Aufgerufen und im Anschluss gelöscht.
Komme jetzt sogar in die Navigation im Adminbereich, erhalte bei Konfiguration allerdings immer noch:

phpBB : Kritischer Fehler

Could not query introportalmod information in admin_board

DEBUG MODE

SQL Error : 1146 Table 'd0029560.INTROPORTALMOD_TABLE' doesn't exist

SELECT * FROM INTROPORTALMOD_TABLE

Line : 73
File : admin_introportalmod.php

P.S. und

Critical Error

COPY FAILED: The target file to be copied [./mods/IntroPortalMOD_V150/IntroPortalMOD_root/intro_portal_mod_db_install.php] could not be found.
COPY IntroPortalMOD_root/intro_portal_mod_db_install.php TO intro_portal_mod_db_install.php
MOD script line #25 :: FAQ :: Report

das zeigt er mir jetzt noch an...ich scheine total zu verblöden...
wenn ich die intro_portal_mod_db_install.php hochgeladen und aufgerufen habe, muss sie doch wieder gelöscht werden, oder?