if i search in the phrases, i become this DB-Error:
(but only if i switch Case-Sensitive and Exact Match tof Yes)
Quote:
Datenbankfehler in vBulletin 3.6.8:
Invalid SQL:
SELECT phrase.*, language.title
FROM phrase AS phrase
LEFT JOIN language AS language USING(languageid)
WHERE BINARY (text = 'to join them.' OR BINARY varname = 'to join them.'
AND phrase.product = 'casino'
ORDER BY languageid DESC, fieldname DESC;
MySQL-Fehler : 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 7
Fehler-Nr. : 1064
Datum : Monday, November 19th 2007 @ 10:25:31 PM
Skript : http://www.xxxx.xxx/forum/admincp/ph...hp?do=dosearch
Referrer : http://www.xxxx.xxx/forum/admincp/phrase.php?do=search
IP-Adresse : 81.xxx.xxx.xxx
Benutzername : trigon
Klassenname : vB_Database_MySQLi
|
The reason is: I want to change the message "X Players are in the Casino and waiting" from english to other Languages