The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
How to change the collation Tables
When i invite Enter Email in Invite Field click submit rec error:
Code:
Invalid SQL: SELECT invite.email, invite.dateline, verified.verified, user.userid, user.username, user.usergroupid, user.infractiongroupid, user.displaygroupid, user.joindate, actionuser_friend.relationid FROM dbtech_registration_invite AS invite LEFT JOIN dbtech_registration_email AS verified ON(invite.email = verified.email) AND verified = '1' LEFT JOIN user AS user ON(verified.email = user.email) AND user.userid != 1 LEFT JOIN userlist AS actionuser_friend ON(actionuser_friend.userid = user.userid) WHERE invite.userid = 1 GROUP BY invite.email ORDER BY invite.dateline DESC LIMIT 10; MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '=' Error Number : 1267 Request Date : Wednesday, May 21st 2014 @ 12:38:36 AM Error Date : Wednesday, May 21st 2014 @ 12:38:37 AM Script : http://www.XXXXXXXXXX.com/registration.php?do=profile&action=invites Referrer : http://www.XXXXXXXXXXX.com/registration.php IP Address : 1**.1**.8.1** Username : M*****r Classname : vB*******se MySQL Version : 5.1.73-cll Quote:
Quote:
let me know your exact db table and db name and the collation format you want to keep, I will check and try to do it, Help please i think DBTech is busy i really need help |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|