FAQ Manager

Printable View

Show 100 post(s) from this thread on one page

5 Mar 2007, 07:03 PM
lankeeyankee

Re: FAQ Manager

Quote:

Originally Posted by 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
10 Mar 2007, 02:26 AM
divaboutiques

Re: FAQ Manager

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
10 Mar 2007, 10:14 AM
Dehaw

Re: FAQ Manager

Quote:

Originally Posted by 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
15 Mar 2007, 08:31 AM
reuben

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

I get the classic sidebox error:

Code:

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:

Code:

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
15 Mar 2007, 09:15 AM
Dehaw

Re: FAQ Manager

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
15 Mar 2007, 11:02 AM
a_berezin

Re: FAQ Manager

Quote:

Originally Posted by reuben

I get the classic sidebox error:

Code:

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):

Code:

if (SHOW_FAQ_CATEGORIES_BOX_FAQS_NEW == 'true') {

Add after:

Code:

$display_limit = '';
16 Mar 2007, 04:09 AM
reuben

Re: FAQ Manager

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
16 Mar 2007, 09:43 AM
Dehaw

Re: FAQ Manager

Finally a Solution!:thumbsup:
16 Mar 2007, 09:53 AM
Dehaw

Re: FAQ Manager

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

Thanks Again

Derek
16 Mar 2007, 10:52 AM
a_berezin

Re: FAQ Manager

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

Code:

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

Code:

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

Show 100 post(s) from this thread on one page