MySQL problem
#1

pawn Код:
format(loe, sizeof(loe), "INSERT INTO kasutajaandmed (id, kasutaja, parool, skoor, raha, skin, level, rptest, tookoht, adminnilvl, vip, kma, liige, pealik, tapmisi, surmasi, vaigistatud, vangistatud, seisatud, vaigistatudk, vangistatudk, seisatudk, bannitud, logimisi, posx, posy, posz, posa, aktiveeritud, IP) VALUES(,'%s', SHA1('%s'), 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '%s')", nimi, passwordstring, IP);
    mysql_query(loe);
I have an problem with this piece of code.
It will give me an error:
Код:
[20:22:00] CMySQLHandler::Query(INSERT INTO kasutajaandmed (id, kasutaja, parool, skoor, raha, skin, level, rptest, tookoht, adminnilvl, vip, kma, liige, pealik, tapmisi, surmasi, vaigistatud, vangistatud, seisatud, vaigistatudk, vangistatudk, seisatudk, bannitud, logimisi, posx, posy, posz, posa, aktiveeritud, IP) VALUES('','Vladimir_Koljanov', SHA1('213'), 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '88.196.165.136')) - An error has occured. (Error ID: 1136, Column count doesn't match value count at row 1)
Does somebody know how to fix it?
Reply


Messages In This Thread
MySQL problem - by vent - 02.02.2012, 17:41
Re: MySQL problem - by lorigio - 02.02.2012, 17:57
Re: MySQL problem - by vent - 02.02.2012, 17:57
Re: MySQL problem - by lorigio - 02.02.2012, 18:00
Re: MySQL problem - by vent - 02.02.2012, 18:11
Re: MySQL problem - by lorigio - 02.02.2012, 18:18

Forum Jump:


Users browsing this thread: 3 Guest(s)