ZenCart 1.51, MySQL 5.5.23-55, PHP 5.2.17 using Hostgator as my host
Printable View
ZenCart 1.51, MySQL 5.5.23-55, PHP 5.2.17 using Hostgator as my host
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.
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!
Glad that you got it working.
How can I put a faq link in my ezpages bar header?
Thanks
Read this thread on how to do ezpages:Quote:
Originally Posted by jabbott
http://www.zen-cart.com/showthread.p...-EZ-Pages-work
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:
1. 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?
2. The FAQ Catagories [more] sidebox title is a link to the page, how do you get rid of the [more] that appears?
3. 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.
http://www.floridagofishing.com/shop/
This is controlled in includes/modules/sideboxes/faq_categories.php.Quote:
Originally Posted by FloridaGoFishing
To always show the FAQ Categories sidebox, change the content of faq_categories to:
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.PHP Code://$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);
//}
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.Quote:
Originally Posted by FloridaGoFishing
Or if you want to remove the link from the FAQ Category sidebox title, in faq_categories.php, change
toPHP Code:$title_link = FILENAME_FAQS;
PHP Code:$title_link = false;
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.Quote:
Originally Posted by FloridaGoFishing
Thank you kamelion0927 for the detailed response, I appreciate it!
1. Revised code per your instructions and the FAQ sidebox now is visable at all times. Thanks!
2. 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....
3. Validating pages. I ran the validator on my site and am not well versed in this area. What I see is errors from scripts I put on the site like GetClicky and AddThis buttons. I am also getting an error from Google +1 and I don't have that on the site except within AddThis! Anyway, I can't figure out how to solve these validation errors, guess hiring an expert is at hand someday. The site works fine anyway.
So the only problem left is the Newsletter sidebox title - I guess users who click it will get a surprise, FAQ page :)
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)