Zen Cart Logo
trapezoid-twopenny
Open navigation menu
Home Community Forum Plugins
Documentation
For Developers For Storeowners
Services Donate Get Started
Forums / General Questions / query factory error

query factory error

Locked
Results 1 to 13 of 13
This thread is locked. New replies are disabled.
19 Sep 2007, 03:23
#1
ethanolic avatar

ethanolic

New Zenner

Join Date:
Mar 2006
Posts:
42
Plugin Contributions:
0

query factory error

Hi All

Just got this error out of the blue, am using 1.2.7 version of zencart, Please help me out here.

Warning: Variable passed to each() is not an array or object in /home/twg/public_html/includes/classes/db/mysql/query_factory.php on line 100

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/twg/public_html/includes/classes/db/mysql/query_factory.php:100) in /home/twg/public_html/includes/functions/sessions.php on line 111

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/twg/public_html/includes/classes/db/mysql/query_factory.php:100) in /home/twg/public_html/includes/functions/sessions.php on line 111

Warning: main(includes/languages/.php) [function.main]: failed to open stream: No such file or directory in /home/twg/public_html/includes/application_top.php on line 355

Warning: main(includes/languages/.php) [function.main]: failed to open stream: No such file or directory in /home/twg/public_html/includes/application_top.php on line 355

Fatal error: main() [function.require]: Failed opening required 'includes/languages/.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/twg/public_html/includes/application_top.php on line 355

Any idea how to resolve this problem? your help and input greatly appreciated. Site address is www.trustytime88.com

Thanks
19 Sep 2007, 05:12
#2
twg avatar

twg

New Zenner

Join Date:
Apr 2006
Posts:
10
Plugin Contributions:
0

Re: query factory error

Urgent Help needed... Website displayed this:

Warning: Variable passed to each() is not an array or object in /home/twg/public_html/includes/classes/db/mysql/query_factory.php on line 100

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/twg/public_html/includes/classes/db/mysql/query_factory.php:100) in /home/twg/public_html/includes/functions/sessions.php on line 111
Home |


HomeBREAD_CRUMBS_SEPARATORNew Products
New Products
Sort by: Product Name Product Name - desc Price - low to high Price - high to low Model Date Added - New to Old Date Added - Old to New

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

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 '-0, MAX_DISPLAY_PRODUCTS_NEW' at line 1


**Whats the problem with the SQL or Script?????

ANDREW
19 Sep 2007, 06:04
#3
ethanolic avatar

ethanolic

New Zenner

Join Date:
Mar 2006
Posts:
42
Plugin Contributions:
0

Re: query factory error

heres a error log from cpanel , SQL database is checked to be ok

[Wed Sep 19 07:25:19 2007] [error] [client 62.13.168.67] File does not exist: /home/twg/public_html/function.main
[Wed Sep 19 07:17:39 2007] [error] [client 204.110.112.2] File does not exist: /home/twg/public_html/404.shtml
[Wed Sep 19 07:17:39 2007] [error] [client 204.110.112.2] File does not exist: /home/twg/public_html/function.session-start
[Wed Sep 19 07:17:36 2007] [error] [client 204.110.112.2] File does not exist: /home/twg/public_html/404.shtml
19 Sep 2007, 10:30
#5
ethanolic avatar

ethanolic

New Zenner

Join Date:
Mar 2006
Posts:
42
Plugin Contributions:
0

Re: query factory error

I tried the SQL patch but this time this error appears

Warning: Variable passed to each() is not an array or object in /home/twg/public_html/includes/classes/db/mysql/query_factory.php on line 100

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/twg/public_html/includes/classes/db/mysql/query_factory.php:100) in /home/twg/public_html/includes/functions/sessions.php on line 111

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 6

So i guess it did not work
The website is www.trustytime88.com/index1.php.

Any other ideas?

Warmest Regards
19 Sep 2007, 11:53
#6
twg avatar

twg

New Zenner

Join Date:
Apr 2006
Posts:
10
Plugin Contributions:
0

Re: query factory error

Seems that ethan and I have tried to disable the modules (Shipping & Payment) and also ethan ran the SQL Patch but still it is not working... Any one can help?

Thanks!

Andrew
19 Sep 2007, 16:46
#7
ethanolic avatar

ethanolic

New Zenner

Join Date:
Mar 2006
Posts:
42
Plugin Contributions:
0

Re: query factory error

can anyone answer this question? thanks
19 Sep 2007, 16:46
#8
twg avatar

twg

New Zenner

Join Date:
Apr 2006
Posts:
10
Plugin Contributions:
0

Re: query factory error

Anyone care to help? 2 lost souls trying so hard to revive the site. =P

Thanks in advance. =P
19 Sep 2007, 18:51
#9
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,506
Plugin Contributions:
173

Re: query factory error

Are you still getting the exact same error message now ?


(By the way, I've merged your two posts into one, to retain continuity of thought.)
19 Sep 2007, 19:01
#10
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,506
Plugin Contributions:
173

Re: query factory error

What addons/contributions do you have installed?
"When" does this happen?
Does it occur on every page?
When did it start? Did it start just after installing or enabling a module?
19 Sep 2007, 23:49
#11
twg avatar

twg

New Zenner

Join Date:
Apr 2006
Posts:
10
Plugin Contributions:
0

Re: query factory error

It happened when I was loading in some new products and suddenly it became like that.

Think the error was in every page. There was no modules installed at that point of time. I have also tried to uninstall all the useless Shipping and Payment Modules which was mentioned in another thread (From archives) but to no avail.. Error message still exists..

See here:

http://www.trustytime88.com/index1.php

I hope you can help me. Its been down for slightly about 25 hours now. =P

Andrew
20 Sep 2007, 00:59
#12
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,506
Plugin Contributions:
173

Re: query factory error

um ... I don't see any errors there ...
20 Sep 2007, 13:40
#13
ethanolic avatar

ethanolic

New Zenner

Join Date:
Mar 2006
Posts:
42
Plugin Contributions:
0

Re: query factory error

Our webhost found the error which is not enough diskspace . So everything is resolved.

Thanks for your help.