[Bug]Warning: mysql_fetch_assoc(): supplied argument

Please report bugs here!

Moderator: Thorsten

Post Reply
cyberdaemon
Posts: 28
Joined: Thu Feb 22, 2007 10:44 am

[Bug]Warning: mysql_fetch_assoc(): supplied argument

Post by cyberdaemon »

Im Adminbereich wird folgende Fehlermeldung angezeigt wenn der Link FAQ bearbeiten angeklickt wird:

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

Code: Select all

DEBUG 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_currentuser->updatesessionid() in line 434:

UPDATE
                        faquser
                    SET
                        session_id          = '1ae7e11bf109742690710dfbf30975fc',
                        session_timestamp   = 1172569547,
                        
                        ip                  = '172.20.130.33'
                    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


pmf_comment->getnumberofcomments() in line 100:

            SELECT
                COUNT(id) AS anz,
                id 
            FROM 
                faqcomments
            GROUP BY id
            ORDER BY id


pmf_category->getcategoryrecordsmatrix() in line 106:

            SELECT
                faqcategoryrelations.category_id AS id_cat,
                faqdata.id AS id
            FROM
                faqdata
            INNER JOIN
                faqcategoryrelations
            ON
                faqdata.id = faqcategoryrelations.record_id
            AND
                faqdata.lang = faqcategoryrelations.category_lang
            ORDER BY
                faqcategoryrelations.category_id, faqdata.id


pmf_category->getnumberofrecordsofcategory() in line 116:

            SELECT
                fcr.category_id AS category_id,
                COUNT(fcr.record_id) AS number
            FROM
                faqcategoryrelations fcr, faqdata fd
            WHERE
                fcr.record_id = fd.id
            AND
                fcr.record_lang = fd.lang
            AND
                fd.active = 'yes'
            GROUP BY fcr.category_id


COOKIES:
pmf_lang: de
pmf_sid: 2
pmf_auth_816ecbfe624c171a0f5ae54fb4cd8c84: 921aa38fc5c547398da677191486cbdc
pmf_auth_false: edc4ffb29df7e09f4f40f47ec2bd0dbf

TABLES & RECORDS:
faqadminlog: 1
faqadminsessions: 0
faqcaptcha: 0
faqcategories: 8
faqcategory_group: 9
faqcategory_user: 10
faqcategoryrelations: 0
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: 1
faqquestions: 0
faqright: 29
faqsessions: 2
faqtags: 0
faquser: 2
faquser_group: 0
faquser_right: 29
faquserdata: 2
faquserlogin: 2
faqvisits: 1
faqvoting: 0
Ciao,

Christian

P.S. Der gleiche Fehler tritt bei FAQ freischalten auf.
Thorsten
Posts: 15725
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

beide Fehler sind im CVS gefixt.

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