FAQ Manager

[lankeeyankee]

Hi matt,

It looks to me that those errors are present as a result of those variables being missing from the database, have you used an older database with new files?

Try installing a fresh copy of the site using a new database, then install the faq manager, it shoulfd all work fine.

Let us know how you get on ;-)

Derek

Hi Derek,

I'm not sure what you mean by using an older database with new files? My server offers zen cart and it installs with Fantastico, there were other databases on the server before adding zen, if that's what you mean.

I don't understand why everything would work fine if the faq manager SQL patch is not installed?

Is there a way for me to manually add these missing variables to get it working properly?

As I said I'm a complete noob so please bear with me if I am missing an obvious point.

Thanks!

Matt

[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

[a_berezin]

Hi Derek,
It not the correct decision. Correctly to do so:
tpl_faqs_new_default.php, tpl_faq_categories.php, new_faqs.php

  switch (true) {
    case (SHOW_NEW_FAQS_LIMIT == '0'):
      $display_limit = '';
      break;
    case (SHOW_NEW_FAQS_LIMIT == '1'):
      $display_limit = " and date_format(p.faqs_date_added, '%Y%m') >= date_format(now(), '%Y%m')";
      break;
    case (SHOW_NEW_FAQS_LIMIT == '30'):
      $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 30';
      break;
    case (SHOW_NEW_FAQS_LIMIT == '60'):
      $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 60';
      break;
    case (SHOW_NEW_FAQS_LIMIT == '90'):
      $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 90';
      break;
    case (SHOW_NEW_FAQS_LIMIT == '120'):
      $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 120';
      break;
  }

replace by

  switch (true) {
    case (SHOW_NEW_FAQS_LIMIT == '1'):
      $display_limit = " and date_format(p.faqs_date_added, '%Y%m') >= date_format(now(), '%Y%m')";
      break;
    case (SHOW_NEW_FAQS_LIMIT == '30'):
      $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 30';
      break;
    case (SHOW_NEW_FAQS_LIMIT == '60'):
      $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 60';
      break;
    case (SHOW_NEW_FAQS_LIMIT == '90'):
      $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 90';
      break;
    case (SHOW_NEW_FAQS_LIMIT == '120'):
      $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 120';
      break;
    case (SHOW_NEW_FAQS_LIMIT == '0'):
    default:
      $display_limit = '';
      break;
  }