Seite 2 von 2

Verfasst: 05.11.2006 00:45
von Santana
na hab i no keines bekommen sorry hab eines wo i hier fand dort ausgeführt aber dann bekam i fehlermeldung das die tabelle nit gefunden wird obwohl sie drinnen stand

hm hm

Verfasst: 05.11.2006 19:21
von Boecki91
Maron.Chatzifrantzis hat geschrieben:Vielleicht so?

In phpmyadmin manuell unter SQL folgende Befehle ausführen:

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

// DROP TABLE phpbb_introportalmodnav;

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

und was ist damit??
das in PHPmyadmin ausführen was da steht das meinte ich damit

Verfasst: 05.11.2006 22:47
von Santana
Vielen Herzlichen Dank

Verfasst: 08.11.2006 17:21
von bandwurm
hatte das gleiche Prblem aber bei mir macht mein php admin dann den Fehler hier
SQL-Befehl:

& lt ; ? phpdefine(
'IN_PHPBB', 1
)

MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<?php
define('IN_PHPBB', 1)' at line 1
wäre nett wenn mir jemand helfen könnte

Verfasst: 08.11.2006 17:36
von Santana
das sind 2 verschiedene tabellen nit nur eine
1.

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'); 
2.

Code: Alles auswählen

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);
so müßte es klappen

lg

Verfasst: 08.11.2006 17:49
von bandwurm
dankeschön genau jetzt hats geklappt

Verfasst: 08.11.2006 18:19
von Santana
bitte gerne doch

lg

Verfasst: 30.11.2006 16:51
von Median
So, ich hatte auch die Fehlermeldung wie der TO:

ich bekam die Meldung von Easymod bei Installationsschritt 3/3, dass einige Dateien, aus den Mod-Ordnern in die eigentlichen Forenordner bzw. direkt in den phpBB2/ Ordner verschoben wurden.

Mit Filezilla konnte ich diese Sachen allerdings nur an den Orten finden, von wo aus sie verschoben sein sollten.

Habe das dann einfach manuell gemacht.
Danach kam die eigentliche Fehlermeldung, als ich die "intro_portal_mod_db_install.php" ausführen wollte.

Nun habe ich in die SQL Tabellen eingefügt und das "Intro + Portal" scheint auch richtig installiet zu sein, nur habe ich jetzt kein einziges Mal die o.g. Datei ausgeführt :roll:

Was für Fehler erwarten mich denn jetzt... ?

Verfasst: 30.11.2006 17:46
von Santana
hm also i hab mit dem phpBB direkt keine ahnung hab des phpBB2 plus des hat alle mods drinnen man muß nix dazu machen außer leicht den newsletter mod den flashchat und den nickpage mod alles andere ist serienmäßig drinnen und funkt prima

lg