FAQ Manager

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

[Dehaw]

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

[divaboutiques]

I'm getting this error when I turn on the FAQ sidebox

Fatal error: Cannot instantiate non-existent class: faq_category_tree in /home/divabou/public_html/Catalog/includes/modules/sideboxes/faq_categories.php on line 22

I can I correct this so that it can work?

[kellan4459]

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.

I was having the problem with my main page text showing on the category pages as well and I made this change so that I could still use the FAQ Manager SideBox

II changed the variable

$show_welcome to $show_faq_welcome

for all of the FAQ file instances and it seems to be working. I will continue to test this change and would love for anyone else experiencing this issue to test it as well.

[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