Column count doesn't match value c
ount at row 1 error....

CREATE TABLE myrunuo_status (
char_id int(12) unsigned default NULL,
char_location varchar(14) default NULL,
char_map varchar(8) default NULL,
char_karma int(6) default NULL,
char_fame int(6) default NULL,
KEY charid (char_id)
) ;


everything else is working good just this table for mysql database
 
Column count doesn't match value c
ount at row 1 error....

CREATE TABLE myrunuo_status (
char_id int(12) unsigned default NULL,
char_location varchar(14) default NULL,
char_map varchar(8) default NULL,
char_karma int(6) default NULL,
char_fame int(6) default NULL,
KEY charid (char_id)
) ;


everything else is working good just this table for mysql database

Fixed.... line in myrunuo was missing (char_id)

if ( mob != null )
m_Command.Enqueue( String.Format( "INSERT INTO myrunuo_status (char_id) VALUES ({0})", mob.Serial.Value.ToString() ) );
 
Back