⚠️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

[QB] 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.

GPT won't open

To ensure your job is correctly configured, you need to verify the config.lua file of the GPT system. Follow these steps:

1. Open the config.lua file in your preferred text editor.

2. Locate the section where jobs are defined.

3. Check if your specific job is listed and configured correctly.

4. Make any necessary adjustments to ensure it aligns with your server’s requirements.

5. Save the file and restart the server to apply changes.