FAQ Manager

[a_berezin]

Hi Derek,

This line of code doesn't actually exist within this contribution,

Yes.

but i have seen myself with another users site that it seems to cause a problem when the sidebox is active

What faq manager they use? What version of faq manager they use? What zen-cart version? What a problem? Problem with 'p.products'?

I personally installed the contribution on 3 seperate sites this week on 3 new installs and never seen this error anywhere on any of the sites

I too. But I remove includes/open-operations/ processing.
And in sideboxes/faq_categories.php change

$main_faq_category_tree = new faq_category_tree;

to

$main_faq_category_tree = new faq_category_tree();

[Dehaw]

Hi Derek,
Yes.
What faq manager they use? What version of faq manager they use? What zen-cart version? What a problem? Problem with 'p.products'?
I too. But I remove includes/open-operations/ processing.
And in sideboxes/faq_categories.php change

$main_faq_category_tree = new faq_category_tree;

to

$main_faq_category_tree = new faq_category_tree();

Hi Andrew,

Yeah this is the original FAQ manager contrib from Dave @ Open Operations, i helped sort a few bugs to get it actually working, which it does for most but not for some, but i'm not sure why.

I have tested on 1.3X including the latest release of Zencart and all is fine. it seems that some people get this error where the sql query is trying to select the p.products_date_added where clearly that doesn't exist and it should be referencing the p.faqs_date_added, but again this p.products_date_added doesn't exist within this contrib.

However, since Dave based this contrib on the zencart site products and amended tables and code to accommodate for FAQS as opposed to products, that would tell me that the FAQ categories side box is conflicting with another sidebox, since this is where the problem seems to occur.

I'm kind of stumped since i never see this problem even on a new install with all sideboxes activated and no one else seems to report that they got it working.

So i'll wait and see if either there is a solution or even an explanation would be good.

Thanks ;-)

Derek

[lankeeyankee]

Hi,

OK, I think I figured out why I kept getting the p.products error in the sidebox. I had expanded catagory mod loaded and once I removed that I didn't get that error anymore.

BUT, every time I reload the SQL patch for faq manager and enable the sidebox I get this message below. The odd thing is, and I know almost nothing about coding yet (but I am learning as fast as I can!), when I go to the store after loading the SQL patch and enabling the faq sidebox everything is normal. Then when I click on anything on the page I get the following errors and they then won't go away for any page unless I restore my SQL database to an earlier time and thus remove the faq patch.

The first error message appears in the main body of the store under the header, and all of the text is really big, even the store's text:

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_PRODUC' at line 7
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from zen_products p, zen_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 >=20070305 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]


These other errors are above the header:


Warning: Variable passed to each() is not an array or object in /home/globaldr/public_html/customdrumshop/zen/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/globaldr/public_html/customdrumshop/zen/includes/classes/db/mysql/query_factory.php:114) in /home/globaldr/public_html/customdrumshop/zen/includes/functions/sessions.php on line 108
Warning: Cannot modify header information - headers already sent by (output started at /home/globaldr/public_html/customdrumshop/zen/includes/classes/db/mysql/query_factory.php:114) in /home/globaldr/public_html/customdrumshop/zen/includes/init_includes/init_templates.php on line 78


When I remove the faq SQL patch by restoring to an earlier database all of these go away.

I disabled all of the sideboxes on the left side except for faq manager and that didn't help.

I have heavily modded the store, I'm new to this and have been trying out the various mods to see what I want to use for our store. I have:

cart upsell/cross sell
dual pricing 1_3_7
easy populate
image handler 2
order steps tableless
quick updates 2.0
testimonials manager
stock by attributes 4.4
designer monthly boxes
usps click and ship
fedex mod
email archive search 1.2
backup mysql
qbi v3.21b

I hope that this helps. Please let me know if you need any more info or would like access to the store to check it out yourself. It's on a remote server but we're not using it yet so you can go in and see for yourself what the problem may be.

Thanks!

Matt

[Dehaw]

Hi matt,

Finally someone has come to the rescue with what might be the problem! ;-)

Ok so the problems you are having now are relating to your configuration, it seems the database entries have not loaded properly.

Do you have a url so we can see it?

many thanks

Derek

[lankeeyankee]

The url is http://www.customdrumshop.com/zen I know that the layout is screwed up somewhat with the search box in a un-aligned spot etc. I am still messing around to get a feel for what does what and haven't focused on the CSS or any layout options yet, so don't laugh too hard. Unless something is causing the problem?

I just installed the faq SQL patch again so you can see what is happening and now when you go to the faq page by clicking on the link the error message in the main body of the page is:

Warning: Division by zero in /home/globaldr/public_html/customdrumshop/zen/includes/classes/split_page_results.php on line 76


The other errors above the headers are there, too. Then when I go back to the home page I get the other errors that I mentioned in the last post.

I hope that this will help figure it out. I just installed a fresh 1.3.7 on my home computer after going through the setup in the new zen cart book, so I will try to install the faq manager on it and see what happens. I'll let you know the results.

Thanks!

Matt

[Dehaw]

Hi matt,

It looks to me that those errors are present as a result of those variables being missing from the database, have you used an older database with new files?

Try installing a fresh copy of the site using a new database, then install the faq manager, it shoulfd all work fine.

Let us know how you get on ;-)

Derek

[lankeeyankee]

Hi matt,

It looks to me that those errors are present as a result of those variables being missing from the database, have you used an older database with new files?

Try installing a fresh copy of the site using a new database, then install the faq manager, it shoulfd all work fine.

Let us know how you get on ;-)

Derek

Hi Derek,

I'm not sure what you mean by using an older database with new files? My server offers zen cart and it installs with Fantastico, there were other databases on the server before adding zen, if that's what you mean.

I don't understand why everything would work fine if the faq manager SQL patch is not installed?

Is there a way for me to manually add these missing variables to get it working properly?

As I said I'm a complete noob so please bear with me if I am missing an obvious point.

Thanks!

Matt

[Mentalist]

Hello, I installed FAQ Manager on my site without any problems...except one.

On the attached screenshot I have circled a section that is repeated. There are two rows which describe where you are on the site and they have been duplicated. The top line is the line that is on my site by default, and the second is the line that FAQ Manager added. It's only duplicated when you enter the FAQ section. What file do I need to alter to get rid of this line? It's very annoying.

Cheers in advance!

[dscott1966]

Im having a problem with fckeditor when i try to list a new category im getting this error.

Warning: Missing argument 1 for FCKeditor::__construct(), called in /home/dscott19/public_html/dealz-r-us/admin/includes/modules/faq/collect_info.php on line 198 and defined in /home/dscott19/public_html/dealz-r-us/admin/includes/fckeditor_php5.php on line 42

Fatal error: Call to undefined method FCKeditor::CreateFCKeditor() in /home/dscott19/public_html/dealz-r-us/admin/includes/modules/faq/collect_info.php on line 200

Can anyone help me solve this problem.

Thank you

[mrowkaz]

<?php
//
// +----------------------------------------------------------------------+
// |zen-cart Open Source E-commerce                                       |
// +----------------------------------------------------------------------+
// | Copyright (c) 2003 The zen-cart developers                           |
// |                                                                      |
// | [url]http://www.zen-cart.com/index.php[/url]                                    |
// |                                                                      |
// | 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:           |
// | [url]http://www.zen-cart.com/license/2_0.txt[/url].                             |
// | 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.          |
// +----------------------------------------------------------------------+
// $Id: faq_manager.php 001 2005-05-05 [email protected]
//
  $content = "";
  $content .= '<div id="' . str_replace('_', '-', $box_id . 'Content') . '" class="sideBoxContent">' . "\n";
  for ($i=0;$i<sizeof($box_faq_categories_array);$i++) {
    switch(true) {
// to make a specific faq_category stand out define a new class in the stylesheet example: A.faq_category-holiday
// uncomment the select below and set the fcPath=3 to the fcPath= your_faq_categories_id
// many variations of this can be done
//      case ($box_faq_categories_array[$i]['path'] == 'fcPath=3'):
//        $new_style = 'faq_category-holiday';
//        break;
      case ($box_faq_categories_array[$i]['top'] == 'true'):
        $new_style = 'category-top';
        break;
      case ($box_faq_categories_array[$i]['has_sub_cat']):
        $new_style = 'category-subs';
        break;
      default:
        $new_style = 'category-products';
      }
     if (zen_get_faq_types_to_faq_category($box_faq_categories_array[$i]['path']) == '3' or ($box_faq_categories_array[$i]['top'] != 'true' and SHOW_FAQ_CATEGORIES_SUBFAQ_CATEGORIES_ALWAYS != 1)) {
        // skip it this is for the document box
      } else {
      $content .= '<a class="' . $new_style . '" href="' . zen_href_link(FILENAME_FAQS, $box_faq_categories_array[$i]['path']) . '">';

      if ($box_faq_categories_array[$i]['current']) {
        if ($box_faq_categories_array[$i]['has_sub_cat']) {
          $content .= '<span class="category-subs-parent">' . $box_faq_categories_array[$i]['name'] . '</span>';
        } else {
          $content .= '<span class="category-subs-selected">' . $box_faq_categories_array[$i]['name'] . '</span>';
        }
      } else {
        $content .= $box_faq_categories_array[$i]['name'];
      }

      if ($box_faq_categories_array[$i]['has_sub_cat']) {
        $content .= FAQ_CATEGORIES_SEPARATOR;
      }
      $content .= '</a>';

      if (SHOW_FAQ_COUNTS == 'true') {
        if ((FAQ_CATEGORIES_COUNT_ZERO == '1' and $box_faq_categories_array[$i]['count'] == 0) or $box_faq_categories_array[$i]['count'] >= 1) {
          $content .= FAQ_CATEGORIES_COUNT_PREFIX . $box_faq_categories_array[$i]['count'] . FAQ_CATEGORIES_COUNT_SUFFIX;
        }
      }

      $content .= '<br />';
    }
  }

  if (SHOW_FAQ_CATEGORIES_BOX_FAQS_NEW == 'true' or SHOW_FAQ_CATEGORIES_BOX_FEATURED_FAQS == 'true' or SHOW_FAQ_CATEGORIES_BOX_FAQS_ALL == 'true') {
// display a separator between faq_categories and links
    if (SHOW_FAQ_CATEGORIES_SEPARATOR_LINK == '1') {
      $content .= '<br />' . zen_draw_separator('pixel_silver.gif') . '<br />';
    }
    if (SHOW_FAQ_CATEGORIES_BOX_FAQS_NEW == 'true') {
      switch (true) {
        case (SHOW_NEW_FAQS_LIMIT == '0'):
          $display_faq_limit = '';
          break;
        case (SHOW_NEW_FAQS_LIMIT == '1'):
          $display_faq_limit = " and date_format(p.faqs_date_added, '%Y%m') >= date_format(now(), '%Y%m')";
          break;
        case (SHOW_NEW_FAQS_LIMIT == '30'):
          $$display_faq_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 30';
          break;
        case (SHOW_NEW_FAQS_LIMIT == '60'):
          $display_faq_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 60';
          break;
        case (SHOW_NEW_FAQS_LIMIT == '90'):
          $display_faq_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 90';
          break;
        case (SHOW_NEW_FAQS_LIMIT == '120'):
          $display_faq_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 120';
          break;
      }

      $show_this = $db->Execute("select p.faqs_id
                                 from " . TABLE_FAQS . " p
                                 where p.faqs_status = '1' " . $display_faq_limit . " limit 1");
      if ($show_this->RecordCount() > 0) {
        $content .= '<a class="category-links" href="' . zen_href_link(FILENAME_FAQS_NEW) . '">' . FAQ_CATEGORIES_BOX_HEADING_WHATS_NEW . '</a>' . '<br />';
      }
    }
     if (SHOW_FAQ_CATEGORIES_BOX_FAQS_ALL == 'true') {
      $content .= '<a class="category-links" href="' . zen_href_link(FILENAME_FAQS_ALL) . '">' . FAQ_CATEGORIES_BOX_HEADING_FAQS_ALL . '</a>';
    }
  }
$content .= '</div>' . "\n";
?>[PHP]

[/PHP]