mysql version falsch? installation nicht möglich

All about webserver configurations, PHP and databases.

Moderator: Thorsten

Post Reply
sprinter
Posts: 49
Joined: Wed Mar 24, 2004 2:05 pm

mysql version falsch? installation nicht möglich

Post by sprinter »

Versuche auf dem Webserver ( von Strato) phpMyFAQ zu installieren gemäß Anleitung.
das Script bringt jedoch die Meldung, dass die Version 3.23.23 oder höher benötigt wird.!

Strato zeigt jedoch im Servicebereich an, dass die Version 4.012 installiert ist.
Der Support-Mitarbeiter hat dies auch bestätigt und mitgeteilt, es wären beide Datei-Version eingespielt.
der Aufruf der Datei info.php zeigt die Version 3.22.32 an

Kann mir jemand einen Tipp geben?
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

ändere mal in der install/installer.php folgende Funktion

Code: Select all

function mysql_check($version) {
    return version_check (mysql_get_client_info(), $version);
    }
in das hier:

Code: Select all

function mysql_check($version) {
    return version_check (mysql_get_server_info(), $version);
    }
Dann sollte es funktionieren.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
sprinter
Posts: 49
Joined: Wed Mar 24, 2004 2:05 pm

Aenderung durchgeführt - ohne Erfolg

Post by sprinter »

Bekomme jetzt folgende Meldung:

Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /mnt/ls1/05/328/00000001/htdocs/faq/install/installer.php on line 43

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /mnt/ls1/05/328/00000001/htdocs/faq/install/installer.php on line 43

Warning: MySQL: A link to the server could not be established in /mnt/ls1/05/328/00000001/htdocs/faq/install/installer.php on line 43

You need MySQL Version 3.23.23 or higher!
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

kopiere mal folgendes in deine installer.php:

Code: Select all

<?php
/******************************************************************************
 * Author:				Thorsten Rinne ~ thorsten@rinne.info
 * Date:				2002-08-20
 * Last Update:			2004-03-02
 * Copyright:           (c) 2001-2004 Thorsten Rinne
 * 
 * The contents of this file are subject to the Mozilla Public License
 * Version 1.1 (the "License"); you may not use this file except in
 * compliance with the License. You may obtain a copy of the License at
 * http://www.mozilla.org/MPL/
 * 
 * Software distributed under the License is distributed on an "AS IS"
 * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
 * License for the specific language governing rights and limitations
 * under the License.
 */

$VERSION	= "1.3.11 RC3";
$COPYRIGHT	= "&copy; 2001-2004 <a href=\"http://www.phpmyfaq.de/\" target=\"_blank\">phpMyFAQ-Team</a> | All rights reserved.";

function version_check ($ist = "", $soll = "", $err_msg = "") {
    if (empty($ist) OR empty($soll)) {
        return FALSE;
        }
    $ist = explode(".", $ist);
    $soll = explode(".", $soll);
    for ($i = 0; $i < count($soll); $i++) {
        if ($ist[$i] <  $soll[$i]) {
            return FALSE;
            }
        if ($ist[$i] == $soll[$i]) {
            continue;
            }
        if ($ist[$i] >= $soll[$i]) {
            return TRUE;
            }
        }
    return TRUE;
    }

function php_check($version) {
    return version_check (phpversion(), $version);
    }

function uninstall() {
	global $uninst, $conn_id;
	while ($each_query = each($uninst)) {
		$result = mysql_query($each_query[1]);
		}
	}

function HTMLFooter() {
	print "<p align=\"center\">&copy; 2001 - 2003 <a href=\"http://www.phpmyfaq.de/\" target=\"_blank\">phpMyFAQ-Team</a> | All rights reserved.</p>\n</body>\n</html>";
	}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
    <title>phpMyFAQ <?php print $VERSION; ?> Installation</title>
	<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
    <style type="text/css">
    <!--
    body { background-color: #999999; }
	p, div, td { color: #000000; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 11px; }
    .button { background-color: #778899; border: 1px solid #000000; color: #ffffff; }
	.big { color: #000000; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 18px; }
	.middle  { color: #000000; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 14px; }
	.input { background-color: #ffffff; border: 1px solid #000000; color: #000000; }
	.help { cursor: help; border-bottom: 1px dotted Black; font-size: 14px; font-weight: bold; }
    -->
    </style>
</head>
<body>
<?php
if (!is_writeable("../inc/data.php")) {
	print "<p align=\"center\">The file ../inc/data.php or the directory ../inc is not writeable.</p>";
	HTMLFooter();
	die();
	}
if (!is_writeable("../inc/config.php")) {
	print "<p align=\"center\">The file ../inc/config.php is not writeable.</p>";
	HTMLFooter();
	die();
	}
if (!is_dir("../attachments")) {
    if (!mkdir ("../attachments", 0755)) {
        print "<p class=\"center\">The directory ../attachments could not be created.</p>";
	    HTMLFooter();
	    die();
        }
    }
if (!is_dir("../pdf")) {
    if (!mkdir ("../pdf", 0755)) {
        print "<p class=\"center\">The directory ../pdf could not be created.</p>";
	    HTMLFooter();
	    die();
        }
    }
if (!is_writeable("../attachments")) {
	print "<p align=\"center\">The directory ../attachments is not writeable.</p>";
	HTMLFooter();
	die();
	}
if (!is_writeable("../data")) {
	print "<p align=\"center\">The directory ../data is not writeable.</p>";
	HTMLFooter();
	die();
	}
if (!is_writeable("../pdf")) {
	print "<p align=\"center\">The directory ../pdf is not writeable.</p>";
	HTMLFooter();
	die();
	}
if (!is_writeable("../xml")) {
	print "<p align=\"center\">The directory ../xml is not writeable.</p>";
	HTMLFooter();
	die();
	}
if (php_check("4.1.0") == FALSE) {
	print "<p align=\"center\">You need PHP Version 4.1.0 or higher!</p>";
	HTMLFooter();
	die();
	}
if (!isset($_POST["mysql_server"]) AND !isset($_POST["mysql_user"]) AND !isset($_POST["mysql_db"])) {
?>

<table width="750" border="0" cellspacing="0" cellpadding="0" align="center" style="border: 2px solid black; background-color: #b0c4de;">
<tr>
	<td align="center">
	<img src="../images/header.jpg" width="750" height="60" alt="" border="0">
	<h1>phpMyFAQ <?php print $VERSION; ?> Installation</h1>
	<p>Your PHP version: <b><?php print phpversion(); ?></b> / Your MySQL client version: <b><?php print mysql_get_client_info(); ?></b></p>
	<p>You should read the documentation carefully before installing phpMyFAQ.</p>
	</td>
</tr>
<tr>
	<td align="center">
	<form action="<?php print $_SERVER["PHP_SELF"]; ?>" method="post">
	<fieldset style="border: 1px solid black; width: 500px;">
	<legend style="border: 1px solid black; background-color: #cccccc; padding: 4px 4px 4px 4px;"><b>MySQL access information</b></legend>
	<table cellspacing="2" cellpadding="2" border="0" width="500" align="center">
	<tr>
		<td align="right" width="150">MySQL server:&nbsp;</td>
		<td><input class="input" style="width: 200px;" type="text" name="mysql_server" value="localhost">&nbsp;<span class="help" title="Please enter the host of your MySQL server here.">?</span></td>
	</tr>
	<tr>
		<td align="right" width="150">MySQL username:&nbsp;</td>
		<td><input class="input" style="width: 200px;" type="text" name="mysql_user" value="root">&nbsp;<span class="help" title="Please enter your MySQL username here.">?</span></td>
	</tr>
	<tr>
		<td align="right" width="150">MySQL password:&nbsp;</td>
		<td><input class="input" style="width: 200px;" name="mysql_passwort" type="PASSWORD">&nbsp;<span class="help" title="Please enter your MySQL password here.">?</span></td>
	</tr>
	<tr>
		<td align="right" width="150">MySQL database:&nbsp;</td>
		<td><input class="input" style="width: 200px;" type="text" name="mysql_db" value="faq">&nbsp;<span class="help" title="Please enter your MySQL database here.">?</span></td>
	</tr>
	<tr>
		<td align="right" width="150">Table prefix:&nbsp;</td>
		<td><input class="input" style="width: 200px;" type="text" name="sqltblpre" value="">&nbsp;<span class="help" title="Please enter a table prefix here if you want to install more phpMyFAQ installations on one database.">?</span></td>
	</tr>
	</table>
	</fieldset>
	<br>&nbsp;<br>
	<fieldset style="border: 1px solid black; width: 500px;">
	<legend style="border: 1px solid black; background-color: #cccccc; padding: 4px 4px 4px 4px;"><b>phpMyFAQ options</b></legend>
	<table cellspacing="2" cellpadding="2" border="0" width="500" align="center">
	<tr>
		<td align="right" width="150">Default language:&nbsp;</td>
		<td><select class="input" style="width: 200px;" name="language" size="1">
<?php
	if ($dir = @opendir("../lang")) {
		while ($dat = @readdir($dir)) {
			if (substr($dat, -4) == ".php") {
				print "\t\t<option value=\"".$dat."\"";
				if ($dat == "english.php") {
					print " selected";
					}
				print ">".str_replace(".php", "", $dat)."</option>\n";
				}
			}
		}
	else {
		print "\t\t<option>english</option>";
		}
?>
			</select>&nbsp;<span class="help" title="Please select your default language.">?</span></td>
	</tr>
	<tr>
		<td align="right" width="150">Admins real name:&nbsp;</td>
		<td><input class="input" style="width: 200px;" type="text" name="realname">&nbsp;<span class="help" title="Please enter your real name here.">?</span></td>
	</tr>
	<tr>
		<td align="right" width="150">Admin email adress:&nbsp;</td>
		<td><input class="input" style="width: 200px;" type="text" name="email">&nbsp;<span class="help" title="Please enter your email adress here.">?</span></td>
	</tr>
	<tr>
		<td align="right" width="150">Admin password:&nbsp;</td>
		<td><input class="input" style="width: 200px;" type="password" name="password">&nbsp;<span class="help" title="Please enter your password for the admin area.">?</span></td>
	</tr>
	<tr>
		<td align="right" width="150">Retype password:&nbsp;</td>
		<td><input class="input" style="width: 200px;" type="password" name="password_retyped">&nbsp;<span class="help" title="Please retype your password for checkup.">?</span></td>
	</tr>
	</table>
	</fieldset>
	<br>
	<table cellspacing="2" cellpadding="2" border="0" width="500" align="center">
	<tr>
		<td colspan="2" align="center" height="30"><p class="middle" align="center"><b>Do not use if you're already running a version of phpMyFAQ!</b></p></td>
	</tr>
	<tr>
		<td colspan="2" align="center" height="40"><input type="submit" value="Install phpMyFAQ" class="button"></td>
	</tr>
	</table>
	
	</form>
	</td>
</tr>
</table>

<?php
	}
else {
?>
<table width="750" border="0" cellspacing="0" cellpadding="0" align="center" style="border: 1px solid black; background-color: #b0c4de;">
<tr>
	<td colspan="2" align="center"><img src="../images/header.jpg" width="750" height="60" alt="" border="0"></td>
</tr>
<tr>
<?php
	$password		  = $_REQUEST["password"];
	$password_retyped = $_REQUEST["password_retyped"];
	
	if ($password == "" || $password_retyped == "") {
		print "<td>\n<p style=\"color: #ff0000;\"><b>Error:</b></p>\n<p>Your password or retyped password are empty. Please set your password and your retyped password.\n</td>\n";
		print "</tr>\n</table>\n</td>\n</tr>\n</table>\n<p align=\"center\">".$COPYRIGHT."</p>\n</body>\n</html>";
		die();
		}
	
	if (strlen($password) < 7 || strlen($password_retyped) < 7) {
		print "<td>\n<p style=\"color: #ff0000;\"><b>Error:</b></p>\n<p>Your password and retyped password are too short. Please set your password and your retyped password with a minimum of 6 characters.\n</td>\n";
		print "</tr>\n</table>\n</td>\n</tr>\n</table>\n<p align=\"center\">".$COPYRIGHT."</p>\n</body>\n</html>";
		die();
		}
	
	if ($password != $password_retyped) {
		print "<td>\n<p style=\"color: #ff0000;\"><b>Error:</b></p>\n<p>Your password and retyped password are not equal. Please check your password and your retyped password.\n</td>\n";
		print "</tr>\n</table>\n</td>\n</tr>\n</table>\n<p align=\"center\">".$COPYRIGHT."</p>\n</body>\n</html>";
		die();
		}
	
	$mysql_server		= $_REQUEST["mysql_server"];
	$mysql_user			= $_REQUEST["mysql_user"];
	$mysql_passwort		= $_REQUEST["mysql_passwort"];
	$mysql_db			= $_REQUEST["mysql_db"];
	
	if (!($conn_id = @mysql_connect($mysql_server, $mysql_user, $mysql_passwort))) {
		print "<td>\n<p style=\"color: #ff0000;\"><b>Error:</b></p>\n<p>No connection to the MySQL server could be created. Please check your input for:</p>\n<ul>\n<li>MySQL Server</li>\n<li>MySQL username</li>\n<li>MySQL password</li>\n</ul>\n</td>\n";
		print "</tr>\n</table>\n</td>\n</tr>\n</table>\n<p align=\"center\">".$COPYRIGHT."</p>\n</body>\n</html>";
		die();
		}
	if (!@mysql_select_db($mysql_db)) {
        print "<td>\n<p style=\"color: #ff0000;\"><b>Error:</b></p>\n<p>No connection to the database <i>".$mysql_db."</i> could be created. Please check your input for:</p>\n<ul>\n<li>MySQL database</li>\n</ul>\n<p>MySQL error: ".mysql_error()."</p>\n</td>\n";
        print "</tr>\n</table>\n</td>\n</tr>\n</table>\n<p align=\"center\">".$COPYRIGHT."</p>\n</body>\n</html>";
        die();
		}
	
	$sqltblpre = $_REQUEST["sqltblpre"];
	$language = $_REQUEST["language"];
	
	/* Tabellenstruktur für das Logging im Adminbereich */
	$query[] = "CREATE TABLE ".$sqltblpre."faqadminlog (
	id int(11) NOT NULL auto_increment,
	time int(11) NOT NULL,
	user int(11) NOT NULL,
	text text NOT NULL,
	ip text NOT NULL,
	PRIMARY KEY (id))";
	$uninst[] = "DROP TABLE ".$sqltblpre."faqadminlog";
	
	/* Tabellenstruktur für die Sessions im Adminbereich */
	$query[] = "CREATE TABLE ".$sqltblpre."faqadminsessions (
	uin varchar(50) BINARY NOT NULL,
	user tinytext NOT NULL,
	pass varchar(64) BINARY NOT NULL,
	ip text NOT NULL,
	time int(11) NOT NULL)";
	$uninst[] = "DROP TABLE ".$sqltblpre."faqadminsessions";
	
	/* Tabellenstruktur für das Logging der Änderungen der Artikel */
	$query[] = "CREATE TABLE ".$sqltblpre."faqchanges (
	id int(11) NOT NULL auto_increment,
	beitrag int(11) NOT NULL,
	lang varchar(5) NOT NULL,
	user int(11) NOT NULL,
	datum int(11) NOT NULL,
	what text NOT NULL,
	PRIMARY KEY (id))";
	$uninst[] = "DROP TABLE ".$sqltblpre."faqchanges";
	
	/* Tabellenstruktur für die Kommentare */
	$query[] = "CREATE TABLE ".$sqltblpre."faqcomments (
	id_comment int(11) NOT NULL auto_increment,
	id int(11) NOT NULL,
	user varchar(255) NOT NULL,
	email varchar(255) NOT NULL,
	comment text NOT NULL,
	datum int(15) NOT NULL,
	helped text NOT NULL,
	PRIMARY KEY (id_comment))";
	$uninst[] = "DROP TABLE ".$sqltblpre."faqcomments";
	
	/* Tabellenstruktur für die offenen Fragen */
	$query[] = "CREATE TABLE ".$sqltblpre."faqfragen (
	id int(11) unsigned NOT NULL auto_increment,
	ask_username varchar(100) NOT NULL,
	ask_usermail varchar(100) NOT NULL,
	ask_rubrik varchar(100) NOT NULL,
	ask_content text NOT NULL,
	ask_date varchar(20) NOT NULL,
	PRIMARY KEY (id))";
	$uninst[] = "DROP TABLE ".$sqltblpre."faqfragen";
	
	/* Tabellenstruktur für die News in der FAQ */
	$query[] = "CREATE TABLE ".$sqltblpre."faqnews (
	id int(11) NOT NULL auto_increment,
	header varchar(255) NOT NULL,
	artikel text NOT NULL,
	datum varchar(14) NOT NULL,
	link varchar(255) NOT NULL,
	linktitel varchar(255) NOT NULL,
	target varchar(255) NOT NULL,
	PRIMARY KEY (id))";
	$uninst[] = "DROP TABLE ".$sqltblpre."faqnews";
	
	/* Tabellenstruktur für die Rubriken der FAQ */
	$query[] = "CREATE TABLE ".$sqltblpre."faqrubrik (
	id int(11) unsigned NOT NULL auto_increment,
	rubrik text NOT NULL,
	titel char(255) NOT NULL,
	datum char(20) NOT NULL,
	PRIMARY KEY (id))";
	$uninst[] = "DROP TABLE ".$sqltblpre."faqrubrik";
	
	/* Tabellenstruktur für die Votings der Artikel */
	$query[] = "CREATE TABLE ".$sqltblpre."faqvoting (
	id int(11) unsigned NOT NULL auto_increment,
	artikel int(11) unsigned NOT NULL,
	vote int(11) unsigned NOT NULL,
	user int(11) unsigned NOT NULL,
	datum varchar(20) NOT NULL default '',
	ip varchar(15) NOT NULL default '',
	PRIMARY KEY (id))";
	$uninst[] = "DROP TABLE ".$sqltblpre."faqvoting";
	
	/* Tabellenstruktur für die Rechtevergabe im Adminbereich */
	$query[] = "CREATE TABLE ".$sqltblpre."faqrights (
	id int(11) NOT NULL auto_increment,
	short text NOT NULL,
	name text NOT NULL,
	PRIMARY KEY (id))";
	$uninst[] = "DROP TABLE ".$sqltblpre."faqrights";
	
	/* Tabellenstruktur für die User-Sessions */
	$query[] = "CREATE TABLE ".$sqltblpre."faqsessions (
	sid int(11) NOT NULL auto_increment,
	ip text NOT NULL,
	time int(11) NOT NULL,
	PRIMARY KEY sid (sid))";
	$uninst[] = "DROP TABLE ".$sqltblpre."faqsessions";
	
	/* Tabellenstruktur für die Statistik */
	$query[] = "CREATE TABLE ".$sqltblpre."faqstatistik (
	id int(2) NOT NULL auto_increment,
	shortn text NOT NULL,
	longn text NOT NULL,
	param text NOT NULL,
	PRIMARY KEY (id))";
	$uninst[] = "DROP TABLE ".$sqltblpre."faqstatistik";
	
	/* Tabellenstruktur für die Artikeldaten */
	$query[] = "CREATE TABLE ".$sqltblpre."faqdata (
	id int(11) NOT NULL auto_increment,
	lang varchar(5) NOT NULL,
	active char(3) NOT NULL,
	rubrik text NOT NULL,
	keywords text NOT NULL,
	thema text NOT NULL,
	content text NOT NULL,
	author varchar(255) NOT NULL,
	email varchar(255) NOT NULL,
	comment enum('y','n') NOT NULL default 'y',
	datum varchar(15) NOT NULL,
	FULLTEXT (keywords,thema,content),
	PRIMARY KEY (id, lang))";
	$uninst[] = "DROP TABLE ".$sqltblpre."faqdata";
	
	/* Tabellenstruktur für die Visits der einzelnen Artikel */
	$query[] = "CREATE TABLE ".$sqltblpre."faqvisits (
	id int(11) NOT NULL auto_increment,
	lang varchar(5) NOT NULL,
	visits int(11) NOT NULL,
	last_visit int(15) NOT NULL,
	PRIMARY KEY (id, lang))";
	$uninst[] = "DROP TABLE ".$sqltblpre."faqvisits";
	
	/* Tabellenstruktur für die User im Adminbereich */
	$query[] = "CREATE TABLE ".$sqltblpre."faquser (
	id int(2) NOT NULL auto_increment,
	name text NOT NULL,
	pass varchar(64) BINARY NOT NULL,
	realname varchar(255) NOT NULL default '',
	email varchar(255) NOT NULL default '',
	rights text NOT NULL,
	PRIMARY KEY (id))";
	$uninst[] = "DROP TABLE ".$sqltblpre."faquser";
	
	/* Tabelleninhalte für die Rechtevergabe und die Statistik */
	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (1,'adduser','Benutzer hinzufügen')";
	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (2,'edituser','Benutzer editieren')";
	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (3,'deluser','Benutzer löschen')";
	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (4,'addbt','Beitrag hinzufügen')";
	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (5,'editbt','Beitrag editieren')";
	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (6,'delbt','Beitrag löschen')";
	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (7,'viewlog','Log ansehen')";
	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (8,'adminlog','Adminlog einsehen')";

	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (9,'delcomment','Kommentar löschen')";
	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (10,'addnews','News hinzufügen')";
	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (11,'editnews','News editieren')";
	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (12,'delnews','News löschen')";
	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (13,'addcateg','Kategorie hinzufügen')";
	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (14,'editcateg','Kategorie editeren')";
	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (15,'delcateg','Kategorie löschen')";
	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (16,'passwd','Kennwort ändern')";
	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (17,'editconfig','Konfiguration editieren')";
	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (18,'addatt','Attachments anfügen')";
	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (19,'delatt','Attachment löschen')";
	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (20,'backup','Sicherung erstellen')";
	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (21,'restore','Sicherung wiederherstellen')";
	$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (22,'delquestion','Offene Fragen löschen')";
	
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (1,'mainpage','Hauptseite','')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (2,'overview','Rubrikübersicht','')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (3,'rubrikview','Rubrikanzeige','Rubrik')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (4,'artikelview','Artikelanzeige','Artikel')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (5,'searchpage','Suchseite','')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (6,'searchresult','Suchergebnis','Suchbegriffe')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (7,'savenewentry','Eintrag speichern','')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (8,'entrypflichfeldfehler','Eintrag Pflichfeldfehler','')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (9,'commentpage','Kommentarseite','Artikel')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (10,'commentsave','Kommantarspeicherung','Artikel')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (11,'commentpflichtfeldfehler','Kommentarspeicherung Pflichtfeldfehler','Artikel')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (12,'newentrypage','Eintrageseite','')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (13,'faqhelp','Faq Hilfeseite','')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (14,'contact','Faq Kontaktseite','')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (16,'savevoting','Bewertung abgegeben','Artikel')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (17,'savevotingerror','Votingabgabe verhindert','Artikel')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (18,'oldSession','Alte Session, aber neue IP','Session-ID')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (19,'frage','Seite zum Fragestellen','')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (20,'xml','XML-Ausgabe erstellt','XML-Output')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (21,'antworten','Antwortseite','')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (22,'frageabsenden','Frage absenden','')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (23,'sendmail','FAQ Kontaktseite','')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (24,'fragen','Frage stellen Formular','')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (25,'NewSession','Neue Session','')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (26,'send2friend','FAQ weiterempfohlen','')";
	$query[] = "INSERT INTO ".$sqltblpre."faqstatistik VALUES (27, 's2fmail', 'FAQ Empfehlung versendet', '')";
	
	$realname			= $_REQUEST["realname"];
	$email				= $_REQUEST["email"];
	
	$query[] = "INSERT INTO ".$sqltblpre."faquser (id, name, pass, realname, email, rights) VALUES (1, 'admin', MD5('".$password."'), '".$realname."', '".$email."', '1111111111111111111111')";
	
	print "<td>";
    flush();
	
	print "<p align=\"center\"><b>";
	while ($each_query = each($query)) {
		$result = @mysql_query($each_query[1]);
		print "|";
		flush();
		if (!$result) {
			print "<!-- ".$each_query[1]." --><br><h3 style=\"color: red;\">Attention!</h3><p>An error occured! Please install your version of phpMyFAQ once again or send us a <a href=\"http://www.phpmyfaq.de/bugtraq.php\" target=\"_blank\">bug report</a>.</p>";
            print "<p>Error: ".mysql_error()."</p>";
            print "</td>";
            print "</tr>\n</table>\n</td>\n</tr>\n</table>\n<p align=\"center\">".$COPYRIGHT."</p>\n</body>\n</html>";
			uninstall();
			die();
			}
		}
	print "</b></p>\n";
	
	print "<p align=\"center\">All tables were created and filled with the data.</p>\n";
	print "<h3 align=\"center\">The SQL tables were created successfully.</h3>\n";
	print "<p align=\"center\">Now the configuration will be written ...</p>\n";
	
	if($fp = @fopen("../inc/data.php","w")) {
		fputs($fp,"<?php\n\$mysql_server = '".$mysql_server."';\n\$mysql_user = '".$mysql_user."';\n\$mysql_passwort = '".$mysql_passwort."';\n\$mysql_db = '".$mysql_db."';\n?>");
		fclose ($fp);
		}
	else {
		print "<p>Cannot write to data.php.</p></td>";
        print "</tr>\n</table>\n</td>\n</tr>\n</table>\n<p align=\"center\">".$COPYRIGHT."</p>\n</body>\n</html>";
		uninstall();
		die();
		}
	
	if ($fp = @fopen("../inc/config.php","r")) {
		$anz = 0;
		while($dat = fgets($fp,1024)) {
			$anz++;
			$inp[$anz] = $dat;
			}
		@fclose($fp);
		
		for ($h = 1; $h <= $anz; $h++) {
			if (str_replace("\$sprache = \"english.php\";", "", $inp[$h]) != $inp[$h]) {
				$inp[$h] = "\$sprache = \"".$language."\";\n";
				}
			if (str_replace("\$sqltblpre", "", $inp[$h]) != $inp[$h]) {
				$inp[$h] = "\$sqltblpre = \"$sqltblpre\";\n";
				}
			}
		
		if ($fp = @fopen("../inc/config.php","w")) {
			for ($h = 1; $h <= $anz; $h++) {
				fputs($fp,$inp[$h]);
				}
			@fclose($fp);
			print "<h1 align=\"center\">Installation successful!</h1>\n";
			print "<p align=\"center\"><a href=\"../index.php\">Go to your phpMyFAQ</a></p>\n";
			}
		else {
			print "<p>Cannot write to config.php.</p></td>";
        	print "</tr>\n</table>\n</td>\n</tr>\n</table>\n<p align=\"center\">".$COPYRIGHT."</p>\n</body>\n</html>";
			uninstall();
			die();
			}
		}	
	else {
		print "<p>Cannot read config.php.</p></td>";
        print "</tr>\n</table>\n</td>\n</tr>\n</table>\n<p align=\"center\">".$COPYRIGHT."</p>\n</body>\n</html>";
		uninstall();
		die();
		}
	}
HTMLFooter();
?>
Dann sollte es funktionieren!

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
sprinter
Posts: 49
Joined: Wed Mar 24, 2004 2:05 pm

Danke!

Post by sprinter »

recht herzlichen Dank für die schnelle und kompetente Hilfe, jetzt hat die Installation funktioniert.

Nochmals Danke!
aabu
Posts: 7
Joined: Tue Aug 03, 2004 1:39 pm
Contact:

gleiches Problem

Post by aabu »

Funktioniert dieser Hinweis nach wie vor?
Das gleiche Problem habe ich auch.
Strato sagte, in absehbarer Zeit würde man mySQL endern. Nur ein Datum kann man nicht nennen :(
Warten geht aber nicht...
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

ja, aber der Hinweis gilt für die 1.3.x, du nutzt sicherlich die 1.4.x, oder?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
aabu
Posts: 7
Joined: Tue Aug 03, 2004 1:39 pm
Contact:

Das dachte ich mir...

Post by aabu »

Hallo Thorsten,

wie der Zufall es will, habe ich mir das schon lääängst gedacht. Dennoch, ich habe es auch ausprobiert. Die aktuelle Version geht nicht. Da ihr aber besser gearbeitet habt als strato kann ich eine der älteren Versionen nehmen. Upgraden sollte ja möglich sein wenn strato mal weiterkommt.

Ada (aabu)
aabu
Posts: 7
Joined: Tue Aug 03, 2004 1:39 pm
Contact:

sorry

Post by aabu »

Ach... vergesse noch das wichtigste!

Vielen, vielen Dank für diese super schnelle Antwort!!!

Ada
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

man kann das Problem aber auch in der 1.4 umgehen. :)

Wenn du willst, poste ich dir hier einen angepassten Installer.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Enay
Posts: 6
Joined: Wed Sep 29, 2004 8:02 am

Post by Enay »

hallo

ich möchte dann doch an dieser stelle darum bitten, das ganze auch für strato für version 1.4 zu posten und gleich noch die frage dranhängen, ob es irgendwelche funktionseinschränkungen dadurch gibt, dass strato nicht die passende php-version hat?

vielen dank im voraus

Enay
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

öffne mal mit einem Editor die install/installer.php und suche nach der Zeile mit

Code: Select all

if (mysql_check("3.23.23") == FALSE) {
und ändere die Versionsnummer in 3.22.22.

Einschränkungen gibts bei Strato meines Wissens nach nicht, da der MySQL-Server bei Version 4.0 ist.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Post Reply