Questions in All

FAQs

Inroads Knowledgebase FAQs

All 0 FAQs

Inroads Knowledgebase

DEBUG INFORMATION

EXCEPTIONS

DATABASE QUERIES

/home/inroads/public_html/Inroads_FAQs/src/Bootstrap.php:
phpMyFAQ\Configuration->getAll() in line 140:


            SELECT
                config_name, config_value
            FROM
                faqconfig

/home/inroads/public_html/Inroads_FAQs/src/phpMyFAQ/Category.php:
phpMyFAQ\Category->getOrderedCategories() in line 141:


            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,
                fc.image AS image,
                fc.show_home AS show_home
            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, fc.image, 
                fc.show_home
            ORDER BY
                fc.parent_id, fc.id

/home/inroads/public_html/Inroads_FAQs/src/phpMyFAQ/Helper/CategoryHelper.php:
phpMyFAQ\Category\CategoryRelation->getNumberOfFaqsPerCategory() in line 44:


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

/home/inroads/public_html/Inroads_FAQs/src/phpMyFAQ/User.php:
phpMyFAQ\User\UserData->get() in line 937:


            SELECT
                display_name
            FROM
                faquserdata
            WHERE
                user_id = 0

/home/inroads/public_html/Inroads_FAQs/src/phpMyFAQ/Helper/CategoryHelper.php:
phpMyFAQ\Category\CategoryRelation->getNumberOfFaqsPerCategory() in line 44:


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

/home/inroads/public_html/Inroads_FAQs/src/phpMyFAQ/Tags.php:
phpMyFAQ\Tags->getAllTags() in line 405:


            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/inroads/public_html/Inroads_FAQs/index.php:
phpMyFAQ\Faq->getRecordsWithoutPagingByCategoryId() in line 675:


            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 <= '20260102095811'
            AND
                fd.date_end   >= '20260102095811'
            AND
                fd.active = 'yes'
            AND
                fcr.category_id = 1
            AND
                fd.lang = 'en'
                AND fdu.user_id = -1
            GROUP BY
                fd.id,fd.lang,fcr.category_id,fv.visits
            ORDER BY
                id DESC