FAQ Manager

Well Dang. It's such a great idea too...

I agree so I have removed the module. Having said that I think that it should be removed from the download section until a fix is available.

I really would like to use this module since it could help my customers.

It's always a good idea to check how many have downloaded the module and search for posts before installing any non-stock feature. This will save you a lot of time as some are not compatible with newer versions, or not 100% tested and buggy.

It doesn't work anymore right now. I did not design the actual contribution, I just changed a few lines of code to make it compatible with version 1.3.5. But it obviously does not work with 1.3.6. I would recommend uninstalling it until a fix is found. Sorry about all the confusion.

It has worked for me and i'm using version 1.3.6. With this mod you have to be careful there is a file you have to mod application top. as far as the sql file it works also. if you want me to send you the file i have p.m me.

I've this problem too
1062 Duplicate entry 'SHOW_FAQ_COUNTS' for key 2
in:
[INSERT INTO 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.

somebody have solution?
I've zencart 1.3.5

Quote:

---

Originally Posted by ccn1

I am trying to install the FAQ Manager 1.(2) into our new test system running 1.3.5 of zencart.

The files upload fine, but when I try to install the SQL I get the following 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 deleted the tables in relation to faq_xxxxx but still get the same error as above.... ?

If anyone has any suggestions that would be great.

Many Thanks.
Chris

---

Hi Guys,

Ok, this sql statement is telling you its trying to insert the same piece of code twice into the configuration, this is because there was a duplicate in the sql within the contrib.

I have updated the contrib sql and will reupload the contrib Monday 20 November.

I realise the contrib requires to be updated but this won't be happening anytime soon because we are just too busy, however i will try and reply to this thread as much as i can to resolve some of the problems.

Derek

Quote:

---

Originally Posted by boyemillar

I'm Getting this error on where the sidebox should appear...

1054 Unknown column 'p.products_date_available' in 'where clause'
in:
[select p.faqs_id from faqs p where p.faqs_status = '1' and p.products_date_available >=20061104 limit 1]

Any ideas

---

This is a known bug and i'll also get this changed, this piece of code:

Code:

---

p.products_date_available

---

needs to be changed to

Code:

---

p.faqs_date_available

---

i'll try and make an effort to get this contrib updated and looking good.

Derek
perfectdesigning.net

The changes in application_top.php have as a result, that the text on main page is shown also on every main-category page. This is not what I want. How can we solve this problem. For this time i comment out the changes in application_top and deactivate the FAQ-Sidebox.

Quote:

---

Originally Posted by michaelhl

The changes in application_top.php have as a result, that the text on main page is shown also on every main-category page. This is not what I want. How can we solve this problem. For this time i comment out the changes in application_top and deactivate the FAQ-Sidebox.

---

Do you have a url?

I dont have this loaded on a test server, hence the lack of support, but will do by the end of the year.

Derek