vb.org Archive - vBulletin Database Error!

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - vBulletin Database Error! (https://vborg.vbsupport.ru/showthread.php?t=290241)

vBulletin Database Error!

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

Can any one help me fix this??

Code:

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

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.

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.

Quote:

Originally Posted by gamerzhut (Post 2378901)

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

Can any one help me fix this??

Code:

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

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01129 seconds Memory Usage 1,761KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: