Re: Failure after upgrading Ubuntu to 12.04

[Sergey Markov]

Hi!

I have a problem looks like this (Ubuntu 12.04, mysql 5.5.22). Some requests terminate mysql, etc.:
SELECT b.rules
FROM b1arf_assets AS a
LEFT JOIN b1arf_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content' OR a.parent_id=0)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft

But if I remove a.name = 'com_content'/a.parent_id=0, it works fine.

This table is from CMS Joomla and it's ~ 30 rows and 6-7 cols.

How to fix this? :-)

UPDATE:
I've changed mysql to 5.1.61. So, it works fine!



Edited 1 time(s). Last edit at 05/24/2012 01:10AM by Sergey Markov.