2006 - MySQL server has gone away

[samiirds]

hi,

i have just installed PayPal WPP Direct Payments & Express Checkout by dynamoeffects

 

now

 

i am getting this error

 

-------------------------------------------------------

 

2006 - MySQL server has gone away

 

insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value) values ('6', 'sam ss', 'possible', '526r e er t', 'dw', 'shertre', '21123', 'mh', 'India', '98901032323', '[email protected]', '1', 'sam ss', 'possible', '526r e er t', 'dw', 'shertre', '21123', 'mh', 'India', '1', 'sam ss', 'possible', '526r e er t', 'dw', 'shertre', '21123', 'mh', 'India', '1', 'Credit Card', 'Visa', 'sam ss', '4111XXXXXXXX1111', '0208', now(), '1', 'USD', '1.00000000')

 

[TEP STOP]

 

2006 - MySQL server has gone away

 

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

 

[TEP STOP]

 

--------------------------------------------------

 

i am using bluehost as webhost

here is my server config

 

MySQL version 5.0.27-standard-log

PHP version 5.1.6

 

 

can anyone please guide me how to rectify it?

 

-thanks

sam

Edited July 18, 2007 by samiirds

[oschellas]

In case you set:

define('USE_PCONNECT', 'true');

 

set it to false:

define('USE_PCONNECT', 'false');

 

in catalog/includes/configure.php and catalog/admin/includes/configure.php

[samiirds]

thanks for your reply

 

 

its already set to false

 

define('USE_PCONNECT', 'false');

 

i had also tried to close connection and reopen it before running the insert order query.

it did not help.

 

 

any idea?

[oschellas]

Maybe this post helps and this one for the patches ...

[chrisjako]

I had same issue so in mysql I did a repair database for all the values and it seemed to fix this problem, do a backup first before trying this!

[jcssolut]

Hello I am having a problem with my store was doing well and now it's generating the following error to give the checkout button to checkout

 

2006 - MySQL server has gone away

 

select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name

 

thanks