V 0.0.10 ^-^

[mwmdragon]

Yeah I have the same error with the latest cavedude install

See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.FormatException: Input string was not in a correct format.
   at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
   at MySql.Data.Common.DBConnectionString.ConnectionParameterParsed(Hashtable hash, String key, String value)
   at MySql.Data.MySqlClient.MySqlConnectionString.ConnectionParameterParsed(Hashtable hash, String key, String value)
   at MySql.Data.Common.DBConnectionString.Parse(String newConnectString)
   at MySql.Data.MySqlClient.MySqlConnection.set_ConnectionString(String value)
   at MySql.Data.MySqlClient.MySqlConnection..ctor(String connectionString)
   at EQemu_SQL_Editor.Common.DatabaseConnect()
   at EQemu_SQL_Editor.frmDBLogin.LoadSQLConnect()
   at EQemu_SQL_Editor.frmDBLogin.cmdLoadSQL_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(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:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
KayotRO's EQemu SQL Editor Merged
    Assembly Version: 1.0.2662.41906
    Win32 Version: 1.0.2662.41906
    CodeBase: file:///C:/Documents%20and%20Settings/MWMDragon/Desktop/KayotRO_EQemu_Editor/KayotRO's%20EQemu%20SQL%20Editor.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/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:///C:/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:///C:/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:///C:/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:///C:/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.

I tried it with the PEQ and the AX databases with the same result.

Hope this helps.

[Kayot]

mamba666 - Have you tried updating your DB's to the PEQ CVS? Cave dudes DB is old, and by old I mean it's missing sevearal thousand entrys.

I checked the scheme of the newest PEQ database and rulesflag is in there.

CREATE TABLE account (
  id int(11) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  charname varchar(64) NOT NULL default '',
  sharedplat int(11) NOT NULL default '0',
  `password` varchar(50) NOT NULL default '',
  `status` int(5) NOT NULL default '0',
  lsaccount_id int(11) unsigned default NULL,
  gmspeed tinyint(3) unsigned NOT NULL default '0',
  revoked tinyint(3) unsigned NOT NULL default '0',
  minilogin_ip varchar(32) NOT NULL default '',
  hideme tinyint(4) NOT NULL default '0',
  rulesflag tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY lsaccount_id (lsaccount_id)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

Also, mwmdragon, are you using Mysql 4.0? That error is about the input of the mysql command being messed up because the connector libabry is for 4.1+

[mamba666]

I downloaded the latest CVS of PEQ and was unable to source it. I kept getting errors.

I then made a backup of the peq I have and update it with the cvs source. This didn't work because of the duplicate entries and the tables weren't quite the same.

I know this isn't your problem and I will figure it out. I just wanted to let you know that I was trying a new database. Once I get it going I'll try your editor on it.

[techguy84]

The error with sourceing the CVS is that you have to navigate your command prompt to the directory where the files are located before running mysql. If you just run mysql, it will look for the files in your bin directory of mysql.

For example, if you downloaded the CVS to c:\peq_db you would then need to cd\peq_db in your command prompt to go into that folder first.

[cavedude]

You can't update the PEQ database, you have to wipe the system tables and then resource them. Using CVS, source drop_system.sql and source load_system.sql will do that for you.

Yeah, my db is way out of date. Most of the data it contained I have merged into PEQ anyway so it's near 100% obsolete.

[mamba666]

I tried starting form a clean fersh database and still didn't work.

This thread really isn't for installing dtabase so I'm gonna stop posting about updating my database here. I'll go to the PEQ forums or the server setup forums.

I'm happy with what I have right now and will address upgrading my database later.

For now I can still use most of the functions of the KayotRo tools. I also can access through an Access front end as well as Navicat MySQL. I'll have trouble with the (Blob) stuff, until I can get the latest database up and running.

Thanks for the help guys. I have a lot of ideas and things to try.

[mamba666]

OK Update.I now have 98% or so fuctionality. I ahd to make a few updates to the databse that I have.

These updates are stated on the PEQ forums. Here are specifically the 2 I had to update.

ALTER TABLE `account` ADD `rulesflag` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';

-- This allowed me to edit the accounts

ALTER TABLE `zone` ADD `cancombat` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';

-- this allowed me to edit the zones

If I was able to source in the CVS database this would have been fixed I am sure.

The forum reference is http://www.projecteq.net/phpBB2/viewtopic.php?t=1679

I am pretty happy now and hope that htis may help someone else.

This should fix the database for using this editor if you installed the EQEMUServerpack3.6 or even 3.52 mostlikely.