Ошибка добавления объекта

Статус
В этой теме нельзя размещать новые ответы.
ITyleR, а какая версия системы? Может стоит обновиться до последней версии?
 
у тебя случаем нет в списки ни какого знака ? в районе где код обрезается
 
у тебя случаем нет в списки ни какого знака ? в районе где код обрезается
Нажмите для раскрытия...
Да нет, нету. Да если б и были, то не работало бы ни в альтернативной ни в стандартной форме.
 
Подскажите плз как что это за ошибка и как исправить?\

PHP: 
SQL/DB Error

Array
(
    [0] => Array
        (
            [error_str] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `btmrast` = NULL, `metro` = NULL, `rentsale` = "0", `metrokm` = NULL, `metromin' at line 1
            [query] => UPDATE Message98 SET `region` = NULL, `oblast` = NULL, `disoblast` = NULL, `district` = NULL, `street` = "Коцюбинского", `btm` = NULL, `house` = "", `btmr` = , `btmrast` = NULL, `metro` = NULL, `rentsale` = "0", `metrokm` = NULL, `metromin` = NULL, `podput` = 0, `podput1` = 0, `podput2` = 0, `podput3` = 0, `gd` = 1, `gd1` = NULL, `vt` = 0, `vt1` = NULL, `aero` = NULL, `dopminf` = "", `otvhran` = 0, `name` = "", `typeneprofsklad` = NULL, `typeneprofsklad1` = 0, `uobject` = "", `var1` = 1, `var2` = 0, `var3` = 1, `var4` = 0, `var5` = 0, `var6` = 0, `var7` = 0, `var8` = 0, `etag` = 0, `etag1` = 0, `etag2` = 0, `etag3` = "", `fond` = NULL, `dbiznes` = 0, `areajurland` = "", `sostarealand` = "", `park1` = 0, `park2` = 1, `park3` = 0, `park4` = 0, `park5` = 0, `park6` = 0, `park7` = 0, `park8` = 0, `doppark` = "", `park9` = 0, `etap` = NULL, `etap1` = 0, `areaallreal` = 900, `areaot` = NULL, `areado` = NULL, `areaindust` = NULL, `areasklad` = NULL, `areaoffice` = NULL, `timebuild` = NULL, `floor` = NULL, `material` = NULL, `stan` = NULL, `height` = 8, `pol` = NULL, `pol1` = 0, `pol2` = 0, `pol3` = "", `water` = "", `gaz` = "", `kanalization` = "", `electrosnab` = "Есть", `schet` = "", `otop` = NULL, `otop1` = 0, `otop4` = 0, `otop2` = 0, `otop3` = 0, `ventilation1` = 0, `ventilation2` = 0, `ventilation3` = 0, `ventilation4` = 0, `ventilation5` = 0, `temperatura` = "", `temperaturaot` = NULL, `temperaturado` = NULL, `rampan1` = 0, `rampan2` = 0, `rampan3` = 0, `rampan4` = 0, `rampan5` = 0, `rampan6` = 0, `oborud1` = 0, `oborud2` = 0, `oborud3` = 0, `oborud4` = 0, `oborud5` = 0, `oborud6` = 0, `oborud7` = 0, `oborud8` = 0, `oborud8kol` = NULL, `oborud8gp` = NULL, `telefon` = 0, `telefon1` = NULL, `telefon2` = 0, `ats` = NULL, `internet` = NULL, `optical` = 0, `ohrana1` = 1, `ohrana2` = 0, `ohrana3` = 0, `ohrana4` = 0, `ohrana5` = 0, `ohrana6` = 0, `ohrana7` = 0, `ohrana8` = 0, `ohrana9` = 0, `ohrana10` = 0, `ohrana11` = 0, `sobstvennik` = NULL, `dopreal` = "", `pricepalletom1` = NULL, `pricepalletom2` = NULL, `pricerps` = NULL, `pricerot` = NULL, `pricerall` = NULL, `nds` = NULL, `predprice` = NULL, `renttypeneprof` = NULL, `rentdata` = 0, `rentdata1` = 0, `month` = NULL, `year` = NULL, `and1` = 0, `and2` = 0, `and3` = 0, `and4` = 0, `and5` = 0, `and6` = 0, `and8` = 0, `and7` = 0, `and9` = 0, `doprent` = "", `prod` = NULL, `prod1` = NULL, `nds1` = NULL, `prod2` = "", `prod3` = "", `proddop1` = 0, `proddop2` = 0, `proddop3` = 0, `proddop4` = 0, `proddop5` = 0, `proddop6` = 0, `proddop7` = 0, `dopproddop` = "", `usovd` = "", `status` = 3, `statusname` = "АН \"Мегаполис\"", `dopstatus` = "", `fio` = "", `post` = "", `mail` = "80978878886@ukr.net", `tel` = "332-8483, 8-097-887-8886", `fax` = "", `site` = "", `dop42` = "", `img` = "1.gif:image/gif:172781", `img1` = "2.gif:image/gif:142911", `img2` = "", `img3` = "", `img4` = "", `img5` = "", `imgmedium` = "", `imgmedium1` = "", `imgmedium2` = "", `imgmedium3` = "", `imgmedium4` = "", `imgmedium5` = "", `holtep` = NULL, `coordinates` = "", `imgsmall` = "", `imgsmall1` = "", `imgsmall2` = "", `imgsmall3` = "", `imgsmall4` = "", `imgsmall5` = "",  Checked=0, Keyword='',LastUser_ID=1, LastIP="93.175.237.45",LastUserAgent="Mozilla/5.0 (Windows; U; Windows NT 5.1; ru; rv:1.9.0.12) Gecko/2009070611 Firefox/3.0.12" WHERE Message_ID='10'
        )

)


Type: Array
Last Query [28]: UPDATE Message98 SET `region` = NULL, `oblast` = NULL, `disoblast` = NULL, `district` = NULL, `street` = "Коцюбинского", `btm` = NULL, `house` = "", `btmr` = , `btmrast` = NULL, `metro` = NULL, `rentsale` = "0", `metrokm` = NULL, `metromin` = NULL, `podput` = 0, `podput1` = 0, `podput2` = 0, `podput3` = 0, `gd` = 1, `gd1` = NULL, `vt` = 0, `vt1` = NULL, `aero` = NULL, `dopminf` = "", `otvhran` = 0, `name` = "", `typeneprofsklad` = NULL, `typeneprofsklad1` = 0, `uobject` = "", `var1` = 1, `var2` = 0, `var3` = 1, `var4` = 0, `var5` = 0, `var6` = 0, `var7` = 0, `var8` = 0, `etag` = 0, `etag1` = 0, `etag2` = 0, `etag3` = "", `fond` = NULL, `dbiznes` = 0, `areajurland` = "", `sostarealand` = "", `park1` = 0, `park2` = 1, `park3` = 0, `park4` = 0, `park5` = 0, `park6` = 0, `park7` = 0, `park8` = 0, `doppark` = "", `park9` = 0, `etap` = NULL, `etap1` = 0, `areaallreal` = 900, `areaot` = NULL, `areado` = NULL, `areaindust` = NULL, `areasklad` = NULL, `areaoffice` = NULL, `timebuild` = NULL, `floor` = NULL, `material` = NULL, `stan` = NULL, `height` = 8, `pol` = NULL, `pol1` = 0, `pol2` = 0, `pol3` = "", `water` = "", `gaz` = "", `kanalization` = "", `electrosnab` = "Есть", `schet` = "", `otop` = NULL, `otop1` = 0, `otop4` = 0, `otop2` = 0, `otop3` = 0, `ventilation1` = 0, `ventilation2` = 0, `ventilation3` = 0, `ventilation4` = 0, `ventilation5` = 0, `temperatura` = "", `temperaturaot` = NULL, `temperaturado` = NULL, `rampan1` = 0, `rampan2` = 0, `rampan3` = 0, `rampan4` = 0, `rampan5` = 0, `rampan6` = 0, `oborud1` = 0, `oborud2` = 0, `oborud3` = 0, `oborud4` = 0, `oborud5` = 0, `oborud6` = 0, `oborud7` = 0, `oborud8` = 0, `oborud8kol` = NULL, `oborud8gp` = NULL, `telefon` = 0, `telefon1` = NULL, `telefon2` = 0, `ats` = NULL, `internet` = NULL, `optical` = 0, `ohrana1` = 1, `ohrana2` = 0, `ohrana3` = 0, `ohrana4` = 0, `ohrana5` = 0, `ohrana6` = 0, `ohrana7` = 0, `ohrana8` = 0, `ohrana9` = 0, `ohrana10` = 0, `ohrana11` = 0, `sobstvennik` = NULL, `dopreal` = "", `pricepalletom1` = NULL, `pricepalletom2` = NULL, `pricerps` = NULL, `pricerot` = NULL, `pricerall` = NULL, `nds` = NULL, `predprice` = NULL, `renttypeneprof` = NULL, `rentdata` = 0, `rentdata1` = 0, `month` = NULL, `year` = NULL, `and1` = 0, `and2` = 0, `and3` = 0, `and4` = 0, `and5` = 0, `and6` = 0, `and8` = 0, `and7` = 0, `and9` = 0, `doprent` = "", `prod` = NULL, `prod1` = NULL, `nds1` = NULL, `prod2` = "", `prod3` = "", `proddop1` = 0, `proddop2` = 0, `proddop3` = 0, `proddop4` = 0, `proddop5` = 0, `proddop6` = 0, `proddop7` = 0, `dopproddop` = "", `usovd` = "", `status` = 3, `statusname` = "АН \"Мегаполис\"", `dopstatus` = "", `fio` = "", `post` = "", `mail` = "80978878886@ukr.net", `tel` = "332-8483, 8-097-887-8886", `fax` = "", `site` = "", `dop42` = "", `img` = "1.gif:image/gif:172781", `img1` = "2.gif:image/gif:142911", `img2` = "", `img3` = "", `img4` = "", `img5` = "", `imgmedium` = "", `imgmedium1` = "", `imgmedium2` = "", `imgmedium3` = "", `imgmedium4` = "", `imgmedium5` = "", `holtep` = NULL, `coordinates` = "", `imgsmall` = "", `imgsmall1` = "", `imgsmall2` = "", `imgsmall3` = "", `imgsmall4` = "", `imgsmall5` = "",  Checked=0, Keyword='',LastUser_ID=1, LastIP="93.175.237.45",LastUserAgent="Mozilla/5.0 (Windows; U; Windows NT 5.1; ru; rv:1.9.0.12) Gecko/2009070611 Firefox/3.0.12" WHERE Message_ID='10'
Last Function Call: $db->query("UPDATE Message98 SET `region` = NULL, `oblast` = NULL, `disoblast` = NULL, `district` = NULL, `street` = "Коцюбинского", `btm` = NULL, `house` = "", `btmr` = , `btmrast` = NULL, `metro` = NULL, `rentsale` = "0", `metrokm` = NULL, `metromin` = NULL, `podput` = 0, `podput1` = 0, `podput2` = 0, `podput3` = 0, `gd` = 1, `gd1` = NULL, `vt` = 0, `vt1` = NULL, `aero` = NULL, `dopminf` = "", `otvhran` = 0, `name` = "", `typeneprofsklad` = NULL, `typeneprofsklad1` = 0, `uobject` = "", `var1` = 1, `var2` = 0, `var3` = 1, `var4` = 0, `var5` = 0, `var6` = 0, `var7` = 0, `var8` = 0, `etag` = 0, `etag1` = 0, `etag2` = 0, `etag3` = "", `fond` = NULL, `dbiznes` = 0, `areajurland` = "", `sostarealand` = "", `park1` = 0, `park2` = 1, `park3` = 0, `park4` = 0, `park5` = 0, `park6` = 0, `park7` = 0, `park8` = 0, `doppark` = "", `park9` = 0, `etap` = NULL, `etap1` = 0, `areaallreal` = 900, `areaot` = NULL, `areado` = NULL, `areaindust` = NULL, `areasklad` = NULL, `areaoffice` = NULL, `timebuild` = NULL, `floor` = NULL, `material` = NULL, `stan` = NULL, `height` = 8, `pol` = NULL, `pol1` = 0, `pol2` = 0, `pol3` = "", `water` = "", `gaz` = "", `kanalization` = "", `electrosnab` = "Есть", `schet` = "", `otop` = NULL, `otop1` = 0, `otop4` = 0, `otop2` = 0, `otop3` = 0, `ventilation1` = 0, `ventilation2` = 0, `ventilation3` = 0, `ventilation4` = 0, `ventilation5` = 0, `temperatura` = "", `temperaturaot` = NULL, `temperaturado` = NULL, `rampan1` = 0, `rampan2` = 0, `rampan3` = 0, `rampan4` = 0, `rampan5` = 0, `rampan6` = 0, `oborud1` = 0, `oborud2` = 0, `oborud3` = 0, `oborud4` = 0, `oborud5` = 0, `oborud6` = 0, `oborud7` = 0, `oborud8` = 0, `oborud8kol` = NULL, `oborud8gp` = NULL, `telefon` = 0, `telefon1` = NULL, `telefon2` = 0, `ats` = NULL, `internet` = NULL, `optical` = 0, `ohrana1` = 1, `ohrana2` = 0, `ohrana3` = 0, `ohrana4` = 0, `ohrana5` = 0, `ohrana6` = 0, `ohrana7` = 0, `ohrana8` = 0, `ohrana9` = 0, `ohrana10` = 0, `ohrana11` = 0, `sobstvennik` = NULL, `dopreal` = "", `pricepalletom1` = NULL, `pricepalletom2` = NULL, `pricerps` = NULL, `pricerot` = NULL, `pricerall` = NULL, `nds` = NULL, `predprice` = NULL, `renttypeneprof` = NULL, `rentdata` = 0, `rentdata1` = 0, `month` = NULL, `year` = NULL, `and1` = 0, `and2` = 0, `and3` = 0, `and4` = 0, `and5` = 0, `and6` = 0, `and8` = 0, `and7` = 0, `and9` = 0, `doprent` = "", `prod` = NULL, `prod1` = NULL, `nds1` = NULL, `prod2` = "", `prod3` = "", `proddop1` = 0, `proddop2` = 0, `proddop3` = 0, `proddop4` = 0, `proddop5` = 0, `proddop6` = 0, `proddop7` = 0, `dopproddop` = "", `usovd` = "", `status` = 3, `statusname` = "АН \"Мегаполис\"", `dopstatus` = "", `fio` = "", `post` = "", `mail` = "80978878886@ukr.net", `tel` = "332-8483, 8-097-887-8886", `fax` = "", `site` = "", `dop42` = "", `img` = "1.gif:image/gif:172781", `img1` = "2.gif:image/gif:142911", `img2` = "", `img3` = "", `img4` = "", `img5` = "", `imgmedium` = "", `imgmedium1` = "", `imgmedium2` = "", `imgmedium3` = "", `imgmedium4` = "", `imgmedium5` = "", `holtep` = NULL, `coordinates` = "", `imgsmall` = "", `imgsmall1` = "", `imgsmall2` = "", `imgsmall3` = "", `imgsmall4` = "", `imgsmall5` = "",  Checked=0, Keyword='',LastUser_ID=1, LastIP="93.175.237.45",LastUserAgent="Mozilla/5.0 (Windows; U; Windows NT 5.1; ru; rv:1.9.0.12) Gecko/2009070611 Firefox/3.0.12" WHERE Message_ID='10'")
Last Rows Returned: 0
 
Провел еще такую манипуляцию..
Форма по умалчанию отлично работает, ошибок добавления не выдает. Скопировал код этой формы и вставил в альтернативную форму добавления.
Результат опять же - ошибка добавления объекта.
Почему?((
 
Встречалась подобная ошибка, давно. :-]
 
Проверь поле btmr. В запросе оно ни к чему не присваевается. Посмотри какой тип поля указан, попробуй пересоздать. Но это именно ошибка апдейта базы, к форме никакого отношения не имеет. Версия системы какая? И какая была первоначально.
 
x_Dev написал(а):
Проверь поле btmr. В запросе оно ни к чему не присваевается. Посмотри какой тип поля указан, попробуй пересоздать. Но это именно ошибка апдейта базы, к форме никакого отношения не имеет. Версия системы какая? И какая была первоначально.
Нажмите для раскрытия...

Огромное спасибо! Пересоздал поле, все заработало))
 
Статус
В этой теме нельзя размещать новые ответы.
Назад
Сверху