TavstalDev / TShop2

SQL based async item and vehicle shop plugin for Unturned 3
GNU General Public License v3.0
3 stars 0 forks source link

Weird Error #18

Closed CatzMR closed 4 days ago

CatzMR commented 4 days ago

image A strange error. I didn't make any changes, but this error suddenly popped up when I started the server.

[TLibrary] [EXCEPTION] > Error in TLibrary:
[TLibrary] [EXCEPTION] > SQL Command: SHOW COLUMNS FROM @TableName;
[TLibrary] [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 ''tshop_products'' at line 1
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x000aa] in <79c409bb2afe4b83bf725092ced7760a>:0
  at MySql.Data.MySqlClient.NativeDriver.GetResult (System.Int32& affectedRow, System.Int64& insertedId) [0x0005d] in <79c409bb2afe4b83bf725092ced7760a>:0
  at MySql.Data.MySqlClient.Driver.GetResult (System.Int32 statementId, System.Int32& affectedRows, System.Int64& insertedId) [0x00000] in <79c409bb2afe4b83bf725092ced7760a>:0
  at MySql.Data.MySqlClient.Driver.NextResult (System.Int32 statementId, System.Boolean force) [0x00023] in <79c409bb2afe4b83bf725092ced7760a>:0
  at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00251] in <79c409bb2afe4b83bf725092ced7760a>:0
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0030c] in <79c409bb2afe4b83bf725092ced7760a>:0
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader (System.Data.CommandBehavior behavior) [0x00000] in <79c409bb2afe4b83bf725092ced7760a>:0
  at System.Data.Common.DbCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00000] in <13eea8be1524432aa35d549c43464c47>:0
  at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync (System.Data.CommandBehavior behavior, System.Threading.CancellationToken cancellationToken) [0x00049] in <13eea8be1524432aa35d549c43464c47>:0
--- End of stack trace from previous location where exception was thrown ---

  at Tavstal.TLibrary.Helpers.General.DatabaseHelper.CheckTableAsync[T] (MySql.Data.MySqlClient.MySqlConnection connection, System.String tableName) [0x0041d] in <ff711032513540a3985aa45e8ff6b25d>:0
CatzMR commented 4 days ago

This problem occurred after I updated https://github.com/TavstalDev/TShop2/releases/tag/4.1.9014.17052 on September 7, but I didn't notice this problem before.

TavstalDev commented 4 days ago

@CatzMR Do you use this version of TLibrary https://github.com/TavstalDev/TLibrary/releases/tag/1.0.9020.18035 ?

CatzMR commented 4 days ago

@CatzMR Do you use this version of TLibrary https://github.com/TavstalDev/TLibrary/releases/tag/1.0.9020.18035 ?

I am using https://github.com/TavstalDev/TLibrary/releases/tag/1.0.9014.16334

CatzMR commented 4 days ago

Tested the latest https://github.com/TavstalDev/TLibrary/releases/tag/1.0.9020.18035, there is no this error.

CatzMR commented 4 days ago

Rocket reload tshop is also normal.

TavstalDev commented 4 days ago

Fixed by newer TLibrary version