Forums / General Questions / query factory error

query factory error

Locked

Started by ethanolic on 19 Sep 2007, 3:23 AM · Views: 4,208

Results 1 to 13 of 13
This thread is locked. New replies are disabled.
19 Sep 2007, 3:23 AM
#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 https://www.trustytime88.com

Thanks

19 Sep 2007, 5:12 AM
#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, 6:04 AM
#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, 8:20 AM
#4
drbyte avatar

drbyte

Sensei

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

Re: query factory error

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

19 Sep 2007, 10:30 AM
#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 https://www.trustytime88.com/index1.php.

Any other ideas?

Warmest Regards

19 Sep 2007, 11:53 AM
#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, 4:46 PM
#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, 4:46 PM
#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, 6:51 PM
#9
drbyte avatar

drbyte

Sensei

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

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

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

19 Sep 2007, 7:01 PM
#10
drbyte avatar

drbyte

Sensei

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

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?

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

19 Sep 2007, 11:49 PM
#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, 12:59 AM
#12
drbyte avatar

drbyte

Sensei

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

Re: query factory error

um ... I don't see any errors there ...

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

20 Sep 2007, 1:40 PM
#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.