[Bug]Warning: mysql_fetch_assoc(): supplied argument

[cyberdaemon]

Im Adminbereich werden die Statistiken nicht angezeigt:

Code: Select all

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/html/phpmyfaq/inc/PMF_DB/Mysql.php on line 139

Die Bewertungen werden auch nicht berücksichtigt.

Code: Select all

EBUG INFORMATION:
pmf_currentuser->getuserbyid() in line 416:

SELECT
                        user_id,
                        login,
                        account_status
                    FROM
                        faquser
                    WHERE
                        user_id = 1


pmf_currentuser->getuserbyid() in line 416:

SELECT
                            pass
                        FROM
                            faquserlogin
                        WHERE
                            login = 'admin'


pmf_userdata->load() in line 331:

          SELECT
            last_modified, display_name, email
          FROM
            faquserdata
          WHERE
            user_id = 1


pmf_currentuser->getsessioninfo() in line 423:

            SELECT
                session_id,
                session_timestamp,
                ip
            FROM
                faquser
            WHERE
                user_id = 1


pmf_permbasic->getallrightsdata() in line 124:

SELECT
                        right_id,
                        name,
                        description,
                        for_users,
                        for_groups
                    FROM
                        faqright
                    ORDER BY
                        right_id ASC


pmf_permbasic->getuserrights() in line 309:

            SELECT
                faqright.right_id AS right_id
            FROM
                faqright,
                faquser_right,
                faquser
            WHERE
                faqright.right_id = faquser_right.right_id AND
                faquser.user_id   = 1 AND
                faquser.user_id   = faquser_right.user_id
        


pmf_category->getorderedcategories() in line 150:

            SELECT
                id, lang, parent_id, name, description
            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
                ( fu.user_id = -1
            OR
                fg.group_id IN (-1) ) AND ORDER BY id


COOKIES:
pmf_lang: de
pmf_sid: 1
pmf_auth_816ecbfe624c171a0f5ae54fb4cd8c84: db01d4a90d76cdff32f1f9cd2ead9bcf

TABLES & RECORDS:
faqadminlog: 1
faqadminsessions: 0
faqcaptcha: 0
faqcategories: 8
faqcategory_group: 9
faqcategory_user: 9
faqcategoryrelations: 1
faqchanges: 1
faqcomments: 0
faqconfig: 30
faqdata: 1
faqdata_group: 0
faqdata_revisions: 0
faqdata_tags: 0
faqdata_user: 1
faqglossary: 0
faqgroup: 0
faqgroup_right: 0
faqlinkverifyrules: 0
faqnews: 0
faqquestions: 0
faqright: 29
faqsessions: 1
faqtags: 0
faquser: 2
faquser_group: 0
faquser_right: 29
faquserdata: 2
faquserlogin: 2
faqvisits: 1
faqvoting: 0

[Thorsten]

Hi,

ist seit eben im CVS gefixt.

bye
Thorsten