ItsikNox / FiveM-Arkadia_

French FiveM Server Edited by ikNox#6088
https://fivem.net
80 stars 284 forks source link

(gcphone) Yello Tweets error #11

Open TanguyOrtegat opened 4 years ago

TanguyOrtegat commented 4 years ago

Sometimes when ingame and looking into server console, this error happens:

[ERROR] [MySQL] An critical error happens on MySQL for query " SELECT yellow_tweets.*, users.firstname, users.phone_number FROM yellow_tweets LEFT JOIN users ON yellow_tweets.firstname = users.firstname ORDER BY time DESC LIMIT 130 {=}": An item with the same key has already been added. Key: firstname at System.Collections.Generic.Dictionary2[TKey,TValue].TryInsert (TKey key, TValue value, System.Collections.Generic.InsertionBehavior behavior) [0x0015a] in :0

at System.Collections.Generic.Dictionary`2[TKey,TValue].Add (TKey key, TValue value) [0x00000] in :0

at MySQLAsync.FetchAll.ReaderAsync (MySql.Data.MySqlClient.MySqlCommand command) [0x000e9] in <4566d747b17a449f9901d640a8efcabd>: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 <4566d747b17a449f9901d640a8efcabd>:0 ` any idea why ? or how to fix it? ( you can answer in french too)

Mariox6 commented 4 years ago

Did you added the yellow pages.sql, which is located in the gcphone directory?