Code:
NHibernate.Exceptions.GenericADOException HResult=0x80131600 Message=could not execute query [ SELECT this_.ID as ID3_0_, this_.Name as Name3_0_, this_.ProfessionReq as Professi3_3_0_, this_.ProficiencyReq as Proficie4_3_0_, this_.LevelReq as LevelReq3_0_, this_.GenderReq as GenderReq3_0_, this_.StrengthReq as Strength7_3_0_, this_.AgilityReq as AgilityReq3_0_, this_.VitalityReq as Vitality9_3_0_, this_.SpiritReq as SpiritReq3_0_, this_.ItemFlags as ItemFlags3_0_, this_.Weight as Weight3_0_, this_.Price as Price3_0_, this_.ActionID as ActionID3_0_, this_.AttackMax as AttackMax3_0_, this_.AttackMin as AttackMin3_0_, this_.DefenseAdd as DefenseAdd3_0_, this_.AccuracyAdd as Accurac18_3_0_, this_.DodgeAdd as DodgeAdd3_0_, this_.HealthAdd as HealthAdd3_0_, this_.ManaAdd as ManaAdd3_0_, this_.Amount as Amount3_0_, this_.AmountMax as AmountMax3_0_, this_.Ident as Ident3_0_, this_.Gem1 as Gem25_3_0_, this_.Gem2 as Gem26_3_0_, this_.Magic1 as Magic27_3_0_, this_.Magic2 as Magic28_3_0_, this_.Magic3 as Magic29_3_0_, this_.MagicAttack as MagicAt30_3_0_, this_.MagicDefense as MagicDe31_3_0_, this_.AttackRange as AttackR32_3_0_, this_.AttackSpeed as AttackS33_3_0_, this_.FrayMode as FrayMode3_0_, this_.RepairMode as RepairMode3_0_, this_.TypeMask as TypeMask3_0_, this_.PriceCP as PriceCP3_0_, this_.TypeDesc as TypeDesc3_0_ FROM itemtype this_ ] [SQL: SELECT this_.ID as ID3_0_, this_.Name as Name3_0_, this_.ProfessionReq as Professi3_3_0_, this_.ProficiencyReq as Proficie4_3_0_, this_.LevelReq as LevelReq3_0_, this_.GenderReq as GenderReq3_0_, this_.StrengthReq as Strength7_3_0_, this_.AgilityReq as AgilityReq3_0_, this_.VitalityReq as Vitality9_3_0_, this_.SpiritReq as SpiritReq3_0_, this_.ItemFlags as ItemFlags3_0_, this_.Weight as Weight3_0_, this_.Price as Price3_0_, this_.ActionID as ActionID3_0_, this_.AttackMax as AttackMax3_0_, this_.AttackMin as AttackMin3_0_, this_.DefenseAdd as DefenseAdd3_0_, this_.AccuracyAdd as Accurac18_3_0_, this_.DodgeAdd as DodgeAdd3_0_, this_.HealthAdd as HealthAdd3_0_, this_.ManaAdd as ManaAdd3_0_, this_.Amount as Amount3_0_, this_.AmountMax as AmountMax3_0_, this_.Ident as Ident3_0_, this_.Gem1 as Gem25_3_0_, this_.Gem2 as Gem26_3_0_, this_.Magic1 as Magic27_3_0_, this_.Magic2 as Magic28_3_0_, this_.Magic3 as Magic29_3_0_, this_.MagicAttack as MagicAt30_3_0_, this_.MagicDefense as MagicDe31_3_0_, this_.AttackRange as AttackR32_3_0_, this_.AttackSpeed as AttackS33_3_0_, this_.FrayMode as FrayMode3_0_, this_.RepairMode as RepairMode3_0_, this_.TypeMask as TypeMask3_0_, this_.PriceCP as PriceCP3_0_, this_.TypeDesc as TypeDesc3_0_ FROM itemtype this_] Source=NHibernate StackTrace: at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) at NHibernate.Loader.Criteria.CriteriaLoader.List(ISessionImplementor session) at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) at NHibernate.Impl.CriteriaImpl.List(IList results) at NHibernate.Impl.CriteriaImpl.List[T]() at Redux.ControlForm.ReadItemInfoAndCorrectDb() in C:\5017SourceFull1\Redux\ControlForm.cs:line 253 at Redux.ControlForm..ctor() in C:\5017SourceFull1\Redux\ControlForm.cs:line 58 at Redux.Program.Main() in C:\5017SourceFull1\Redux\Program.cs:line 31 This exception was originally thrown at this call stack: [External Code] Inner Exception 1: FormatException: Input string '90000' was not in the correct format. Inner Exception 2: OverflowException: Value was either too large or too small for a UInt16.
Code:
<?xml version="1.0" encoding="utf-8" ?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="Redux" namespace="Redux.Database.Domain"> <class name="DbItemInfo" table="itemtype"> <id name="ID" column="ID"> <generator class="identity" /> </id> <property name="Name" column="Name" /> <property name="ProfessionReq" column="ProfessionReq" /> <property name="ProficiencyReq" column="ProficiencyReq" /> <property name="LevelReq" column="LevelReq" /> <property name="GenderReq" column="GenderReq" /> <property name="StrengthReq" column="StrengthReq" /> <property name="AgilityReq" column="AgilityReq" /> <property name="VitalityReq" column="VitalityReq" /> <property name="SpiritReq" column="SpiritReq" /> <property name="Flags" column="ItemFlags" /> <property name="Weight" column="Weight" /> <property name="Price" column="Price" /> <property name="ActionID" column="ActionID" /> <property name="AttackMax" column="AttackMax" /> <property name="AttackMin" column="AttackMin" /> <property name="DefenseAdd" column="DefenseAdd" /> <property name="AccuracyAdd" column="AccuracyAdd" /> <property name="DodgeAdd" column="DodgeAdd" /> <property name="HealthAdd" column="HealthAdd" /> <property name="ManaAdd" column="ManaAdd" /> <property name="Amount" column="Amount" /> <property name="AmountMax" column="AmountMax" /> <property name="Ident" column="Ident" /> <property name="Gem1" column="Gem1" /> <property name="Gem2" column="Gem2" /> <property name="Magic1" column="Magic1" /> <property name="Magic2" column="Magic2" /> <property name="Magic3" column="Magic3" /> <property name="MagicAttack" column="MagicAttack" /> <property name="MagicDefense" column="MagicDefense" /> <property name="AttackRange" column="AttackRange" /> <property name="AttackSpeed" column="AttackSpeed" /> <property name="FrayMode" column="FrayMode" /> <property name="RepairMode" column="RepairMode" /> <property name="TypeMask" column="TypeMask" /> <property name="PriceCP" column="PriceCP" /> <property name="TypeDesc" column="TypeDesc" /> </class> </hibernate-mapping>
Code:
# Name Type Collation Attributes Null Default Comments Extra Action 1 IDPrimary int(4) No None Change Change Drop Drop More More 2 Name varchar(20) latin1_swedish_ci No None Change Change Drop Drop More More 3 ProfessionReq smallint(2) No None Change Change Drop Drop More More 4 ProficiencyReq smallint(2) No None Change Change Drop Drop More More 5 LevelReq smallint(2) No None Change Change Drop Drop More More 6 GenderReq tinyint(1) No None Change Change Drop Drop More More 7 StrengthReq smallint(3) No None Change Change Drop Drop More More 8 AgilityReq smallint(3) No None Change Change Drop Drop More More 9 VitalityReq smallint(3) No None Change Change Drop Drop More More 10 SpiritReq smallint(3) No None Change Change Drop Drop More More 11 ItemFlags int(4) No None Change Change Drop Drop More More 12 Weight smallint(2) No None Change Change Drop Drop More More 13 Price int(4) No None Change Change Drop Drop More More 14 ActionID int(4) No None Change Change Drop Drop More More 15 AttackMax smallint(4) No None Change Change Drop Drop More More 16 AttackMin smallint(4) No None Change Change Drop Drop More More 17 DefenseAdd smallint(2) No None Change Change Drop Drop More More 18 AccuracyAdd smallint(2) No None Change Change Drop Drop More More 19 DodgeAdd smallint(2) No None Change Change Drop Drop More More 20 HealthAdd smallint(2) No None Change Change Drop Drop More More 21 ManaAdd smallint(2) No None Change Change Drop Drop More More 22 Amount int(4) No None Change Change Drop Drop More More 23 AmountMax int(4) No None Change Change Drop Drop More More 24 Ident tinyint(1) No None Change Change Drop Drop More More 25 Gem1 tinyint(1) No None Change Change Drop Drop More More 26 Gem2 tinyint(1) No None Change Change Drop Drop More More 27 Magic1 smallint(2) No None Change Change Drop Drop More More 28 Magic2 smallint(2) No None Change Change Drop Drop More More 29 Magic3 smallint(2) No None Change Change Drop Drop More More 30 MagicAttack smallint(2) No None Change Change Drop Drop More More 31 MagicDefense smallint(2) No None Change Change Drop Drop More More 32 AttackRange smallint(2) No None Change Change Drop Drop More More 33 AttackSpeed smallint(2) No None Change Change Drop Drop More More 34 FrayMode tinyint(1) No None Change Change Drop Drop More More 35 RepairMode tinyint(1) No None Change Change Drop Drop More More 36 TypeMask tinyint(2) No None Change Change Drop Drop More More 37 PriceCP int(4) No None Change Change Drop Drop More More 38 TypeDesc varchar(32) latin1_swedish_ci No None Change Change Drop Drop More More 39 Description varchar(512) latin1_swedish_ci No None Change Change Drop Drop More More