FAQ Manager

[muaz]

Hello,

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

Thanks

[beasleybub]

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

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.

[beasleybub]

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.

[beasleybub]

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!

[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

[Doodlebuckets]

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

[Dehaw]

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

[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.

[Noutje]

[QUOTE=Dehaw;293636]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 did a search in the files for p.products_date_available but could not find it in the files..

I solved this now by adding a field p.products_date_available in the faq table and now it works perfectly

Still want to know which file contains the where clause that include p.products_date_available

[skunkworx]

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

So I guess there's no answer forthcoming to this then?

i too cant find the text...i originally asked about it last year around june...now i know it's not a revenue generator for you guys but please zencart is a revenue generator for you, and many of us contribute to the development of it...so can you please tidy this contribution?

i know when i asked about it the answer i got was ''sorry, its not a ticket item so we wont be putting it high on the priority list, but we should have it fixed shortly''- that was about august 2006.

another thing that this atually does is serve as visibility for your company, and an opportunity to correlate your name with a quality module...which in turn increases the chance of getting seen..

so i think theres some real reasons why pefrfect design should address this issue- more than just as a ''nice thing to do''..although let it be said that many of us do actually contribute with no commercial link or thought of financial gain.

is the above fix going to actually arrive guys?

the community needs to know, otherwise please do the right thing and ask zencart to remove it from the module downloads...as you can see it is costing people time and effort as it is.

Cheers.

Tim