FAQ Module [Support]

[cubmanky]

Anyone get this to work with 1.5.8a?
I get a the folowing when i try to go to admin on FAQ
WARNING: An Error occurred, please let us know! If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you entered valid data.
log below

[17-Aug-2023 16:38:00 America/New_York] Request URI: /store/admin/index.php?cmd=faq_categories&fcPath=3, IP address: x.x.x.x, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /homepagessite/includes/classes/db/mysql/query_factory.php(667): trigger_error()
#2 /homepagessite/includes/classes/db/mysql/query_factory.php(634): queryFactory->show_error()
#3 /homepagessite/includes/classes/db/mysql/query_factory.php(275): queryFactory->set_error()
#4 /homepagessite/admin/includes/classes/split_page_results.php(220): queryFactory->Execute()
#5 /homepagessite/admin/includes/classes/split_page_results.php(131): splitPageResults->numberRows()
#6 /homepagessite/admin/includes/modules/faq_category_faq_listing.php(161): splitPageResults->__construct()
#7 /homepagessite/admin/faq_categories.php(373): require('/homepages/...')
#8 /homepagessite/admin/index.php(11): require('/homepages/...')
--> PHP Fatal error: 1060:Duplicate column name 'faqs_id' :: SELECT count(*) as total FROM (select p.*, pd.*, p2c.*                                from zen_faqs p, zen_faqs_description pd, zen_faqs_to_faq_categories p2c                                where p.faqs_id = pd.faqs_id                                and pd.language_id = '1'                                and p.faqs_id = p2c.faqs_id                                and p2c.faq_categories_id = '3'                                order by p.faqs_sort_order, pd.faqs_name) countresults ==> (as called by) /homepagessite/admin/includes/classes/split_page_results.php on line 220 <== in /homepagessite/includes/classes/db/mysql/query_factory.php on line 667.

[DannyVarley]

Still using 1.5.7d

I believe this plugin breaks the "EZ-Pages Meta Tag Fields" plugin (https://www.zen-cart.com/downloads.php?do=file&id=746)

The docs of the FAQ module when installing the META TAGS does not include a break for the above case:'page'

I believe to make this accurate you would need to update the docs to say to insert the following:

//BOF FAQ Metatags
break;
    case (strstr($_GET['main_page'], 'faq_info')):
    $sql= "select pd.faqs_name, p.faqs_id, pd.faqs_answer
                              from " . TABLE_FAQS . " p, " . TABLE_FAQS_DESCRIPTION . " pd
                              where p.faqs_id = '" . (int)$_GET['faqs_id'] . "'
                              and p.faqs_id = pd.faqs_id
                              and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";
    $faq_info_metatags = $db->Execute($sql);
    $meta_faqs_name = $faq_info_metatags->fields['faqs_name'];
    $meta_faqs_name = zen_clean_html($meta_faqs_name);
    $meta_faqs_answer = zen_truncate_paragraph(strip_tags(stripslashes($faq_info_metatags->fields['faqs_answer'])), MAX_META_TAG_DESCRIPTION_LENGTH);
    $meta_faqs_answer = zen_clean_html($meta_faqs_answer);

    define('META_TAG_TITLE', str_replace('"','',$meta_faqs_name . PRIMARY_SECTION . TITLE . TAGLINE));
    define('META_TAG_DESCRIPTION', str_replace('"','', $meta_faqs_answer . ' '));
    define('META_TAG_KEYWORDS', str_replace('"','',$meta_faqs_name . METATAGS_DIVIDER . KEYWORDS));
    break;
    //EOF FAQ Metatags 

Hope this might help someone!

[cubmanky]

I stopped using the module as its not supported in newer version When i try to import my database I get the following

Table structure for table `zen_faqs_description`--CREATE TABLE `zen_faqs_description` ( `faqs_id` int NOT NULL, `language_id` int NOT NULL DEFAULT '1', `faqs_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '', `faqs_answer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `faqs_viewed` int DEFAULT '0') ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;