[mysql] Column count doesn't match value count - 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] Column count doesn't match value count (/showthread.php?tid=635004)
+- 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] Column count doesn't match value count (/showthread.php?tid=635004)
[mysql] Column count doesn't match value count - Lirbo - 30.05.2017
PHP код:
[19:14:02 05/30/17] [ERROR] CMySQLQuery::Execute - (error #1136) Column count doesn't match value count at row 1 (Query: "INSERT INTO `Houses` (`Price`, `Owner`, `X1`, `Y1`, `Z1`, `A1`, `Interior1`, `VirtualWorld1`, `X2`, `Y2`, `Z2`, `A2`, `Interior2`, `VirtualWorld2`) VALUES (0, 'None', 2270.411, -7.503, 28.154, 179.425, 0, 0, 266.5, 304.9, 999.15, 270.0, 2)")
[19:14:02 05/30/17] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
Re: [mysql] Column count doesn't match value count - Deroxi - 30.05.2017
It would be nice if you included your script here, the part where you get the error from.
Re: [mysql] Column count doesn't match value count - Vince - 30.05.2017
It says "count" in the error message. So start counting. You have 14 columns but only 13 values.
Re: [mysql] Column count doesn't match value count - SyS - 30.05.2017
listed fields are 14 and values specified is 13.
Edit : i'm becoming old
Re: [mysql] Column count doesn't match value count - Lirbo - 30.05.2017
Quote:
|
Originally Posted by SyS
 listed fields are 14 and values specified is 13.
Edit : i'm becoming old |