MYSQL Error Items/shop

[Julian_Brueckner]

i have a problem i setup my server with the ESX files and when i start the server i got this error:

[ERROR] [MySQL] An critical error happens on MySQL for query “SELECT * FROM shops LEFT JOIN items ON items.name = shops.item {=}”: An item with the same key has already been added. Key: id at System.Collections.Generic.Dictionary2[TKey,TValue].TryInsert (TKey key, TValue value, System.Collections.Generic.InsertionBehavior behavior) [0x0015a] in <fbc4ec45371543bfba3678ebb82caf6d>:0 at System.Collections.Generic.Dictionary2[TKey,TValue].Add (TKey key, TValue value) [0x00000] in :0
at MySQLAsync.FetchAll.ReaderAsync (MySql.Data.MySqlClient.MySqlCommand command) [0x000e9] in <6b79789832b34a31961dbb39358e1b3f>:0
at MySQLAsync.Operation1[TResult].ExecuteAsync (System.String query, System.Collections.Generic.IDictionary2[TKey,TValue] parameters, CitizenFX.Core.CallbackDelegate callback, System.Boolean debug) [0x00169] in <6b79789832b34a31961dbb39358e1b3f>:100:

i dont found a sullution t ofix it and i have the newest version for all.

Please help me

[system]

Hello, this is a friendly reminder because this is your first time creating a topic (or it has been a while since your last topic) in this category.

Please note that most of the support is provided by the FiveM community on a voluntary basis. We ask you to be patient; there is no guarantee we have a solution to your problem(s). To avoid unnecessary/duplicate topics, please browse the forums before creating a topic.

To improve your chances of your issue(s) being solved, please provide as much information as possible about the issue(s) you are having. Also —whenever possible— please use the template given to you when creating a topic.

Thanks for keeping these forums tidy!

[kheire007]

@Julian_Brueckner

SELECT * FROM shops LEFT JOIN items ON items.name = shops.item {=}”: An item with the same key has already been added. Key:

first answer here
SELECT * FROM shops LEFT JOIN items ON items.name = shops.item {=}”: An item with the same key has already been added. Key: “check your bbd items shop”

[Julian_Brueckner]

Sry im new in programming.

what do i have to do?