Jump to content
×
×
  • Create New...
  • 0

Could not load Departments from database; Index outside bounds of array


Go to solution Solved by CRUGG,
Reason for Locking
Answered

By TheCipher01, on 07/20/20 04:55 PM.

Question

Hello there,

I've just tried to set up FivePD 1.1.4 on my Linux Debian 9 VPS. I have set up a new User and Database in my MySQL Database (which works perfectly fine for other things) and tried to start the Server. When I try to start the Server, I get this Error in the Console

[ FivePD ] An error has occured: Could not connect to the database
[ FivePD ] An error has occured: Could not load the departments from the database. Message: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at System.Diagnostics.TraceInternal.get_AppName () [0x0000e] in <d73e79af0dae4ef9ac6dff954f077e0a>:0 
  at System.Diagnostics.TraceInternal.TraceEvent (System.Diagnostics.TraceEventType eventType, System.Int32 id, System.String format, System.Object[] args) [0x0003d] in <d73e79af0dae4ef9ac6dff954f077e0a>:0 
  at System.Diagnostics.Trace.TraceError (System.String message) [0x00000] in <d73e79af0dae4ef9ac6dff954f077e0a>:0 
  at MySql.Data.MySqlClient.MySqlTrace.LogError (System.Int32 id, System.String msg) [0x00026] in <c17c8d07cfd740ad931906166ef04bff>:0 
  at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x0002e] in <c17c8d07cfd740ad931906166ef04bff>:0 
  at MySql.Data.MySqlClient.MySqlPool.GetConnection () [0x0001c] in <c17c8d07cfd740ad931906166ef04bff>:0 
  at MySql.Data.MySqlClient.MySqlConnection.Open () [0x002be] in <c17c8d07cfd740ad931906166ef04bff>:0 
  at Ul29xmGv62Xl120Qs㲽立䞈㬊䃊⤚�㎸䦍㸲䈲㩑㷮�䎳㑲喇㧨䔌㳎呂猪䶮䮬䑇䡸�䖨�䗳+Ul29xmGv62Xl120Qs䒩㭯䜯䆞䰕䮳㧐䧙㰰㰄䫘㖘㟮⏀䴆�㤼䙮㳦䧺㡞㊂�J䙎䶣䐉䡿�㋼㐭..ctor (MySql.Data.MySqlClient.MySqlConnection ⎸) [0x00022] in <80c8bb28078d4213802fb1796440c2c4>:0 
  at Ul29xmGv62Xl120Qs㲽立䞈㬊䃊⤚�㎸䦍㸲䈲㩑㷮�䎳㑲喇㧨䔌㳎呂猪䶮䮬䑇䡸�䖨�䗳.Ul29xmGv62Xl120Qs㍳䨬え䭘㹂䐫㳰䔨䅮䃸頻䢶䪼䛇㺳䱋︁䥩䭧ん㒁䍕⍩蓮⎷㥟䂱 () [0x00007] in <80c8bb28078d4213802fb1796440c2c4>:0

While I do have some programming knowledge and experience with MySQL, I am having trouble understanding what causes this Error...

Edit: Of course, I have run the SQL Commands from the Download and have put the SQL Data in my Config File

Edited by CRUGG
Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0
  • Solution

Even though I have done exactly that before as well, I fixed it by running the following SQL Command:

GRANT ALL PRIVILEGES ON fivepd.* TO 'fivepd'@'%';

 

Link to post
Share on other sites
Guest
This topic is now closed to further replies.
  • Recently Browsing   0 members

    No registered users viewing this page.

Important Information

Please view the site: Terms of Use, Privacy Policy, and Guidelines. // IMPORTANT: We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.