Installation Problem ver. phpMyFAQ 1.6.1

[Tshunsh]

Hallo Leute,

ich habe wieder das Problem mit installieren unter Suse 10.1, setup läuft sauber durch ohne zu meckern, die Login Seite und die Hauptseite werden aufgerufen, Datenbank bleibt aber leer,
das heißt dass keine Tabellen angelegt werden, wie gesagt bei der Installation bekomme ich keine
Fehlermeldungen nur im Apache-Log steht folgendes:

Code: Select all

Sat Jun 03 00:43:20 2006] [error] [client 127.0.0.1] PHP Warning:  mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/myfaq/inc/mysql.php on line 312, referer: http://localhost/myfaq/install/update.php?step=5
[Sat Jun 03 00:43:20 2006] [error] [client 127.0.0.1] PHP Warning:  mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/myfaq/inc/mysql.php on line 162, referer: http://localhost/myfaq/install/update.php?step=5
[Sat Jun 03 00:43:20 2006] [error] [client 127.0.0.1] PHP Warning:  mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/myfaq/inc/mysql.php on line 144, referer: http://localhost/myfaq/install/update.php?step=5
[Sat Jun 03 00:43:20 2006] [error] [client 127.0.0.1] PHP Notice:  Trying to get property of non-object in /srv/www/htdocs/myfaq/inc/functions.php on line 823, referer: http://localhost/myfaq/install/update.php?step=5
[Sat Jun 03 00:43:20 2006] [error] [client 127.0.0.1] PHP Warning:  mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/myfaq/inc/mysql.php on line 144, referer: http://localhost/myfaq/install/update.php?step=5
[Sat Jun 03 00:43:20 2006] [error] [client 127.0.0.1] PHP Warning:  mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/myfaq/inc/mysql.php on line 144, referer: http://localhost/myfaq/install/update.php?step=5
[Sat Jun 03 00:43:20 2006] [error] [client 127.0.0.1] PHP Warning:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/myfaq/inc/mysql.php on line 176, referer: http://localhost/myfaq/install/update.php?step=5

Mein System:

Linux Suse 10.1
PHP Version 5.1.2
Apache/2.2.0 (Linux/SUSE)
MySQL version: 5.0.18

[Thorsten]

Hi,

hast du eine DB für phpMyFAQ erstellt? Darf der DB-User dort Tabellen erstellen?

bye
Thorsten

[Tshunsh]

Hallo Thorsten,

das Thema Datenbank und Berechtigungen haben wir doch schon,
natürlich existiert ein DB und der User hat volle Rechte drauf, per Hand oder per phpMyAdmin kann ich alles mit DB machen. Das Skript erstellt einfach keine Tabellen im DB und macht dabei gar keine Fehlermeldung, sagt das aller soweit in Ordnung ist und dass man los kann legen. Gipst es so was wie Debug-Modus oder kann ich vielleicht die Tabellen per Hand erstellen?

mfg Tshunsh

[matteo]

Hi,

Code: Select all

Sat Jun 03 00:43:20 2006] [error] [client 127.0.0.1] PHP Warning:  mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/myfaq/inc/mysql.php on line 312, referer: http://localhost/myfaq/install/update.php?step=5

Mein System:

Linux Suse 10.1
PHP Version 5.1.2
Apache/2.2.0 (Linux/SUSE)
MySQL version: 5.0.18

I'm actually not able to reproduce the error 'cause I miss a system like yours, so find below some notes:

1. try to do a fresh PMF 1.6.1 install to see IF PHP 5.1.2+MySQL 5.0.18 could be the issue (I don't think Apache 2.2 as an issue);
2. From your code quotation I've seen you're updating PMF from 1.? to 1.6.1 coming from a MySQL < 4.1.x: this info is taken from your using inc/mysql.php instead of inc/mysqli.php. Please take a look to your inc/data.php at $DB["type"]. Can you confirm that the old PMF 1.? was running on a different DB server, MySQL < 4.1.x?

PS: FYI, read here

[Leaf]

Hi,

1. try to do a fresh PMF 1.6.1 install to see IF PHP 5.1.2+MySQL 5.0.18 could be the issue (I don't think Apache 2.2 as an issue);
2. From your code quotation I've seen you're updating PMF from 1.? to 1.6.1 coming from a MySQL < 4.1.x: this info is taken from your using inc/mysql.php instead of inc/mysqli.php. Please take a look to your inc/data.php at $DB["type"]. Can you confirm that the old PMF 1.? was running on a different DB server, MySQL < 4.1.x?

I've tried the steps you recommend, and now I see this when I load my FAQ webpage:

Fatal error: Class 'mysqli' not found in /var/www/phpMyFAQ/inc/mysqli.php on line 72

EDIT

New/updated information and for those running Debian.

mysqli is not in Debian yet.

http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=344817
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=320835

Work around (solution?) can be found in bug # 320835

http://bugs.debian.org/cgi-bin/bugrepor ... 835;msg=55

[matteo]

Hi,
unfortunately I've no Suse Server for directly helping you:

1. is using a different MySQL version an option?
2. have you tried this PEAR package?