форум vBSupport.ru > vBulletin > Вопрос — Ответ
  • »
VBsupport перешел с домена .ORG на родной .RU Ура! Пожалуйста, обновите свои закладки - VBsupport.ru
 
 
 
 
Naymen
Гость
Default Хелп! ошибка бд, при поиске фразы

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


Bot
Yandex Bot Yandex Bot is online now
 
Join Date: 05.05.2005
Реклама на форуме А что у нас тут интересного? =)
 
 
g0rn
Гуру
Default
0

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


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off




All times are GMT +4. The time now is 04:57 PM.


Powered by vBulletin® Version 3.5.7
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Loading...