FAQ Manager

[Noutje]

[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

[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

[Noutje]

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.)

[purple-circle]

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

[Noutje]

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.

[lextechs]

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. www.lextechs.com

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

[Dehaw]

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

[Dehaw]

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

[redmonds]

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