[tanzeelniazi]

DragonByte Tech:
This means you have changed the collation of certain DB tables but not your entire database, you will need to make sure all DBTech tables and their columns have the same collation as your vB tables.

when i open my phpmyadmin i see all tables are showing same.
see My DBTECH Tables rows all is showing
dbtech_registration_action
dbtech_registration_criteria
dbtech_registration_email
dbtech_registration_field
dbtech_registration_instance
dbtech_registration_instance_action
dbtech_registration_instance_criteria
etc all is showing:latin1_swedish_ci
See Picture All dbtech_Registration same


After i check User
User is showing: latin1_general_ci
See this Picture


Now after i check Userlist showing same : latin1_general_ci
See pic


Now please tell me what i do ?
before Zachery says Change Collaction User and Uselist i see User and Userlist showing is latin1_general_ci if i change to latin1_swedish_ci can i loss anything like users etc ?
My english is not good please tell me what i do and i dont want to loose anything

--------------- Added [DATE]1402067899[/DATE] at [TIME]1402067899[/TIME] ---------------

1 more thing
dbtech_vbsecurity
dbtech_vbshout
dbtech_infopanels
dbtech_forumtabs
dbtech_vbactivity
are showing Collaction is : latin1_general_ci
but dbtech_registration is showing only Collaction is: latin1_swedish_ci ?

--------------- Added [DATE]1402073986[/DATE] at [TIME]1402073986[/TIME] ---------------

i change all dbtech_registration tables latin1_swedish_ci to latin1_general_ci
still error:

Database error in vBulletin 4.2.0:

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
		a	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  : Friday, June 6th 2014 @ 06:57:04 PM
Error Date    : Friday, June 6th 2014 @ 06:57:04 PM
Script        : http://www.************.com/registration.php?do=profile&action=invites
Referrer      : http://www.*************.com/usercp.php
IP Address    : 1********8.**5
Username      : *******r
Classname     : v*******e
MySQL Version : 5.1.73-cll