Upgraded to 11.04, where mysql version changed to 5.1.54. Works for now.
Perhaps you should consider upgrading mysql server in maverick
repositories. I think this is quite a nasty bug. It had been affecting
me and my application for months and took quite a few days to track
down.
mysql> select version();
+-----------------+
| version() |
+-----------------+
| 5.1.54-1ubuntu4 |
+-----------------+
1 row in set (0.00 sec)
mysql> SELECT `units`.* FROM `units` INNER JOIN `units_users` ON `units`.id =
`units_users`.unit_id WHERE (`units`.`id` = 72) AND ((`units_users`.user_id =
22)) LIMIT 1;
+----+------------+-------------------+------------+-------+------+-------+------+----------+--------------------+---------------------+---------------------+---------------------+----------------+--------------+------+
| id | company_id | name | address_id | phone | fax | email | www
| valid_to | created_by_user_id | modified_by_user_id | created_at |
updated_at | receipt_number | lock_version | type |
+----+------------+-------------------+------------+-------+------+-------+------+----------+--------------------+---------------------+---------------------+---------------------+----------------+--------------+------+
| 72 | 22 | Company 1 | NULL | | | | | NULL
| NULL | NULL | 2009-11-03 07:45:55 |
2010-08-25 20:32:29 | 69760 | 21722 | NULL |
+----+------------+-------------------+------------+-------+------+-------+------+----------+--------------------+---------------------+---------------------+---------------------+----------------+--------------+------+
1 row in set (0.00 sec)
mysql>
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/706988
Title:
Major Bug in MySQL 5.1.49 up to 5.1.52
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
