SQL Error

[Sam H.]

When starting the server I am getting this error message in the server. I haven't gotten this error before and don't really know what to do about it. If anyone has any ideas I'd appreciate it.

 

[ FivePD ] Successfully connected to the Database

[ FivePD ] An error has occured: Could not load the departments from the database. Message: System.IndexOutOfRangeException: Could not find specified column in results: rankNumber

at MySql.Data.MySqlClient.ResultSet.GetOrdinal (System.String name) [0x0001d] in <c17c8d07cfd740ad931906166ef04bff>:0

at MySql.Data.MySqlClient.MySqlDataReader.GetOrdinal (System.String name) [0x00026] in <c17c8d07cfd740ad931906166ef04bff>:0

at MySql.Data.MySqlClient.MySqlDataReader.get_Item (System.String name) [0x00000] in <c17c8d07cfd740ad931906166ef04bff>:0

at Ul29xmGv62Xl120Qs�㡋䉻䞞㻵㚂䔥㩇䮄䀍䪰㯖㘥㍏㱾㯺㳖謁㡩䞞䗾�䳄⍾洛㭔㎉䋽䪩.Ul29xmGv62Xl120Qs䙣ﬕ㐈�㨬�䳢⟾�ｽｷ䤔⌲䝛䫁ピ㣧㔭䈌㬸יִ㣀䓾�㼁㋋㾂䀖 (MySql.Data.MySqlClient.MySqlDataReader ⥱) [0x00046] in <7c24277f2e8541eb98eb92237322d466>:0

at Ul29xmGv62Xl120Qs�㡋䉻䞞㻵㚂䔥㩇䮄䀍䪰㯖㘥㍏㱾㯺㳖謁㡩䞞䗾�䳄⍾洛㭔㎉䋽䪩.Ul29xmGv62Xl120Qs䙣ﬕ㐈�㨬�䳢⟾�ｽｷ䤔⌲䝛䫁ピ㣧㔭䈌㬸יִ㣀䓾�㼁㋋㾂䀗 (System.Int32 ⥲) [0x00053] in <7c24277f2e8541eb98eb92237322d466>:0

[ FivePD ] Los Santos Police Department has been loaded

[ FivePD ] An error has occured: Could not load the departments from the database. Message: System.IndexOutOfRangeException: Could not find specified column in results: rankNumber

at MySql.Data.MySqlClient.MySqlDataReader.GetOrdinal (System.String name) [0x00026] in <c17c8d07cfd740ad931906166ef04bff>:0

at MySql.Data.MySqlClient.MySqlDataReader.get_Item (System.String name) [0x00000] in <c17c8d07cfd740ad931906166ef04bff>:0

at Ul29xmGv62Xl120Qs�㡋䉻䞞㻵㚂䔥㩇䮄䀍䪰㯖㘥㍏㱾㯺㳖謁㡩䞞䗾�䳄⍾洛㭔㎉䋽䪩.Ul29xmGv62Xl120Qs䙣ﬕ㐈�㨬�䳢⟾�ｽｷ䤔⌲䝛䫁ピ㣧㔭䈌㬸יִ㣀䓾�㼁㋋㾂䀖 (MySql.Data.MySqlClient.MySqlDataReader ⥱) [0x00046] in <7c24277f2e8541eb98eb92237322d466>:0

at Ul29xmGv62Xl120Qs�㡋䉻䞞㻵㚂䔥㩇䮄䀍䪰㯖㘥㍏㱾㯺㳖謁㡩䞞䗾�䳄⍾洛㭔㎉䋽䪩.Ul29xmGv62Xl120Qs䙣ﬕ㐈�㨬�䳢⟾�ｽｷ䤔⌲䝛䫁ピ㣧㔭䈌㬸יִ㣀䓾�㼁㋋㾂䀗 (System.Int32 ⥲) [0x00053] in <7c24277f2e8541eb98eb92237322d466>:0

[ FivePD ] Blaine County Sheriffs Office has been loaded

[ FivePD ] An error has occured: Could not load the departments from the database. Message: System.IndexOutOfRangeException: Could not find specified column in results: rankNumber

at MySql.Data.MySqlClient.ResultSet.GetOrdinal (System.String name) [0x0001d] in <c17c8d07cfd740ad931906166ef04bff>:0

at MySql.Data.MySqlClient.MySqlDataReader.GetOrdinal (System.String name) [0x00026] in <c17c8d07cfd740ad931906166ef04bff>:0

at MySql.Data.MySqlClient.MySqlDataReader.get_Item (System.String name) [0x00000] in <c17c8d07cfd740ad931906166ef04bff>:0

at Ul29xmGv62Xl120Qs�㡋䉻䞞㻵㚂䔥㩇䮄䀍䪰㯖㘥㍏㱾㯺㳖謁㡩䞞䗾�䳄⍾洛㭔㎉䋽䪩.Ul29xmGv62Xl120Qs䙣ﬕ㐈�㨬�䳢⟾�ｽｷ䤔⌲䝛䫁ピ㣧㔭䈌㬸יִ㣀䓾�㼁㋋㾂䀖 (MySql.Data.MySqlClient.MySqlDataReader ⥱) [0x00046] in <7c24277f2e8541eb98eb92237322d466>:0

at Ul29xmGv62Xl120Qs�㡋䉻䞞㻵㚂䔥㩇䮄䀍䪰㯖㘥㍏㱾㯺㳖謁㡩䞞䗾�䳄⍾洛㭔㎉䋽䪩.Ul29xmGv62Xl120Qs䙣ﬕ㐈�㨬�䳢⟾�ｽｷ䤔⌲䝛䫁ピ㣧㔭䈌㬸יִ㣀䓾�㼁㋋㾂䀗 (System.Int32 ⥲) [0x00053] in <7c24277f2e8541eb98eb92237322d466>:0

[ FivePD ] San Andreas State Police has been loaded

[TheCipher01]

2 minutes ago, Sam H. said:

Your mysql user doesnt have permissions to modify the table.

[Smanbg]

If you have installed the most recent hotfixes, also make sure to execute the MySql commands displayed at the bottom of the 1.1.2 release newsletter.

 

 

[Sam H.]

When I execute the last command it gives an sql error. I cannot copy it because it just auto closes

[Smanbg]

Does it specify what kind of error?

[Sam H.]

[Sam H.]

Well that's awkward isn't it lol. Thanks

[TheCipher01]

This content has been locked by the Community Team. If you feel this was a mistake, please report this reply with a valid reason.