[mysql] Column count doesn't match value count
#1

PHP код:
[19:14:02 05/30/17] [ERRORCMySQLQuery::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] [WARNINGCMySQLHandle::DeleteSavedResult invalid result id ('0'
Reply
#2

It would be nice if you included your script here, the part where you get the error from.
Reply
#3

It says "count" in the error message. So start counting. You have 14 columns but only 13 values.
Reply
#4

listed fields are 14 and values specified is 13.
Edit : i'm becoming old
Reply
#5

Quote:
Originally Posted by SyS
Посмотреть сообщение
listed fields are 14 and values specified is 13.
Edit : i'm becoming old
Lol, i'm the one who should say that
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)