Anyone have a fix for this FAQ addon error?

[Rob905]

I tried to re-install the latest version of the FAQ module on my 1.3.8a cart and all seems to work OK in the admin section except when you try to view the FAQ that shows up in the sidebox you get a cart page with a blank area in the middle.

Several questions have gone unaswered in this area so I was wondering if anyone is supporting this mod anymore or is there a better way and just toast this mod?

[kobra]

check for the reasons one gets a blank page
https://www.zen-cart.com/tutorials/index.php?article=82

[Rob905]

check for the reasons one gets a blank page
https://www.zen-cart.com/tutorials/index.php?article=82

Thanks Cobra, that got the page displayed.
Unfortunately I'm back to the original problem now of not being able to use the FAQ module because it kills the right column (where I'm currently displaying it) with some coding error message. :-(

Does anyone work on this mod anymore, there seems to be lots of interest in it and I could use it on some of my other sites.

[Rob905]

check for the reasons one gets a blank page
https://www.zen-cart.com/tutorials/index.php?article=82

Thanks Cobra, that got the page displayed.
Unfortunately I'm back to the original problem now of not being able to use the FAQ module because it kills the right column (where I'm currently displaying it) with some coding error message. :-(

Does anyone work on this mod anymore, there seems to be lots of interest in it and I could use it on some of my other sites.

The error that I get when the sidebox is enabled is: 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 >20090703235959 limit 1]

[DrByte]

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 >20090703235959 limit 1]

As you've mentioned, it's related to something you've got wrong in the FAQ addon you're using.

[Rob905]

As you've mentioned, it's related to something you've got wrong in the FAQ addon you're using.

Thanks.
I've decided to pull the mod from the site cuz it's just not worth the agrivation anymore. Since no-one is supporting this mod anyway, I've decided to use the EZPage instead.

Can I code regular HTML on the page so when some one clicks on the FAQ link it will jump to the tag on the page that gives the answer?

[DrByte]

If you code the full anchor tag syntax, it should work.

[Rob905]

If you code the full anchor tag syntax, it should work.

Thank you DrByte, I think that is the best way to go then for now.

[davewest]

The error that I get when the sidebox is enabled is: 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 >20090703235959 limit 1]

The SQL statement $order_by is malformed for how it's being used. $order_by has to do with reordering the FAQ list. I didn't keep this in my use of the mod so I removed it and fixed the SQL statements having to do with $order_by and all works.

Look to the includes/modules/ folder, search the files for $order_by and fix them.

old code includes/modules/faq_categories_tabs.php

$order_by = " order by c.sort_order, cd.faq_categories_name ";
  $faq_categories_tab_query = "select c.faq_categories_id, cd.faq_categories_name from " .
                          TABLE_FAQ_CATEGORIES . " c, " . TABLE_FAQ_CATEGORIES_DESCRIPTION . " cd
                          where c.faq_categories_id=cd.faq_categories_id and c.parent_id= '0' and cd.language_id='" . $_SESSION['languages_id'] . "' and c.faq_categories_status='1'" .
                          $order_by;

new code

 $faq_categories_tab_query = "select c.faq_categories_id, cd.faq_categories_name from " 
                              . TABLE_FAQ_CATEGORIES . " c, "
                              . TABLE_FAQ_CATEGORIES_DESCRIPTION . " cd
                          where c.faq_categories_id=cd.faq_categories_id 
                          and c.parent_id= '0' 
                          and cd.language_id='" . $_SESSION['languages_id'] . "' 
                          and c.faq_categories_status='1'
                          order by c.sort_order, cd.faq_categories_name";

On the exmple above the c. and cd. is used, on most of the others, it's

order by fc.sort_order, fcd.faq_categories_name"

Search the includes/modules folder and includes\templates\YOUR_TEMPLATE\templates\ folder for $order_by call and you will find the problem files... I didn't use all the files that came with the mod so I can't say which one for sure. I also made many edits to the files to remove the tables so I can't post the files.

Once the SQL statements are reworked, the mod does work it's running on my site. I don't have the sidebox installed ether...

[Rob905]

The SQL statement $order_by is malformed for how it's being used. $order_by has to do with reordering the FAQ list. I didn't keep this in my use of the mod so I removed it and fixed the SQL statements having to do with $order_by and all works.

Look to the includes/modules/ folder, search the files for $order_by and fix them.

old code includes/modules/faq_categories_tabs.php

$order_by = " order by c.sort_order, cd.faq_categories_name ";
  $faq_categories_tab_query = "select c.faq_categories_id, cd.faq_categories_name from " .
                          TABLE_FAQ_CATEGORIES . " c, " . TABLE_FAQ_CATEGORIES_DESCRIPTION . " cd
                          where c.faq_categories_id=cd.faq_categories_id and c.parent_id= '0' and cd.language_id='" . $_SESSION['languages_id'] . "' and c.faq_categories_status='1'" .
                          $order_by;

new code

 $faq_categories_tab_query = "select c.faq_categories_id, cd.faq_categories_name from " 
                              . TABLE_FAQ_CATEGORIES . " c, "
                              . TABLE_FAQ_CATEGORIES_DESCRIPTION . " cd
                          where c.faq_categories_id=cd.faq_categories_id 
                          and c.parent_id= '0' 
                          and cd.language_id='" . $_SESSION['languages_id'] . "' 
                          and c.faq_categories_status='1'
                          order by c.sort_order, cd.faq_categories_name";

On the exmple above the c. and cd. is used, on most of the others, it's Search the includes/modules folder and includes\templates\YOUR_TEMPLATE\templates\ folder for $order_by call and you will find the problem files... I didn't use all the files that came with the mod so I can't say which one for sure. I also made many edits to the files to remove the tables so I can't post the files.

Once the SQL statements are reworked, the mod does work it's running on my site. I don't have the sidebox installed ether...

Thanks for the input but i've decided that I can't afford to re-install the site again because everytime I've tried to install this mod it kills the entire site when I try to fix it.
I'm not a programmer so I'll use the EZPage way to create an FAQ.
The mod should maybe be removed from the downloads until someone has one that actually works.