svn phpMyFAQ 2.5.0-beta

[redonkuless]

Hello,

Everything seemed to be working fine. I was able to install it, and login, I was even able to create a category. However as the admin i tried to create a knowledge article for one of my categories and when i wen to approve it... The session time tracker stopped working and everything below the links (navigation) was blank. Same thing when I tried editing the article. The debug mode is as follows:

/var/www/mysite*.com/kb/inc/Init.php:
PMF_Configuration->getAll() in line 95:

SELECT
config_name, config_value
FROM
faqconfig


/var/www/mysite*.com/kb/inc/PMF_User/CurrentUser.php:
PMF_User->getUserById() in line 384:

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


/var/www/mysite*.com/kb/inc/PMF_User/CurrentUser.php:
PMF_User->getUserById() in line 384:

SELECT
pass
FROM
faquserlogin
WHERE
login = 'admin'


/var/www/mysite*.com/kb/inc/User.php:
PMF_User_UserData->load() in line 306:

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


/var/www/mysite*.com/kb/inc/PMF_User/CurrentUser.php:
PMF_User_CurrentUser->getSessionInfo() in line 391:

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


/var/www/mysite*.com/kb/admin/index.php:
PMF_Perm_PermBasic->getAllRightsData() in line 122:

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


/var/www/mysite*.com/kb/inc/PMF_Perm/PermBasic.php:
PMF_Perm_PermBasic->getUserRights() in line 260:

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


/var/www/mysite*.com/kb/inc/Category.php:
PMF_Category->getOrderedCategories() in line 154:

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


/var/www/mysite*.com/kb/inc/Linkverifier.php:
PMF_Linkverifier->loadConfigurationFromDB() in line 151:

SELECT type, url, reason FROM faqlinkverifyrules WHERE enabled = 'y'


/var/www/mysite*.com/kb/admin/record.show.php:
PMF_Comment->getNumberOfComments() in line 127:

SELECT
COUNT(id) AS anz,
id
FROM
faqcomments
WHERE
type = 'faq'
GROUP BY id
ORDER BY id


/var/www/mysite*.com/kb/admin/record.show.php:
PMF_Category->getCategoryRecordsMatrix() in line 133:

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


/var/www/mysite*.com/kb/admin/record.show.php:
PMF_Category->getNumberOfRecordsOfCategory() in line 143:

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 = 'no'
GROUP BY fcr.category_id


/var/www/mysite*.com/kb/admin/record.show.php:
PMF_Faq->getAllRecords() in line 207:

SELECT
fd.id AS id,
fd.lang AS lang,
fcr.category_id AS category_id,
fd.solution_id AS solution_id,
fd.revision_id AS revision_id,
fd.active AS active,
fd.keywords AS keywords,
fd.thema AS thema,
fd.content AS content,
fd.author AS author,
fd.email AS email,
fd.comment AS comment,
fd.datum AS datum,
fd.links_state AS links_state,
fd.links_check_date AS links_check_date,
fd.date_start AS date_start,
fd.date_end AS date_end
FROM
faqdata fd
LEFT JOIN
faqcategoryrelations fcr
ON
fd.id = fcr.record_id
AND
fd.lang = fcr.record_lang
WHERE fd.active = 'no'

ORDER BY
fcr.category_id,
fd.id


/var/www/mysite*.com/kb/inc/Linkverifier.php:
PMF_Linkverifier->getEntryState() in line 749:

SELECT links_state, links_check_date FROM faqdata WHERE id = 1 AND lang='en'


/var/www/mysite*.com/kb/inc/Linkverifier.php:
PMF_Linkverifier->getEntryState() in line 765:

SELECT links_state, links_check_date FROM faqdata WHERE id = 1 AND lang='en'


COOKIES:
pmf_sid: 1
aaf3e60f5845210c5141dea9a73edc27: 57e68783857b5300e7cd0bffb76bc2f1
metamorphj15-fontstyle: f-small
3190937fedf2a91f6630893749db72c7: c7e85e827d1bfb864cd364471dc7cb45
pmf_auth: 4a496077a1dda82f5e78b1d0a58283c1
pmfauth: 396aa5b8cfa68a886a67b754d0c0432e

TABLES & RECORDS:
faqadminlog: 23
faqcaptcha: 0
faqcategories: 3
faqcategory_group: 4
faqcategory_user: 4
faqcategoryrelations: 0
faqchanges: 1
faqcomments: 0
faqconfig: 34
faqdata: 1
faqdata_group: 0
faqdata_revisions: 0
faqdata_tags: 0
faqdata_user: 0
faqglossary: 0
faqgroup: 0
faqgroup_right: 0
faqlinkverifyrules: 0
faqnews: 0
faqquestions: 0
faqright: 29
faqsearches: 0
faqsessions: 1
faqtags: 0
faquser: 3
faquser_group: 0
faquser_right: 29
faquserdata: 3
faquserlogin: 3
faqvisits: 0
faqvoting: 0

[redonkuless]

Sorry the debug information is from clicking either, edit or approve, on both pages when you click edit or approve the page becomes blank and the debug information is not displayed.

[Thorsten]

Hi,

thanks for the hint. It's fixed in SVN now. Please try the SVN build tomorrow.

bye
Thorsten