# Common Issues

<details>

<summary>Ilegal mix of collations</summary>

<figure><img src="https://3808595786-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWtp2CzACAMvuPWbeJ3cy%2Fuploads%2Fl6JLuyCnhOx6cbuff5RE%2Fimage.png?alt=media&#x26;token=109ae403-7a5d-4995-b33f-1885445fa2cd" alt=""><figcaption><p>Example of Error</p></figcaption></figure>

{% hint style="info" %}
Works for every script with this error
{% endhint %}

### 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

<img src="https://3808595786-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWtp2CzACAMvuPWbeJ3cy%2Fuploads%2FrxukxW2NPjv6OamSV4He%2Fimage.png?alt=media&#x26;token=aed54955-3887-4d43-af3e-69882842245c" alt="" data-size="original">

4. Scroll to `Collation` Section on **Bottom** of `Operations` Page
5. Select `utf8mb4_unicode_ci` from Dropdown List - Make sure to check 2 checkboxes and click `Go`

<figure><img src="https://3808595786-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWtp2CzACAMvuPWbeJ3cy%2Fuploads%2FO04WbfuAbZdtKyOPBJh2%2Fimage.png?alt=media&#x26;token=ae28ea1d-d6da-437c-9e0f-4dc79f8269c9" alt=""><figcaption><p>Example</p></figcaption></figure>

{% hint style="danger" %}
\[QB] Cannot change column 'citizenid': used in a foreign key constraint 'fk\_citizenid' of table 'database\_name.player\_groups'
{% endhint %}

Solution for this Error

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

<div align="left"><figure><img src="https://3808595786-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWtp2CzACAMvuPWbeJ3cy%2Fuploads%2F21dghBff3JiiFxE7AL0g%2Fimage.png?alt=media&#x26;token=ea92f3e2-d0e5-498f-9aaa-3341bb23cffa" alt=""><figcaption><p>Example</p></figcaption></figure></div>

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

<div align="left"><figure><img src="https://3808595786-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWtp2CzACAMvuPWbeJ3cy%2Fuploads%2FoBMnTqhSPzJWXeUXuWuG%2Fimage.png?alt=media&#x26;token=29382c6c-755d-4c14-825b-1d67a9536e1c" alt=""><figcaption><p>Example</p></figcaption></figure></div>

### 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`

<figure><img src="https://3808595786-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWtp2CzACAMvuPWbeJ3cy%2Fuploads%2F2ErjFZcc5slYbzVmJVbE%2Fimage.png?alt=media&#x26;token=4296e1d8-2bca-4d64-8d3b-897f4e2183ce" alt=""><figcaption><p>Example of Error</p></figcaption></figure>

2. 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.

<figure><img src="https://3808595786-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWtp2CzACAMvuPWbeJ3cy%2Fuploads%2FWjbHQ3Wpkll9rMI0iU6R%2Fimage.png?alt=media&#x26;token=06e558fe-d563-4dd0-a28d-ceb017cb4af7" alt=""><figcaption></figcaption></figure>

</details>

<details>

<summary>GPT won't open</summary>

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.

</details>
