Database error in vBulletin 4.0.3:
Invalid SQL:
SELECT adminmessage.adminmessageid
FROM adminmessage AS adminmessage
INNER JOIN adminlog AS adminlog ON (adminlog.script = adminmessage.script AND adminlog.action = adminmessage.action)
WHERE adminmessage.status = 'undone'
AND adminmessage.script <> ''
AND adminlog.dateline > adminmessage.dateline
GROUP BY adminmessage.adminmessageid;
MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_cs,IMPLICIT) for operation '='
Error Number : 1267
ALTER TABLE `adminmessage` CHANGE `varname` `varname` VARCHAR( 250 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
CHANGE `script` `script` VARCHAR( 50 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
CHANGE `action` `action` VARCHAR( 20 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
CHANGE `execurl` `execurl` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
CHANGE `method` `method` ENUM( 'get', 'post' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'post',
CHANGE `status` `status` ENUM( 'undone', 'done', 'dismissed' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'undone'
Database error in vBulletin 3.8.5:
Invalid SQL:
SELECT searchid, search.userid, query, searchuser, user.userid AS targetuserid
FROM search AS search
LEFT JOIN user AS user ON (user.username = search.searchuser)
WHERE searchid IN (0,9797);
MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
ALTER TABLE `search` CHANGE `ipaddress` `ipaddress` VARCHAR(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
CHANGE `query` `query` VARCHAR(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
CHANGE `searchuser` `searchuser` VARCHAR(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
CHANGE `forumchoice` `forumchoice` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
CHANGE `prefixchoice` `prefixchoice` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
CHANGE `sortby` `sortby` VARCHAR(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
CHANGE `sortorder` `sortorder` VARCHAR(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
CHANGE `orderedids` `orderedids` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
CHANGE `announceids` `announceids` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
CHANGE `searchterms` `searchterms` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
CHANGE `displayterms` `displayterms` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
CHANGE `searchhash` `searchhash` VARCHAR( 32 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT prefix.*, prefixpermission.usergroupid AS restriction
FROM forumprefixset AS forumprefixset
INNER JOIN prefixset AS prefixset ON (prefixset.prefixsetid = forumprefixset.prefixsetid)
INNER JOIN prefix AS prefix ON (prefix.prefixsetid = prefixset.prefixsetid)
LEFT JOIN prefixpermission AS prefixpermission ON (prefix.prefixid = prefixpermission.prefixid)
WHERE forumprefixset.forumid = 15
ORDER BY prefixset.displayorder, prefix.displayorder;
MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
ALTER TABLE `prefix` CHANGE `prefixid` `prefixid` VARCHAR( 25 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
CHANGE `prefixsetid` `prefixsetid` VARCHAR( 25 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
ALTER TABLE `prefixpermission` CHANGE `prefixid` `prefixid` VARCHAR( 25 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
ALTER TABLE `prefixset` CHANGE `prefixsetid` `prefixsetid` VARCHAR( 25 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
Database error in vBulletin 4.0.2:
Invalid SQL:
SELECT plugin.*,
IF(product.productid IS NULL, 0, 1) AS foundproduct,
IF(plugin.product = 'vbulletin', 1, product.active) AS productactive
FROM plugin AS plugin
LEFT JOIN product AS product ON(product.productid = plugin.product)
WHERE plugin.active = 1
AND plugin.phpcode <> ''
ORDER BY plugin.executionorder ASC;
MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
ALTER TABLE `plugin` CHANGE `title` `title` VARCHAR( 250 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
CHANGE `hookname` `hookname` VARCHAR( 250 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
CHANGE `phpcode` `phpcode` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
CHANGE `product` `product` VARCHAR( 25 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
CHANGE `devkey` `devkey` VARCHAR( 25 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL