Fehlermeldung nach Login

[schmitz]

Hallo,

ich habe mir die aktuelle Version 2.5.4 runtergeladen und installiert. Klappte auch alles super. Sobald ich mich jetzt aber einlogge und eine Kategorie auswähle, bekomme ich folgende Fehlermeldung angezeigt:

Code: Select all

phpMyFAQ warning [2]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in Mysql.php on line 160

Dabei wird auch mein Layout ein wenig zerschossen. Kennt Ihr das Problem?

Gruß,
Mike

[Thorsten]

Hi,

uh... kannst du mal bitte in der inc/Init.php den DEBUG MODE aktivieren und dann die Ausgaben hier posten?

Danke!

bye
Thorsten

[schmitz]

Hallo Thorsten,

die Ausgabe sieht so aus:

Code: Select all

<pre> SELECT config_name, config_value FROM faqconfig</pre>
<br/>
<pre> SELECT user_id, login, account_status FROM faquser WHERE user_id = 1</pre>
<br/>
<pre> SELECT pass FROM faquserlogin WHERE login = 'admin'</pre>
<br/>
<pre> SELECT last_modified, display_name, email FROM faquserdata WHERE user_id = 1</pre>
<br/>
<pre> SELECT session_id, session_timestamp, ip FROM faquser WHERE user_id = 1</pre>
<br/>
<pre> SELECT right_id, name, description, for_users, for_groups FROM faqright ORDER BY right_id ASC</pre>
<br/>
<pre> SELECT fr.right_id AS right_id FROM faqright fr, faquser_right fur, faquser fu WHERE fr.right_id = fur.right_id AND fu.user_id = 1 AND fu.user_id = fur.user_id</pre>
<br/>
<pre> SELECT fr.right_id AS right_id FROM faqright fr, faqgroup_right fgr, faqgroup fg, faquser_group fug, faquser fu WHERE fu.user_id = 1 AND fu.user_id = fug.user_id AND fg.group_id = fug.group_id AND fg.group_id = fgr.group_id AND fr.right_id = fgr.right_id</pre>
<br/>
<pre> SELECT fg.group_id AS group_id FROM faquser fu, faquser_group fug, faqgroup fg WHERE fu.user_id = 1 AND fu.user_id = fug.user_id AND fg.group_id = fug.group_id</pre>
<br/>
<pre> SELECT sid FROM faqsessions WHERE sid = 40 AND ip = '213.240.180.205' AND time > 1259491653</pre>
<br/>
<pre> UPDATE faqsessions SET time = 1259578053, user_id = 1 WHERE sid = 40 AND ip = '213.240.180.205'</pre>
<br/>
<pre> SELECT fc.id AS id, fc.lang AS lang, fc.parent_id AS parent_id, fc.name AS name, fc.description AS description, fc.user_id AS user_id FROM faqcategories fc LEFT JOIN faqcategory_group fg ON fc.id = fg.category_id LEFT JOIN faqcategory_user fu ON fc.id = fu.category_id WHERE ( fg.group_id IN (-1, 2, 3) OR (fu.user_id = 1 AND fg.group_id IN (-1, 2, 3))) AND fc.lang = 'de' GROUP BY fc.id, fc.lang, fc.parent_id, fc.name, fc.description, fc.user_id ORDER BY fc.id</pre>
<br/>
<pre> SELECT COUNT(record_id) AS n FROM faqdata_tags</pre>
<br/>
<pre> SELECT count(sid) AS anonymous_users FROM faqsessions WHERE user_id = -1 AND time > 1259577753</pre>
<br/>
<pre> SELECT count(session_id) AS registered_users FROM faquser WHERE session_timestamp > 1259577753</pre>
<br/>
<pre> SELECT fd.id AS id, fd.lang AS lang, fd.thema AS thema, fcr.category_id AS category_id FROM faqdata fd LEFT JOIN faqcategoryrelations fcr ON fd.id = fcr.record_id AND fd.lang = fcr.record_lang LEFT JOIN faqdata_group AS fdg ON fd.id = fdg.record_id LEFT JOIN faqdata_user AS fdu ON fd.id = fdu.record_id WHERE fd.lang = 'de' AND fd.date_start <= '20091130114733' AND fd.date_end >= '20091130114733' AND fd.active = 'yes' AND fd.sticky = 1 AND ( fdg.group_id IN (-1, 2, 3) OR (fdu.user_id = 1 AND fdg.group_id IN (-1, 2, 3)))</pre>
<br/>
<br/>
<b>phpMyFAQ warning</b>
[2]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in
<b>/home/.sites/12/site127/web/inc/PMF_DB/Mysql.php</b>
on line
<b>160</b>


<div id="debug_main">
DEBUG INFORMATION:
<br/>
<pre> SELECT config_name, config_value FROM faqconfig</pre>
<br/>
<pre> SELECT user_id, login, account_status FROM faquser WHERE user_id = 1</pre>
<br/>
<pre> SELECT pass FROM faquserlogin WHERE login = 'admin'</pre>
<br/>
<pre> SELECT last_modified, display_name, email FROM faquserdata WHERE user_id = 1</pre>
<br/>
<pre> SELECT session_id, session_timestamp, ip FROM faquser WHERE user_id = 1</pre>
<br/>
<pre> SELECT right_id, name, description, for_users, for_groups FROM faqright ORDER BY right_id ASC</pre>
<br/>
<pre> SELECT fr.right_id AS right_id FROM faqright fr, faquser_right fur, faquser fu WHERE fr.right_id = fur.right_id AND fu.user_id = 1 AND fu.user_id = fur.user_id</pre>
<br/>
<pre> SELECT fr.right_id AS right_id FROM faqright fr, faqgroup_right fgr, faqgroup fg, faquser_group fug, faquser fu WHERE fu.user_id = 1 AND fu.user_id = fug.user_id AND fg.group_id = fug.group_id AND fg.group_id = fgr.group_id AND fr.right_id = fgr.right_id</pre>
<br/>
<pre> SELECT fg.group_id AS group_id FROM faquser fu, faquser_group fug, faqgroup fg WHERE fu.user_id = 1 AND fu.user_id = fug.user_id AND fg.group_id = fug.group_id</pre>
<br/>
<pre> SELECT sid FROM faqsessions WHERE sid = 40 AND ip = '213.240.180.205' AND time > 1259491653</pre>
<br/>
<pre> UPDATE faqsessions SET time = 1259578053, user_id = 1 WHERE sid = 40 AND ip = '213.240.180.205'</pre>
<br/>
<pre> SELECT fc.id AS id, fc.lang AS lang, fc.parent_id AS parent_id, fc.name AS name, fc.description AS description, fc.user_id AS user_id FROM faqcategories fc LEFT JOIN faqcategory_group fg ON fc.id = fg.category_id LEFT JOIN faqcategory_user fu ON fc.id = fu.category_id WHERE ( fg.group_id IN (-1, 2, 3) OR (fu.user_id = 1 AND fg.group_id IN (-1, 2, 3))) AND fc.lang = 'de' GROUP BY fc.id, fc.lang, fc.parent_id, fc.name, fc.description, fc.user_id ORDER BY fc.id</pre>
<br/>
<pre> SELECT COUNT(record_id) AS n FROM faqdata_tags</pre>
<br/>
<pre> SELECT count(sid) AS anonymous_users FROM faqsessions WHERE user_id = -1 AND time > 1259577753</pre>
<br/>
<pre> SELECT count(session_id) AS registered_users FROM faquser WHERE session_timestamp > 1259577753</pre>
<br/>
<pre> SELECT fd.id AS id, fd.lang AS lang, fd.thema AS thema, fcr.category_id AS category_id FROM faqdata fd LEFT JOIN faqcategoryrelations fcr ON fd.id = fcr.record_id AND fd.lang = fcr.record_lang LEFT JOIN faqdata_group AS fdg ON fd.id = fdg.record_id LEFT JOIN faqdata_user AS fdu ON fd.id = fdu.record_id WHERE fd.lang = 'de' AND fd.date_start <= '20091130114733' AND fd.date_end >= '20091130114733' AND fd.active = 'yes' AND fd.sticky = 1 AND ( fdg.group_id IN (-1, 2, 3) OR (fdu.user_id = 1 AND fdg.group_id IN (-1, 2, 3)))</pre>
<br/>

Kannst du damit was anfangen?

Vielen Dank. Mike

[schmitz]

Hallo Thorsten,

konntest du der Ausgabe etwas anfangen?

Gruß,
Mike

[Thorsten]

Hi,

leider nicht wirklich... Könntest du mir einen Dump deiner DB zukommen lassen?

bye
Thorsten

[schmitz]

Hi Thorsten,

hab dir ne Mail geschickt!

Gruß,
Mike

[Thorsten]

Hi Mike,

vielen Dank!

bye
Thorsten

[Thorsten]

Hi,

bei dir sind einige Werte in der faqconfig Tabelle nicht mehr korrekt. Führe mal die Queries aus:

Code: Select all

UPDATE faqconfig SET config_value = 'visits' WHERE config_name = 'records.orderby';
UPDATE faqconfig SET config_value = 'DESC' WHERE config_name = 'records.sortby';

Einige andere Werte stimmen auch nicht in der faqconfig, hast du da was händisch geändert?

bye
Thorsten

[schmitz]

Hallo Thorsten,

vielen Dank für die Hilfe. Die Fehlermeldung wird jetz nicht mehr angezeigt. Scheint also wieder alles zu laufen.
Händisch habe ich in der Tabelle allerdings nichts geändert.

Gruß,
Mike

[Thorsten]

Hi,

komisch... aber gut, dass es wieder klappt.

bye
Thorsten

[schmitz]

Hallo Thorsten,

ich richte das System zum Testen einfach nochmal bei mir auf dem Server ein.
Falls der Fehler nochmal auftreten sollte, sage ich dir Bescheid.

Gruß,
Mike

[Thorsten]

Hi,

das wäre klasse! Eventuell ist ja doch irgendwo ein Problem, dass ich übersehen habe.

bye
Thorsten