If this is your first visit, check our documentation. To post, register or login.
Forums / All Other Contributions/Addons / FAQ Module [Support]

FAQ Module [Support]

Started by kamelion0927 on 24 Sep 2012, 10:59 PM · Views: 28,201

Results 21 to 40 of 130
11 Oct 2012, 12:42 AM
#21
kamelion0927 avatar

kamelion0927

Zen Follower

Join Date:
Dec 2009
Posts:
208
Plugin Contributions:
1

FAQ Module [Support]

raj3396:

Nice plugin Does this plugin work on version 1.39h

Not as is - it's formatted for 1.5. I have an earlier version installed on a 1.39h store but I believe I had to make quite a few modifications to it. I'm in the middle of "remodeling" this version. If you can give me a couple of days, I'll install it on my 1.39h store, see if it works and let you know.

11 Oct 2012, 6:32 AM
#22
raj3396 avatar

raj3396

New Zenner

Join Date:
May 2011
Location:
DELHI,INDIA
Posts:
43
Plugin Contributions:
0

Re: FAQ Module [Support]

Thanks for the reply, we version 1.39 people shall be eagerly waiting for the faq mod for 1.39 ..

15 Oct 2012, 1:38 PM
#23
raj3396 avatar

raj3396

New Zenner

Join Date:
May 2011
Location:
DELHI,INDIA
Posts:
43
Plugin Contributions:
0

Re: FAQ Module [Support]

thanks for the version 1.39, I have already installed FAQ PAGE. So how should I go ahead with the FAQ MODULE installation

15 Oct 2012, 9:17 PM
#24
kamelion0927 avatar

kamelion0927

Zen Follower

Join Date:
Dec 2009
Posts:
208
Plugin Contributions:
1

Re: FAQ Module [Support]

raj3396:

thanks for the version 1.39, I have already installed FAQ PAGE. So how should I go ahead with the FAQ MODULE installation

Whoa that was fast! I just submitted the mod update late last week - didn't think it would get approved so fast. Thanks Zen Cart team!

I just took a look at the FAQ Page Mod and because of some conflicting file names, you would want to uninstall the FAQ Page Mod and install the FAQ Manager Mod.

But before you do that - these mods are very similar and give a similar look to a site - if you already have the FAQ Page set up and looking the way you want, you may want to consider sticking with it. It would be a lot of work to uninstall that mod and replace it with FAQ Manger.

17 Oct 2012, 2:06 PM
#25
canvas101 avatar

canvas101

New Zenner

Join Date:
Apr 2007
Posts:
41
Plugin Contributions:
0

Re: FAQ Module [Support]

Great Module....

I've used it a few times on earlier sites.

Was very disappointed to learn that the submit question option is no longer available?

Any ideas when this may be integrated within the module again?

Many Thanks

17 Oct 2012, 3:19 PM
#26
kamelion0927 avatar

kamelion0927

Zen Follower

Join Date:
Dec 2009
Posts:
208
Plugin Contributions:
1

Re: FAQ Module [Support]

Canvas101:

Great Module....

I've used it a few times on earlier sites.

Was very disappointed to learn that the submit question option is no longer available?

Any ideas when this may be integrated within the module again?

Many Thanks

I didn't include the submit a question because it isn't a feature that I use on my site so unless for some reason I decide to start using it, I probably won't add it back on. You're welcome to take a crack at it however :smile:

18 Oct 2012, 1:32 AM
#27
arsanat avatar

arsanat

New Zenner

Join Date:
Sep 2012
Location:
Monterrey (metropolitan area) NL, MEXICO
Posts:
11
Plugin Contributions:
0

Re: FAQ Module [Support]

I can not get individual faq's shown, only categories are shown in main page after clicking on either side box or header link of Zen Cart Store. The history follows: Installed Faq Manager v2.0 on Zen Cart v1.5, tried but failed to implement forum corrections and uninstalled the module. Then upgraded to Zen Cart v1.5.1 added spanish language and reinstalled FAQ Manager v 2.2, adding all english folder related files to the corresponding spanish folders, also using all examples in the install folder of v 2.2. placed in the same structure as the provided directories and replicating as needed in the spanish directories. On trying to upload the SQL patch I got the following message in the patch installing tool of ZC:
20 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

I have created a few categories and FAQ´s in admin, also featured FAQ's, but in the store only categories show, no individual FAQ´s. Also in both English and Spanish languages, categories appear in both languages, instead of only the language selected.
I noticed too that in ZC admin on selecting FAQ manger three columns with headers: faq options, settings, and action, appear blank. Also, in Spanish, action is replaced with TABLE_HEADING_ACTION.

Thanks for your help, this is my first store and first post. :wacko:

18 Oct 2012, 2:37 AM
#28
kamelion0927 avatar

kamelion0927

Zen Follower

Join Date:
Dec 2009
Posts:
208
Plugin Contributions:
1

Re: FAQ Module [Support]

You received the SQL error because you didn't copy and paste the contents of faq_uninstall.sql in admin > tools > Install SQL Patches when you uninstalled 2.0.

Basically what happened was because the database tables were not removed before reinstalling, it messed up all of your settings and is causing most (if not all) of your problems.

Let's get everything working in english before we tackle the spanish language issues.

First, copy the following code:

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'FAQ Manager'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;

DELETE FROM admin_pages WHERE page_key = 'configFAQManager' LIMIT 1;

Then go to admin > tools > install sql patches, paste the code and hit send. This will remove the old settings from your admin.

Then copy the following code:

SELECT @cid:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'FAQ Manager';
DELETE FROM configuration WHERE configuration_group_id = @cid;
DELETE FROM configuration_group WHERE configuration_group_id = @cid;

INSERT INTO configuration_group VALUES (NULL, 'FAQ Manager', 'Set FAQ Manager Options', '1', '1');
SET @cid=last_insert_id();
UPDATE configuration_group SET sort_order = @cid WHERE configuration_group_id = @cid;
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES
(NULL, 'Admin - Configuration Group ID', 'FAQ_LISTS_GROUP_ID_ALL', @cid, '<br/>Warning: Only change this if your FAQs Group ID has changed from the default<br /><br/>What is the configuration_group_id for FAQ Listings?<br/>', @cid, 1, NOW(), NULL, NULL),
(NULL, 'Admin - Maximum FAQ Categories FAQs Display List', 'MAX_DISPLAY_RESULTS_FAQ_CATEGORIES', '10', '<br/>Number of FAQs to list per screen in the admin display<br/>', @cid, 1, NOW(), NULL, NULL),
(NULL, 'FAQ Info - Breadcrumb Status', 'DEFINE_FAQ_BREADCRUMB_STATUS', '1', '<br/>Show the breadcrumb on the FAQ info pages?<br/>', @cid, 9, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),'),
(NULL, 'FAQ Info - Breadcrumb Seperator', 'FAQ_BREAD_CRUMBS_SEPARATOR', ':', '<br/>Enter the separator symbol to appear between links on the FAQ breadcrumb<br/><br/>Note: Include spaces with the &nbsp; symbol if you want them part of the separator.<br /><br/>Default = &nbsp;::&nbsp;', @cid, 10, NOW(), NULL, 'zen_cfg_textarea_small('),
(NULL, 'FAQ Info - Prev/Next Navigation Bar Status', 'FAQ_INFO_PREVIOUS_NEXT_STATUS', '1', '<br/>Show the prev/next navigation bar on the FAQ info pages?<br/>', @cid, 11, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),'),
(NULL, 'FAQ Info - Prev/Next Navigation Bar Position', 'FAQ_INFO_PREVIOUS_NEXT_POSITION', '1', '<br/>Set the location of prev/next navigation bar on the FAQ info pages<br/>', @cid, 12, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'Top of Page\'), array(\'id\'=>\'2\', \'text\'=>\'Bottom of Page\'), array(\'id\'=>\'3\', \'text\'=>\'Both Top & Bottom of Page\')),'),
(NULL, 'FAQ Info - Prev/Next Sort Order', 'FAQ_INFO_PREVIOUS_NEXT_SORT', '1', '<br/>Sort order of prev/next navigation bar on the FAQ info pages<br/>', @cid, 13, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'FAQ Name\'), array(\'id\'=>\'2\', \'text\'=>\'FAQ Name DESC\'), array(\'id\'=>\'3\', \'text\'=>\'FAQ Sort Order, FAQ Category Sort Order\'), array(\'id\'=>\'4\', \'text\'=>\'FAQ Category Sort Order\'), array(\'id\'=>\'5\', \'text\'=>\'Date Added DESC, FAQs Name\'), array(\'id\'=>\'5\', \'text\'=>\'Date Added DESC, FAQs Name\'), array(\'id\'=>\'7\', \'text\'=>\'FAQs Sort Order\')),'),
(NULL, 'FAQ Info - Back Button Status', 'FAQ_INFO_BACK_BUTTON', '1', '<br/>Show the back button on the FAQ info pages?<br/>', @cid, 14, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),'),
(NULL, 'FAQ Index - Max Display', 'MAX_DISPLAY_FAQS_ALL', '20', '<br/>Number of FAQs to show on the main FAQ index page<br/>', @cid, 20, NOW(), NULL, NULL),
(NULL, 'FAQ Index - Default Sort Order', 'FAQ_SORT_DEFAULT', '3', '<br/>Sets the default FAQ sort order<br />', @cid, 22, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'FAQ Name A - Z\'), array(\'id\'=>\'2\', \'text\'=>\'FAQs Name Z - A\'), array(\'id\'=>\'3\', \'text\'=>\'Category Name with Admin Sort Order\'), array(\'id\'=>\'4\', \'text\'=>\'Admin Defined Sort Order\'), array(\'id\'=>\'6\', \'text\'=>\'Date Added Oldest First\'), array(\'id\'=>\'7\', \'text\'=>\'Date Added Newest First\')),'),
(NULL, 'FAQ Index - Display Sorter', 'FAQ_ALL_DISPLAY_SORT_ORDER', '1', '<br/>Show the FAQ sorter on the FAQ index page?<br/>', @cid, 23, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),'),
(NULL, 'FAQ Index - Prev/Next Navigation Bar Status', 'FAQ_INDEX_PREVIOUS_NEXT_STATUS', '1', '<br/>Show the prev/next navigation bar on the FAQ index page?<br/>', @cid, 24, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),'),
(NULL, 'FAQ Index - Prev/Next Navigation Bar Position', 'FAQ_INDEX_PREVIOUS_NEXT_POSITION', '1', '<br/>Set the location of prev/next navigation bar on the FAQ index page<br/>', @cid, 25, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'Top of Page\'), array(\'id\'=>\'2\', \'text\'=>\'Bottom of Page\'), array(\'id\'=>\'3\', \'text\'=>\'Both Top & Bottom of Page\')),'),
(NULL, 'FAQ Index - Show Featured FAQs', 'SHOW_FEATURED_FAQS_INDEX', '1', 'Show featured FAQs on the main FAQ index page?', @cid, 26, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),'),
(NULL, 'FAQ Index - Max Display Featured FAQs', 'MAX_DISPLAY_SEARCH_RESULTS_FEATURED_FAQ', '5', '<br/>Number of featured FAQs to show on the main FAQ index page<br/>', @cid, 27, NOW(), NULL, NULL),
(NULL, 'FAQ Category Box - Show Counter', 'SHOW_FAQ_COUNTS', 'true', '<br/>Count recursively how many products are in each category<br/><br/>default=true<br/>', @cid, 50, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),' ),
(NULL, 'FAQ Category Box - Count Prefix', 'FAQ_CATEGORIES_COUNT_PREFIX', ' (', '<br/>What do you want to prefix the FAQ count with?<br/><br/>Default= " ("<br/>', @cid, 51, NOW(), NULL, 'zen_cfg_textarea_small(' ),
(NULL, 'FAQ Category Box - Count Suffix', 'FAQ_CATEGORIES_COUNT_SUFFIX', ')', '<br/>What do you want as a suffix to the FAQ count?<br/><br/>Default= ")"<br/>', @cid, 52, NOW(), NULL, 'zen_cfg_textarea_small(' ),
(NULL, 'FAQ Category Box - Categories with 0 FAQs Status', 'FAQ_CATEGORIES_COUNT_ZERO', '1', '<br/>Show FAQ Count for categories with no active FAQs?<br/>', @cid, 53, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),' ),
(NULL, 'Display FAQ Name', 'FAQ_ALL_LIST_NAME', '2101', 'Do you want to display the FAQ Name?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @cid, 82, NOW(), NULL, NULL); 

INSERT IGNORE INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configFAQManager','BOX_CATALOG_FAQ_MANAGER','FILENAME_FAQ_MANAGER',CONCAT('gID=',@cid),'extras','Y',@cid);

Then go to admin > tools > install sql patches, paste the code and hit send. This will add the new settings to your admin without removing any of the faqs and categories that you created.

Then try going to your faq page again and see if your faqs are showing up. If they aren't, make sure all of the files from the mod uploaded into their correct folders and try again.

If you still need help, I need a link to your faq page so I can see what's going on in the code.

Good luck :smile:

19 Oct 2012, 5:44 AM
#29
arsanat avatar

arsanat

New Zenner

Join Date:
Sep 2012
Location:
Monterrey (metropolitan area) NL, MEXICO
Posts:
11
Plugin Contributions:
0

Re: FAQ Module [Support]

[QUOTE=kamelion0927;1158246]You received the SQL error because you didn't copy and paste the contents of faq_uninstall.sql in admin > tools > Install SQL Patches when you uninstalled 2.0.

Basically what happened was because the database tables were not removed before reinstalling, it messed up all of your settings and is causing most (if not all) of your problems.

Let's get everything working in english before we tackle the spanish language issues.

Thanks kamelion for your very fast response. I followed your instructions, the uninstall patch ran smoothly with 5 statements processed, however your recommended install SQL gave me:

8 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details

so, basically nothing changed :no:and the problem remains. Before installing FAQ module 2.2 I did run the uninstall patch for version 2.0. However, in my post I missed informing that besides the spanish module, before installing FAQ Manager v 2.2 I have also succesfully installed the following modules: reward_point_full_suite_2.1b, orders_exporter_1.6, group_pricing_per_item_150a, Admin_Login_As_Customer_v3.0_For_ZCv150, and Zen Cart Spanish Language Pack for Zen Cart 1.5.1

kamelion0927, could you kindly check the SQL code? Thank you. I hope my begginer's errors could help others avoid them!

arsanat

19 Oct 2012, 7:15 PM
#30
kamelion0927 avatar

kamelion0927

Zen Follower

Join Date:
Dec 2009
Posts:
208
Plugin Contributions:
1

Re: FAQ Module [Support]

I actually tried the SQL code on my site before I posted it and was successful. Maybe the issue is that because I'm a store owner and not a coder, I'm not troubleshooting as well as someone who is proficient with this kind of issue.

Before you try to install another language on any mod (unless it's already included in the mod), you should get it working in english first - it's just one less variable to consider.

The only other suggestion I have is to restore the backed up version of your database and run the sql statement again. If you didn't back up, you can try to run the uninstall.sql through mySQL (directly in your database).

22 Oct 2012, 5:59 AM
#31
arsanat avatar

arsanat

New Zenner

Join Date:
Sep 2012
Location:
Monterrey (metropolitan area) NL, MEXICO
Posts:
11
Plugin Contributions:
0

Re: FAQ Module [Support]

kamelion0927:

The only other suggestion I have is to restore the backed up version of your database and run the sql statement again. If you didn't back up, you can try to run the uninstall.sql through mySQL (directly in your database).

When running the uninstall v.2.2 SQL patch from inside the store, I found that the faqs table did not exist:
6 statements processed.
ERROR: No se puede borrar la tabla faqs porque no existe.
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.
I then ran the uninstall v2. SQL and got exactly the same reply as above. I installed v 2.2 anew and the reply on running the SQL patch was the same as the one reported in my first post, namely:
20 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

The problem remained the same :(
So this suggests to me that the faqs table is prevented from installatation from extant configuration_key ocurring twice in the install script. Furthermore, neither uninstall scripts have been able to remove said configuration_key. Could it be removed by a specific query? is it possible that another module needs it?:unsure:
Arsanat

22 Oct 2012, 7:44 AM
#32
arsanat avatar

arsanat

New Zenner

Join Date:
Sep 2012
Location:
Monterrey (metropolitan area) NL, MEXICO
Posts:
11
Plugin Contributions:
0

Re: FAQ Module [Support]

arsanat:

So this suggests to me that the faqs table is prevented from installatation from extant configuration_key ocurring twice in the install script. Furthermore, neither uninstall scripts have been able to remove said configuration_key. Could it be removed by a specific query? is it possible that another module needs it?:unsure:
Arsanat
The module Product Pagination for Zen Cart v 1.4.3 uses configuration_key also, for example in the statement:

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) VALUES ('Products Pagination — Maximum Links', 'PRODUCTS_PAGINATION_MAX', '10', 'This is the maximum number of product links to be displayed before pagination begins. This value should be greater than the number of Intermediate Links

Just as with Faq Manager v2.2, y got the same error for each of 4 insert statementes, namely:

ERROR: Cannot insert configuration_key "" because it already exists

So, is this a case of conflicting plug ins? the first to be installed wins? or is perhaps something I did wrongly?:dontgetit

22 Oct 2012, 8:02 PM
#33
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,140
Plugin Contributions:
56

Re: FAQ Module [Support]

arsanat, your problem seems to be due to the use of 'backticks' in the FAQ module's installation SQL; there's a ZC wiki article on this (http://www.zen-cart.com/wiki/index.php/Troubleshooting_-_SQL_Patches#Cannot_insert_configuration_key_.22.22_because_it_already_exists).

Anyway, if you edit the /v1.5 and v1.5.1 install/faq_install.sql file to remove the 'backticks' and re-run the SQL (after running the uninstall SQL) it should be OK. I've highlighted the sections in red that you'll need to edit (and I didn't include the entire installation SQL file):

DROP TABLE IF EXISTS faq_categories;
CREATE TABLE faq_categories (
  faq_categories_id int(11) NOT NULL auto_increment,
  parent_id int(11) NOT NULL default '0',
  sort_order int(3) default NULL,
  date_added datetime default NULL,
  last_modified datetime default NULL,
  faq_categories_status tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (faq_categories_id),
  KEY idx_faq_categories_parent_id (parent_id),
  KEY idx_sort_order (sort_order)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

DROP TABLE IF EXISTS faq_categories_description;
CREATE TABLE faq_categories_description (
  faq_categories_id int(11) NOT NULL default '0',
  language_id int(11) NOT NULL default '1',
  faq_categories_name varchar(400) NOT NULL default '',
  faq_categories_description text NOT NULL,
  PRIMARY KEY  (faq_categories_id,language_id),
  KEY idx_faq_categories_name (faq_categories_name)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

DROP TABLE IF EXISTS faqs;
CREATE TABLE faqs (
  faqs_id int(11) NOT NULL auto_increment,
  faqs_date_added datetime NOT NULL default '0001-01-01 00:00:00',
  faqs_last_modified datetime default NULL,
  faqs_status tinyint(1) NOT NULL default '0',
  faqs_sort_order int(11) NOT NULL default '0',
  master_faq_categories_id int(11) NOT NULL default '0',
  PRIMARY KEY  (faqs_id),
  KEY idx_faqs_date_added (faqs_date_added)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;


DROP TABLE IF EXISTS `faqs_description`;
CREATE TABLE `faqs_description` (
  `faqs_id` int(11) NOT NULL auto_increment,
  `language_id` int(11) NOT NULL default '1',
  `faqs_name` varchar(500) NOT NULL default '',
  `faqs_answer` text,
  `faqs_viewed` int(5) default '0',
  PRIMARY KEY  (`faqs_id`,`language_id`),
  KEY `faqs_name` (`faqs_name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

DROP TABLE IF EXISTS faqs_to_faq_categories;
CREATE TABLE faqs_to_faq_categories (
  faqs_id int(11) NOT NULL default '0',
  faq_categories_id int(11) NOT NULL default '0',
  PRIMARY KEY  (faqs_id,faq_categories_id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

DROP TABLE IF EXISTS `faqs_featured`;
CREATE TABLE IF NOT EXISTS `faqs_featured` (
  `featured_faqs_id` int(11) NOT NULL auto_increment,
  `faqs_id` int(11) NOT NULL default '0',
  `featured_date_added` datetime default NULL,
  `featured_last_modified` datetime default NULL,
  `expires_date` date NOT NULL default '0001-01-01',
  `date_status_change` datetime default NULL,
  `status` int(1) NOT NULL default '1',
  `featured_date_available` date NOT NULL default '0001-01-01',
  PRIMARY KEY  (`featured_faqs_id`),
  KEY `idx_status_zen` (`status`),
  KEY `idx_faqs_id_zen` (`faqs_id`),
  KEY `idx_date_avail_zen` (`featured_date_available`),
  KEY `idx_expires_date_zen` (`expires_date`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

I've seen this error on another plugin (don't remember which), and it seems to be highly related to the version of MySQL that you are running. If you use your admin's Tools->Server/Version Information, you'll see what version of mySQL your shop runs on ... it might be interesting for others to know what version that is.

25 Oct 2012, 1:01 AM
#34
arsanat avatar

arsanat

New Zenner

Join Date:
Sep 2012
Location:
Monterrey (metropolitan area) NL, MEXICO
Posts:
11
Plugin Contributions:
0

Re: FAQ Module [Support]

lat9:

arsanat, your problem seems to be due to the use of 'backticks' in the FAQ module's installation SQL; there's a ZC wiki article on this (http://www.zen-cart.com/wiki/index.php/Troubleshooting_-_SQL_Patches#Cannot_insert_configuration_key_.22.22_because_it_already_exists).

Anyway, if you edit the /v1.5 and v1.5.1 install/faq_install.sql file to remove the 'backticks' and re-run the SQL (after running the uninstall SQL) it should be OK. I've highlighted the sections in red that you'll need to edit (and I didn't include the entire installation SQL file):
......
I've seen this error on another plugin (don't remember which), and it seems to be highly related to the version of MySQL that you are running. If you use your admin's Tools->Server/Version Information, you'll see what version of mySQL your shop runs on ... it might be interesting for others to know what version that is.

The hosting data for my store is:
Database: MySQL 5.0.92-log
Server Date: 10/24/2012 18:32:04 Database Date: 10/24/2012 11:32:04
HTTP Server: Apache
PHP Version: 5.3.14 (Zend: 2.3.0) PHP Memory Limit: 64M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 32M POST Max Size: 33M

I am in the process of editing v1.5.1 install/faq_install.sql file to remove the 'backticks' . Thanks

25 Oct 2012, 7:34 AM
#35
arsanat avatar

arsanat

New Zenner

Join Date:
Sep 2012
Location:
Monterrey (metropolitan area) NL, MEXICO
Posts:
11
Plugin Contributions:
0

Re: FAQ Module [Support]

lat9:

arsanat, your problem seems to be due to the use of 'backticks' in the FAQ module's installation SQL; there's a ZC wiki article on this (http://www.zen-cart.com/wiki/index.php/Troubleshooting_-_SQL_Patches#Cannot_insert_configuration_key_.22.22_because_it_already_exists).

Anyway, if you edit the /v1.5 and v1.5.1 install/faq_install.sql file to remove the 'backticks' and re-run the SQL (after running the uninstall SQL) it should be OK. I've highlighted the sections in red that you'll need to edit (and I didn't include the entire installation SQL file):
.....

I have edited out backticks from the install and uninstall sql files for v2.2. I had uninstalled previously with the unedited script, but on trying to install the edited script I get the following log debug message:

[25-Oct-2012 06:49:26 UTC] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''faqs_description'' at line 1 :: DROP TABLE IF EXISTS zen_'faqs_description'; in /home/content/01/9781801/html/includes/classes/db/mysql/query_factory.php on line 120

The corresponding edited code seems to me to be:

DROP TABLE IF EXISTS 'faqs_description';
CREATE TABLE 'faqs_description' (
  'faqs_id' int(11) NOT NULL auto_increment,
  'language_id' int(11) NOT NULL default '1',
  'faqs_name' varchar(500) NOT NULL default '',
  'faqs_answer' text,
  'faqs_viewed' int(5) default '0',
  PRIMARY KEY  ('faqs_id','language_id'),
  KEY 'faqs_name' ('faqs_name')
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

Please help me find the reason for the bug. Thank you

25 Oct 2012, 11:19 AM
#36
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,140
Plugin Contributions:
56

Re: FAQ Module [Support]

You've changed the backticks to quotes instead of removing them. Here's an updated version of the install SQL:

DROP TABLE IF EXISTS faq_categories;
CREATE TABLE faq_categories (
  faq_categories_id int(11) NOT NULL auto_increment,
  parent_id int(11) NOT NULL default '0',
  sort_order int(3) default NULL,
  date_added datetime default NULL,
  last_modified datetime default NULL,
  faq_categories_status tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (faq_categories_id),
  KEY idx_faq_categories_parent_id (parent_id),
  KEY idx_sort_order (sort_order)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

DROP TABLE IF EXISTS faq_categories_description;
CREATE TABLE faq_categories_description (
  faq_categories_id int(11) NOT NULL default '0',
  language_id int(11) NOT NULL default '1',
  faq_categories_name varchar(400) NOT NULL default '',
  faq_categories_description text NOT NULL,
  PRIMARY KEY  (faq_categories_id,language_id),
  KEY idx_faq_categories_name (faq_categories_name)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

DROP TABLE IF EXISTS faqs;
CREATE TABLE faqs (
  faqs_id int(11) NOT NULL auto_increment,
  faqs_date_added datetime NOT NULL default '0001-01-01 00:00:00',
  faqs_last_modified datetime default NULL,
  faqs_status tinyint(1) NOT NULL default '0',
  faqs_sort_order int(11) NOT NULL default '0',
  master_faq_categories_id int(11) NOT NULL default '0',
  PRIMARY KEY  (faqs_id),
  KEY idx_faqs_date_added (faqs_date_added)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;


DROP TABLE IF EXISTS faqs_description;
CREATE TABLE faqs_description (
  faqs_id int(11) NOT NULL auto_increment,
  language_id int(11) NOT NULL default '1',
  faqs_name varchar(500) NOT NULL default '',
  faqs_answer text,
  faqs_viewed int(5) default '0',
  PRIMARY KEY  (faqs_id,language_id),
  KEY faqs_name (faqs_name)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

DROP TABLE IF EXISTS faqs_to_faq_categories;
CREATE TABLE faqs_to_faq_categories (
  faqs_id int(11) NOT NULL default '0',
  faq_categories_id int(11) NOT NULL default '0',
  PRIMARY KEY  (faqs_id,faq_categories_id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

DROP TABLE IF EXISTS faqs_featured;
CREATE TABLE IF NOT EXISTS faqs_featured (
  featured_faqs_id int(11) NOT NULL auto_increment,
  faqs_id int(11) NOT NULL default '0',
  featured_date_added datetime default NULL,
  featured_last_modified datetime default NULL,
  expires_date date NOT NULL default '0001-01-01',
  date_status_change datetime default NULL,
  status int(1) NOT NULL default '1',
  featured_date_available date NOT NULL default '0001-01-01',
  PRIMARY KEY  (featured_faqs_id),
  KEY idx_status_zen (status),
  KEY idx_faqs_id_zen (faqs_id),
  KEY idx_date_avail_zen (featured_date_available),
  KEY idx_expires_date_zen (expires_date)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

SELECT @cid:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'FAQ Manager';
DELETE FROM configuration WHERE configuration_group_id = @cid AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @cid AND configuration_group_id != 0;

INSERT INTO configuration_group VALUES (NULL, 'FAQ Manager', 'Set FAQ Manager Options', '1', '1');
SET @cid=last_insert_id();
UPDATE configuration_group SET sort_order = @cid WHERE configuration_group_id = @cid;
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES 
(NULL, 'Admin - Configuration Group ID', 'FAQ_LISTS_GROUP_ID_ALL', @cid, '<br/>Warning: Only change this if your FAQs Group ID has changed from the default<br /><br/>What is the configuration_group_id for FAQ Listings?<br/>', @cid, 1, NOW(), NULL, NULL),
(NULL, 'Admin - Maximum FAQ Categories FAQs Display List', 'MAX_DISPLAY_RESULTS_FAQ_CATEGORIES', '10', '<br/>Number of FAQs to list per screen in the admin display<br/>', @cid, 1, NOW(), NULL, NULL),
(NULL, 'FAQ Info - Breadcrumb Status', 'DEFINE_FAQ_BREADCRUMB_STATUS', '1', '<br/>Show the breadcrumb on the FAQ info pages?<br/>', @cid, 9, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),'),
(NULL, 'FAQ Info - Breadcrumb Seperator', 'FAQ_BREAD_CRUMBS_SEPARATOR', ':', '<br/>Enter the separator symbol to appear between links on the FAQ breadcrumb<br/><br/>Note: Include spaces with the &nbsp; symbol if you want them part of the separator.<br /><br/>Default = &nbsp;::&nbsp;', @cid, 10, NOW(), NULL, 'zen_cfg_textarea_small('),
(NULL, 'FAQ Info - Prev/Next Navigation Bar Status', 'FAQ_INFO_PREVIOUS_NEXT_STATUS', '1', '<br/>Show the prev/next navigation bar on the FAQ info pages?<br/>', @cid, 11, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),'),
(NULL, 'FAQ Info - Prev/Next Navigation Bar Position', 'FAQ_INFO_PREVIOUS_NEXT_POSITION', '1', '<br/>Set the location of prev/next navigation bar on the FAQ info pages<br/>', @cid, 12, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'Top of Page\'), array(\'id\'=>\'2\', \'text\'=>\'Bottom of Page\'), array(\'id\'=>\'3\', \'text\'=>\'Both Top & Bottom of Page\')),'),
(NULL, 'FAQ Info - Prev/Next Sort Order', 'FAQ_INFO_PREVIOUS_NEXT_SORT', '1', '<br/>Sort order of prev/next navigation bar on the FAQ info pages<br/>', @cid, 13, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'FAQ Name\'), array(\'id\'=>\'2\', \'text\'=>\'FAQ Name DESC\'), array(\'id\'=>\'3\', \'text\'=>\'FAQ Sort Order, FAQ Category Sort Order\'), array(\'id\'=>\'4\', \'text\'=>\'FAQ Category Sort Order\'), array(\'id\'=>\'5\', \'text\'=>\'Date Added DESC, FAQs Name\'), array(\'id\'=>\'5\', \'text\'=>\'Date Added DESC, FAQs Name\'), array(\'id\'=>\'7\', \'text\'=>\'FAQs Sort Order\')),'),
(NULL, 'FAQ Info - Back Button Status', 'FAQ_INFO_BACK_BUTTON', '1', '<br/>Show the back button on the FAQ info pages?<br/>', @cid, 14, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),'),
(NULL, 'FAQ Index - Max Display', 'MAX_DISPLAY_FAQS_ALL', '20', '<br/>Number of FAQs to show on the main FAQ index page<br/>', @cid, 20, NOW(), NULL, NULL),
(NULL, 'FAQ Index - Default Sort Order', 'FAQ_SORT_DEFAULT', '3', '<br/>Sets the default FAQ sort order<br />', @cid, 22, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'FAQ Name A - Z\'), array(\'id\'=>\'2\', \'text\'=>\'FAQs Name Z - A\'), array(\'id\'=>\'3\', \'text\'=>\'Category Name with Admin Sort Order\'), array(\'id\'=>\'4\', \'text\'=>\'Admin Defined Sort Order\'), array(\'id\'=>\'6\', \'text\'=>\'Date Added Oldest First\'), array(\'id\'=>\'7\', \'text\'=>\'Date Added Newest First\')),'),
(NULL, 'FAQ Index - Display Sorter', 'FAQ_ALL_DISPLAY_SORT_ORDER', '1', '<br/>Show the FAQ sorter on the FAQ index page?<br/>', @cid, 23, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),'),
(NULL, 'FAQ Index - Prev/Next Navigation Bar Status', 'FAQ_INDEX_PREVIOUS_NEXT_STATUS', '1', '<br/>Show the prev/next navigation bar on the FAQ index page?<br/>', @cid, 24, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),'),
(NULL, 'FAQ Index - Prev/Next Navigation Bar Position', 'FAQ_INDEX_PREVIOUS_NEXT_POSITION', '1', '<br/>Set the location of prev/next navigation bar on the FAQ index page<br/>', @cid, 25, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'Top of Page\'), array(\'id\'=>\'2\', \'text\'=>\'Bottom of Page\'), array(\'id\'=>\'3\', \'text\'=>\'Both Top & Bottom of Page\')),'),
(NULL, 'FAQ Index - Show Featured FAQs', 'SHOW_FEATURED_FAQS_INDEX', '1', 'Show featured FAQs on the main FAQ index page?', @cid, 26, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),'),
(NULL, 'FAQ Index - Max Display Featured FAQs', 'MAX_DISPLAY_SEARCH_RESULTS_FEATURED_FAQ', '5', '<br/>Number of featured FAQs to show on the main FAQ index page<br/>', @cid, 27, NOW(), NULL, NULL),
(NULL, 'FAQ Category Box - Show Counter', 'SHOW_FAQ_COUNTS', 'true', '<br/>Count recursively how many products are in each category<br/><br/>default=true<br/>', @cid, 50, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),' ),
(NULL, 'FAQ Category Box - Count Prefix', 'FAQ_CATEGORIES_COUNT_PREFIX', ' (', '<br/>What do you want to prefix the FAQ count with?<br/><br/>Default= " ("<br/>', @cid, 51, NOW(), NULL, 'zen_cfg_textarea_small(' ),
(NULL, 'FAQ Category Box - Count Suffix', 'FAQ_CATEGORIES_COUNT_SUFFIX', ')', '<br/>What do you want as a suffix to the FAQ count?<br/><br/>Default= ")"<br/>', @cid, 52, NOW(), NULL, 'zen_cfg_textarea_small(' ),
(NULL, 'FAQ Category Box - Categories with 0 FAQs Status', 'FAQ_CATEGORIES_COUNT_ZERO', '1', '<br/>Show FAQ Count for categories with no active FAQs?<br/>', @cid, 53, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),' ),
(NULL, 'Display FAQ Name', 'FAQ_ALL_LIST_NAME', '2101', 'Do you want to display the FAQ Name?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @cid, 82, NOW(), NULL, NULL); 

INSERT IGNORE INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configFAQManager','BOX_CATALOG_FAQ_MANAGER','FILENAME_FAQ_MANAGER',CONCAT('gID=',@cid),'extras','Y',@cid);

and an updated version of the uninstall SQL:

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'FAQ Manager'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;

DELETE FROM admin_pages WHERE page_key = 'configFAQManager' LIMIT 1;

DROP TABLE faqs ,
faqs_description ,
faqs_featured ,
faqs_to_faq_categories ,
faq_categories ,
faq_categories_description ;

In each case, I've removed the backticks and added the bits in red, per this post by swguy: http://www.zen-cart.com/showthread.php?194965-Mod-Authors-Please-read-if-you-are-creating-install-sql-files

1 Nov 2012, 12:04 PM
#37
honda_crunch avatar

honda_crunch

New Zenner

Join Date:
Jul 2011
Posts:
22
Plugin Contributions:
0

Re: FAQ Module [Support]

Just a few questions.....

I have installed this mod on our testing server with the hope of putting it on our live site when I'm sure everything is working.

  1. installed sql - sucess!
  2. installed catalog files - success!
  3. installed admin files - white screen in admin, removed config.faq.manager.php in admin/auto_loaders admin now works and faqs also work. Is it correct to remove the file after install in this mod?
  4. set categories box to show on top of left column - white screen after properly displayed header. Looks like page will show properly until it reaches the categories box code then stops responding. Tweaked code in includes/modules/sideboxes/faq_categories.php. Managed to get site working, but no sign of a category box. Is this normal?

Basically wipped out section:

//   $show_faq_categories = true;
// if ($_GET['main_page']=='faqs_all' or $_GET['main_page']=='faq_info')  {
  // show it
//  $show_faq_categories = true; 
//} else {
  // do not show it
//  $show_faq_categories = false;
//}

Also tried changing the = to ==.

if ($show_faq_categories == true) {
 ($_GET['main_page']=='faqs_all' or $_GET['main_page']=='faq_info');
  // show it
  $show_faq_categories == true; 
} else {
  // do not show it
  $show_faq_categories == false;
}  

Not the correct thing to do but it brought my page back. Of cause the other thing to do was to hide the box in layout boxes controller.
Apart from that, I have created some categories and questions, placed links in the information sidebox and product info. All of which work perfectly.
Rather hestitant to put it on our live site until I'm sure about the categories box.

1 Nov 2012, 3:10 PM
#38
kamelion0927 avatar

kamelion0927

Zen Follower

Join Date:
Dec 2009
Posts:
208
Plugin Contributions:
1

Re: FAQ Module [Support]

honda-crunch:

Just a few questions.....

I have installed this mod on our testing server with the hope of putting it on our live site when I'm sure everything is working.

  1. installed sql - sucess!
  2. installed catalog files - success!
  3. installed admin files - white screen in admin, removed config.faq.manager.php in admin/auto_loaders admin now works and faqs also work. Is it correct to remove the file after install in this mod?
  4. set categories box to show on top of left column - white screen after properly displayed header. Looks like page will show properly until it reaches the categories box code then stops responding. Tweaked code in includes/modules/sideboxes/faq_categories.php. Managed to get site working, but no sign of a category box. Is this normal?

Basically wipped out section:

// $show_faq_categories = true;
// if ($_GET['main_page']=='faqs_all' or $_GET['main_page']=='faq_info') {
// show it
// $show_faq_categories = true;
//} else {
// do not show it
// $show_faq_categories = false;
//}

> 
> Also tried changing the = to ==. 
> ```php
if ($show_faq_categories == true) {
 ($_GET['main_page']=='faqs_all' or $_GET['main_page']=='faq_info');
  // show it
  $show_faq_categories == true; 
} else {
  // do not show it
  $show_faq_categories == false;
}  

Not the correct thing to do but it brought my page back. Of cause the other thing to do was to hide the box in layout boxes controller.
Apart from that, I have created some categories and questions, placed links in the information sidebox and product info. All of which work perfectly.
Rather hestitant to put it on our live site until I'm sure about the categories box.

What version of zen cart are you using? If you're getting a white screen, there will be an error log in either your cache folder (if you're using version 1.39 or 1.5) or in the log folder (if you're using v1.51).

1 Nov 2012, 3:15 PM
#39
kamelion0927 avatar

kamelion0927

Zen Follower

Join Date:
Dec 2009
Posts:
208
Plugin Contributions:
1

Re: FAQ Module [Support]

lat9:

You've changed the backticks to quotes instead of removing them. Here's an updated version of the install SQL:

DROP TABLE IF EXISTS faq_categories;
CREATE TABLE faq_categories (
faq_categories_id int(11) NOT NULL auto_increment,
parent_id int(11) NOT NULL default '0',
sort_order int(3) default NULL,
date_added datetime default NULL,
last_modified datetime default NULL,
faq_categories_status tinyint(1) NOT NULL default '1',
PRIMARY KEY (faq_categories_id),
KEY idx_faq_categories_parent_id (parent_id),
KEY idx_sort_order (sort_order)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

DROP TABLE IF EXISTS faq_categories_description;
CREATE TABLE faq_categories_description (
faq_categories_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '1',
faq_categories_name varchar(400) NOT NULL default '',
faq_categories_description text NOT NULL,
PRIMARY KEY (faq_categories_id,language_id),
KEY idx_faq_categories_name (faq_categories_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

DROP TABLE IF EXISTS faqs;
CREATE TABLE faqs (
faqs_id int(11) NOT NULL auto_increment,
faqs_date_added datetime NOT NULL default '0001-01-01 00:00:00',
faqs_last_modified datetime default NULL,
faqs_status tinyint(1) NOT NULL default '0',
faqs_sort_order int(11) NOT NULL default '0',
master_faq_categories_id int(11) NOT NULL default '0',
PRIMARY KEY (faqs_id),
KEY idx_faqs_date_added (faqs_date_added)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

DROP TABLE IF EXISTS faqs_description;
CREATE TABLE faqs_description (
faqs_id int(11) NOT NULL auto_increment,
language_id int(11) NOT NULL default '1',
faqs_name varchar(500) NOT NULL default '',
faqs_answer text,
faqs_viewed int(5) default '0',
PRIMARY KEY (faqs_id,language_id),
KEY faqs_name (faqs_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

DROP TABLE IF EXISTS faqs_to_faq_categories;
CREATE TABLE faqs_to_faq_categories (
faqs_id int(11) NOT NULL default '0',
faq_categories_id int(11) NOT NULL default '0',
PRIMARY KEY (faqs_id,faq_categories_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

DROP TABLE IF EXISTS faqs_featured;
CREATE TABLE IF NOT EXISTS faqs_featured (
featured_faqs_id int(11) NOT NULL auto_increment,
faqs_id int(11) NOT NULL default '0',
featured_date_added datetime default NULL,
featured_last_modified datetime default NULL,
expires_date date NOT NULL default '0001-01-01',
date_status_change datetime default NULL,
status int(1) NOT NULL default '1',
featured_date_available date NOT NULL default '0001-01-01',
PRIMARY KEY (featured_faqs_id),
KEY idx_status_zen (status),
KEY idx_faqs_id_zen (faqs_id),
KEY idx_date_avail_zen (featured_date_available),
KEY idx_expires_date_zen (expires_date)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

SELECT @cid:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'FAQ Manager';
DELETE FROM configuration WHERE configuration_group_id = @cid AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @cid AND configuration_group_id != 0;

INSERT INTO configuration_group VALUES (NULL, 'FAQ Manager', 'Set FAQ Manager Options', '1', '1');
SET @cid=last_insert_id();
UPDATE configuration_group SET sort_order = @cid WHERE configuration_group_id = @cid;
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES
(NULL, 'Admin - Configuration Group ID', 'FAQ_LISTS_GROUP_ID_ALL', @cid, '<br/>Warning: Only change this if your FAQs Group ID has changed from the default<br /><br/>What is the configuration_group_id for FAQ Listings?<br/>', @cid, 1, NOW(), NULL, NULL),
(NULL, 'Admin - Maximum FAQ Categories FAQs Display List', 'MAX_DISPLAY_RESULTS_FAQ_CATEGORIES', '10', '<br/>Number of FAQs to list per screen in the admin display<br/>', @cid, 1, NOW(), NULL, NULL),
(NULL, 'FAQ Info - Breadcrumb Status', 'DEFINE_FAQ_BREADCRUMB_STATUS', '1', '<br/>Show the breadcrumb on the FAQ info pages?<br/>', @cid, 9, NOW(), NULL, 'zen_cfg_select_drop_down(array(array('id'=>'0', 'text'=>'Off'), array('id'=>'1', 'text'=>'On')),'),
(NULL, 'FAQ Info - Breadcrumb Seperator', 'FAQ_BREAD_CRUMBS_SEPARATOR', ':', '<br/>Enter the separator symbol to appear between links on the FAQ breadcrumb<br/><br/>Note: Include spaces with the   symbol if you want them part of the separator.<br /><br/>Default =  :: ', @cid, 10, NOW(), NULL, 'zen_cfg_textarea_small('),
(NULL, 'FAQ Info - Prev/Next Navigation Bar Status', 'FAQ_INFO_PREVIOUS_NEXT_STATUS', '1', '<br/>Show the prev/next navigation bar on the FAQ info pages?<br/>', @cid, 11, NOW(), NULL, 'zen_cfg_select_drop_down(array(array('id'=>'0', 'text'=>'Off'), array('id'=>'1', 'text'=>'On')),'),
(NULL, 'FAQ Info - Prev/Next Navigation Bar Position', 'FAQ_INFO_PREVIOUS_NEXT_POSITION', '1', '<br/>Set the location of prev/next navigation bar on the FAQ info pages<br/>', @cid, 12, NOW(), NULL, 'zen_cfg_select_drop_down(array(array('id'=>'0', 'text'=>'Off'), array('id'=>'1', 'text'=>'Top of Page'), array('id'=>'2', 'text'=>'Bottom of Page'), array('id'=>'3', 'text'=>'Both Top & Bottom of Page')),'),
(NULL, 'FAQ Info - Prev/Next Sort Order', 'FAQ_INFO_PREVIOUS_NEXT_SORT', '1', '<br/>Sort order of prev/next navigation bar on the FAQ info pages<br/>', @cid, 13, NOW(), NULL, 'zen_cfg_select_drop_down(array(array('id'=>'1', 'text'=>'FAQ Name'), array('id'=>'2', 'text'=>'FAQ Name DESC'), array('id'=>'3', 'text'=>'FAQ Sort Order, FAQ Category Sort Order'), array('id'=>'4', 'text'=>'FAQ Category Sort Order'), array('id'=>'5', 'text'=>'Date Added DESC, FAQs Name'), array('id'=>'5', 'text'=>'Date Added DESC, FAQs Name'), array('id'=>'7', 'text'=>'FAQs Sort Order')),'),
(NULL, 'FAQ Info - Back Button Status', 'FAQ_INFO_BACK_BUTTON', '1', '<br/>Show the back button on the FAQ info pages?<br/>', @cid, 14, NOW(), NULL, 'zen_cfg_select_drop_down(array(array('id'=>'0', 'text'=>'Off'), array('id'=>'1', 'text'=>'On')),'),
(NULL, 'FAQ Index - Max Display', 'MAX_DISPLAY_FAQS_ALL', '20', '<br/>Number of FAQs to show on the main FAQ index page<br/>', @cid, 20, NOW(), NULL, NULL),
(NULL, 'FAQ Index - Default Sort Order', 'FAQ_SORT_DEFAULT', '3', '<br/>Sets the default FAQ sort order<br />', @cid, 22, NOW(), NULL, 'zen_cfg_select_drop_down(array(array('id'=>'1', 'text'=>'FAQ Name A - Z'), array('id'=>'2', 'text'=>'FAQs Name Z - A'), array('id'=>'3', 'text'=>'Category Name with Admin Sort Order'), array('id'=>'4', 'text'=>'Admin Defined Sort Order'), array('id'=>'6', 'text'=>'Date Added Oldest First'), array('id'=>'7', 'text'=>'Date Added Newest First')),'),
(NULL, 'FAQ Index - Display Sorter', 'FAQ_ALL_DISPLAY_SORT_ORDER', '1', '<br/>Show the FAQ sorter on the FAQ index page?<br/>', @cid, 23, NOW(), NULL, 'zen_cfg_select_drop_down(array(array('id'=>'0', 'text'=>'Off'), array('id'=>'1', 'text'=>'On')),'),
(NULL, 'FAQ Index - Prev/Next Navigation Bar Status', 'FAQ_INDEX_PREVIOUS_NEXT_STATUS', '1', '<br/>Show the prev/next navigation bar on the FAQ index page?<br/>', @cid, 24, NOW(), NULL, 'zen_cfg_select_drop_down(array(array('id'=>'0', 'text'=>'Off'), array('id'=>'1', 'text'=>'On')),'),
(NULL, 'FAQ Index - Prev/Next Navigation Bar Position', 'FAQ_INDEX_PREVIOUS_NEXT_POSITION', '1', '<br/>Set the location of prev/next navigation bar on the FAQ index page<br/>', @cid, 25, NOW(), NULL, 'zen_cfg_select_drop_down(array(array('id'=>'0', 'text'=>'Off'), array('id'=>'1', 'text'=>'Top of Page'), array('id'=>'2', 'text'=>'Bottom of Page'), array('id'=>'3', 'text'=>'Both Top & Bottom of Page')),'),
(NULL, 'FAQ Index - Show Featured FAQs', 'SHOW_FEATURED_FAQS_INDEX', '1', 'Show featured FAQs on the main FAQ index page?', @cid, 26, NOW(), NULL, 'zen_cfg_select_drop_down(array(array('id'=>'0', 'text'=>'Off'), array('id'=>'1', 'text'=>'On')),'),
(NULL, 'FAQ Index - Max Display Featured FAQs', 'MAX_DISPLAY_SEARCH_RESULTS_FEATURED_FAQ', '5', '<br/>Number of featured FAQs to show on the main FAQ index page<br/>', @cid, 27, NOW(), NULL, NULL),
(NULL, 'FAQ Category Box - Show Counter', 'SHOW_FAQ_COUNTS', 'true', '<br/>Count recursively how many products are in each category<br/><br/>default=true<br/>', @cid, 50, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),' ),
(NULL, 'FAQ Category Box - Count Prefix', 'FAQ_CATEGORIES_COUNT_PREFIX', ' (', '<br/>What do you want to prefix the FAQ count with?<br/><br/>Default= " ("<br/>', @cid, 51, NOW(), NULL, 'zen_cfg_textarea_small(' ),
(NULL, 'FAQ Category Box - Count Suffix', 'FAQ_CATEGORIES_COUNT_SUFFIX', ')', '<br/>What do you want as a suffix to the FAQ count?<br/><br/>Default= ")"<br/>', @cid, 52, NOW(), NULL, 'zen_cfg_textarea_small(' ),
(NULL, 'FAQ Category Box - Categories with 0 FAQs Status', 'FAQ_CATEGORIES_COUNT_ZERO', '1', '<br/>Show FAQ Count for categories with no active FAQs?<br/>', @cid, 53, NOW(), NULL, 'zen_cfg_select_drop_down(array(array('id'=>'0', 'text'=>'Off'), array('id'=>'1', 'text'=>'On')),' ),
(NULL, 'Display FAQ Name', 'FAQ_ALL_LIST_NAME', '2101', 'Do you want to display the FAQ Name?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @cid, 82, NOW(), NULL, NULL);

INSERT IGNORE INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configFAQManager','BOX_CATALOG_FAQ_MANAGER','FILENAME_FAQ_MANAGER',CONCAT('gID=',@cid),'extras','Y',@cid);

> 
> and an updated version of the uninstall SQL:
> 
> ```
SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'FAQ Manager'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;

DELETE FROM admin_pages WHERE page_key = 'configFAQManager' LIMIT 1;

DROP TABLE faqs ,
faqs_description ,
faqs_featured ,
faqs_to_faq_categories ,
faq_categories ,
faq_categories_description ;

In each case, I've removed the backticks and added the bits in red, per this post by swguy: http://www.zen-cart.com/showthread.php?194965-Mod-Authors-Please-read-if-you-are-creating-install-sql-files

Hey thanks lat9! You so totally rock. I was having the same problem with a different mod and now I know why.

2 Nov 2012, 7:16 AM
#40
arsanat avatar

arsanat

New Zenner

Join Date:
Sep 2012
Location:
Monterrey (metropolitan area) NL, MEXICO
Posts:
11
Plugin Contributions:
0

Re: FAQ Module [Support]

lat9:

You've changed the backticks to quotes instead of removing them. Here's an updated version of the install SQL:

.......

and an updated version of the uninstall SQL:

........

In each case, I've removed the backticks and added the bits in red, per this post by swguy: http://www.zen-cart.com/showthread.php?194965-Mod-Authors-Please-read-if-you-are-creating-install-sql-files

Thank you very much LAT9 for writing the install and uninstall files without backticks. The uninstall did not run on the SQL patch of the store, but the original file did. The install file without backticks did run but did not solve the problem; Query reply:
20 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists

So, daring into deep waters (poodles) I did add zen_ to all tables in the install file without backticks and sent it as query with phpMyAdmin and, finally, a faq table was created in the MySQL data base :D the code submitted was:

DROP TABLE IF EXISTS zen_faq_categories;
CREATE TABLE zen_faq_categories (
  faq_categories_id int(11) NOT NULL auto_increment,
  parent_id int(11) NOT NULL default '0',
  sort_order int(3) default NULL,
  date_added datetime default NULL,
  last_modified datetime default NULL,
  faq_categories_status tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (faq_categories_id),
  KEY idx_faq_categories_parent_id (parent_id),
  KEY idx_sort_order (sort_order)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

DROP TABLE IF EXISTS zen_faq_categories_description;
CREATE TABLE zen_faq_categories_description (
  faq_categories_id int(11) NOT NULL default '0',
  language_id int(11) NOT NULL default '1',
  faq_categories_name varchar(400) NOT NULL default '',
  faq_categories_description text NOT NULL,
  PRIMARY KEY  (faq_categories_id,language_id),
  KEY idx_faq_categories_name (faq_categories_name)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

DROP TABLE IF EXISTS zen_faqs;
CREATE TABLE zen_faqs (
  faqs_id int(11) NOT NULL auto_increment,
  faqs_date_added datetime NOT NULL default '0001-01-01 00:00:00',
  faqs_last_modified datetime default NULL,
  faqs_status tinyint(1) NOT NULL default '0',
  faqs_sort_order int(11) NOT NULL default '0',
  master_faq_categories_id int(11) NOT NULL default '0',
  PRIMARY KEY  (faqs_id),
  KEY idx_faqs_date_added (faqs_date_added)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;


DROP TABLE IF EXISTS zen_faqs_description;
CREATE TABLE zen_faqs_description (
  faqs_id int(11) NOT NULL auto_increment,
  language_id int(11) NOT NULL default '1',
  faqs_name varchar(500) NOT NULL default '',
  faqs_answer text,
  faqs_viewed int(5) default '0',
  PRIMARY KEY  (faqs_id,language_id),
  KEY faqs_name (faqs_name)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

DROP TABLE IF EXISTS zen_faqs_to_faq_categories;
CREATE TABLE zen_faqs_to_faq_categories (
  faqs_id int(11) NOT NULL default '0',
  faq_categories_id int(11) NOT NULL default '0',
  PRIMARY KEY  (faqs_id,faq_categories_id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

DROP TABLE IF EXISTS zen_faqs_featured;
CREATE TABLE IF NOT EXISTS zen_faqs_featured (
  featured_faqs_id int(11) NOT NULL auto_increment,
  faqs_id int(11) NOT NULL default '0',
  featured_date_added datetime default NULL,
  featured_last_modified datetime default NULL,
  expires_date date NOT NULL default '0001-01-01',
  date_status_change datetime default NULL,
  status int(1) NOT NULL default '1',
  featured_date_available date NOT NULL default '0001-01-01',
  PRIMARY KEY  (featured_faqs_id),
  KEY idx_status_zen (status),
  KEY idx_faqs_id_zen (faqs_id),
  KEY idx_date_avail_zen (featured_date_available),
  KEY idx_expires_date_zen (expires_date)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

SELECT @cid:=configuration_group_id
FROM zen_configuration_group
WHERE configuration_group_title= 'FAQ Manager';
DELETE FROM zen_configuration WHERE configuration_group_id = @cid AND configuration_group_id != 0;
DELETE FROM zen_configuration_group WHERE configuration_group_id = @cid AND configuration_group_id != 0;

INSERT INTO zen_configuration_group VALUES (NULL, 'FAQ Manager', 'Set FAQ Manager Options', '1', '1');
SET @cid=last_insert_id();
UPDATE zen_configuration_group SET sort_order = @cid WHERE configuration_group_id = @cid;
INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES 
(NULL, 'Admin - Configuration Group ID', 'FAQ_LISTS_GROUP_ID_ALL', @cid, '<br/>Warning: Only change this if your FAQs Group ID has changed from the default<br /><br/>What is the configuration_group_id for FAQ Listings?<br/>', @cid, 1, NOW(), NULL, NULL),
(NULL, 'Admin - Maximum FAQ Categories FAQs Display List', 'MAX_DISPLAY_RESULTS_FAQ_CATEGORIES', '10', '<br/>Number of FAQs to list per screen in the admin display<br/>', @cid, 1, NOW(), NULL, NULL),
(NULL, 'FAQ Info - Breadcrumb Status', 'DEFINE_FAQ_BREADCRUMB_STATUS', '1', '<br/>Show the breadcrumb on the FAQ info pages?<br/>', @cid, 9, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),'),
(NULL, 'FAQ Info - Breadcrumb Seperator', 'FAQ_BREAD_CRUMBS_SEPARATOR', ':', '<br/>Enter the separator symbol to appear between links on the FAQ breadcrumb<br/><br/>Note: Include spaces with the &nbsp; symbol if you want them part of the separator.<br /><br/>Default = &nbsp;::&nbsp;', @cid, 10, NOW(), NULL, 'zen_cfg_textarea_small('),
(NULL, 'FAQ Info - Prev/Next Navigation Bar Status', 'FAQ_INFO_PREVIOUS_NEXT_STATUS', '1', '<br/>Show the prev/next navigation bar on the FAQ info pages?<br/>', @cid, 11, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),'),
(NULL, 'FAQ Info - Prev/Next Navigation Bar Position', 'FAQ_INFO_PREVIOUS_NEXT_POSITION', '1', '<br/>Set the location of prev/next navigation bar on the FAQ info pages<br/>', @cid, 12, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'Top of Page\'), array(\'id\'=>\'2\', \'text\'=>\'Bottom of Page\'), array(\'id\'=>\'3\', \'text\'=>\'Both Top & Bottom of Page\')),'),
(NULL, 'FAQ Info - Prev/Next Sort Order', 'FAQ_INFO_PREVIOUS_NEXT_SORT', '1', '<br/>Sort order of prev/next navigation bar on the FAQ info pages<br/>', @cid, 13, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'FAQ Name\'), array(\'id\'=>\'2\', \'text\'=>\'FAQ Name DESC\'), array(\'id\'=>\'3\', \'text\'=>\'FAQ Sort Order, FAQ Category Sort Order\'), array(\'id\'=>\'4\', \'text\'=>\'FAQ Category Sort Order\'), array(\'id\'=>\'5\', \'text\'=>\'Date Added DESC, FAQs Name\'), array(\'id\'=>\'5\', \'text\'=>\'Date Added DESC, FAQs Name\'), array(\'id\'=>\'7\', \'text\'=>\'FAQs Sort Order\')),'),
(NULL, 'FAQ Info - Back Button Status', 'FAQ_INFO_BACK_BUTTON', '1', '<br/>Show the back button on the FAQ info pages?<br/>', @cid, 14, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),'),
(NULL, 'FAQ Index - Max Display', 'MAX_DISPLAY_FAQS_ALL', '20', '<br/>Number of FAQs to show on the main FAQ index page<br/>', @cid, 20, NOW(), NULL, NULL),
(NULL, 'FAQ Index - Default Sort Order', 'FAQ_SORT_DEFAULT', '3', '<br/>Sets the default FAQ sort order<br />', @cid, 22, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'FAQ Name A - Z\'), array(\'id\'=>\'2\', \'text\'=>\'FAQs Name Z - A\'), array(\'id\'=>\'3\', \'text\'=>\'Category Name with Admin Sort Order\'), array(\'id\'=>\'4\', \'text\'=>\'Admin Defined Sort Order\'), array(\'id\'=>\'6\', \'text\'=>\'Date Added Oldest First\'), array(\'id\'=>\'7\', \'text\'=>\'Date Added Newest First\')),'),
(NULL, 'FAQ Index - Display Sorter', 'FAQ_ALL_DISPLAY_SORT_ORDER', '1', '<br/>Show the FAQ sorter on the FAQ index page?<br/>', @cid, 23, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),'),
(NULL, 'FAQ Index - Prev/Next Navigation Bar Status', 'FAQ_INDEX_PREVIOUS_NEXT_STATUS', '1', '<br/>Show the prev/next navigation bar on the FAQ index page?<br/>', @cid, 24, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),'),
(NULL, 'FAQ Index - Prev/Next Navigation Bar Position', 'FAQ_INDEX_PREVIOUS_NEXT_POSITION', '1', '<br/>Set the location of prev/next navigation bar on the FAQ index page<br/>', @cid, 25, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'Top of Page\'), array(\'id\'=>\'2\', \'text\'=>\'Bottom of Page\'), array(\'id\'=>\'3\', \'text\'=>\'Both Top & Bottom of Page\')),'),
(NULL, 'FAQ Index - Show Featured FAQs', 'SHOW_FEATURED_FAQS_INDEX', '1', 'Show featured FAQs on the main FAQ index page?', @cid, 26, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),'),
(NULL, 'FAQ Index - Max Display Featured FAQs', 'MAX_DISPLAY_SEARCH_RESULTS_FEATURED_FAQ', '5', '<br/>Number of featured FAQs to show on the main FAQ index page<br/>', @cid, 27, NOW(), NULL, NULL),
(NULL, 'FAQ Category Box - Show Counter', 'SHOW_FAQ_COUNTS', 'true', '<br/>Count recursively how many products are in each category<br/><br/>default=true<br/>', @cid, 50, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),' ),
(NULL, 'FAQ Category Box - Count Prefix', 'FAQ_CATEGORIES_COUNT_PREFIX', ' (', '<br/>What do you want to prefix the FAQ count with?<br/><br/>Default= " ("<br/>', @cid, 51, NOW(), NULL, 'zen_cfg_textarea_small(' ),
(NULL, 'FAQ Category Box - Count Suffix', 'FAQ_CATEGORIES_COUNT_SUFFIX', ')', '<br/>What do you want as a suffix to the FAQ count?<br/><br/>Default= ")"<br/>', @cid, 52, NOW(), NULL, 'zen_cfg_textarea_small(' ),
(NULL, 'FAQ Category Box - Categories with 0 FAQs Status', 'FAQ_CATEGORIES_COUNT_ZERO', '1', '<br/>Show FAQ Count for categories with no active FAQs?<br/>', @cid, 53, NOW(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Off\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),' ),
(NULL, 'Display FAQ Name', 'FAQ_ALL_LIST_NAME', '2101', 'Do you want to display the FAQ Name?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @cid, 82, NOW(), NULL, NULL); 

INSERT IGNORE INTO zen_admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configFAQManager','BOX_CATALOG_FAQ_MANAGER','FILENAME_FAQ_MANAGER',CONCAT('gID=',@cid),'extras','Y',@cid);