MyRUNOU - MySQL table PROBLEM

[Admin_Shaka]

Hello Guys !

As you see I got MyRunUO working on my server... (A lot of work since I do not know MySQL)

RunUO - [www.runuo.com] Version 2.0, Build 2357.32527
Core: Running on .NET Framework Version 2.0.50727
Scripts: Compiling C# scripts...done (cached)
Scripts: Compiling VB.NET scripts...no files found.
Scripts: Verifying...done (3036 items, 592 mobiles)
Regions: Loading...done
World: Loading...done (118375 items, 2634 mobiles) (8,49 seconds)
Xanthos.Utilities.ConfigParser attempting to load Data/AuctionConfig.xml...
Xanthos.Utilities.ConfigParser success!
Pandora is listening on port 8035 - BoxServer version 0.3
Address: 127.0.0.1:2593
Address: xxxxxxxxxxx:2593
Address: xxxxxxx:2593
Warning: 25 bad spawns detected, logged: 'badspawn.log'
Sistema de Loteria atualizando...
MyRunUO: Updating character database
MyRunUO: Database statements compiled in 1,47 seconds
MyRunUO: Updating status database
MyRunUO: Characeter database updated in 9,4 seconds
MyRunUO: Status database updated in 2,6 seconds

This is when there is NO PLAYERS on the server !!!

But, when there is a player logged I have a ERROR in the STATUS database!

MyRunUO: Updating status database
MyRunUO: Exception caught in database thread
System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-4
.1.22-standard]Contagem de colunas não confere com a contagem de valores na linh
a 1
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode r
etcode)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior,
 String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMet
hod)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior,
 String method, Boolean needReader)
   at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
   at Server.Engines.MyRunUO.DatabaseCommandQueue.Thread_Start()
MyRunUO: Status database updated in 2,4 seconds

The translation of this: Contagem de colunas não confere com a contagem de valores na linha 1: "The number of coluns dont match with the number of values on line 1"

Here is the structure of the table STATUS:

CREATE TABLE myrunuo_status (
char_id Int(12) UNSIGNED,
char_location VARCHAR(14),
char_map VARCHAR(8),
char_karma Int(6),
char_fame Int(6));

Thanks...

[Admin_Shaka]

I am not bumping IT !

Just posting a reply for those in future have the same error as me!

The problem is that devs removed some stuff from original MyRunUO!

I just dont know why !

here is how to solve it:

Find the line that starts with:

m_Command.Enqueue(String.Format("INSERT INTO myrunuo_status

and replace the WHOLE line with:

 m_Command.Enqueue(String.Format("INSERT INTO myrunuo_status (char_id, char_location, char_map, char_Karma, char_fame) VALUES ({0},'{1},{2},{3}','{4}',{5},{6})", mob.Serial.Value.ToString(), mob.X.ToString(), mob.Y.ToString(), mob.Z.ToString(), mob.Map, mob.Karma, mob.Fame));

Thank you all