MySQL Forums
Forum List  »  Quality Assurance

Re: Failure after upgrading Ubuntu to 12.04
Posted by: Sergey Markov
Date: May 23, 2012 11:20PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Failure after upgrading Ubuntu to 12.04
1097
May 23, 2012 11:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.