problem writing

[diarmuid]

i'm having a problem writing to a mysql database. here's the code, followed by the error.

Code: Select all

proc db:write { id table_write nick uhost } {
   global as_game as_gametype as_server as_map as_players as_location sb_set db trigger_channel

   set sqlhand [mysqlconnect -host $db(host) -user $db(user) -password $db(pass)]

   mysqluse $sqlhand $db(dbase)

$ers` , `map` , `server` , `channel` , `location` ) VALUES (NOW( ), '$sb_set(counter)', '$nick', '$uhost', '$as_game($uhost)', '$as_gametype($uhost)', '$as_players($uhost)v$as_players($uhost)', '$as_map($uhost)', '$as_server($uhost)', '$trigger_channel($uhost)', '$as_location($uhost)')"

   mysqlclose $sqlhand
   return 0
}

the error

Code: Select all

Tcl error [msg:filter]: mysqlexec/db server: Column count doesn't match value count at row 1

i've checked, and re-checked all my tables and i can't find anything wrong. please help!

-diar

[Ofloo]

check this forum i posted a sample script for this ..

http://forum.egghelp.org/viewtopic.php? ... ight=mysql