New Zenner
- Join Date:
- Dec 2010
- Posts:
- 11
- Plugin Contributions:
- 0
FAQ Module [Support]
ZenCart 1.51, MySQL 5.5.23-55, PHP 5.2.17 using Hostgator as my host
New Zenner
ZenCart 1.51, MySQL 5.5.23-55, PHP 5.2.17 using Hostgator as my host
Totally Zenned
Ok,,, I have the same hosting company.
What I realized was go into your phpMyAmin and remove all your FAQ's in your database. But be very careful on how you remove them. Once you have remove all the FAQ that is in the database then re-install the latest SQL and it should work.
New Zenner
OK, I managed to got it working by going into phpMyAdmin and deleted all FAQs tables also all FAQs inside configuration, and configuration_group tables.
Thank you so much for your help
Cheers!
Totally Zenned
Glad that you got it working.
New Zenner
How can I put a faq link in my ezpages bar header?
Thanks
Totally Zenned
jabbott:
How can I put a faq link in my ezpages bar header?
Thanks
Read this thread on how to do ezpages:
http://www.zen-cart.com/showthread.php?43675-How-do-EZ-Pages-work
New Zenner
Hi, I just installed this module and it is great! Thank you for your hard work. I have version 1.5.0
I have 3 questions:
I noticed on my install and on several other Zen Stores that you only see FAQs in the Information sidebox. Once you click FAQs, you are directed to the page and now the FAQ Catagories sidebox appears. Is there a way to keep this sidebox open at all times?
The FAQ Catagories [more] sidebox title is a link to the page, how do you get rid of the [more] that appears?
If you look at my site after clcking the FAQs in the Information sidebox, the sidebox below FAQ Catagories for MailChimp now has in the title Newsletter [more] and when you click it, it goes to the FAQ page. The [more] part was not there before installing this mod and obviously the link is wrong. I have fumbled around trying to figure out how these two sideboxes are crossed to no avail.
Zen Follower
FloridaGoFishing:
- I noticed on my install and on several other Zen Stores that you only see FAQs in the Information sidebox. Once you click FAQs, you are directed to the page and now the FAQ Catagories sidebox appears. Is there a way to keep this sidebox open at all times?
This is controlled in includes/modules/sideboxes/faq_categories.php.
To always show the FAQ Categories sidebox, change the content of faq_categories to:
//$show_faq_categories = true;
//if ($_GET['main_page']=='faqs_all' or $_GET['main_page']=='faq_info') {
// show it
//$show_faq_categories = true;
//} else {
// do not show it
//$show_faq_categories = false;
//}
//if ($show_faq_categories == true) {
$main_faq_category_tree = new faq_category_tree;
$row = 0;
$box_faq_categories_array = array();
// don't build a tree when no faq_categories
$check_faq_categories = $db->Execute("select faq_categories_id from " . TABLE_FAQ_CATEGORIES . " where faq_categories_status=1 limit 1");
if ($check_faq_categories->RecordCount() > 0) {
$box_faq_categories_array = $main_faq_category_tree->zen_faq_category_tree();
}
require($template->get_template_dir('tpl_faq_categories.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_faq_categories.php');
$title = BOX_HEADING_FAQ_CATEGORIES;
$title_link = FILENAME_FAQS;
require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
//}
which removes the if statement for showing the sidebox. By commenting the code out instead of removing it, you can simply remove the "//" from in front of it to turn the if statement back on.
FloridaGoFishing:
- The FAQ Catagories [more] sidebox title is a link to the page, how do you get rid of the [more] that appears?
All sidebox titles with a link have the [more] on it. Search for how to remove the [more] off of all sidebox title links - I did it on my store but can't remember off the top of my head how to do it.
Or if you want to remove the link from the FAQ Category sidebox title, in faq_categories.php, change
$title_link = FILENAME_FAQS;
to
$title_link = false;
FloridaGoFishing:
- If you look at my site after clcking the FAQs in the Information sidebox, the sidebox below FAQ Catagories for MailChimp now has in the title Newsletter [more] and when you click it, it goes to the FAQ page. The [more] part was not there before installing this mod and obviously the link is wrong. I have fumbled around trying to figure out how these two sideboxes are crossed to no avail.
That's an interesting conundrum and not one I've run across before. When I try to validate your site using the Firefox extension Web Developer (Firebug is another great tool to locate issues on your site) to see if I can locate the problem, there are multiple validation issues that could be causing it. I would be happy to look at it again to see if I can locate the issue after the validation issues have been resolved.
New Zenner
Thank you kamelion0927 for the detailed response, I appreciate it!
Revised code per your instructions and the FAQ sidebox now is visable at all times. Thanks!
Removing [more] I found the easy fix and instructions are here http://www.zen-cart.com/showthread.php?94344-Remove-quot-more-quot-link-from-under-New-Products-Sidebox-Title
This removed the [more] text from FAQ & Newsletter sideboxes.
The Newsetter sidebox title still goes to the FAQ page which we will not be able to fix because....
So the only problem left is the Newsletter sidebox title - I guess users who click it will get a surprise, FAQ page :)
New Zenner
Fixed the MailChimp Newsletter sidebox title link problem - I just moved the FAQ sidebox to a new position and now all is working fine! (boxes were previously ordered Information > FAQ > Newsletter - now they are FAQ > Information > Newsletter)
Zen Follower
Glad you got it sorted.
Totally Zenned
I found a bug in tpl_faq_info_display in both versions. Line 44 reads:
require($template->get_template_dir('/tpl_faqs_next_previous.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_faqs_next_previous.php'); ?>
but it should be:
require($template->get_template_dir('/tpl_faq_next_previous.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_faq_next_previous.php'); ?>
(there's an s on faq, but it should be faq and not faqs)
This was breaking the bottom previous/next buttons as well as not showing the footer menu since it stopped there and nothing after was being rendered.
Thanks for this mod!!!
Zen Follower
First, thank you thank you for such a great mod!!
Second - I stewed and stewed about how in the world to get my questions to show up under the categories on the FAQ All page, instead of showing them in the order that I had put entered them in.
Hoping that this will help someone else who has the same dilemma. Here is what I did:
Now the questions show up neatly right underneath the category they belong to!
Judy Gunderson, 406-880-4330
New Zenner
Hello, I am using Zen-Cart 1.5.1 and the latest version 2.3 of the FAQ module and am using three languages (English, German and Spanish).
My problem is very similar to the user arsanat.
On page: https://www.zen-cart.com/index.php?main_page=faqs_all
I see three different faqs in the language I am using and three different categories name.
It looks something like this (in English language, if I am using Spanish languages then the category name stays the same, but all the questions are shown in Spansih language):
Frequently Asked Questions
Sort by: FAQ Name
Product Information
Can the product by manufacturer X be used in the engine of the manufacturer Y?
Produkt information
Can the product by manufacturer X be used in the engine of the manufacturer Y?
Información del producto
Can the product by manufacturer X be used in the engine of the manufacturer Y?
All the languages have been translated and the problem still persist and has not magically disappeared .
Does anybody have any ideas!?
Any help would be appreciated!
New Zenner
I solved the problem with multiple languages with the help by user FredSchenk and the thread FAQ Manager - FAQs multiple times displayed.
The code in zen-cart\includes\modules\pages\faqs_all\header_php.php line 21-22 which reads:
$faqs_all_query_raw = "select p.*, pd.*, pcd.faq_categories_name from " . TABLE_FAQS . " p, " . TABLE_FAQS_DESCRIPTION . " pd, " . TABLE_FAQ_CATEGORIES_DESCRIPTION . " pcd, " . TABLE_FAQ_CATEGORIES . " pc " .
"where p.faqs_status = '1' and p.faqs_id = pd.faqs_id and pd.language_id = '" . (int)$_SESSION['languages_id'] . "' and p.master_faq_categories_id = pcd.faq_categories_id and p.master_faq_categories_id = pc.faq_categories_id and pc.faq_categories_status='1' ";
must be changed to read:
$faqs_all_query_raw = "select p.*, pd.*, pcd.faq_categories_name from " . TABLE_FAQS . " p, " . TABLE_FAQS_DESCRIPTION . " pd, " . TABLE_FAQ_CATEGORIES_DESCRIPTION . " pcd, " . TABLE_FAQ_CATEGORIES . " pc " .
"where p.faqs_status = '1' and p.faqs_id = pd.faqs_id and pd.language_id = '" . (int)$_SESSION['languages_id'] . "' and p.master_faq_categories_id = pcd.faq_categories_id and p.master_faq_categories_id = pc.faq_categories_id and pc.faq_categories_status='1' and pd.language_id = pcd.language_id ";
New Zenner
Let me first say thank you for a great module - congrats. I have it installed here: business - support - uk dot co dot uk and it appears to be fine with two small exceptions that I hope somebody can help with. The first issue I have is when I go to the featured faqs page within admin I appear to be missing some button definition information.
I have included this screen shot for reference:
My second problem is that I am unable to include the module within another profile other than a 'super user'. When I grant access rights it appears in the other user profiles 'extras' menu but says they don't have permission when the relevant box is definitely ticked. This is the only module that this happens to. I have gone into the database and can see the following information:
admin_pages
Page Key: configFAQManager
Language Key: BOX_CATALOG_FAQ_MANAGER
main_page: FILENAME_FAQ_MANAGER
page_params: gID=41
menu_key: extras
display_on_menu: Y
sort_order: 41
admin_pages_to_profiles
profile_id: 4
page_key: configFAQManager
Any ideas?
New Zenner
Apologises - I'm using Zen ver 1.51 and FAQ Manager ver 2.2 lol:blush:
Zen Follower
I'm wondering where the category description is supposed to show up. I am not seeing it showing anywhere. I would like to have the category description under the category title on the category listing page... Is there some setting I need to turn on or do I need to modify the code somewhere?
New Zenner
Ok, so I don't seem to be getting anywhere with this. Is this thread still alive? Does anybody have any idea why I am unable to grant access to another admin user? It is a great module but unfortunately is no good if only I can manage it - would be a shame to have to uninstall it cos it is exactly what I have been looking for.
Administrator
Dave Mc:
Ok, so I don't seem to be getting anywhere with this. Is this thread still alive? Does anybody have any idea why I am unable to grant access to another admin user? It is a great module but unfortunately is no good if only I can manage it - would be a shame to have to uninstall it cos it is exactly what I have been looking for.
Usually, there's a plugin file that is in the /YOUR_ADMIN/includes/extra_datafiles folder that contains the plugin's "filenames" and "database" names. If there is a PHP define statement that contains the plugin's filename, make sure that the definition value does not end with .php. If it does, remove the .php bit from the definition and you'll be able to allow non-superuser admins to also use the tool.
Tell staff why this post should be reviewed.