FAQ Manager

[helpme]

Anyone out there that knows what I can do? "if you look at my faqs pages everything is at the bottom of the page, is this how it is suppose to look and also you have to click on the first question and the second question to get the answer." This module would be really great if I can get it right!! Thank you in advance!

Any have any ideas?? I still can't get it to work!

[CJ Internet Sales]

Couple of issues with this module that I need help with.

1. On the page index.php?main_page=faqs_all I am missing an image for BUTTON_IMAGE_SUBMIT_FAQ. It is not in the download.

I tried finding other Zen Cart installs using this module so I could simply copy the image and past it into my cart. Couldn't find anyone in this thread who is currently using the module (who had a link in their thread).

Would someone please either supply this button or give me a chance to copy it from their site?

2. After going to the page that allows a visitor to input their question, when I click the link that is supposed to take me to the Question and Answer page I get this error includes/templates/template_default/templates/tpl_index_default.php on line 39.

Any ideas on these issues would be appreciated.

[Fluffy Bunny]

Anyone that can help us? I'm having issues aswell, could anyone make an updated version please

[Seamstobesew]

A new one has been uploaded in the downloads area, which is the same script updated, but now named Faq Module. I tried installing it but ran into a problem where it gave me a blank page for my entire site, it turns out that the button_names.php file which should go in includes/languages/english is under just the languages folder, and probably needs to be moved to the english folder. It was the only way I got my site back up and running.

Either or, the script is now uninstalled again, I'd love a patch that removes the sql entries as this is something I am unclear on how to do.

I will not try a reinstall again without it nor, will I reinstall till I hear others have it working properly.

Either or, if you have the same thing happen, try moving that button_names.php into the english folder before giving up, and if you have to rename because an original is suppose to be there, I'd try putting it in a template override folder. (This is where I would have put it in the first place).

Another thing...

He's put all the template stuff under template_default, instead of a template_override folder for design. The old one had the templates go to the classic folder under includes/templates. I'm sure it's fine under template_default, but I would have rather seen it go to my template override folder.

Hope these suggestions help for anyone thinking of trying the newest version.

Marian

[lina0962]

hello,

I intalled FAQ manager on my new zencat 1.37.

www.wholesale.thesbeauty.com

In the FAQ list and FAQ new page, the "send now" button is missing. I don't know how to fix it.

Can somebody give me a tip? Thanks

Lina

[Dehaw]

Did you follow the instructions?

It may be that the button is issing from your buttons folder within your template, just copy it in there.

Then make sure the button define is defined properly.

Derek

[ChrisR]

Hi Derek

It seems you have been following this thread the most. I have been trying to install the FAQ module today and have come up with all the same issues everyone has been having from the 1064 syntax error, duplicate key error and when overcomming that the FAQ sidebox would only work in the left column. As soon as you put it on the right side and hit anythin in the catagory, document box it would come up with a p. error that everyone was getting as well. Just so you all know I have no exp with PHP but have been playing with various ways of installing this today and have come up with the following: Hope it helps you out. If anyone sees what I have done will make a mess of something else please let us know as I have no idea.

Step 1:
Follow the instructions to install the files in the Admin and Include files as per the insatll guide.

Step2:
In order to stop the first error you get when using the cart Install SQL patches to run the faq_manager.sql patch (which is a syntax error) you need to change the last section of the script: Lines 2- 6 and line 8. All the end bits that say (array(\'true\', \'false\'),'); change to (array("true", "false"),'); and all the (array(\'0\', \'1\'),'); change to (array("0", "1"),'); this should sort out the syntax error.

Step 3:
If you have installed a previous version or tried this version already and had problems , you must remove all the FAQ files that were created in the database before going to step 4 or you will get the duplicate error.

Step 4:
before running the scrip you need to go tp MyPHP and to the _configuration table. click on the configuration_group_id, press the edit button or pencil. Now go to the "Null" field and change the "NOT NULL" to "NULL" Click on save

Step5:
You can now go to the admin panel in your Zen cart and go to the Tools Menu and click on "Install SQL patches" In the upload file section at the bottom , browse for the faq_manager.sql you changed and select this file. now click on UPLOAD. The scrip should run fine now without any errors.

Step 6:
Now do as in step 4 above and change the "NULL" back to "NOT NULL"

Step 7: Derek this is where u come in plse
I found that if you goto the tpl_faq_catagories.php in the directory includes/templates/template_default/sideboxes and add to // in front of the code in lines 98,99,100 as shown
//$show_this = $db->Execute("select p.faqs_id
// from " . TABLE_FAQS . " p
// where p.faqs_status = 1 " . $display_limit . " limit 1");

You should be able to place the Sidebox on the right hand side without anymore issue.
I must stress that I have no idea what this piece of code does but once eliminated the side box works. Derek as this is now narrowed down perhaps you or someone else can help. Unfortunately if you are using other languages there is still a graphic issue but probably not to difficult to sort out.

Step8: FAQ Send Button
If you go to the includes/modules directory and edit the faqs_all_listing.php and the faqs_new_listing.php both at around line 122 from zen_image_button('BUTTON_IMAGE_SUBMIT_FAQ', BUTTON_SEND_ALT) change to zen_image_button('button_ask_a_question.gif', BUTTON_SEND_ALT)

This should give you the "Ask a question" button supplied in the module.

I hope this was clear enough for all to achieve. Derek or anyone else please come back on the remmed code above if possible. I will keep testing to see if anything else still goes wrong. Any other feedback would also be appreciated.

Good Luck!!! hope it helps

[Kruna]

Hi all,

sorry for double post, I know it is not appreciated, but soemhow I dont get any answer, hopefully have more luck here....dont know what I did wrong, but seems that I am not the only one

http://www.zen-cart.com/forum/showth...ghlight=faq%2A

so please take a look at

http://clickyshop.com/newzen/index.php?main_page=faq

this is the error i get, any idea what will fix it?
Help is much appreciated..

Tahnks in advanced,

regards,
kruna

[xiongzhi555]

Hi Derek


Step2:
In order to stop the first error you get when using the cart Install SQL patches to run the faq_manager.sql patch (which is a syntax error) you need to change the last section of the script: Lines 2- 6 and line 8. All the end bits that say (array(\'true\', \'false\'),'); change to (array("true", "false"),'); and all the (array(\'0\', \'1\'),'); change to (array("0", "1"),'); this should sort out the syntax error.

Step 3:
If you have installed a previous version or tried this version already and had problems , you must remove all the FAQ files that were created in the database before going to step 4 or you will get the duplicate error.

Step 4:
before running the scrip you need to go tp MyPHP and to the _configuration table. click on the configuration_group_id, press the edit button or pencil. Now go to the "Null" field and change the "NOT NULL" to "NULL" Click on save

Step5:
You can now go to the admin panel in your Zen cart and go to the Tools Menu and click on "Install SQL patches" In the upload file section at the bottom , browse for the faq_manager.sql you changed and select this file. now click on UPLOAD. The scrip should run fine now without any errors.

always failed from step 2 to step 5.

here is the information of the error:
1062 Duplicate entry 'SHOW_FAQ_COUNTS' for key 2
in:
[INSERT INTO zen_configuration VALUES ('', 'Show FAQ Category Counts', 'SHOW_FAQ_COUNTS', 'true', 'Count recursively how many FAQs are in each FAQ category', @t4, 9, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[ChrisR]

always failed from step 2 to step 5.

here is the information of the error:
1062 Duplicate entry 'SHOW_FAQ_COUNTS' for key 2
in:
[INSERT INTO zen_configuration VALUES ('', 'Show FAQ Category Counts', 'SHOW_FAQ_COUNTS', 'true', 'Count recursively how many FAQs are in each FAQ category', @t4, 9, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I always got this error if I did not first clear any files created with the first installation attempt. For some reason you only get the syntax error the first time and then if you keep running the script without first clearing the data base files created from the first time you ran the script it will give you the duplicate error all the time but never show you the syntax error from the first try. Did you remove all FAQ files created in the datga base before running the script again.