Item Editor & Event Viewer Source

[Zabeeble]

Wish I could see the rest of it, though. Strange error. Could be my fault, as I'm a total noob at EQEmu. But maybe you can make sense of it and help me.

Your database version is incompatible with the version selected in the ItemEditor.



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 'range,banedmgamt,banedmgbody,banedmgrace,elemdmgtype,elemdmgamt,augslot1type,aug' at line 1
   at MySql.Data.MySqlClient.PacketReader.CheckForError()
   at MySql.Data.MySqlClient.PacketReader.ReadHeader()
   at MySql.Data.MySqlClient.PacketReader.OpenPacket()
   at MySql.Data.MySqlClient.NativeDriver.ReadResult(Int64& affectedRows, Int64& lastInsertId)
   at MySql.Data.MySqlClient.CommandResult.ReadNextResult(Boolean isFirst)
   at MySql.Data.MySqlClient.CommandResult..ctor(Driver d, Boolean isBinary)
   at MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32 length, Boolean consume)
   at MySql.Data.MySqlClient.MySqlCommand.GetNextResultSet(MySqlDataReader reader)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at ItemEditor.Database.getItems()

I'm using EQEmu 946 with ax_classic_3.10o_R42. The game runs, so I'm not sure what the DB problem is.

[Andrew80k]

The code is probably built against an older version of the database as the first line says. You'll either need image to update it or you'll need the source to do it yourself. I'm not sure if the source was ever released for the 0.7.0 version though.

[Zabeeble]

I guess my search for an item editor will keep on... (*shields eyes from sunlight as he looks boldly into the future*)

[GeorgeS]

Looks like a similar error I noticed in my tools. The error stems from using range without the `range` quotes.
This has to be fixed in code however, and also earlier versions of mysql may not complain about reserved words


GeorgeS