FAQ Manager

But my main question is to all of this: How did you get to main_page=faq to begin with? I couldn't see where there is a link anywhere on my site to take me to that page, so how did you get there from your website?

It was by accident, I was translating it into spanish, so I saw that there was a faq.php file , so I got curious what this file is displaying as in the sidebox I was just seeing ALL FAQ and NEW FAQ.

I know I repeat myself, but would be graet if anybody has a fix for this..

Many thanks and regards,
kruna

lankeeyankee:

But my main question is to all of this: How did you get to main_page=faq to begin with? I couldn't see where there is a link anywhere on my site to take me to that page, so how did you get there from your website?

Matt

Gee Guys, all I did was install it and followed the instructions in the file. My site is down at the moment so I can't really look at the code. I was playing around last night with Joomla and inadvertently deleted my admin folder. Yeah I know and I broke my No. 1 rule. Backup, backup, backup. I'm installing it again and will get back to all of you sometime tomorrow if everything goes OK.

Almost forgot, Matt look in admin>Extras and you should see the FAQ link to set it up. Don't for get to turn it on in the Layout side boxes area and you should see the link on your page.

Thx, Starcad, please hurry up, I am about to uninstall the FAQ Manager if I cannot find a solution for it pretty soon... By the way, where do you fly R/C? You should look at my page - as I am bringing in products for FPV flying (with the video goggles... ) :)
Ox.

Sorry I didn't get back to you sooner oxxyfx, one of those rough weeks at work. OK here is what I did this time. I uploaded the file to my site. Then Uploaded the SQL using the Zen SQL update. However this time I received the dreaded SQL error. Checking my SQL out via my FTP software I saw that all the required tables had indeed been inserted so give it a try and sure enough it works. Not sure yet if I'm getting the dreaded error that everyone is reporting as I really don't have time tonight to check. I did put up a test FAQ and the url to the site is

http://www.mydesertjade.com if you want to have a look. Note not much on that site yet as it is still in development.

Oh Almost forgot oxxyfx, I fly in Tucson, AZ. My son Scott is really big into FPV back in the D.C. West Virginia area. At the moment he's developing a package to take to the Arizona Electric Festival in Mesa, Az in January this coming year. He should be out in late November when we will be doing flight testing on the airframe and the Video system. I'm looking forward to going under the goggles again as this is probably the most exciting part of R/C flying I've ever done except flying UAV's.

i have qusetion regard the installation of FAQ Manager.
i have zen cart 1.3.7 and after installation of FAQ MANAGER i have the error:

FAQ in FAQ Category: "Top"

FAQs Status: Active In Active

FAQs Name:

FAQs Contact Name:

FAQs Contact_mail:

FAQs Description:
Warning: Missing argument 1 for fckeditor() in /home/content/c/h/i/chimicaluser/html/shop/admin/includes/fckeditor_php4.php on line 39

Fatal error: Call to undefined function: createfckeditor() in /home/content/c/h/i/chimicaluser/html/shop/admin/includes/modules/faq/collect_info.php on line 200

im getting it on FAQs and FAQ Categories Page when im trying to add FAQ.
i hope someone can help me top fix it, thank you very much.
:unsure:

i think it might be something on the installation instruction that i didn't understood.

somewhere in here:

INSTALLATION:
Step 1: Upload files to server
Step 2: Run .sql file

=== Step 1 ===
All files are arranged in the correct Zen Cart v1.3.7 structure.
Just upload to your server as they are without any editing required.

(Is prefered to change the template_default folder in this release to the foldername of your template. In this way you leave intact the template_default folder for future updates)

=== Step 2 ===
New database tables need to be created to store your new FAQs and FAQ categories.
New configuration options are added to the zen_configuration table.
Upload the included faq_manager.sql using the Zen-Cart Admin Sql Patches tool.

DONE!

i didn't understood the instruction on red.

Trole:

i have qusetion regard the installation of FAQ Manager.
i have zen cart 1.3.7 and after installation of FAQ MANAGER i have the error:

im getting it on FAQs and FAQ Categories Page when im trying to add FAQ.
i hope someone can help me top fix it, thank you very much.
:unsure:

i think it might be something on the installation instruction that i didn't understood.

somewhere in here:

INSTALLATION:
Step 1: Upload files to server
Step 2: Run .sql file

=== Step 1 ===
All files are arranged in the correct Zen Cart v1.3.7 structure.
Just upload to your server as they are without any editing required.

(Is prefered to change the template_default folder in this release to the foldername of your template. In this way you leave intact the template_default folder for future updates)

=== Step 2 ===
New database tables need to be created to store your new FAQs and FAQ categories.
New configuration options are added to the zen_configuration table.
Upload the included faq_manager.sql using the Zen-Cart Admin Sql Patches tool.

DONE!

i didn't understood the instruction on red.

UPDATE:

right now it is working good, the only thing that i did is to change the HTML EDITOR under Configuration > my store.
back to HTMLAREA.

i dont know how it will effect my website but it seems like everything is ok now.

Ok, so today I finally had the time to look at Starcad's site and sure enough it works... However it seem that I found where the problem might be.

Starcad is using a template with a left and right column - I am not sure which one, but it sure looks close to the standard Zen look.

My template is the apple_zen with only one column on the right side. THis may be the reason why the FAQ's are showing up on the bottom. It may be a template issue, it may be an FAQ manager issue...

Now the question is how do we find a resolution of this problem?

I will post a new post on the apple_zen support thread, maybe somebody there has the answer to this.

Otherwise - if you know the answer - please don't hold it back - let us know!

Thx, Ox.

Hey Ox, if it helps I'm using Nifty Zen and have the cart centered with both the left and right columns on. I plane on populating it with jewelry from my other shop bestjewelryboutique.com that is Joomla base with Vurtuemart as the shopping cart. I prefer Zen over Joomla as Joomla has more bells and whistles than I feel comfortable with.

I should be populating the FAQ this weekend when i have more time but Comcast has me doing overtime on Saturday with another new project launch for our center. I should be able to get to Zen on Sunday I hope.

Later - Guy

Hi guys, finally we have a breakthrough... Jade who designed the Apple_zen template came forward with the resolution of the problem - the FAQ pages not showing up in the main screen, but on the bottom of the screen. Please read the resolution in the following thread:
http://www.zen-cart.com/forum/showthread.php?p=443467#post443467
post 1262 is mine and the solution is to be found under post: 1263.

I will send a note to the designer of the FAQ manager to make sure he includes the modification on the release on the download page.

Mine is working great after applying the modifications Jade suggested. Please take a look:

http://www.nghobbies.com/cart/index.php?main_page=faqs_all&fcPath=1&zenid=d75b718b3daf3da830cdb3e708db54b5

Cheers, I hope this helps a lot of other people...

Ox.

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

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

if (SHOW_FAQ_CATEGORIES_BOX_FAQS_NEW == 'true') {

> Add after:
> ```
$display_limit = '';

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?

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

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.

modchipfitters.co.uk:

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

a_berezin:

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

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.

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?

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/index.php?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 https://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

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

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 | // | [[email protected]](mailto:"[email protected]") so we can mail you a copy immediately. | // +----------------------------------------------------------------------+ // Original contrib by Vijay Immanuel for osCommerce, converted to zen by [[email protected]](mailto:"[email protected]") - <http://www.open-operations.com> // $Id: links_manager.php 2004-11-19 [[email protected]](mailto:"[email protected]") //?> <?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.