MySQL Forums
Forum List  »  Quality Assurance

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


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 ( = 'com_content' OR a.parent_id=0)
GROUP BY, b.rules, b.lft
ORDER BY b.lft

But if I remove = '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? :-)

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

Written By
Re: Failure after upgrading Ubuntu to 12.04
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.