search

TavstalDev / TShop2

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

Unable to migrate shop #9

Closed khaiizha closed 1 month ago

khaiizha commented 1 month ago

Im using another shop plugins and was unable to migrate the table to TShop table. I cloned my shop table to match with zaup table name and column type but still error. Most of my shop table consist of escalation item ID with range from 51xxx - 52xxx. Is there anything else i should change?

[TShop] [EXCEPTION] > System.OverflowException: Value was either too large or too small for an Int16. at System.Convert.ThrowInt16OverflowException () [0x00000] in <47fc8c70fa834cbf8141d7c1a7589125>:0 at System.Convert.ToInt16 (System.UInt16 value) [0x00008] in <47fc8c70fa834cbf8141d7c1a7589125>:0 at System.UInt16.System.IConvertible.ToInt16 (System.IFormatProvider provider) [0x00000] in <47fc8c70fa834cbf8141d7c1a7589125>:0 at System.Convert.ChangeType (System.Object value, System.Type conversionType, System.IFormatProvider provider) [0x000b1] in <47fc8c70fa834cbf8141d7c1a7589125>:0 at MySql.Data.MySqlClient.MySqlDataReader.ChangeType (MySql.Data.Types.IMySqlValue value, System.Int32 fieldIndex, System.Type newType) [0x0001f] in <b1c7788755a74283a1149114261547b3>:0 at MySql.Data.MySqlClient.MySqlDataReader.GetInt16 (System.Int32 i) [0x00020] in <b1c7788755a74283a1149114261547b3>:0 at Tavstal.TLibrary.Extensions.MySqlExtensions.GetUInt16 (System.Data.Common.DbDataReader reader, System.String column) [0x00009] in <94311928e26a42749e932a865da09cb7>:0 at Tavstal.TShop.DatabaseManager.GetZaupProductsAsync (System.String itemTable, System.String vehicleTable) [0x0017d] in <f754e87912724931af5c4dedee550a89>:0

TavstalDev commented 1 month ago

@khaiizha Could you tell me the name of the other shop plugin? I would like to reproduce the error so It will be easier to fix.

khaiizha commented 1 month ago

its Plov Shop System

TavstalDev commented 1 month ago

@khaiizha I have uploaded a new version that contains a fix attempt related to this issue.

khaiizha commented 1 month ago

Now its library error, already using the same library as the previous release.

Could not find dependency: TLibrary, Version=1.0.8959.19784, Culture=en, PublicKeyToken=null Could not find dependency: TLibrary, Version=1.0.8959.19784, Culture=en, PublicKeyToken=null Invalid or outdated plugin assembly: TShop

TavstalDev commented 1 month ago

@khaiizha I have updated the release

khaiizha commented 1 month ago

Tested and verified good now. Able to migrate. Thank you for the prompt response