1. These forums are still being retired! Please use GitHub discussions or Discord. You cannot create new threads or new accounts now. If you need to contact some user of the forums, you should do it sooner, rather than later. This notice was last updated on May 30th, 2021.

Resolved Server Crashes on Start

Discussion in 'Help and Support' started by Gamesmann, Oct 1, 2013.

Thread Status:
Not open for further replies.
  1. Gamesmann

    Gamesmann Level 4

    Joined:
    Aug 10, 2011
    Messages:
    55
    I'm using TShock 4.2 Pre Release 5 but I am getting an error within msql. I've deleted the database and started with a fresh one but still not working. This is the error message I get:

    2013-10-01 13:53:26 - TShock: INFO: TShock was improperly shut down. Please use the exit command in the future to prevent this.
    2013-10-01 13:53:27 - TShock: ERROR: Fatal Startup Exception
    2013-10-01 13:53:27 - TShock: ERROR: MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Character (Account INT PRIMARY KEY , Health INT , MaxHealth INT , Mana INT ' at line 1
    at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
    at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
    at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
    at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
    at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
    at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
    at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
    at TShockAPI.DB.DbExt.Query(IDbConnection olddb, String query, Object[] args)
    at TShockAPI.DB.SqlTableCreator.EnsureExists(SqlTable table)
    at TShockAPI.DB.CharacterManager..ctor(IDbConnection db)
    at TShockAPI.TShock.Initialize()

    Is this my database causing this or is it one of the msql dll files?
     
  2. Gamesmann

    Gamesmann Level 4

    Joined:
    Aug 10, 2011
    Messages:
    55
    I had the server use sqlite at start and it created a new database fine. When I try mysql it crashes on creating the table 'Character'. The other tables are created just fine. So I am going to attemp to create the tables myself and see if it works.
     
  3. Krejza9

    Krejza9 Level 0

    Joined:
    Oct 1, 2013
    Messages:
    4
  4. Gamesmann

    Gamesmann Level 4

    Joined:
    Aug 10, 2011
    Messages:
    55
    Yeah. I created the table myself and the server started up fine.
     
  5. nicatronTg

    nicatronTg Shank / hakusaro
    TShock Founder TShock Admin

    Joined:
    Jul 21, 2011
    Messages:
    723
Thread Status:
Not open for further replies.