FAQ Manager

1054 Unknown column 'p.products_date_available' in 'where clause'
in:
[select p.faqs_id from faqs p where p.faqs_status = '1' and p.products_date_available >20080627235959 limit 1]

I get this error when I am logged in and have something in the shopping cart for this site http://www.ncwheatmontanacoop.com/order/

Any ideas how to fix? Thanks!

Doodlebuckets:

1054 Unknown column 'p.products_date_available' in 'where clause'
in:
[select p.faqs_id from faqs p where p.faqs_status = '1' and p.products_date_available >20080627235959 limit 1]

I get this error when I am logged in and have something in the shopping cart for this site http://www.ncwheatmontanacoop.com/order/

Any ideas how to fix? Thanks!

Nevermind...it disappeared after adding my first entry

http://www.ncwheatmontanacoop.com/order/index.php?main_page=faq_reviews_write&fcPath=1&faqs_id=1

OK, at the bottom, the images for the reviews are not displaying properly...

Doodlebuckets:

1054 Unknown column 'p.products_date_available' in 'where clause'
in:
[select p.faqs_id from faqs p where p.faqs_status = '1' and p.products_date_available >20080627235959 limit 1]

I get this error when I am logged in and have something in the shopping cart for this site http://www.ncwheatmontanacoop.com/order/

Any ideas how to fix? Thanks!

OK this is still a problem. Adding an item only fixed the error on the main page....

Phil020782:

Hi,
I am having a little trouble with my sub catagories. If I click on a catagory that has sub catagories the main homepage is displayed with the subcatagories below it. Someone said that by removing the file open-operations/faq_application_top.php the problem would be solved but if I do that I lose the faq sidebox and all sideboxes after it.

Does anyone know how I can solve this issue?

Thanks

Having the same problem, very frustrating. Any solutions out there?

Hello. I am new here. Every time I qet a new question (FAQ), it shows duplicated in the FAQs page. So it someone posts "what colors do you have?" it will show 2 times in the users FAQs page.
When I go to the admin faqs, i see just 1 posted question and answer in the category floder.

I have apple zen, english and spanish, and i am at

https://www.ganamarcando.com

I read must of the forum and fix some problems. I has been really helpful to go over all this issues.

Thanks.

Heeeeeelp!!!

I just installed the FAQ Manager and I LOVE it however there is one problem. For some reason whenever a question is asked on the FAQ page and submitted it should send a email notification to the email address setup in the FAQ manager in the zen cart admin. I have set it up but for some reason I am not getting the email notification. Although when a question is submitted it does go through in the faq manager on the site. I just don't get an email notification. Any thoughts to get this fixed?

Is it not interfering with the display of subcategories when parent categories are clicked on?

I am not sure what you are talking about? You can look at the website here.

wpc- con sul ting.com/~stxmill/

My problem is i just don't get an email whenever a customer asks a question. Can you tell me what I am doing wrong? Any thoughts.

I think you can change the email settings in Extras > FAQ Manager

This problem isn't showing up on your website b/c you don't have any categories with subcategories. Just top level cats with products.

Yeah I have it set to an email address in there but for some reason I am not getting them. Can't figure it out.

I'm not sure what it is then. Do your stores other email fxns work?

Yes when i test the "ask a question" function on the FAQ page and type in my email address in the form and hit submit I will get an email as the "question asker" saying thanks for your submission and stuff like that. I just don't get an email for the admin portion letting me know that a question has been submitted. Which means the only way to know is to go to the FAQ manager all the time to see if one has been added which can be annoying.

Also my "Ask a question" image or link has an 'x' in internet explorer 7 but looks great in firefox. Not sure why this is happening but it doesn't look very good.

Also my "Ask a question" image or link has an 'x' in internet explorer 7 but looks great in firefox. Not sure why this is happening but it doesn't look very good.

I'm also getting this image error, I copied all the button into the right folder, /public_html/store/includes/templates/mystorename/buttons/english, and double checked to see if the image appeared, but I am still getting the X error for the image, when the button is in the right folder.

Yeah not really sure what this is because if you look at it in firefox there is actually no image it is just a link which looks fine in firefox. Have you tried the email notification. Like if someone asks a question if you set it up in the FAQ manager to send you an email it should but for mine it isn't working.

Adolfo:

Hello. I am new here. Every time I qet a new question (FAQ), it shows duplicated in the FAQs page. So it someone posts "what colors do you have?" it will show 2 times in the users FAQs page.
When I go to the admin faqs, i see just 1 posted question and answer in the category floder.

I have apple zen, english and spanish, and i am at

https://www.ganamarcando.com

I read must of the forum and fix some problems. I has been really helpful to go over all this issues.

Thanks.

Heeeeeelp!!!
I was getting this also... and I found a fix... couldnt' see it mentioned anywhere else so here it is I changed both files tpl_faq_default.php and tpl_faq_all_default.php and replaced the $faqs_all_query_raw = ..... line of code with the one below....

$faqs_all_query_raw = "select f., fd., fcd.faq_categories_name from " . TABLE_FAQS . " f, " . TABLE_FAQS_DESCRIPTION . " fd, " . TABLE_FAQ_CATEGORIES_DESCRIPTION . " fcd, " . TABLE_FAQ_CATEGORIES . " fc " .
"where f.faqs_status = '1' and f.faqs_id = fd.faqs_id and fd.language_id = '" . (int)$_SESSION['languages_id'] . "' and f.master_faq_categories_id = fcd.faq_categories_id and f.master_faq_categories_id = fc.faq_categories_id and fc.faq_categories_status='1' and fcd.language_id = '" . (int)$_SESSION['languages_id'] . "' " .
$order_by;

I added the fcd.language_id = to avoid the duplicate rows being selected..

Neil

I've searched this thread and have been unable to find anything related to my question.

In the email that is sent out to the question submitter it says this:

You will receive an email about the status of your submittal. If you have not received it within the next 48 hours, please contact us before submitting your question again.

I'm assuming that means that once the FAQ is answered an email will automatically be sent to the submitter notifying them that their question has been answered. The problem is, those emails aren't being sent. Any ideas?

I'm running the mod on 1.3.8a and every aspect seems to function propertly except for the answer email.

So are you saying if you ask a question on the actual page you get an email sent the FAQ manager?

welchyboy:

So are you saying if you ask a question on the actual page you get an email sent the FAQ manager?

If a question is submitted both myself and the person that submitted the question get an email. The problem is, when I answer the question, there is no email sent to the submitter letting them know that their question has been answered.

The initial email sent to the customer after submission leads me to believe that they should also be receiving an email when I answer their question.

flightoffancy:

I've searched this thread and have been unable to find anything related to my question.

In the email that is sent out to the question submitter it says this:

I'm assuming that means that once the FAQ is answered an email will automatically be sent to the submitter notifying them that their question has been answered. The problem is, those emails aren't being sent. Any ideas?

I'm running the mod on 1.3.8a and every aspect seems to function propertly except for the answer email.

In addition to the above problem I am also experiencing the problem mentioned a few pages back .... when a top level category is clicked the subcategories are appearing beneath the main page text instead of on their own page.