Datenbankfehler in vBulletin 4.2.5:
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 language AS language
INNER JOIN phrase AS pmaster ON
(pmaster.languageid IN (-1, 0))
LEFT JOIN phrase AS pcustom ON
(pcustom.languageid = language.languageid AND pcustom.varname = pmaster.varname AND pcustom.fieldname = pmaster.fieldname)
WHERE 1=1
HAVING text LIKE '%größte%'
ORDER BY languageid DESC, fieldname DESC;
MySQL-Fehler : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'
Fehler-Nr. : 1267
Fehler-Zeit : Friday, 12.10.2018 @ 17:23:25
Datum : Friday, 12.10.2018 @ 17:23:26
Skript :
http://www.xxx/forum/admincp/phrase.php?do=dosearch
Referrer :
https://www.xxx/forum/admincp/phrase.php?do=search
IP-Adresse : 92.218.233.16
Benutzername : Marius
Klassenname : vB_Database_MySQLi
MySQL-Version : 10.1.26-MariaDB-0+deb9u1
Lesezeichen