FAQ Manager

Dehaw:

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

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

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

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

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

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

reuben:

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 = '';

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

Finally a Solution!:thumbsup:

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

Thanks Again

Derek

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;
  }

Also would be correct to result a code in conformity with zen-cart ideology.
Remove strange open-operations directory, don't edit any zen-cart core files, and so on.
I have no time for this.

a_berezin:

Also would be correct to result a code in conformity with zen-cart ideology.
Remove strange open-operations directory, don't edit any zen-cart core files, and so on.
I have no time for this.

Yes i agree with this too, although i also do not have time.

This is a contribution for the community if someone else wants to do it thats great, it was Dave at Open Operations that originally developed it so i would also think that it's fair to leave some form of mention to Dave on there, and since this is also the way of the GNU/GPL licence.

Derek

So is it safe to try this mod again?

Yes but the mod hasn't been updated fully yet so make sure you apply the updates above.

Derek

I followed the instructions for the installation but now all of my templates buttons are gone. It appears that all the links are looking for the right images but each has the word image placed in the middle of the button name.

For example:
button_login.gif is not being found
My site is looking for button_image_login.gif now.

I am sure it had to do with the sql install errors. Is there a fix for duplicate query errors? I looked through this thread but had a hard time finding my answer. Or is there a command I can send through my database to change the links back to looking for images without the image in the names?

Thanks,
Nick

I've read the entire thread and it seems noone has encountered the error I'm currently getting. :-/

I'm testing 1.3.7 and all the modules I want on it.

Currently the entire of the FAQ manager works until I add categories and/or FAQs

When I add FAQs or categories everything below the header disappears and I get the following error message.

Fatal error: Call to a member function on a non-object in \nas30ent\domains\p\petpromises.co.uk\user\htdocs\zencarttesting\includes\modules\sideboxes\faq_categories.php** online 28

**If anyone could help it would be very much appreciated.

:frusty: With regards to post 77 I am also getting the same error messages.

However I DO NOT have faq manager installed or a SQL patch.

I got my error messages after installing the Royal mail mod and adding products.

Have disabled the mail mod but still getting message.

Any ideas

I installed the this faq module and after alittle fixing, I have it working. However if you look at my faqs pages everything is at the bottom of the page, is this how it is suppose to look and also you have to click on the first question and the second question to get the answer. Any help is appreciated!! Thanks
https://www.mommyandbabyessentials.com

Anyone out there that knows what I can do? "if you look at my faqs pages everything is at the bottom of the page, is this how it is suppose to look and also you have to click on the first question and the second question to get the answer." This module would be really great if I can get it right!! Thank you in advance!

I just installed this MOD tonight, and did a few test that all went O.K. (knock on wood). Is there any more documentation than the Readme File? If there is where can I find it?
Thanks.