FAQ Manager

09 Oct 2006, 20:26

#1

Zen Follower

Join Date:: Sep 2004
Posts:: 152
Plugin Contributions:: 0

FAQ Manager

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

24 Oct 2006, 14:59

#2

muaz

New Zenner

Join Date:: Oct 2006
Posts:: 14
Plugin Contributions:: 0

Re: FAQ Manager

Hello,

Me too I have got the same problem. Can someone kindly help with a solution.

Thanks

30 Oct 2006, 04:24

#3

beasleybub

Zen Follower

Join Date:: May 2006
Posts:: 176
Plugin Contributions:: 1

Re: FAQ Manager

I have the same exact errer.
1062 Duplicate entry 'SHOW_FAQ_COUNTS' for key 2
Can someone please fix this?
Thanks:cry:

The only partial solution I have come up with is that the reason this is happening is we are trying to enter data into the database that is already there, or at least some part of it is identical that must not be.

What we are getting there is a duplicate key error. There's a column in the database that has a unique key defined on it, so any time it see's that data is being entered into that column that is identical to data already in the column, we get the error.

30 Oct 2006, 05:23

#4

beasleybub

Zen Follower

Join Date:: May 2006
Posts:: 176
Plugin Contributions:: 1

Re: FAQ Manager

Long story short, I simply replaced "INSERT" with "REPLACE" in the faq_manager.sql file and it worked like a charm. I am attaching the updated faq_manager.sql file.
Worked for me BUT USE AT YOUR OWN RISK.:blink:

30 Oct 2006, 05:59

#5

beasleybub

Zen Follower

Join Date:: May 2006
Posts:: 176
Plugin Contributions:: 1

Re: FAQ Manager

Well before anyone runs and does this. It did work but it also failed.
It did install data to mysql but at the same time it also replaced data already there. So my fix is a start but IT DID NOT WORK.
Can someone with alot more experience give this a crack?
Thanks!:lamo:

04 Nov 2006, 13:27

#6

boyemillar

Zen Follower

Join Date:: Jun 2004
Posts:: 89
Plugin Contributions:: 0

Re: FAQ Manager

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

04 Nov 2006, 23:36

#7

doodlebuckets

Totally Zenned

Join Date:: Jul 2005
Posts:: 497
Plugin Contributions:: 0

Re: FAQ Manager

Fatal error: Cannot instantiate non-existent class: faq_category_tree in /home/fuzzibunz/www/www/store/includes/modules/sideboxes/faq_categories.php on line 22

I'm getting the above error, so my index doesn't load fully and I have no idea if this mod will work.

Anyone have a fix for this? I am running 1.3.6 and the site in question is www.fuzzibunzdepot.com

05 Nov 2006, 01:32

#8

ghgarcia

New Zenner

Join Date:: Sep 2006
Posts:: 34
Plugin Contributions:: 0

Re: FAQ Manager

I'm also getting the following error:

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

The Sql had a problem. Any help would be greatly appreciated.

Thanks

05 Nov 2006, 01:39

#9

beasleybub

Zen Follower

Join Date:: May 2006
Posts:: 176
Plugin Contributions:: 1

Re: FAQ Manager

It looks like faq manager has a bunch of bugs.
I just chose to scrap using it. "Much easier":yes:

05 Nov 2006, 01:57

#10

rnet

Zen Follower

Join Date:: Jun 2005
Posts:: 99
Plugin Contributions:: 0

Re: FAQ Manager

Not sure this is a working contrib, suggest you remove the sql tables and wait for someone to post a solution:

DROP TABLE IF EXISTS faq_categories;
DROP TABLE IF EXISTS faq_categories_description;
DROP TABLE IF EXISTS faq_reviews;
DROP TABLE IF EXISTS faq_reviews_description;
DROP TABLE IF EXISTS faq_type_layout;
DROP TABLE IF EXISTS faq_types;
DROP TABLE IF EXISTS faq_types_to_faq_category;
DROP TABLE IF EXISTS faqs;
DROP TABLE IF EXISTS `faqs_description`;
DROP TABLE IF EXISTS faqs_to_faq_categories;

05 Nov 2006, 11:45

#11

doodlebuckets

Totally Zenned

Join Date:: Jul 2005
Posts:: 497
Plugin Contributions:: 0

Re: FAQ Manager

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

05 Nov 2006, 14:23

#12

ghgarcia

New Zenner

Join Date:: Sep 2006
Posts:: 34
Plugin Contributions:: 0

Re: FAQ Manager

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.

05 Nov 2006, 14:58

#13

rnet

Zen Follower

Join Date:: Jun 2005
Posts:: 99
Plugin Contributions:: 0

Re: FAQ Manager

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.

08 Nov 2006, 00:22

#14

izilla_pod

New Zenner

Join Date:: Sep 2006
Posts:: 26
Plugin Contributions:: 0

Re: FAQ Manager

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.

16 Nov 2006, 03:30

#15

dscott1966

Zen Follower

Join Date:: Apr 2005
Posts:: 298
Plugin Contributions:: 0

Re: FAQ Manager

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.

16 Nov 2006, 09:47

#16

100asa

Totally Zenned

Join Date:: Oct 2006
Posts:: 636
Plugin Contributions:: 0

Re: FAQ Manager

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

19 Nov 2006, 20:54

#17

dehaw

Zen Follower

Join Date:: Feb 2005
Posts:: 423
Plugin Contributions:: 0

Re: FAQ Manager

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

19 Nov 2006, 20:57

#18

dehaw

Zen Follower

Join Date:: Feb 2005
Posts:: 423
Plugin Contributions:: 0

Re: FAQ Manager

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:

p.products_date_available

needs to be changed to

p.faqs_date_available

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

Derek
perfectdesigning.net

27 Nov 2006, 23:56

#19

michaelhl

New Zenner

Join Date:: Oct 2005
Posts:: 60
Plugin Contributions:: 0

Re: FAQ Manager

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.

30 Nov 2006, 14:44

#20

dehaw

Zen Follower

Join Date:: Feb 2005
Posts:: 423
Plugin Contributions:: 0

Re: FAQ Manager

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