error #1136 MYSQL

[pap04ka]

Ошибка

[20:36:48] [ERROR] CMySQLQuery::Execute[()] - (error #1136) Column count doesn't match value count at row 1

Запрос:


mysql_format(MYSQL_ARG, pizdarezka, sizeof(pizdarezka), "INSERT INTO `"Houses"` (`hID`, `hOwned`, `hOwner`, `hEnterX`, `hEnterY`, `hEnterZ`, `hExitX`, `hExitY`, `hExitZ`, `hCarX`, `hCarY`, `hCarZ`, `hCarFA`, `SafeX`, `SafeY`, `SafeZ`, `SafeFA`, `ShkafX`, `ShkafY`, `ShkafZ`, `ShkafFA`, `HoloX`, `HoloY`, `HoloZ`, `HoloFA`, `hLevel`, `hPrice`, `hLock`, `hTakings`, `hInt`, `hHel`, `hClass`, `hIconID`, `hPickupID`, `hTextID`) VALUES ('%d', '%d', '%e', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%e')",
z,
HouseInfo[hid][hOwned],
HouseInfo[hid][hOwner],
HouseInfo[hid][hEnterX],
HouseInfo[hid][hEnterY],
HouseInfo[hid][hEnterZ],
HouseInfo[hid][hExitX],
HouseInfo[hid][hExitY],
HouseInfo[hid][hExitZ],
HouseInfo[hid][hCarX],
HouseInfo[hid][hCarY],
HouseInfo[hid][hCarZ],
HouseInfo[hid][hCarFA],
HouseInfo[hid][SafeX],
HouseInfo[hid][SafeY],
HouseInfo[hid][SafeZ],
HouseInfo[hid][SafeFA],
HouseInfo[hid][ShkafX],
HouseInfo[hid][ShkafY],
HouseInfo[hid][ShkafZ],
HouseInfo[hid][ShkafFA],
HouseInfo[hid][HoloX],
HouseInfo[hid][HoloY],
HouseInfo[hid][HoloZ],
HouseInfo[hid][HoloFA],
HouseInfo[hid][hLevel],
HouseInfo[hid][hPrice],
HouseInfo[hid][hLock],
HouseInfo[hid][hTakings],
HouseInfo[hid][hInt],
HouseInfo[hid][hHel],
HouseInfo[hid][hClass],
HouseInfo[hid][hClass], //updates
HouseInfo[hid][hIconID],
HouseInfo[hid][hPickupID],
HouseInfo[hid][hOwner] //textid
);

[pap04ka]

Можно удалять, Tracker1 помог. Спасибо ему :dance4:

[Osetin]

Можно удалять, Tracker1 помог. Спасибо ему :dance4:

Так объясните решение,может кому понадобиться!

[pap04ka]

'%d' лишняя была

[bredvix]

Закрыто.