FAQ Manager

[divaboutiques]

How do I clear this error for my FAQ manager I have installed all the file into the right folders, but when Iturn on the sidebox I am getting the following error.


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

[Dehaw]

How do I clear this error for my FAQ manager I have installed all the file into the right folders, but when Iturn on the sidebox I am getting the following error.


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

Looks like you haven't followed the instructions fully, you need to add the extra code to your application top, you'll find the code within the instructions.

Derek

[reuben]

Well, I hope this helps. And Derek, I appreciate the work you have done on this mod. Thanks.

I get the classic sidebox error:

1054 Unknown column 'p.products_date_added' in 'where clause'
in:
[select p.faqs_id from faqs p where p.faqs_status = '1' and TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) <= 30 limit 1]

Store:

• ZenCart 1.3.7

• DB patch level 1.3.7

• MySQL 5.0.27-standard

• PHP 4.4.4 (Zend: 1.3.0)

• custom template

Contribs:

• admin store name

• edit orders

• email address exporter

• email archive search

• encrypted master password

• recover cart sales

• sales report

• user tracking

• faq manager

Sideboxes:

sideboxes/banner_box_all.php  	 OFF  	 LEFT  	0  	0  	 OFF  	 Edit  	 Info 
sideboxes/order_history_backup.php 	OFF 	LEFT 	0 	0 	OFF 	MISSING Edit 	MISSING Info 
sideboxes/search_header.php 	OFF 	LEFT 	0 	0 	OFF 	Edit 	Info 
sideboxes/ezpages.php 	OFF 	LEFT 	0 	0 	OFF 	Edit 	Info 
sideboxes/document_categories.php 	OFF 	LEFT 	0 	0 	OFF 	Edit 	Info 
sideboxes/whats_new.php 	OFF 	LEFT 	20 	0 	OFF 	Edit 	Info 
sideboxes/reviews.php 	OFF 	LEFT 	40 	0 	OFF 	Edit 	Info 
sideboxes/record_companies.php 	OFF 	RIGHT 	0 	0 	OFF 	Edit 	Info 
sideboxes/music_genres.php 	OFF 	RIGHT 	0 	0 	OFF 	Edit 	Info 
sideboxes/search.php 	ON 	RIGHT 	10 	10 	ON 	Edit 	Info 
sideboxes/shopping_cart.php 	OFF 	RIGHT 	20 	30 	OFF 	Edit 	Info 
sideboxes/categories.php 	ON 	RIGHT 	20 	20 	ON 	Edit 	Info 
sideboxes/best_sellers.php 	OFF 	RIGHT 	30 	70 	OFF 	Edit 	Info 
sideboxes/manufacturers.php 	ON 	RIGHT 	30 	20 	ON 	Edit 	Info 
sideboxes/manufacturer_info.php 	OFF 	RIGHT 	35 	95 	OFF 	Edit 	Info 
sideboxes/specials.php 	ON 	RIGHT 	45 	40 	ON 	Edit 	Info 
sideboxes/featured.php 	ON 	RIGHT 	47 	47 	ON 	Edit 	Info 
sideboxes/order_history.php 	ON 	RIGHT 	50 	50 	ON 	Edit 	Info 
sideboxes/product_notifications.php 	OFF 	RIGHT 	55 	85 	OFF 	Edit 	Info 
sideboxes/tell_a_friend.php 	ON 	RIGHT 	65 	0 	ON 	Edit 	Info 
sideboxes/languages.php 	OFF 	RIGHT 	70 	50 	OFF 	Edit 	Info 
sideboxes/currencies.php 	ON 	RIGHT 	80 	60 	ON 	Edit 	Info 
sideboxes/banner_box.php 	ON 	RIGHT 	82 	82 	ON 	Edit 	Info 
sideboxes/banner_box2.php 	ON 	RIGHT 	85 	85 	ON 	Edit 	Info 
sideboxes/cc_accept.php 	OFF 	RIGHT 	90 	90 	OFF 	MISSING Edit MISSING Info 
sideboxes/whos_online.php 	OFF 	RIGHT 	200 	200 	OFF 	Edit 	Info 
sideboxes/infopages.php 	ON 	RIGHT 	300 	300 	ON 	MISSING Edit 	MISSING Info 
sideboxes/bonbonniere/information.php 	OFF 	RIGHT 	350 	350 	OFF 	Edit Info 
sideboxes/more_information.php 	OFF 	RIGHT 	400 	400 	OFF 	Edit 	Info 
sideboxes/faq_categories.php 	OFF 	RIGHT 	500 	500 	OFF 	Edit

If my site gets really quiet tonight I'll turn off the other sideboxes and see if it makes a difference.

regards,
Reuben

[Dehaw]

I was contacted by another user only last week and once i asked him to switch off all the sideboxes he did and the module worked, then when he switch them all back on and tried moving the module to the right it also worked, so as i said before, this is a clear indication that there must be interference between this module and another module already installed, i can only imagine that its maybe one that isn't default to zencart as in a custom mod since i installed this contrib fine on three seperate sites.

Let us know how you get on.

Derek

[a_berezin]

I get the classic sidebox error:

1054 Unknown column 'p.products_date_added' in 'where clause'
in:
[select p.faqs_id from faqs p where p.faqs_status = '1' and TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) <= 30 limit 1]

Test this.
/sideboxes/tpl_faq_categories.php.
Find (~76):

if (SHOW_FAQ_CATEGORIES_BOX_FAQS_NEW == 'true') {

Add after:

$display_limit = '';

[reuben]

Andrew,

Your suggested change did fix the problem. This module now works perfectly.

Thankyou very much for your help!

Also thanks to everyone who has developed, tested, and argued about this contrib.

Cheers
Reuben

[Dehaw]

Finally a Solution!

[Dehaw]

Thanks Andrew, i have updated the package and provided a mention on that very line for you.

Thanks Again

Derek

[modchipfitters.co.uk]

i was having the

1054 Unknown column 'p.products_date_added' in 'where clause'
in:
[select p.faqs_id from faqs p where p.faqs_status = '1' and TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) <= 30 limit 1]

problem and i did the fix below which fixed everything except for when i clicked on the new faq's link in the side box which then gave the the same error but in the center section of the site
i got round this by dissabling the new faq link in the faq manager admin under "FAQs Category Box Config" section

Test this.
/sideboxes/tpl_faq_categories.php.
Find (~76):

if (SHOW_FAQ_CATEGORIES_BOX_FAQS_NEW == 'true') {

Add after:

$display_limit = '';

[delia]

attached is the corrected sql file. I don't have the time to do more right now but if I get a chance, I'll make the necessary corrections to the mod and upload the corrected version. If that is, someone has a completely working faq manager (any version) that I can look at from both catalog side and admin so I can figure out this is supposed to work. Anybody?