FAQ Manager

[a_berezin]

So, would you kindly mind telling us which file contains the p.products code line that needs to be changed? I have searched and can't seem to find it.

Why you ask about it? You gote an error with 'p.products'? Can you show me this error?

[Dehaw]

Why you ask about it? You gote an error with 'p.products'? Can you show me this error?

Hi Andrew,

This line of code doesn't actually exist within this contribution, but i have seen myself with another users site that it seems to cause a problem when the sidebox is active, which tells me there is a conflict in the sidebox code, but we need to find out which box it is.

I personally installed the contribution on 3 seperate sites this week on 3 new installs and never seen this error anywhere on any of the sites, so it kind of beats me now, so i now need to wait to find out from other users where the conflict exists.

If you foind the error or anyone else for that matter please let us know which modules you have installed, this will help us narrow down the problem.

Kind regards

Derek

[DrByte]

What version of MySQL is being used on these sites?

[Dehaw]

What version of MySQL is being used on these sites?

Hi DrByte,

I can't talk for anyone else but i have installed it on verion 4 & 5 and everything works perfect.

Derek

[a_berezin]

Hi Derek,

This line of code doesn't actually exist within this contribution,

Yes.

but i have seen myself with another users site that it seems to cause a problem when the sidebox is active

What faq manager they use? What version of faq manager they use? What zen-cart version? What a problem? Problem with 'p.products'?

I personally installed the contribution on 3 seperate sites this week on 3 new installs and never seen this error anywhere on any of the sites

I too. But I remove includes/open-operations/ processing.
And in sideboxes/faq_categories.php change

$main_faq_category_tree = new faq_category_tree;

to

$main_faq_category_tree = new faq_category_tree();

[Dehaw]

Hi Derek,
Yes.
What faq manager they use? What version of faq manager they use? What zen-cart version? What a problem? Problem with 'p.products'?
I too. But I remove includes/open-operations/ processing.
And in sideboxes/faq_categories.php change

$main_faq_category_tree = new faq_category_tree;

to

$main_faq_category_tree = new faq_category_tree();

Hi Andrew,

Yeah this is the original FAQ manager contrib from Dave @ Open Operations, i helped sort a few bugs to get it actually working, which it does for most but not for some, but i'm not sure why.

I have tested on 1.3X including the latest release of Zencart and all is fine. it seems that some people get this error where the sql query is trying to select the p.products_date_added where clearly that doesn't exist and it should be referencing the p.faqs_date_added, but again this p.products_date_added doesn't exist within this contrib.

However, since Dave based this contrib on the zencart site products and amended tables and code to accommodate for FAQS as opposed to products, that would tell me that the FAQ categories side box is conflicting with another sidebox, since this is where the problem seems to occur.

I'm kind of stumped since i never see this problem even on a new install with all sideboxes activated and no one else seems to report that they got it working.

So i'll wait and see if either there is a solution or even an explanation would be good.

Thanks ;-)

Derek

[lankeeyankee]

Hi,

OK, I think I figured out why I kept getting the p.products error in the sidebox. I had expanded catagory mod loaded and once I removed that I didn't get that error anymore.

BUT, every time I reload the SQL patch for faq manager and enable the sidebox I get this message below. The odd thing is, and I know almost nothing about coding yet (but I am learning as fast as I can!), when I go to the store after loading the SQL patch and enabling the faq sidebox everything is normal. Then when I click on anything on the page I get the following errors and they then won't go away for any page unless I restore my SQL database to an earlier time and thus remove the faq patch.

The first error message appears in the main body of the store under the header, and all of the text is really big, even the store's text:

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 zen_products p, zen_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 >=20070305 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]


These other errors are above the header:


Warning: Variable passed to each() is not an array or object in /home/globaldr/public_html/customdrumshop/zen/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/globaldr/public_html/customdrumshop/zen/includes/classes/db/mysql/query_factory.php:114) in /home/globaldr/public_html/customdrumshop/zen/includes/functions/sessions.php on line 108
Warning: Cannot modify header information - headers already sent by (output started at /home/globaldr/public_html/customdrumshop/zen/includes/classes/db/mysql/query_factory.php:114) in /home/globaldr/public_html/customdrumshop/zen/includes/init_includes/init_templates.php on line 78


When I remove the faq SQL patch by restoring to an earlier database all of these go away.

I disabled all of the sideboxes on the left side except for faq manager and that didn't help.

I have heavily modded the store, I'm new to this and have been trying out the various mods to see what I want to use for our store. I have:

cart upsell/cross sell
dual pricing 1_3_7
easy populate
image handler 2
order steps tableless
quick updates 2.0
testimonials manager
stock by attributes 4.4
designer monthly boxes
usps click and ship
fedex mod
email archive search 1.2
backup mysql
qbi v3.21b

I hope that this helps. Please let me know if you need any more info or would like access to the store to check it out yourself. It's on a remote server but we're not using it yet so you can go in and see for yourself what the problem may be.

Thanks!

Matt

[Dehaw]

Hi matt,

Finally someone has come to the rescue with what might be the problem! ;-)

Ok so the problems you are having now are relating to your configuration, it seems the database entries have not loaded properly.

Do you have a url so we can see it?

many thanks

Derek

[lankeeyankee]

The url is http://www.customdrumshop.com/zen I know that the layout is screwed up somewhat with the search box in a un-aligned spot etc. I am still messing around to get a feel for what does what and haven't focused on the CSS or any layout options yet, so don't laugh too hard. Unless something is causing the problem?

I just installed the faq SQL patch again so you can see what is happening and now when you go to the faq page by clicking on the link the error message in the main body of the page is:

Warning: Division by zero in /home/globaldr/public_html/customdrumshop/zen/includes/classes/split_page_results.php on line 76


The other errors above the headers are there, too. Then when I go back to the home page I get the other errors that I mentioned in the last post.

I hope that this will help figure it out. I just installed a fresh 1.3.7 on my home computer after going through the setup in the new zen cart book, so I will try to install the faq manager on it and see what happens. I'll let you know the results.

Thanks!

Matt

[Dehaw]

Hi matt,

It looks to me that those errors are present as a result of those variables being missing from the database, have you used an older database with new files?

Try installing a fresh copy of the site using a new database, then install the faq manager, it shoulfd all work fine.

Let us know how you get on ;-)

Derek