SQL Error

[RoninS14]

I know its a fairly common error but does anyone have any experience dealing with this one is particular? I am more concerned with the second part of the error. Does any of the code look wrong?

 

2013 - Lost connection to MySQL server during query

 

select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '21') and tr.tax_class_id = '1' group by tr.tax_priority

 

[TEP STOP]

[♥Vger]

Which version of osCommerce is giving you that error, and in which file is it being generated?

 

Vger

[RoninS14]

It happens when the customer is in the shopping cart and presses "Checkout". I believe the file being called is "checkout_shipping.php".

 

I was using OSc MS2.2 when it started giving me this error. I recently patched it to "patch060817vs2003".

[RoninS14]

Here's my server info if it helps:

 

Server OS: Linux 2.4.7-10smp Database: MySQL 3.23.53a

Server Date: 02/04/2008 15:25:14 Datebase Date: 02/04/2008 15:25:13

Server Up Time: 3:25pm up 38 days, 7:17, 0 users, load average: 2.05, 3.89, 4.59

HTTP Server: Apache/1.3.33 (Unix) PHP/4.3.10 mod_ssl/2.8.22 OpenSSL/0.9.7e

PHP Version: 4.3.10 (Zend: 1.3.0)

[RoninS14]

I am currently trying to get my web host to upgrade the mysql version and php version. I was told that it could be an issue

[RoninS14]

I don't get it. I can receive orders from Japan just fine, but anytime I try running the order from a local IP, I get that SQL error.

[RoninS14]

I can PM you my site address if any of you want to take a look at it. Maybe you'll know what's going on.