mariovaldez.net

Hi!

I don't know whether this is a bug or error or maybe I am doing something wrong, but processing the product cannot be done...
There's a requester prompting:
"An error occured while processing the database query.
SQL Error: Lost connection to MySQL server during query"
The MySQL version on the server is 4.0.20, so it should be supported, while the program uses mysql-4.0 protocol in "Configuration"...
This is weird, while i.e. renaming the category works fine, I can download the product list, view a product and even almost change its image: "Delete image", "Select image", "Download image" look fine but accepting the changes result in an error as above...
There's another thing - the product description window is a bit too small - the buttons are cut in the half, increasing the window size by 15 pixels both width and height should work.

Log printout:

--- CUT ---
products_description.products_url, products.products_image, specials.specials_new_products_price, products_description.language_id, products.products_tax_class_id, products_description.products_viewed, DATE_FORMAT(products.products_date_available, "%Y-%m-%d %H:%i:%S"), DATE_FORMAT(products.products_date_added, "%Y-%m-%d %H:%i:%S"), DATE_FORMAT(products.products_last_modified, "%Y-%m-%d %H:%i:%S") from products, products_description, products_to_categories left join specials ON products.products_id = specials.products_id where products.products_id=products_description.products_id and products_to_categories.products_id=products.products_id and products_to_categories.categories_id=107 order by products_description.products_name
2004-09-17 10:07:05:100|Ready... set...
2004-09-17 10:07:05:100|Go!
2004-09-17 10:07:05:370|Done!
2004-09-17 10:07:16:690|Executing query of type 2: update products set products_status=0 where products_id=10393
2004-09-17 10:07:16:690|Ready... set...
2004-09-17 10:07:16:740|Go!
2004-09-17 10:07:16:740|ERROR! : SQL Error: Lost connection to MySQL server during query
2004-09-17 10:07:17:570|Executing query of type 0: select products.products_id, products.products_quantity, products.products_model, products.products_price, products.products_weight, products.manufacturers_id, products_description.products_name, products.products_status, products_description.products_description, products_description.products_url, products.products_image, specials.specials_new_products_price, products_description.language_id, products.products_tax_class_id, products_description.products_viewed,
--- CUT ---

Thanks in advance for an answer

my email:
m0dy@o2.pl

m0dy:

> There's a requester prompting: "An error
> occured while processing the database query.
> SQL Error: Lost connection to MySQL server
> during query" The MySQL version on the server
> is 4.0.20...

I'm checking this out, I'll try to reproduce it.
Send me or post any information you think can be usefull (about your connection, if you have tested with other computers or other servers or other protocol versions, if it happens always or not, Windows version, etc).

Regards,

Mario A. Valdez-Ramirez.

> I'm checking this out, I'll try to reproduce it.

There's a really weird thing:
I've just discovered that if the operation is done really fast (like deleting an image in 2 seconds) then it works. And what does the DB connection timeout mean?

> Send me or post any information you think can be usefull (about your
> connection, if you have tested with other computers or other servers or
> other protocol versions, if it happens always or not, Windows version,
> etc).

The connection is 1Mbps asynchronical DSL (256kbps upload), splitted, resulting in an average download speed of ~30 KB/s. The Windows 98 version is 4.10.2222A. I haven't tested it yet with other computers nor servers, but am going to do that as soon as possible.

Possible-bug-update:

The same thing as above happens when using win XP.
Maybe it's some incompatibility with the version of MySQL server,
looks like it's losing connection with the server in a few seconds after
double-clicking on the product. And as above: updating it really fast does work.

m0dy:

> ...Maybe it's some incompatibility
> with the version of MySQL server...

I've thought about that. Please try the protocol version (in the Configuration window) to mysql-3.20 and mysql-3.23.

Regards,

Mario A. Valdez-Ramirez.