vBulletin Database Error!

[snakes1100]

The actual reason you get the Illegal mix of collations is that your column doesnt support the collation they are trying to use, its not from an injection, but a simple change in the column would fix the issue.

Its simply a "incompatible collation" between the two.

You can leave the table as it is, or set the column to support both collations.

Originally Posted by gamerzhut

Hey, i am keep getting these emails from my forum.

Can any one help me fix this??

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT userid, usergroupid, membergroupids, infractiongroupids, username, password, salt FROM user WHERE username = '`` : http://www.timberlandjpshoes.com/ \r\n``\r\n`\r\n``\r\n``\r\n`\r\n``\r\n?ƥ????Щ`?????ɥ֩`??\r\n?ƥ????Щ`?????ɤ?ѥ\r\n?ƥ????Щ`?????ɥ????`????????\r\n?ƥ????Щ`?????ɥ֩`?? : http://www.timberlandjpshoes.com/\r\n  : http://www.jpguccicheap.com/  `  `   `    `    `  `   `     `  \r\n   : http://www.jpguccicheap.com/   : http://www.jpguccicheap.com/   : http://www.jpguccicheap.com/\r\n???å? ???? : http://www.jpguccicheap.com/ ???å? ?????????`?Хå? ???å? ?????????`?Хå? ???å? ???? ???ߥ? ???å? ?ȩ`?ȥХå? ???å? ???? ???ߥ? ???å? ?Хå? ???å? ?????????`?Хå? ???å? ???? ???å? ???? ???å? ?????????`?Хå? ???å? ?????????`?Хå? ???å? ???? ???ߥ? ???å? ?ȩ`?ȥХå? ???å? ???? ???ߥ? ???å? ?Хå? ???å? ???? ???å? ?????????`?Хå? ???å? ???? \r\n???å? ???? ???ߥ? : http://www.jpguccicheap.com/ ???å? ???? : http://www.jpguccicheap.com/ ???å? ???? : http://www.jpguccicheap.com/\r\n\r\n : http://www.jppradahandbags.com/\r\n \r\n \r\n \r\n \r\n \r\n \r\n?ץ????Хå? \r\n?ץ????????饤???????饤?? \r\n?ץ????ϥ??ɥХå? \r\n?ץ????ΥХå? \r\n?ץ????????ȥ??å? \r\n?ץ????Хå? \r\n?ץ????Хå? : http://www.jppradahandbags.com/\r\n\r\n?????????`???????? : http://www.monclershopjajapan.com/ ???????????Хå? : http://www.longchampjapapan.com/\r\n?????????`???????? ?????????`?른?㥱?å? ?????????`?뼤?? ???????????Хå? ???????????ȩ`?? ???????????????ȥ??å?\r\n` ` `  ` \r\n` : http://www.monclershopjajapan.com/  : http://www.longchampjapapan.com/';

MySQL Error   : Illegal mix of collations (cp1257_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
Error Number  : 1267
Request Date  : Friday, November 2nd 2012 @ 09:43:18 PM
Error Date    : Friday, November 2nd 2012 @ 09:43:18 PM
Script        : xxxxxxxxxxxxxxxxx/forums/login.php?do=login
Referrer      : xxxxxxxxxxxxxxxxxx/forums/register.php