Lost connection to MySQL server during query

[fabriccut100]

I've double checked my install and it all seems to go through until I hit confirm checkout, it hangs way too long and then I get this error

any help or direction would be greatly appreciated

 

 

 

Your Cart Contains

2 items

Sub Total: 2013 - Lost connection to MySQL server during query

 

select products_id, products_price, products_tax_class_id, products_weight from products where products_id = '17'

 

[TEP STOP]

 

2006 - MySQL server has gone away

 

select count(*) as total from sessions where sesskey = '6045618c4e4b9e8687293fcb1d234563653e3e'

 

[TEP STOP]

 

 

Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0

[♥geoffreywalton]

A google search for

 

gave lots of results but a bit of digging gave

 

For us, the problem was resolved by our internet service provider.

I suspect it was a MySQL configuration issue since the MySQL server can disconnect if query results are too large.

 

http://www.oscommerce.com/forums/index.php?showtopic=269936

 

Check the number of records in your sessions table and purge it.