Category sort error.

[TRB2929]

We have an automotive based site which needs many categories for easy listings. We have been working on a new site now for 1.5 years and until recently things have been working great. In the past I have ran the category sort feature without any issues. I recently needed to run this sort and I received the following error and it messed up the category listings in general.

I?m looking for any realistic fixes be a new way to sort the categories or additional software for the categories. We currently have about 10,000 categories but must are used in the background of internal listings

website: www.ackits.com (http://www.ackits.com)

Host says it is a Miva 5 issue not a mysql issue on their part.

Runtime error in lib/db.mvc @ [00000035:0000022e]: lib/dbeng/sort.mv: Line 80: MvSKIP: mysql_stmt_fetch: Lost connection to MySQL server during query

[Vic - WolfPaw Computers]

Of course they do...

The problem is a configuration issue. Either the MIVA configuration's global timeout is not long enough, or the mysql timeout is too short.

In either case, they should be fixing it.

[TRB2929]

Of course they do...

The problem is a configuration issue. Either the MIVA configuration's global timeout is not long enough, or the mysql timeout is too short.

In either case, they should be fixing it.

Is the Miva timeout something I can change through the admin utilities? I checked around and did not see where this could be done.

[TRB2929]

Making this change is it something I can do within the Miva admin or is it a code issue which Miva needs to address? I looked around and did not see a place to change the Global timeout.