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