FAQ Module fro zen cart 1.3.8A [updated]

by Jason on Jun.25, 2009, under Zen Cart

My customer John need me to add a FAQ Module fro zen cart for his zen cart site.

In fact, newbies will be confused ……, so many zen cart users are finding why so many bugs!! But nobody deal with?

You can down original source from here:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=329

But some bugs i found:

1. I’m Getting this error on where the sidebox should appear…

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 >=20061104 limit 1]

Fixed:

You need to edit
includes/templates/YOUR_TEMPLATE_FOLDER/sideboxes/tpl_faq_categories.php
Put PHP Code:
$display_limit = '';
on the first AND last line.

2. Double duplicated bread navigation:

Home > Frequently Asked Questions > I can’t find my child’s name. What should I do?

In fact, the zen cart has brad navigation itself, so you need to delete the double duplicated bread navigation code:

<?php if (DEFINE_BREADCRUMB_STATUS == '1' || DEFINE_BREADCRUMB_STATUS == '2' ) { ?> <tr> <td colspan="2"><?php echo $breadcrumb->trail(BREAD_CRUMBS_SEPARATOR); ?></td> </tr> <?php } ?>

from below php pages:

page