FAQ Manager

[bgroup99]

Can anybody help? Please?

Thanks in advance!

There are some serious bugs with this FAQ mod right now, I would not recommend using it unless they have been resolved. It will mess up how your categories are displayed.

[P3George]

I installed this module and all seemed to go fine until I turned on the side box. Then it went really crazy. It put the left column in the center of the page and nothing else on the screen. Anyone have any fixes for this? I think this is a great idea for an add on but....

Hi, I just installed the FAQ module and this also happened to me.

What I neglected to realize, and it is not mentioned in the readme is that if you are running a template then you need to copy the files from /includes/template/YOUR_TEMPLATE to your template directory. Once I did this it seems to work.

Hope this helps a bit.

[Grace38]

I notice several people asked this question already but no one has answered it at least in the pages i have read ( it's a long thread )

How do you stop your main page showing up when you click one of your product categories after installing this.

My main page shows up in all categories which have subcategories.

If the category doesn't have subcategories the main page doesn't show up and thats how i want it.

Someone suggested deleting a file but thats no use if you want to actually use the module.

So what is the fix for this issue ?

[Grace38]

I understand that using FAQ module causes the main page to be displayed above the body of any category page. Is this true? If it is, what is the work around it besides eliminating the main page?

Thats my problem too although it's only the very top of the page - The one you can edit in define pages editior.

[ctcentralinfo]

Does anyone have this mod installed on their site? I would like to see how it works.

[raspberryjamcloth]

I installed it, but it is off - changes the colors on my template and gives this error:

1054 Unknown column 'p.products_date_added' in 'where clause'
in:
[select p.faqs_id from zen_faqs p where p.faqs_status = '1' and p.products_date_added >=20081211 and (p.products_date_available <=20081218 or p.products_date_available IS NULL) limit 1]

[bgroup99]

I notice several people asked this question already but no one has answered it at least in the pages i have read ( it's a long thread )

How do you stop your main page showing up when you click one of your product categories after installing this.

My main page shows up in all categories which have subcategories.

If the category doesn't have subcategories the main page doesn't show up and thats how i want it.

Someone suggested deleting a file but thats no use if you want to actually use the module.

So what is the fix for this issue ?

Unless someone fixes the PHP code in the module, all you can do is uninstall it.

[danilovig]

it works only there is had that injectar this sql....

but @t4 is the group configuration Where you want to install it

INSERT INTO configuration VALUES ('', 'Limit New Faq', 'SHOW_NEW_FAQS_LIMIT', '60', 'Limit fac', @t4, 100, NULL, now(), NULL, '');


ExampleI have put it in the last position )

NSERT INTO configuration_group VALUES ('', 'FAQ Manager - FAQ Listing', 'FAQ Manager FAQ Listing Settings', '1' , '0');

UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SET @t4=0;

SELECT (@t4:=configuration_group_id) as t4

FROM configuration_group

WHERE configuration_group_title= 'FAQ Manager - FAQ Listing';

INSERT INTO configuration VALUES ('', 'Display FAQ Name', 'FAQ_LIST_NAME', '1', 'Do you want to display the FAQ Name?', @t4, 50, NULL, now(), '', '');

INSERT INTO configuration VALUES ('', 'Prev/Next Split Page Navigation (1-top, 2-bottom, 3-both)', 'PREV_NEXT_FAQ_BAR_LOCATION', '1', 'Sets the location of the FAQ Prev/Next Split Page Navigation', @t4, 51, NULL, now(), '', 'zen_cfg_select_option(array(''1'', ''2'', ''3''), ');

INSERT INTO configuration VALUES ('', 'Display FAQ Listing Default Sort Order', 'FAQ_LISTING_DEFAULT_SORT_ORDER', '', 'FAQ Listing Default sort order?<br />NOTE: Leave Blank for FAQ Sort Order. Sort the FAQ Listing in the order you wish for the default display to start in to get the sort order setting. Example: 2a', @t4, 52, NULL, now(), '', '');

INSERT INTO configuration VALUES ('', 'Number Per Page', 'MAX_DISPLAY_FAQS_LISTING', '10', 'Maximum Number of FAQs to list per page on main page', @t4, 53, NULL, now(), '', '');


INSERT INTO configuration VALUES ('', 'Limit New Faq', 'SHOW_NEW_FAQS_LIMIT', '60', 'Limit fac', @t4, 100, NULL, now(), NULL, '');

Unless someone fixes the PHP code in the module, all you can do is uninstall it.

[danilovig]

Another solution is:

includes/templates/yourtemplate/sideboxes/tpl_faq_categories.php

line:96

add after:

      case (SHOW_NEW_FAQS_LIMIT == '120'):

          $display_limit = ' and TO_DAYS(NOW()) -  TO_DAYS(p.faqs_date_added) <= 120';

          break; 

Put

          default:
          $display_limit= '';
          break;
      } 

The final code:

   if (SHOW_FAQ_CATEGORIES_BOX_FAQS_NEW == 'true') {

      switch (true) {

        case (SHOW_NEW_FAQS_LIMIT == '0'):

          $display_limit = '';

          break;

        case (SHOW_NEW_FAQS_LIMIT == '1'):

          $display_limit = " and date_format(p.faqs_date_added, '%Y%m') >= date_format(now(), '%Y%m')";

          break;

        case (SHOW_NEW_FAQS_LIMIT == '30'):

          $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 30';

          break;

        case (SHOW_NEW_FAQS_LIMIT == '60'):

          $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 60';

          break;

        case (SHOW_NEW_FAQS_LIMIT == '90'):

          $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 90';

          break;

        case (SHOW_NEW_FAQS_LIMIT == '120'):

          $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 120';

          break;

        default:
          $display_limit= '';
          break;
      } 

it works only there is had that inject this sql....

[gofer_p]

Another solution is:

includes/templates/yourtemplate/sideboxes/tpl_faq_categories.php

line:96

add after:

      case (SHOW_NEW_FAQS_LIMIT == '120'):

          $display_limit = ' and TO_DAYS(NOW()) -  TO_DAYS(p.faqs_date_added) <= 120';

          break; 

Put

          default:
          $display_limit= '';
          break;
      } 

The final code:

   if (SHOW_FAQ_CATEGORIES_BOX_FAQS_NEW == 'true') {

      switch (true) {

        case (SHOW_NEW_FAQS_LIMIT == '0'):

          $display_limit = '';

          break;

        case (SHOW_NEW_FAQS_LIMIT == '1'):

          $display_limit = " and date_format(p.faqs_date_added, '%Y%m') >= date_format(now(), '%Y%m')";

          break;

        case (SHOW_NEW_FAQS_LIMIT == '30'):

          $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 30';

          break;

        case (SHOW_NEW_FAQS_LIMIT == '60'):

          $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 60';

          break;

        case (SHOW_NEW_FAQS_LIMIT == '90'):

          $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 90';

          break;

        case (SHOW_NEW_FAQS_LIMIT == '120'):

          $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 120';

          break;

        default:
          $display_limit= '';
          break;
      } 

This solution worked for me.Thanks danilovig.