Loading Page Errors

[zbdude]

I have started getting error on my loading page. When people first go to my home page they get the page correctly. But when they try to link to another page they get the following errors. I have edited my sql db cache from blob to medblob and then to longblog but it has made no difference.
I have searched the tutorials and found nothing on this subject at all, I know that it is there but I just cannot find it

Is there a max number of products that you can load into the store/site?

Thanks

Norman

ERRORS RECIEVED:

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




================================================================================ =================

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

[zbdude]

Do I need to move all of my files individually up one directory?
I tried to move the whole site up once and that did not work.

Also, I know some people will think that I need to upgrade. Well I tried that twice and lost everything. I just had a very hard time making that upgrade.

norman

[Ajeh]

What version of Zen Cart are you running?

Did your hosting company recently upgrade the server?

[zbdude]

Thanks for the response



I am using version 1.3.7.1

My server did not change versions recently.
mysql version : MySQL 5.0.51


Thanks

Norman

[DrByte]

http://www.zen-cart.com/forum/showpo...57&postcount=3

[zbdude]

Hey DrByte,
Thanks for the response. I did try that earlier and it did not work.

Thanks, Any other suggestions will be greatly appreciated

Norman
aka zbdude