Хелп! ошибка бд, при поиске фразы

03-02-2008, 08:35 AM

Invalid SQL:

SELECT IF (pcustom.fieldname IS NOT NULL, pcustom.fieldname, pmaster.fieldname) AS fieldname,
IF (pcustom.varname IS NOT NULL, pcustom.varname, pmaster.varname) AS varname,
IF (pcustom.languageid IS NOT NULL, pcustom.languageid, pmaster.languageid) AS languageid,
IF (pcustom.text IS NOT NULL, pcustom.text, pmaster.text) AS text,
language.title
FROM phrase AS pmaster
LEFT JOIN phrase AS pcustom ON (pcustom.languageid = 2 AND pcustom.varname = pmaster.varname)
LEFT JOIN language AS language ON (pcustom.languageid = language.languageid)
WHERE pmaster.languageid IN (-1, 0)

AND pmaster.product = 'vbulletin'
HAVING (text = '$vboptions[simpleversion]' OR varname = '$vboptions[simpleversion]'
ORDER BY languageid DESC, fieldname DESC;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY languageid DESC, fieldname DESC' at line 13
Error Number : 1064
Date : Saturday, March 1st 2008 @ 10:28:50 PM

03-02-2008, 09:49 AM

Скобка незакрыта. Какая версия? Обновись до последней.