SA-MP Forums Archive
MySQL problem - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL problem (/showthread.php?tid=315314)


MySQL problem - vent - 02.02.2012

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?

Re: MySQL problem - lorigio - 02.02.2012

the first values doesn't need ,

change it from
Quote:

VALUES(,'%s'
to
Quote:

VALUES('%s'


Re: MySQL problem - vent - 02.02.2012

This isn't the problem. Fixed it already.

Re: MySQL problem - lorigio - 02.02.2012

id is autoincrement?

Re: MySQL problem - vent - 02.02.2012

it should be.

Re: MySQL problem - lorigio - 02.02.2012

Column contains 31 parameters
Quote:

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
Else values contains 32 parameter
Quote:

'','%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'
find the missing column