⚠️Common Issues

Ilegal mix of collations

Example of Error

Works for every script with this error

Solution for PhpMyAdmin

1. Open your PhpMyAdmin Panel

2. Select Database which u are using for your FiveM Server in Panel on Left Side

3. Click Operations Section on Top of Panel

1. Scroll to Collation Section on Bottom of Operations Page

2. Select utf8mb4_unicode_ci from Dropdown List - Make sure to check 2 checkboxes and click Go

Example

Cannot change column 'citizenid': used in a foreign key constraint 'fk_citizenid' of table 'database_name.player_groups'

Solution for this Error

1. Go to player_groups table - Open Structure Page and Select Relation view

Example

1. Click Drop on fk_citizenid key and Change Collation again :)

Example

Solution for HeidiSQL

1. Open your database and find tables from error in your server console - in my example it will be players and doj_citizen_profiles

Example of Error

1. Go to first table [in my example it will be players] and check collation of every column. Collation should be the same in every column and in both tables. If they are different, double click on it and change. Do the same with second table.