Zen Cart Logo
Forums / General Questions / Errors on my pages

Errors on my pages

Locked

Views: 883

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
30 Apr 2008, 4:45 PM
#1
zbdude avatar

zbdude

New Zenner

Join Date:
Aug 2007
Location:
Clinton, Michigan USA
Posts:
89
Plugin Contributions:
0

Errors on my pages

HELP!!

I have had my site on line for a couple of months, it has worked fine the way is is configured until yesterday.

When I first load my home page it is fine, but if I refresh or try to go to one of my links, I am getting warnings for a number of things at the top, all of the product and other links vanish, and I get mysql errors appear at the bottom

My first thought was a hack, My host said no, I tried to see if i could find any programing/ code mistakes( from my very limited knowledge) and I could not.

Can anyone help?

Norman

***Do the Impossible!!
***

30 Apr 2008, 5:00 PM
#3
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

Re: Errors on my pages

Links help

Zen cart PCI compliant Hosting

30 Apr 2008, 5:13 PM
#4
zbdude avatar

zbdude

New Zenner

Join Date:
Aug 2007
Location:
Clinton, Michigan USA
Posts:
89
Plugin Contributions:
0

Re: Errors on my pages

These are on the top:

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

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

These are on the bottom:

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_PRODUCT' 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 >=20080430 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]

Thanks

Norman

***Do the Impossible!!
***

30 Apr 2008, 6:29 PM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Errors on my pages

Your SQL error is addressed here:
http://www.zen-cart.com/forum/showthread.php?t=56436

For your query_factory errors, did your host recently upgrade your PHP and/or MySQL versions?
What version of Zen Cart are you running?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

30 Apr 2008, 9:16 PM
#6
zbdude avatar

zbdude

New Zenner

Join Date:
Aug 2007
Location:
Clinton, Michigan USA
Posts:
89
Plugin Contributions:
0

Re: Errors on my pages

I'll Find out
thanks

***Do the Impossible!!
***