kordric
March 4th, 2006, 08:41 AM
SQL query:
`Durability` , `MaxDurability` , `Condition` , `MaxCondition` , `Quality` , `MaxQuality` , `DPS_AF` , `SPD_ABS` SELECT *
FROM `itemtemplate`
WHERE 1
LIMIT 0 , 30
MySQL said:
#1064 - 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 'Durability` , `MaxDurability` , `Condition` , `MaxCondition` , `Quality` , `MaxQ' at line 1
Error i get when i querie it. An this next error is what i get when i run the server application:
00:40:38,671 - [MAIN] - ERROR - DOL.Database.Connection.DataConnection - Error while creating table ItemTemplate
MySql.Data.MySqlClient.MySqlException: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Condition INT, MaxCondition INT, Quality INT, MaxQuality INT, DPS_AF INT, SPD_AB' at line 1
at DOL.Database.Connection.DataConnection.ExecuteNonQ uery(String sqlcommand) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\Connection\DataConnection.cs:li ne 154
at DOL.Database.Connection.DataConnection.CheckOrCrea teTable(DataTable table) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\Connection\DataConnection.cs:li ne 359
00:40:38,703 - [MAIN] - ERROR - DOL.Database.Connection.DataConnection - ExecuteSelect: "SELECT ItemTemplate_ID, Id_nb, Name, Level, Durability, MaxDurability, Condition, MaxCondition, Quality, MaxQuality, DPS_AF, SPD_ABS, Hand, Type_Damage, Object_Type, Item_Type, Color, Emblem, Effect, Weight, Model, Extension, Bonus, Bonus1, Bonus2, Bonus3, Bonus4, Bonus5, ExtraBonus, Bonus1Type, Bonus2Type, Bonus3Type, Bonus4Type, Bonus5Type, ExtraBonusType, IsPickable, IsDropable, Gold, Silver, Copper, MaxCount, PackSize, Charges, MaxCharges, SpellID, ProcSpellID, Realm FROM ItemTemplate"
MySql.Data.MySqlClient.MySqlException: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Condition, MaxCondition, Quality, MaxQuality, DPS_AF, SPD_ABS, Hand, Type_Damage' at line 1
at MySql.Data.MySqlClient.PacketReader.CheckForError( ) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\MySQL\mysqlclient\PacketReader. cs:line 149
at MySql.Data.MySqlClient.PacketReader.ReadHeader() in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\MySQL\mysqlclient\PacketReader. cs:line 117
at MySql.Data.MySqlClient.PacketReader.OpenPacket() in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\MySQL\mysqlclient\PacketReader. cs:line 131
at MySql.Data.MySqlClient.NativeDriver.ReadResult(Int 64& affectedRows, Int64& lastInsertId) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\MySQL\mysqlclient\nativedriver. cs:line 384
at MySql.Data.MySqlClient.CommandResult.ReadNextResul t(Boolean isFirst) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\MySQL\mysqlclient\CommandResult .cs:line 125
at MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32 length, Boolean consume) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\MySQL\mysqlclient\nativedriver. cs:line 347
at MySql.Data.MySqlClient.MySqlCommand.GetNextResultS et(MySqlDataReader reader) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\MySQL\mysqlclient\command.cs:li ne 295
at MySql.Data.MySqlClient.MySqlDataReader.NextResult( ) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\MySQL\mysqlclient\datareader.cs :line 668
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\MySQL\mysqlclient\command.cs:li ne 406
at DOL.Database.Connection.DataConnection.ExecuteSele ct(String sqlcommand) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\Connection\DataConnection.cs:li ne 188
00:40:38,718 - [MAIN] - FATAL - DOL.GS.GameServer - GameServer initialization failed!
MySql.Data.MySqlClient.MySqlException: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Condition, MaxCondition, Quality, MaxQuality, DPS_AF, SPD_ABS, Hand, Type_Damage' at line 1
at DOL.Database.Connection.DataConnection.ExecuteSele ct(String sqlcommand) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\Connection\DataConnection.cs:li ne 200
at DOL.Database.ObjectDatabase.SQLSelectObjects(Type objectType, String whereClause) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\ObjectDatabase.cs:line 677
at DOL.Database.ObjectDatabase.RegisterDataObject(Typ e dataObjectType) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\ObjectDatabase.cs:line 948
at DOL.GS.GameServer.InitDB() in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\GameServer\GameServer.cs:line 1045
at DOL.GS.GameServer..ctor(GameServerConfiguration config) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\GameServer\GameServer.cs:line 1168.
Please help very frustrated here :curse:
`Durability` , `MaxDurability` , `Condition` , `MaxCondition` , `Quality` , `MaxQuality` , `DPS_AF` , `SPD_ABS` SELECT *
FROM `itemtemplate`
WHERE 1
LIMIT 0 , 30
MySQL said:
#1064 - 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 'Durability` , `MaxDurability` , `Condition` , `MaxCondition` , `Quality` , `MaxQ' at line 1
Error i get when i querie it. An this next error is what i get when i run the server application:
00:40:38,671 - [MAIN] - ERROR - DOL.Database.Connection.DataConnection - Error while creating table ItemTemplate
MySql.Data.MySqlClient.MySqlException: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Condition INT, MaxCondition INT, Quality INT, MaxQuality INT, DPS_AF INT, SPD_AB' at line 1
at DOL.Database.Connection.DataConnection.ExecuteNonQ uery(String sqlcommand) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\Connection\DataConnection.cs:li ne 154
at DOL.Database.Connection.DataConnection.CheckOrCrea teTable(DataTable table) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\Connection\DataConnection.cs:li ne 359
00:40:38,703 - [MAIN] - ERROR - DOL.Database.Connection.DataConnection - ExecuteSelect: "SELECT ItemTemplate_ID, Id_nb, Name, Level, Durability, MaxDurability, Condition, MaxCondition, Quality, MaxQuality, DPS_AF, SPD_ABS, Hand, Type_Damage, Object_Type, Item_Type, Color, Emblem, Effect, Weight, Model, Extension, Bonus, Bonus1, Bonus2, Bonus3, Bonus4, Bonus5, ExtraBonus, Bonus1Type, Bonus2Type, Bonus3Type, Bonus4Type, Bonus5Type, ExtraBonusType, IsPickable, IsDropable, Gold, Silver, Copper, MaxCount, PackSize, Charges, MaxCharges, SpellID, ProcSpellID, Realm FROM ItemTemplate"
MySql.Data.MySqlClient.MySqlException: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Condition, MaxCondition, Quality, MaxQuality, DPS_AF, SPD_ABS, Hand, Type_Damage' at line 1
at MySql.Data.MySqlClient.PacketReader.CheckForError( ) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\MySQL\mysqlclient\PacketReader. cs:line 149
at MySql.Data.MySqlClient.PacketReader.ReadHeader() in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\MySQL\mysqlclient\PacketReader. cs:line 117
at MySql.Data.MySqlClient.PacketReader.OpenPacket() in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\MySQL\mysqlclient\PacketReader. cs:line 131
at MySql.Data.MySqlClient.NativeDriver.ReadResult(Int 64& affectedRows, Int64& lastInsertId) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\MySQL\mysqlclient\nativedriver. cs:line 384
at MySql.Data.MySqlClient.CommandResult.ReadNextResul t(Boolean isFirst) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\MySQL\mysqlclient\CommandResult .cs:line 125
at MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32 length, Boolean consume) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\MySQL\mysqlclient\nativedriver. cs:line 347
at MySql.Data.MySqlClient.MySqlCommand.GetNextResultS et(MySqlDataReader reader) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\MySQL\mysqlclient\command.cs:li ne 295
at MySql.Data.MySqlClient.MySqlDataReader.NextResult( ) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\MySQL\mysqlclient\datareader.cs :line 668
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\MySQL\mysqlclient\command.cs:li ne 406
at DOL.Database.Connection.DataConnection.ExecuteSele ct(String sqlcommand) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\Connection\DataConnection.cs:li ne 188
00:40:38,718 - [MAIN] - FATAL - DOL.GS.GameServer - GameServer initialization failed!
MySql.Data.MySqlClient.MySqlException: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Condition, MaxCondition, Quality, MaxQuality, DPS_AF, SPD_ABS, Hand, Type_Damage' at line 1
at DOL.Database.Connection.DataConnection.ExecuteSele ct(String sqlcommand) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\Connection\DataConnection.cs:li ne 200
at DOL.Database.ObjectDatabase.SQLSelectObjects(Type objectType, String whereClause) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\ObjectDatabase.cs:line 677
at DOL.Database.ObjectDatabase.RegisterDataObject(Typ e dataObjectType) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\DOLDatabase\ObjectDatabase.cs:line 948
at DOL.GS.GameServer.InitDB() in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\GameServer\GameServer.cs:line 1045
at DOL.GS.GameServer..ctor(GameServerConfiguration config) in c:\CopyofGameServer2006-01-28_src\CopyofGameServer2006-01-28_src\GameServer\GameServer.cs:line 1168.
Please help very frustrated here :curse: