FAQ Manager

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

[strelitzia]

I have tried to install the FAQ manager several times on my site but each time i get the following error messages.
These appear above the header:

Warning: Variable passed to each() is not an array or object in /home/******/public_html/includes/classes/db/mysql/query_factory.php on line 114

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/******/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/******/public_html/includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at /home/******/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/******/public_html/includes/init_includes/init_templates.php on line 78

And this appears below the header:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCT' at line 7
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' and p.products_date_available >=20071110 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]

The server details are:
PHP Version: 4.4.7 (Zend: 1.3.0)
Database: MySQL 4.1.22-standard

However, if i install it on my local machine, running Apache2Triad, with an exact copy of my online site, it runs fine, with no errors at all.

Local server details are:
PHP Version: 4.4.3-dev (Zend: 1.3.0)
Database: MySQL 4.0.26-nt-log


Both the live site, and the local site are version 1.3.7.

Personally, i can think of no major differences between the two versions of PHP, or MySQL. Anybody got any ideas what might be the problem.

Thanks
Steve

[ChrisR]

Hi All
for those still wishing to fix the Submit button which should say "Ask a question" It seems that the define is in the wrong place. If you look in the includes/language you should find an installed file called button_names.php with define('BUTTON_IMAGE_SUBMIT_FAQ', 'button_ask_a_question.gif');
?>

If you now go on directory further to the includes/language/english you will find the same file there button_names.php paste the line above into this file and you should get the "Ask a question" button image to work.

Hope this helps.

[ChrisR]

i was having the 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 = '';

I have also just changed the code in line 76 and I now have a working FAQ in both colums. Before it would only work if the FAQ box was in the left hand column now it works on the right as well.

Thanks all for the info hope others also come right. You can take a look at
www.totallyautomated.eu/ZStore

[pixelpadre]

There is a minor syntax error that appears to have significant impact on submitting questions.

I found that the file tpl_faqs_submit_default is missing the first ?>

See below:

<?php
//
// +----------------------------------------------------------------------+
// |zen-cart Open Source E-commerce |
// +----------------------------------------------------------------------+
// | Copyright (c) 2003 The zen-cart developers |
// | |
// | http://www.zen-cart.com/index.php |
// | |
// | Portions Copyright (c) 2003 osCommerce |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.0 of the GPL license, |
// | that is bundled with this package in the file LICENSE, and is |
// | available through the world-wide-web at the following url: |
// | http://www.zen-cart.com/license/2_0.txt. |
// | If you did not receive a copy of the zen-cart license and are unable |
// | to obtain it through the world-wide-web, please send a note to |
// | [email protected] so we can mail you a copy immediately. |
// +----------------------------------------------------------------------+
// Original contrib by Vijay Immanuel for osCommerce, converted to zen by [email protected] - http://www.open-operations.com
// $Id: links_manager.php 2004-11-19 [email protected]
//?>

Without the ?> you get an error when posting question and then a guest greeting screen appears.

[pixelpadre]

Additionally, when I post a question I get the following printed out on the top of the screen.

echo zen_draw_form('submit_faq', zen_href_link(FILENAME_FAQS_SUBMIT, '', 'SSL'), 'post', 'enctype="multipart/form-data"', 'onSubmit="return check_form(submit_faq);"') . zen_draw_hidden_field('action', 'process'); ?>

Is there a way to hide it?

[Kruna]

Hi,

I will give it one more try, after having posted and bumped already several times.

I noticed that the error I get is something common it is not that i am the only one with this issue and I believe taht most may not have noticed yet taht they have the same issue.

Please take a look at

http://www.clickyshop.com/tienda1/in...?main_page=faq

I dont know what causes this error, but most of the webites having installed FAQ MAnager, as I mentioned before, have the same error.

You can checkout by yourself, try to enter www.yourdomain.com/your_shop/index.php?main_page=faq

You will see that this is common error....

Does anybody has an idea how to fix this?
Or should I just let it go and there is no fix for it?


Would be great if anybody finds an answer on this matter.

Help really apreciated.

regards,
kruna

[pixelpadre]

If you put the ?> in the file that I told you about above ..that will fix one of your problems. Please find the tpl_faqs_submit_default.php file in your templates directory and add the ?>

[pixelpadre]

ok clicky I had 2 margarittas and one zambuca and I found your problem....and mine

go to your templates and find the file I referred to above

tpl_faqs_submit_default.php is either in your default template directory or in your custom directory.

Place this in the top of the file: and remove the same:

<?php
//
// +----------------------------------------------------------------------+
// |zen-cart Open Source E-commerce |
// +----------------------------------------------------------------------+
// | Copyright (c) 2003 The zen-cart developers |
// | |
// | http://www.zen-cart.com/index.php |
// | |
// | Portions Copyright (c) 2003 osCommerce |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.0 of the GPL license, |
// | that is bundled with this package in the file LICENSE, and is |
// | available through the world-wide-web at the following url: |
// | http://www.zen-cart.com/license/2_0.txt. |
// | If you did not receive a copy of the zen-cart license and are unable |
// | to obtain it through the world-wide-web, please send a note to |
// | license AT zen-cart DOT com so we can mail you a copy immediately. |
// +----------------------------------------------------------------------+
// Original contrib by Vijay Immanuel for osCommerce, converted to zen by dave AT open-operations DOT com - http://www.open-operations.com
// $Id: links_manager.php 2004-11-19 dave AT open-operations DOT com
//?>

<?php

you will notice, I hope, that the last two lines are different from what you had.

the ?> is missing in the original file
and
the <?php is missing in the original file

that should do it for you.