FAQ Manager

[lankeeyankee]

Hello,

currently I am in two threads concerning the FAQ mod, because there seems to be no help.

Mostly the mod is working fine except the this part here
I dont know what is causing this error

Sorry to put my two cents here, but oxxyfx, you also have the same error, yake a look here

Starcad...yours works, would love to know what would be the fix...

regards,
kruna

I checked /index.php?main_page=faq on my test site and it does the same thing. I've played around with tpl_faq_default as well as modules/pages/faq/header_php.php and had success in changing a bit of the text around and even got it to display the main page contents but no luck in getting it corrected. It seems odd since I was even copying the header code from other faq pages and it did change main_page=faq to whatever page I copied it from but they all said "no questions available" and then after I entered in an faq through the admin panel I get

"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 'AND language_id = '1'' at line 3
in:
[select faq_categories_name from zen_faq_categories_description where faq_categories_id = AND language_id = '1']"

I tried pasting the contents of tpl_faq_info into tpl_faq_default to match up with the same swap in modules/pages/faq/ (I copied the contents of modules/pages/faq_info into pages/faq) but no joy.

I'm certainly no programmer and I don't know where else to look to change.

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