mysql erorr
 

hello,

i need your help guys,
i keep getting this error when registerting with arabic names,

Invalid SQL:

SELECT COUNT(userchangelog.changeid) AS change_count
FROM userchangelog AS userchangelog
LEFT JOIN user AS user ON(user.userid = userchangelog.userid)
LEFT JOIN user AS adminuser ON(adminuser.userid = userchangelog.adminid)
WHERE userchangelog.fieldname = 'username' AND change_time >= 1171263098 AND (userchangelog.oldvalue = 'الضربة القاضية' OR userchangelog.newvalue = 'الضربة القاضية');

MySQL Error : Illegal mix of collations (cp1256_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
Error Number : 1267
Date : Tuesday, February 12th 2008 @ 06:51:38 AM

any idea?

Thanks

this query is not pary of ibProArcade, for sure.

which script is named to cause this problem ?

what is ibProArcade?

i'm using vBulletin

thank you :)

You posted in the wrong area, thank you. ;)

Welcome to the ibProArcade Support Section :)

by the way, you should try ibProArcade, just check link in my signature ;)

Thank you, sir. I will do that. I can't wait to try it out. What does it do? ;)

Moved to correct forum


Ammari,

You are currently showing up as unlicensed.

To be able to download modifications and/or receive support here at vBulletin.org, we ask you to please click here (vB-Germany users click here, vB-Chinese users click here) and enter your email address. You will need to use your customer number and password (which will be in the email you got when you paid for your license) to access that page. Please note that your email is case sensitive.

To protect our customers privacy you will also need to Opt-In to license validation for all Support Sites. You must authorise vBulletin.org in order to validate your license status here. You can do this at the page linked above for your distributor. Make sure to set the permission to allow vBulletin.org to validate your status.

The update of your account can take up to one hour.

Thank you.