PDA

View Full Version : vBulletin Database Error!


gamerzhut
11-06-2012, 03:54 PM
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`` (http://www.timberlandjpshoes.com/)\r\n` (http://www.timberlandjpshoes.com/)\r\n`` (http://www.timberlandjpshoes.com/)\r\n`` (http://www.timberlandjpshoes.com/)\r\n` (http://www.timberlandjpshoes.com/)\r\n`` (http://www.timberlandjpshoes.com/)\r\n?ƥ????Щ`?????ɥ֩`?? (http://www.timberlandjpshoes.com/)\r\n?ƥ????Щ`?????ɤ?ѥ (http://www.timberlandjpshoes.com/)\r\n?ƥ????Щ`?????ɥ????`???????? (http://www.timberlandjpshoes.com/)\r\n?ƥ????Щ`?????ɥ֩`?? : http://www.timberlandjpshoes.com/\r\n : http://www.jpguccicheap.com/ ` (http://www.jpguccicheap.com/) ` (http://www.jpguccicheap.com/) ` (http://www.jpguccicheap.com/) ` (http://www.jpguccicheap.com/) ` (http://www.jpguccicheap.com/) ` (http://www.jpguccicheap.com/) ` (http://www.jpguccicheap.com/) ` (http://www.jpguccicheap.com/) \r\n : http://www.jpguccicheap.com/ : http://www.jpguccicheap.com/ : http://www.jpguccicheap.com/\r\n???å? ???? : http://www.jpguccicheap.com/ ???å? ?????????`?Хå? (http://www.jpguccicheap.com/) ???å? ?????????`?Хå? (http://www.jpguccicheap.com/) ???å? ???? ???ߥ? (http://www.jpguccicheap.com/) ???å? ?ȩ`?ȥХå? (http://www.jpguccicheap.com/) ???å? ???? ???ߥ? (http://www.jpguccicheap.com/) ???å? ?Хå? (http://www.jpguccicheap.com/) ???å? ?????????`?Хå? (http://www.jpguccicheap.com/) ???å? ???? (http://www.jpguccicheap.com/) ???å? ???? (http://www.jpguccicheap.com/) ???å? ?????????`?Хå? (http://www.jpguccicheap.com/) ???å? ?????????`?Хå? (http://www.jpguccicheap.com/) ???å? ???? ???ߥ? (http://www.jpguccicheap.com/) ???å? ?ȩ`?ȥХå? (http://www.jpguccicheap.com/) ???å? ???? ???ߥ? (http://www.jpguccicheap.com/) ???å? ?Хå? (http://www.jpguccicheap.com/) ???å? ???? (http://www.jpguccicheap.com/) ???å? ?????????`?Хå? (http://www.jpguccicheap.com/) ???å? ???? (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?ץ????Хå? (http://www.jppradahandbags.com/) \r\n?ץ????????饤???????饤?? (http://www.jppradahandbags.com/) \r\n?ץ????ϥ??ɥХå? (http://www.jppradahandbags.com/) \r\n?ץ????ΥХå? (http://www.jppradahandbags.com/) \r\n?ץ????????ȥ??å? (http://www.jppradahandbags.com/) \r\n?ץ????Хå? (http://www.jppradahandbags.com/) \r\n?ץ????Хå? : http://www.jppradahandbags.com/\r\n\r\n?????????`???????? : http://www.monclershopjajapan.com/ ???????????Хå? : http://www.longchampjapapan.com/\r\n?????????`???????? (http://www.monclershopjajapan.com/) ?????????`?른?㥱?å? (http://www.monclershopjajapan.com/) ?????????`?뼤?? (http://www.monclershopjajapan.com/) ???????????Хå? (http://www.longchampjapapan.com/) ???????????ȩ`?? (http://www.longchampjapapan.com/) ???????????????ȥ??å? (http://www.longchampjapapan.com/)\r\n` (http://www.monclershopjajapan.com/) ` (http://www.monclershopjajapan.com/) ` (http://www.monclershopjajapan.com/) ` (http://www.longchampjapapan.com/) \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

In Omnibus
11-06-2012, 04:53 PM
You'll receive those e-mails when a bot attempts to inject code into your forums. If you look carefully you'll notice that the attempt to register and login is from a bot trying to inject URL links to Timberland shoes and Gucci and Prada handbags. My guess is these are not accurate descriptions of the links and they are probably some form of malware. Don't visit the links. And don;t worry about getting e-mailed. You want to know, especially if one of these happens to actually damage your forums.

snakes1100
11-06-2012, 10:55 PM
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.

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`` (http://www.timberlandjpshoes.com/)\r\n` (http://www.timberlandjpshoes.com/)\r\n`` (http://www.timberlandjpshoes.com/)\r\n`` (http://www.timberlandjpshoes.com/)\r\n` (http://www.timberlandjpshoes.com/)\r\n`` (http://www.timberlandjpshoes.com/)\r\n?ƥ????Щ`?????ɥ֩`?? (http://www.timberlandjpshoes.com/)\r\n?ƥ????Щ`?????ɤ?ѥ (http://www.timberlandjpshoes.com/)\r\n?ƥ????Щ`?????ɥ????`???????? (http://www.timberlandjpshoes.com/)\r\n?ƥ????Щ`?????ɥ֩`?? : http://www.timberlandjpshoes.com/\r\n : http://www.jpguccicheap.com/ ` (http://www.jpguccicheap.com/) ` (http://www.jpguccicheap.com/) ` (http://www.jpguccicheap.com/) ` (http://www.jpguccicheap.com/) ` (http://www.jpguccicheap.com/) ` (http://www.jpguccicheap.com/) ` (http://www.jpguccicheap.com/) ` (http://www.jpguccicheap.com/) \r\n : http://www.jpguccicheap.com/ : http://www.jpguccicheap.com/ : http://www.jpguccicheap.com/\r\n???å? ???? : http://www.jpguccicheap.com/ ???å? ?????????`?Хå? (http://www.jpguccicheap.com/) ???å? ?????????`?Хå? (http://www.jpguccicheap.com/) ???å? ???? ???ߥ? (http://www.jpguccicheap.com/) ???å? ?ȩ`?ȥХå? (http://www.jpguccicheap.com/) ???å? ???? ???ߥ? (http://www.jpguccicheap.com/) ???å? ?Хå? (http://www.jpguccicheap.com/) ???å? ?????????`?Хå? (http://www.jpguccicheap.com/) ???å? ???? (http://www.jpguccicheap.com/) ???å? ???? (http://www.jpguccicheap.com/) ???å? ?????????`?Хå? (http://www.jpguccicheap.com/) ???å? ?????????`?Хå? (http://www.jpguccicheap.com/) ???å? ???? ???ߥ? (http://www.jpguccicheap.com/) ???å? ?ȩ`?ȥХå? (http://www.jpguccicheap.com/) ???å? ???? ???ߥ? (http://www.jpguccicheap.com/) ???å? ?Хå? (http://www.jpguccicheap.com/) ???å? ???? (http://www.jpguccicheap.com/) ???å? ?????????`?Хå? (http://www.jpguccicheap.com/) ???å? ???? (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?ץ????Хå? (http://www.jppradahandbags.com/) \r\n?ץ????????饤???????饤?? (http://www.jppradahandbags.com/) \r\n?ץ????ϥ??ɥХå? (http://www.jppradahandbags.com/) \r\n?ץ????ΥХå? (http://www.jppradahandbags.com/) \r\n?ץ????????ȥ??å? (http://www.jppradahandbags.com/) \r\n?ץ????Хå? (http://www.jppradahandbags.com/) \r\n?ץ????Хå? : http://www.jppradahandbags.com/\r\n\r\n?????????`???????? : http://www.monclershopjajapan.com/ ???????????Хå? : http://www.longchampjapapan.com/\r\n?????????`???????? (http://www.monclershopjajapan.com/) ?????????`?른?㥱?å? (http://www.monclershopjajapan.com/) ?????????`?뼤?? (http://www.monclershopjajapan.com/) ???????????Хå? (http://www.longchampjapapan.com/) ???????????ȩ`?? (http://www.longchampjapapan.com/) ???????????????ȥ??å? (http://www.longchampjapapan.com/)\r\n` (http://www.monclershopjajapan.com/) ` (http://www.monclershopjajapan.com/) ` (http://www.monclershopjajapan.com/) ` (http://www.longchampjapapan.com/) \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