Version 0.1.1

[Amra]

I always read. I read your updates and crazy stories haha!

I love your additude, Kayot. You rock

[ChaosSlayer]

when tryign to open anything (like npc or item) i am geting the same error everywhere

************** Exception Text **************
System.InvalidOperationException: Connection must be valid and open
at MySql.Data.MySqlClient.MySqlCommand.CheckState()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( )
at EQemu_SQL_Editor.frmStartingEditor.Load_Items()
at EQemu_SQL_Editor.frmStartingEditor.lstClass_Select edIndexChanged(Object sender, EventArgs e)
at System.Windows.Forms.ListBox.OnSelectedIndexChange d(EventArgs e)
at System.Windows.Forms.ListBox.WmReflectCommand(Mess age& m)
at System.Windows.Forms.ListBox.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///D:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
KayotRO's EQemu SQL Editor Merged
Assembly Version: 1.0.2701.31826
Win32 Version: 1.0.2701.31826
CodeBase: file:///D:/games/EMULATOR/KayotRO_EQemu_Editor/EQemu%20SQL%20Database%20Editor.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///D:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///D:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///D:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///D:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///D:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

[jimbabwe]

Originally Posted by ChaosSlayer

************** Exception Text **************
System.InvalidOperationException: Connection must be valid and open

Looks like it can't make a connection to your database. Are your settings correct?

[ChaosSlayer]

as far as i can tell they are
they identical to settings i use for all editors writen by GeorgeS

[Kayot]

I need some more information:

Bug Report Template

Message: <Error Message>

MySQL Ver: 4.0/4.1/5.0

EQemu Ver: 0.0.0R000

Database type: PEQ/Angelox/Hybrid

What you did to create error - Only use if you did something to cause the error. Like dragging an item or saving an integer. A good bug is using the symbol ' in any text field.

[ChaosSlayer]

mySQl 5.0
EQEmu 0.7.0-992
Db PEQ
What you did to create error : tried to open anything =)

Error: DB error: Unhandled exception has occured in your applictaion. Connection must be valid and open.

[Amra]

The editor does seem to time out (connection to the DB) after a while. This may be the problem you are having. It seems to happen in a shorter period of time than it used to.