Can't add product to Catalog

[sormui]

When I click "insert" to add a new product, I keep getting the following SQL error, any idea? MySQL and database are in localhost. MySQL is 5.0 and OC is 2.2.

 

2013 - Lost connection to MySQL server during query

 

insert into products (products_quantity, products_model, products_price, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_image, products_date_added) values ('5', '', '6', null, '3', '1', '0', '0', 'R1102.jpg', now())

 

[TEP STOP]

 

2006 - MySQL server has gone away

 

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

 

[TEP STOP]

 

 

Thanks in advance!!

 

PS. When I add a new category, it works, I only have problems with products.

[sormui]

When I click "insert" to add a new product, I keep getting the following SQL error, any idea? MySQL and database are in localhost. MySQL is 5.0 and OC is 2.2.

 

2013 - Lost connection to MySQL server during query

 

insert into products (products_quantity, products_model, products_price, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_image, products_date_added) values ('5', '', '6', null, '3', '1', '0', '0', 'R1102.jpg', now())

 

[TEP STOP]

 

2006 - MySQL server has gone away

 

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

 

[TEP STOP]

 

 

Thanks in advance!!

 

PS. When I add a new category, it works, I only have problems with products.

Can anyone help please? I'm so frustrated .....

[sormui]

Can anyone help please? I'm so frustrated .....

Please help ......

[BryceJr]

You can find here what's causing your "Lost Connection"

 

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

 

It seems increasing packet size might do the job.

 

http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html

[ejeffay]

hey there, i got a serious problem and my client has freaked on me.

 

When i go to my catalog/products section in my admin, NOTHING shows. The only thing that does show is at the top saying "Categories/Products" and the far left having its search box. Thats it!

 

Really would appreciate any help. Or direction to where i might be able to get the help, the search on this forums isn't the best, its why i haven't been able to find much after hours of searching.

[sormui]

You can find here what's causing your "Lost Connection"

 

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

 

It seems increasing packet size might do the job.

 

http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html

Thanks for your suggestions but it still doesn't work after I've increased the max_allowed_packet to 1G. It is so strange that when I add a new category, it works, I only have problems with products. Do you think if there is another configuration issue?

[sormui]

Thanks for your suggestions but it still doesn't work after I've increased the max_allowed_packet to 1G. It is so strange that when I add a new category, it works, I only have problems with products. Do you think if there is another configuration issue?

Please help ....

[sormui]

Please help ....

I have tried to uninstall and re-install MySQL but still doesn't work. Does anyone know if there is something wrong with the version/configuration issue with Apache/PHP/MySQL? Your help is appreciated.