DEBUG INFORMATION
EXCEPTIONS
DATABASE QUERIES
/home/www/markanthonymiller.com/phpmyfaq/inc/Bootstrap.php:
PMF_Configuration->getAll() in line 152:
SELECT
config_name, config_value
FROM
faqconfig
/home/www/markanthonymiller.com/phpmyfaq/index.php:
PMF_Session->checkSessionId() in line 214:
SELECT
sid
FROM
faqsessions
WHERE
sid = 198543
AND
ip = '18.216.114.23'
AND
time > 1713191651
/home/www/markanthonymiller.com/phpmyfaq/inc/PMF/Category.php:
PMF_Category->getOrderedCategories() in line 152:
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,
fc.group_id AS group_id,
fc.active AS active
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
( fg.group_id IN (-1)
OR
(fu.user_id = -1 AND fg.group_id IN (-1)))
AND
fc.active = 1
AND
fc.lang = 'en'
GROUP BY
fc.id, fc.lang, fc.parent_id, fc.name, fc.description, fc.user_id, fc.group_id, fc.active
ORDER BY
fc.parent_id, fc.id
/home/www/markanthonymiller.com/phpmyfaq/index.php:
PMF_Session->getUsersOnline() in line 454:
SELECT
count(sid) AS anonymous_users
FROM
faqsessions
WHERE
user_id = -1
AND
time > 1713277751
/home/www/markanthonymiller.com/phpmyfaq/index.php:
PMF_Session->getUsersOnline() in line 454:
SELECT
count(session_id) AS registered_users
FROM
faquser
WHERE
session_timestamp > 1713277751
/home/www/markanthonymiller.com/phpmyfaq/inc/PMF/Helper/Category.php:
PMF_Category->getNumberOfRecordsOfCategory() in line 53:
SELECT
fcr.category_id AS category_id,
COUNT(fcr.record_id) AS num_records
FROM
faqcategoryrelations fcr, faqdata fd
WHERE
fcr.record_id = fd.id
AND
fcr.record_lang = fd.lang
GROUP BY fcr.category_id
/home/www/markanthonymiller.com/phpmyfaq/inc/PMF/User.php:
PMF_User_UserData->get() in line 911:
SELECT
display_name
FROM
faquserdata
WHERE
user_id = 0
/home/www/markanthonymiller.com/phpmyfaq/inc/PMF/Helper/Category.php:
PMF_Category->getNumberOfRecordsOfCategory() in line 53:
SELECT
fcr.category_id AS category_id,
COUNT(fcr.record_id) AS num_records
FROM
faqcategoryrelations fcr, faqdata fd
WHERE
fcr.record_id = fd.id
AND
fcr.record_lang = fd.lang
GROUP BY fcr.category_id
/home/www/markanthonymiller.com/phpmyfaq/inc/PMF/Faq.php:
PMF_Faq->getStickyRecordsData() in line 3257:
SELECT
fd.id AS id,
fd.lang AS lang,
fd.thema AS thema,
fcr.category_id AS category_id
FROM
faqdata fd
LEFT JOIN
faqcategoryrelations fcr
ON
fd.id = fcr.record_id
AND
fd.lang = fcr.record_lang
LEFT JOIN
faqdata_group AS fdg
ON
fd.id = fdg.record_id
LEFT JOIN
faqdata_user AS fdu
ON
fd.id = fdu.record_id
WHERE
fd.lang = 'en'
AND
fd.date_start <= '20240416163411'
AND
fd.date_end >= '20240416163411'
AND
fd.active = 'yes'
AND
fd.sticky = 1
AND fdu.user_id = -1
/home/www/markanthonymiller.com/phpmyfaq/inc/PMF/Faq.php:
PMF_Faq->getTopTenData() in line 1815:
SELECT
fd.id AS id,
fd.lang AS lang,
fd.thema AS question,
fd.updated AS updated,
fcr.category_id AS category_id,
fv.visits AS visits,
fv.last_visit AS last_visit,
fdg.group_id AS group_id,
fdu.user_id AS user_id
FROM
faqvisits fv,
faqdata fd
LEFT JOIN
faqcategoryrelations fcr
ON
fd.id = fcr.record_id
AND
fd.lang = fcr.record_lang
LEFT JOIN
faqdata_group AS fdg
ON
fd.id = fdg.record_id
LEFT JOIN
faqdata_user AS fdu
ON
fd.id = fdu.record_id
WHERE
fd.date_start <= '20240416163411'
AND fd.date_end >= '20240416163411'
AND fd.id = fv.id
AND fd.lang = fv.lang
AND fd.active = 'yes'
AND
fd.lang = 'en'
AND fdu.user_id = -1
GROUP BY
fd.id, fd.lang, fd.thema, fd.updated, fcr.category_id, fv.visits, fv.last_visit, fdg.group_id, fdu.user_id
ORDER BY
fv.visits DESC
/home/www/markanthonymiller.com/phpmyfaq/inc/PMF/Faq.php:
PMF_Faq->getLatestData() in line 1855:
SELECT
fd.id AS id,
fd.lang AS lang,
fcr.category_id AS category_id,
fd.thema AS question,
fd.content AS content,
fd.updated AS updated,
fv.visits AS visits,
fdg.group_id AS group_id,
fdu.user_id AS user_id
FROM
faqvisits fv,
faqdata fd
LEFT JOIN
faqcategoryrelations fcr
ON
fd.id = fcr.record_id
AND
fd.lang = fcr.record_lang
LEFT JOIN
faqdata_group AS fdg
ON
fd.id = fdg.record_id
LEFT JOIN
faqdata_user AS fdu
ON
fd.id = fdu.record_id
WHERE
fd.date_start <= '20240416163411'
AND fd.date_end >= '20240416163411'
AND fd.id = fv.id
AND fd.lang = fv.lang
AND fd.active = 'yes'
AND
fd.lang = 'en'
AND fdu.user_id = -1
GROUP BY
fd.id, fd.lang, fcr.category_id, fd.thema, fd.content, fd.updated, fv.visits, fdg.group_id, fdu.user_id
ORDER BY
fd.updated DESC
/home/www/markanthonymiller.com/phpmyfaq/inc/PMF/Tags.php:
PMF_Tags->getAllTags() in line 489:
SELECT
MIN(t.tagging_id) AS tagging_id, t.tagging_name AS tagging_name
FROM
faqtags t
LEFT JOIN
faqdata_tags dt
ON
dt.tagging_id = t.tagging_id
LEFT JOIN
faqdata d
ON
d.id = dt.record_id
WHERE
1=1
AND d.active = 'yes'
GROUP BY
tagging_name
ORDER BY
tagging_name ASC
/home/www/markanthonymiller.com/phpmyfaq/index.php:
PMF_Faq->showAllRecordsWoPaging() in line 748:
SELECT
fd.id AS id,
fd.lang AS lang,
fd.thema AS thema,
fcr.category_id AS category_id,
fv.visits AS visits
FROM
faqdata fd
LEFT JOIN
faqcategoryrelations fcr
ON
fd.id = fcr.record_id
AND
fd.lang = fcr.record_lang
LEFT JOIN
faqvisits fv
ON
fd.id = fv.id
AND
fv.lang = fd.lang
LEFT JOIN
faqdata_group fdg
ON
fd.id = fdg.record_id
LEFT JOIN
faqdata_user fdu
ON
fd.id = fdu.record_id
WHERE
fd.date_start <= '20240416163411'
AND
fd.date_end >= '20240416163411'
AND
fd.active = 'yes'
AND
fcr.category_id = 0
AND
fd.lang = 'en'
AND fdu.user_id = -1
GROUP BY
fd.id, fd.lang, fd.thema, fcr.category_id, fv.visits
ORDER BY
id DESC
