FAQ Manager

[QUOTE=Dehaw;293636]This is a known bug and i'll also get this changed, this piece of code:

p.products_date_available 

needs to be changed to

p.faqs_date_available 

I did a search in the files for p.products_date_available but could not find it in the files..

I solved this now by adding a field p.products_date_available in the faq table and now it works perfectly

Still want to know which file contains the where clause that include p.products_date_available

I haven't managed to update the files as yet, i'm just too busy.

The reason it SEEMS to have worked 'perfectly' is because there is now a column there for the script to reference, however this is wrong and the script will not function properly because the script need to be changed as above, adding another column will only make the error disapear.

Derek

Dehaw:

I haven't managed to update the files as yet, i'm just too busy.

The reason it SEEMS to have worked 'perfectly' is because there is now a column there for the script to reference, however this is wrong and the script will not function properly because the script need to be changed as above, adding another column will only make the error disapear.

Derek

It seems to work perfect now and all faq's are displayed. Maybe I am missing some functions the scipt should do but i do not know what they are.

I found however another bug.
After installing FAQ manager when clicking on a top level product categorie when this categorie has Sub- categories the mainpage text is displayed. This is caused by the faq manager script because when i comment out the addition in /included/ application_top.php all functions normal again (for the categorie selection this is. Only the faq manager box triggers an error then.)

So which file or files does p.products_date_available need to be changed in?

Dehaw:

I haven't managed to update the files as yet, i'm just too busy.

The reason it SEEMS to have worked 'perfectly' is because there is now a column there for the script to reference, however this is wrong and the script will not function properly because the script need to be changed as above, adding another column will only make the error disapear.

Derek

Well this change cannot be done because i checked all files in the contrib and there is NO text in the files like "p.products_date_available" to change.

I noticed this contrib is heavenly drawn from the products display and info files. Maybe this error occurs using a function or class or include from the products files.

This contri is not compatible with 1.36 yet.

Also the button "Ask a question" is only displayed in FAQ ALL and FAQ NEW but not when displaying a FAQ selected from the FAQ CATEGORIES. I would like this button on all faq pages to apear and maybe as a feature request also on all product pages with the possibility to switch it on and off on admin? (e.g. in Admin config: "Do you want to display the "ASK QUESTION BUTTON" on the product_info pages?)

The main thing that bothers me is that de main page description is shown when selecting a top-gategory that has subs.

I checked all files but cannot find what causes this.

I uplaoded this mod and for some reason after i uploaded it me site just screw up see and i goot all these error messages...

Warning: Variable passed to each() is not an array or object in /home/keepnitr/public_html/lextechs/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/keepnitr/public_html/lextechs/includes/classes/db/mysql/query_factory.php:114) in /home/keepnitr/public_html/lextechs/includes/functions/sessions.php on line 102

Warning: Cannot modify header information - headers already sent by (output started at /home/keepnitr/public_html/lextechs/includes/classes/db/mysql/query_factory.php:114) in /home/keepnitr/public_html/lextechs/includes/init_includes/init_templates.php on line 78

Warning: Cannot modify header information - headers already sent by (output started at /home/keepnitr/public_html/lextechs/includes/classes/db/mysql/query_factory.php:114) in /home/keepnitr/public_html/lextechs/includes/classes/seo.url.php on line 1247

Warning: Cannot modify header information - headers already sent by (output started at /home/keepnitr/public_html/lextechs/includes/classes/db/mysql/query_factory.php:114) in /home/keepnitr/public_html/lextechs/includes/classes/seo.url.php on line 1248

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 products p, 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 >=20070108 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]

Sometime the site looks like it's up but when i click a link i get the above. https://www.lextechs.com

I had a problem with this FAQ mod as described here...

then i found the problem.
the FAQ mod is causing the main page to show up on other pages
seems like the ../open-operations/faq_aplication_top.php is causing it
when i removed the directory and disabled the box it started working normal again!

is there a fix for this, as i do want to bring it back to my site?

Alik:

I had a problem with this FAQ mod as described here...

then i found the problem.
the FAQ mod is causing the main page to show up on other pages
seems like the ../open-operations/faq_aplication_top.php is causing it
when i removed the directory and disabled the box it started working normal again!

is there a fix for this, as i do want to bring it back to my site?

You need the extra application top to make sure the categories show properly, without it they wont show.

Anyway open up includes/modules/pages/faq/main_template_vars.php and look for line number 129 (or around there) it will most probably say this:

$tpl_page_body = 'tpl_index_default.php';

change it to this:

$tpl_page_body = 'tpl_faq_default.php';

Once your on this page if all you have in the url parameter is:

index.php?main_page=faq

change it to this:

index.php?main_page=faq&fcPath=0

that will either show the list of faqs or the categories with there are no faqs at the top level.

I am updating this faq manager to work better with the latest release and removing unwanted tables and also fixing the images problem, i'll let you know onjce its updated.

Derek

Noutje:

Well this change cannot be done because i checked all files in the contrib and there is NO text in the files like "p.products_date_available" to change.

I noticed this contrib is heavenly drawn from the products display and info files. Maybe this error occurs using a function or class or include from the products files.

This contri is not compatible with 1.36 yet.

Also the button "Ask a question" is only displayed in FAQ ALL and FAQ NEW but not when displaying a FAQ selected from the FAQ CATEGORIES. I would like this button on all faq pages to apear and maybe as a feature request also on all product pages with the possibility to switch it on and off on admin? (e.g. in Admin config: "Do you want to display the "ASK QUESTION BUTTON" on the product_info pages?)

The main thing that bothers me is that de main page description is shown when selecting a top-gategory that has subs.

I checked all files but cannot find what causes this.

On the intial release from Open Ops this software was not usable at all, we then took it on board for use with one of our clients and developed it so that it would work the way we wanted it to, now your right in that the ask a question buttons etc are only on certain pages, this is because thats the only pages we used at the time of development and it would be a waste of time to develop it further since we also have to live we need to make money ;).

However, this mod has alot of potential and we have already sorted alot of the major problems with it, but are still developing it to be more user friendly and actually a good working mod, but again this does take time more so since we are running a very busy development company ourselves.

I will be updating the mod very soon, or in a month or too but it will be alot more functional with less problems or even better none at all.

Currently though even we are coming across things that really shouldnt be there and its quite surprising that they are.

Derek

We are also getting the following error. Only on the 'faqs_new' page.

1054 Unknown column 'p.products_date_added' in 'where clause'
in:
[select count(*) as total from faqs p, faqs_description pd where p.faqs_status = '1' and p.faqs_id = pd.faqs_id and pd.language_id = '1' and p.products_date_added >=20061127].

I understand that we have to change 'p.products_date_added' to 'pfaqs_date_added' but can not find where to make the change. It seems like it should be very easy to fix if someone can tell me where it is.

Thanks

Do you have a url?

I am working on a new version of this and haven't come across it lately.

Derek

I installed this before I read this thread. I asumed it would work since it was in the downloads section.

Should I remove it and wait for the upgrade?

I think it's better set the FAQ question description field as not required when submiting a question. Any idea how to do that?

You would need to edit the header.php file within includes/modules/pages/testimonials_submit/header.php.

You may also want to remove the little red star too which can be done within the actual template file.

Hope this helps

Derek

p.s., i'm going to be changing the way this mod woeks and removing the redundant code and files, so any suggestions would be good.

Thank you for your help Derek. The mod is working perfectly!

Dehaw:

You would need to edit the header.php file within includes/modules/pages/testimonials_submit/header.php.

You may also want to remove the little red star too which can be done within the actual template file.

Hope this helps

Derek

p.s., i'm going to be changing the way this mod woeks and removing the redundant code and files, so any suggestions would be good. Will it be working for 1.3.7 in the near future? I can't get past the database error.

I'm using 1.3.7. It is working fine with Derek's FAQ. However, I did change quite a lot to get it work on my site. As for database, I did not upload through zen cart sql patch, I used phpmyadmin sql to avoid 1064 error in SQL syntax.

Cool I'll use myadmin. Got any other tips for getting it to work? I'm impatient and I already added a link for it.

Don't forget to backup your database before you do any changes. When I import FAQ sql, myadmin doesn't seem to add prefix 'zen_' automatically. So, I added this myself in the sql file (just use search and replace tool). I also deleted the previous imported FAQ tables before I imported them again so that duplicate error would not appear. You can paste the following sql to your myadmin once you are ready. (broken line is not included). Good luck!

--------------------------------------------------------->
DROP TABLE IF EXISTS faq_categories;
DROP TABLE IF EXISTS zen_faq_categories;
CREATE TABLE zen_faq_categories (
faq_categories_id int(11) NOT NULL auto_increment,
faq_categories_image varchar(64) default NULL,
parent_id int(11) NOT NULL default '0',
sort_order int(3) default NULL,
date_added datetime default NULL,
last_modified datetime default NULL,
faq_categories_status tinyint(1) NOT NULL default '1',
PRIMARY KEY (faq_categories_id),
KEY idx_faq_categories_parent_id (parent_id),
KEY idx_sort_order (sort_order)
) TYPE=MyISAM;
DROP TABLE IF EXISTS faq_categories_description;
DROP TABLE IF EXISTS zen_faq_categories_description;
CREATE TABLE zen_faq_categories_description (
faq_categories_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '1',
faq_categories_name varchar(32) NOT NULL default '',
faq_categories_description text NOT NULL,
PRIMARY KEY (faq_categories_id,language_id),
KEY idx_faq_categories_name (faq_categories_name)
) TYPE=MyISAM;
DROP TABLE IF EXISTS faq_reviews;
DROP TABLE IF EXISTS zen_faq_reviews;
CREATE TABLE zen_faq_reviews (
reviews_id int(11) NOT NULL auto_increment,
faqs_id int(11) NOT NULL default '0',
customers_id int(11) default NULL,
customers_name varchar(64) NOT NULL default '',
reviews_rating int(1) default NULL,
date_added datetime default NULL,
last_modified datetime default NULL,
reviews_read int(5) NOT NULL default '0',
status int(1) NOT NULL default '1',
PRIMARY KEY (reviews_id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS faq_reviews_description;
DROP TABLE IF EXISTS zen_faq_reviews_description;
CREATE TABLE zen_faq_reviews_description (
reviews_id int(11) NOT NULL default '0',
languages_id int(11) NOT NULL default '0',
reviews_text text NOT NULL,
PRIMARY KEY (reviews_id,languages_id)
) TYPE=MyISAM;
DROP TABLE IF EXISTS faq_type_layout;
DROP TABLE IF EXISTS zen_faq_type_layout;
CREATE TABLE zen_faq_type_layout (
configuration_id int(11) NOT NULL auto_increment,
configuration_title text NOT NULL,
configuration_key varchar(255) NOT NULL default '',
configuration_value text NOT NULL,
configuration_description text NOT NULL,
faq_type_id int(11) NOT NULL default '0',
sort_order int(5) default NULL,
last_modified datetime default NULL,
date_added datetime NOT NULL default '0001-01-01 00:00:00',
use_function text,
set_function text,
PRIMARY KEY (configuration_id)
) TYPE=MyISAM;
DROP TABLE IF EXISTS faq_types;
DROP TABLE IF EXISTS zen_faq_types;
CREATE TABLE zen_faq_types (
type_id int(11) NOT NULL auto_increment,
type_name varchar(255) NOT NULL default '',
type_handler varchar(255) NOT NULL default '',
type_master_type int(11) NOT NULL default '1',
allow_add_to_cart char(1) NOT NULL default 'Y',
default_image varchar(255) NOT NULL default '',
date_added datetime NOT NULL default '0001-01-01 00:00:00',
last_modified datetime NOT NULL default '0001-01-01 00:00:00',
PRIMARY KEY (type_id)
) TYPE=MyISAM;
INSERT INTO zen_faq_types VALUES (1, 'FAQ - General', 'faq', 1, 'N', '', now(), '');
DROP TABLE IF EXISTS faq_types_to_faq_category;
DROP TABLE IF EXISTS zen_faq_types_to_faq_category;
CREATE TABLE zen_faq_types_to_faq_category (
faq_type_id int(11) NOT NULL default '0',
faq_category_id int(11) NOT NULL default '0'
) TYPE=MyISAM;

DROP TABLE IF EXISTS faqs;
DROP TABLE IF EXISTS zen_faqs;
CREATE TABLE zen_faqs (
faqs_id int(11) NOT NULL auto_increment,
faqs_type int(11) NOT NULL default '1',
faqs_image varchar(64) default NULL,
faqs_date_added datetime NOT NULL default '0001-01-01 00:00:00',
faqs_last_modified datetime default NULL,
faqs_status tinyint(1) NOT NULL default '0',
faqs_sort_order int(11) NOT NULL default '0',
master_faq_categories_id int(11) NOT NULL default '0',
PRIMARY KEY (faqs_id),
KEY idx_faqs_date_added (faqs_date_added)
) TYPE=MyISAM;

DROP TABLE IF EXISTS faqs_description;
DROP TABLE IF EXISTS zen_faqs_description;
CREATE TABLE zen_faqs_description (
faqs_id int(11) NOT NULL auto_increment,
language_id int(11) NOT NULL default '1',
faqs_name varchar(64) NOT NULL default '',
faqs_description text,
faqs_answer text,
faqs_url varchar(255) default NULL,
faqs_contact_name varchar(255) default NULL,
faqs_contact_mail varchar(255) default NULL,
faqs_owner varchar(11) default '0',
faqs_viewed int(5) default '0',
PRIMARY KEY (faqs_id,language_id),
KEY faqs_name (faqs_name)
) TYPE=MyISAM;

DROP TABLE IF EXISTS faqs_to_faq_categories;
DROP TABLE IF EXISTS zen_faqs_to_faq_categories;
CREATE TABLE zen_faqs_to_faq_categories (
faqs_id int(11) NOT NULL default '0',
faq_categories_id int(11) NOT NULL default '0',
PRIMARY KEY (faqs_id,faq_categories_id)
) TYPE=MyISAM;