Problem mit "Intro + Portal *EMC" - Mod

reinhardm · Beitrag von **reinhardm** » 18.03.2004 22:21

Hallo,
ich hab da ein Problem mit SQL 4.0.17.

Bei der Installation des IntroPortalMOD´s, wird die Installation an sich fertig gestellt, nur nicht im SQL. Dazu sollte man die Datei "intro_portal_mod_db_install.php" ausführen.
Ich bekomme da nur Fehlermeldungen und nix funzt

Ich würde jetzt ganz gerne mit Hilfe einer Datei die Datenbank befüllen, nur akteptiert meine SQL-Version den Code nicht, der in der Datei "intro_portal_mod_db_install.php" enthalten ist.
Kann mir da einer Helfen, und die datei so umstricken, damit ich es Manuell ins SQL einlesen kann?

Ich wäre Euch sehr dankbar

Der Code in der Datei "intro_portal_mod_db_install.php" lautet:

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

Beitrag von **Markus67** » 18.03.2004 22:27

hi reinhard ....

probiers es mal manuell mit phpmyadmin ...

sorry hatte den falschen code erwiwscht ....

kommt sofort ... moment

markus

Beitrag von **Markus67** » 18.03.2004 22:44

hi reinhard,

jetzt passt es ... hatte vorhin die falsche erwischt ...

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

reinhardm · Beitrag von **reinhardm** » 18.03.2004 23:24

Suuper danke, des hat gefunzt

Beitrag von **Markus67** » 18.03.2004 23:30

... kein thema

viel spass mit dem portal .... ist ein superteilchen und nur zum weiterempfehlen

markus

manne · Beitrag von **manne** » 19.03.2004 02:50

Hallo Markus

Möchte Dir auch noch danken für's machen und Posten des Dumps vor einigen Tagen. Damit hat's dann geklappt mit den Portal_Intro Tabellen.
Es steckt zwar irgendwo noch n Fehler drin, aber den werd ich auch noch finden.

gruesse
manne[/url]

Beitrag von **Markus67** » 19.03.2004 09:00

hi manne ...

was für einen fehler hast du denn ?

markus

Sephice · Beitrag von **Sephice** » 06.06.2004 18:36

Hab den Code auch per phpmyadmin eingefügt, aber ich kriegs einfach net gelaufen. immer noch die gleiche Fehlermeldung ...

Code: Alles auswählen

phpBB : Kritischer Fehler 

Could not query database for theme info

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near '' at line 3

Kann wer da helfen?

Beitrag von **Markus67** » 06.06.2004 20:50

Hi ...

welches Template hast du denn installiert ?

Alle Dateien auch in das richtige Template hochgeladen ?

Markus

Sephice · Beitrag von **Sephice** » 06.06.2004 21:48

Ok, das Template ist KillThrill

Ich hab die daten auch kopiert, aber es scheint so, dass man das irgendwo anders umschreiben muss?

Weil das Portal ja auf SubSilver ausgelegt ist ...

Wenn du FTP Zugang brauchst, ich kann ihn dir auch gerne geben.
Oder auch den Datenbank Zugang.

phpBB.de

Problem mit "Intro + Portal *EMC" - Mod

Problem mit "Intro + Portal *EMC" - Mod

:(