Danke für den Hinweis, hatte ich bereits vorher schon gelesen und beachtet. Die Daten in der Datei sind alle richtig - hilft folglich nicht weiter.
Ich habe auch die dbinformer.php benutzt und festgestellt, dass ich die DB nur auf MySQL 3x und 4x testen kann, ich benutze jedoch MySQL 5.0, kann dies ein Grund für den Fehler sein?
Aber davon einmal abgesehen, besteht die Möglichkeit die Datenbank Anweisungen aus der intro_portal_mod_db_install.php manuell in der DB via phpmyadmin auszuführen? Wie müssten die Anweisungen der Datei dann lauten? Anbei die originalen Anweisungen der Datei intro_portal_mod_db_install.php als Auszug von meinem Server:
Code: Alles auswählen
<?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 !';
}
}
?>
Übrigens, im Backend ist alles soweit in Ordnung, es wird wie zu erwarten war das ACP um "Intro + Portal" erweitert, bei Aufruf wird natürlich eine Fehlermeldung ausgegeben, dass die Tabellen nicht vorhanden sind (Was sie logischerweise auch nicht sein können).