FAQ Manager

[ChrisR]

Hi,

I will give it one more try, after having posted and bumped already several times.

I noticed that the error I get is something common it is not that i am the only one with this issue and I believe taht most may not have noticed yet taht they have the same issue.

Please take a look at

http://www.clickyshop.com/tienda1/in...?main_page=faq

I dont know what causes this error, but most of the webites having installed FAQ MAnager, as I mentioned before, have the same error.

You can checkout by yourself, try to enter www.yourdomain.com/your_shop/index.php?main_page=faq

You will see that this is common error....

Does anybody has an idea how to fix this?
Or should I just let it go and there is no fix for it?


Would be great if anybody finds an answer on this matter.

Help really apreciated.

regards,
kruna

Kruna, without typing the location in your browser how would you get to this page following any of the FAQ links. As I cannot get to this error unless I actually type in the line you suggest in your post.

Thanks

[ChrisR]

Hi All

When disabling images in admin for the faq New page you will find that the test does not line up when looking at this page in your browser. The includes/modules/faq_new_listings.php seems to be faulty/ I have edited and attached a new one which fixes the problem. Hope it helps.

[Kruna]

Hi ChrisR,

Tahnk you for answering.
I cant remember anymore how I got there, I just remeber taht it appeared in the breadcrumb and when I clicked on that breadcrumb i got this error.

Anyway it is an error which I would like to fix, if it is possible, if not I will have to live with it.

I suppose that this page has to show available question and I wanted to use this in EZ-pages, linking this page.

pixelpadre,

thank you too, but your fix didnt work for me...

regards,
kruna

[Kruna]

I found when and where this error appears...

http://www.clickyshop.com/tienda1/in...ge=faqs_submit

in the breadcrumb you can see PREGUNTAS Y RESPUESTAS (Questions and answers)

When you click there this error page comes up...

thanks.

regards,
kruna

[ChrisR]

Kruna

The post I did with the attached file was to fix the alignment of the text when you choose not to show images for "New faq" if you switch the images off then the text still leaves place to show the image but you do not need this. The "All nes questions" worked fine, so i made the "New Questions" one work the same as the All queations.

[ChrisR]

I found when and where this error appears...



in the breadcrumb you can see PREGUNTAS Y RESPUESTAS (Questions and answers)

When you click there this error page comes up...

thanks.

regards,
kruna

Hi Kruna

The quickest way right now is to go to the includes/extra_datafiles/faq_manager_file_names.php and chnage the line on 28
define('FILENAME_FAQS', 'faq');

define('FILENAME_FAQS', 'faqs_all');

This will at least make the link work. I am still ooking why the actual page for FAQ link does not work but as I am not a programmer it will take some time yet.

Good luck

[pixelpadre]

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?

[james739]

--------------------------------------------------------->
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;

------------------------------
Nice site!
How did you get your footer like that. WIth the different columns?

Thanks

[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!

[Dehaw]

Hi,

Unfortunately we haven't had time to upgrade the mod for the latest releases, this problem is caused by the template file you installed, so please view the faq templates and remove the breadcrumb code from the template since its now being called elsewhere.

I hope this helps

Derek