#93 Database freezes with long query string

[Anonymous]

The query below will freeze the database server
completely, every time (version 1.60).

UPDATE halls SET skinname='Kids
Bingo',multiplewinners='0',delayforbingo=30,breaksecond
s=45,numcards=5,winnersurl=' ',winnerslog=' ',probabili
ty=0.0,greeting='Welcome to Kids
Bingo!',gamestyle='c',ballinterval=10,potstartvalue=10.
0,potincperuser=0.0,potincpergame=0.0,potvalue=10.0,per
userpot=0.0,jackpotasinteger=0,useheadlines=0,headlined
elay=45,headlineid=1,phraseuser='SYSTEM',privateallowed
=0 WHERE id=1

But if you break it down into 3 separate updates,
doing 1/3 of the above field updates at a time, there
is no freeze. So apparently there is a limit to either
the SQL query length, or the number of fields you can
update at once.

Please fix! :(

Chuck Carter
cfoc@home.com