Hi, regarding http://ep33.tp4.ruhr-uni-bochum.de/mlists/MySQL/May.2000/index.html#2025 , I had the same problem with MySQL 3.23.30. The following statement "Update Tree set left=left+2 where (left>$right and right>=$right);" sometimes (not reproducable) locked up MySQL completely. The "left" value in at least one row was very high (e.g. 455434), but should be e.g 56. After updating MySQL to version 3.23.37 I couldn cause this error any more. Can anybody tell me if this Bug is fixed now finally? Best regards, Manuel --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php