SQLite does not is not supported

All about webserver configurations, PHP and databases.

Moderator: Thorsten

Post Reply
cemkaan
Posts: 3
Joined: Sun Apr 20, 2008 8:46 am

SQLite does not is not supported

Post by cemkaan » Sun Apr 20, 2008 9:03 am

Only phpMyFAQ 2.5.0-alpha installed with Sqlite database.
But it couldn't add FAQ. I think problem is about user id.
I modified sqlite database but non of these did not help. I deleted some "index keys" hoping that may be left join kind of queries will not require an unique content.
Of course , user id -1 is needed for security reasons but If it is the reason system not to work than we should consider to disable it.

Code: Select all

Administration of Records

Warning: sqlite_query() [function.sqlite-query]: columns category_id, user_id are not unique in /home/netles9/public_html/demo/phpmyfaq/inc/PMF_DB/Sqlite.php on line 84
The changes were saved successfully.
Automatic link verification result

No URLs compatible with link verifier feature found.
DEBUG INFORMATION:

            SELECT
                config_name, config_value
            FROM
                faqconfig


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


SELECT
                            pass
                        FROM
                            faquserlogin
                        WHERE
                            login = 'admin'


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


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


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


            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
        


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


SELECT
                            pass
                        FROM
                            faquserlogin
                        WHERE
                            login = 'admin'


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


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


SELECT max(id) AS current_id FROM faqadminlog


            SELECT
                user_id
            FROM
                faquserdata
            WHERE
                user_id = 1


INSERT INTO
                    faqadminlog
                    (id, time, usr, text, ip)
                VALUES (1, 1208678191, 1, 'Beitragcreatesave', '85.30.220.19')


            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
                fc.lang = 'en'
            GROUP BY
                fc.id, fc.lang, fc.parent_id, fc.name, fc.description, fc.user_id
            ORDER BY
                fc.id


SELECT max(id) AS current_id FROM faqdata


            SELECT
                MAX(solution_id) AS solution_id
            FROM
                faqdata


INSERT INTO
                faqdata
            VALUES
                (1, 'en', 1000, 0, 'no', '', 'am', 'amcccıııı
', 'kaan', 'cemkaan@gmail.com', 'n', '20080420025632', '', 0, '00010101000000', '99991231235959')


SELECT max(id) AS current_id FROM faqchanges


INSERT INTO
                faqchanges
            (id, beitrag, lang, revision_id, usr, datum, what)
                VALUES
            (1, 1, 'en', 0, 1, 1208678192, '')


INSERT INTO
                faqvisits
            VALUES
                (1, 'en', 1, 1208678192)


INSERT INTO
                    faqcategoryrelations
                VALUES
                    (1, 'en', 1, 'en')


            INSERT INTO
                faqdata_user
            (record_id, user_id)
                VALUES
            (1, -1)


                INSERT INTO
                    faqcategory_user
                (category_id, user_id)
                    VALUES
                (1, -1)


COOKIES:
pmf_sid: 1
coppermine_data: YTo0OntzOjI6IklEIjtzOjMyOiIzYzU3Yzg1ZjNmMWVmYzBkNjA2NTc4ZDcyYWZjNGMzOSI7czoyOiJhbSI7aToxO3M6NDoibGFuZyI7czo3OiJ0dXJraXNoIjtzOjM6ImxpdiI7YTozOntpOjA7czozOiIxMTEiO2k6MTtzOjM6IjEyOSI7aToyO3M6MzoiMTM1Ijt9fQ==
cdfe23eb395021e1e20440f412e03c95: 50eb7ad35c206b8ce111f453e8966f59
pmf_auth_: a68bb3523f92483eb4120413ab7a70f8

TABLES & RECORDS:
faqadminlog: 1
faqcaptcha: 0
faqcategories: 1
faqcategory_group: 1
faqcategory_user: 1
faqcategoryrelations: 1
faqchanges: 1
faqcomments: 0
faqconfig: 33
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

Post Reply