Unknown Error

Incorrect integer value: '' for column `atrium`.`projects`.`buildup_area` at row 1 (1366) :: INSERT INTO `projects` (`added`,`updated`,`mainphoto`,`year_launch`,`year_completition`,`authors`,`collaborators`,`location_gm_lng`,`location_gm_lat`,`buildup_area`,`costs`,`videos`,`show`,`show_on_main_page`,`show_on_teasers`,`web`,`order`,`location_gm_zoom`,`streetview_lat`,`streetview_lng`,`streetview_heading`,`streetview_pitch`,`streetview_zoom`,`streetview_show`) VALUES ('2024-07-03 22:33:04','2024-07-03 22:33:04',null,'2000','2000','','','','','','','','0','0','0','','','17','','','','','','0')

/mnt/devel/Atrium/atriumstudio/vendor/Onion/Database/Model.php

Url/Visitor

http://www.atriumarchitekti.loc/admin/project/create (POST)

Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0

Source

214
215 $this->db->table = $table;
216
217 $relations = $this->db->tableRelations;
218
219 if ($table !== $this->table) {
220 $column = array_search($this->table, $relations);
221
222 if ($column !== false) {
223 $data[$column] = $tables[$this->table][$this->primaryKey];
224 }
225 }
226
227 if (is_array($updateOnDuplicate) === false) {
228 $this->db->updateOnDuplicate = $updateOnDuplicate;
229 try {
230 $id = $this->db->insert($data);
231
232 } catch(\Onion\Database\DatabaseException $e) {
233 throw new \Onion\Database\ModelException($e->getMessage(), $e->getCode());
234 }
235
236 } else {
237 $this->db->where = $updateOnDuplicate;
238
239 try {
240 $this->db->update($data);
241 $id = $data['id'];
242
243 } catch(\Onion\Database\DatabaseException $e) {

Backtrace

$_SERVER

array (
  'REDIRECT_STATUS' => '200',
  'HTTP_HOST' => 'www.atriumarchitekti.loc',
  'HTTP_USER_AGENT' => 'Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0',
  'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8',
  'HTTP_ACCEPT_LANGUAGE' => 'sk,cs;q=0.8,en-US;q=0.5,en;q=0.3',
  'HTTP_ACCEPT_ENCODING' => 'gzip, deflate',
  'CONTENT_TYPE' => 'application/x-www-form-urlencoded',
  'CONTENT_LENGTH' => '1248',
  'HTTP_ORIGIN' => 'http://www.atriumarchitekti.loc',
  'HTTP_CONNECTION' => 'keep-alive',
  'HTTP_REFERER' => 'http://www.atriumarchitekti.loc/admin/project/create',
  'HTTP_COOKIE' => 'qazfdrtygdfxsw=jbahh4rnolvrtjqqsrocge1rss; language=sk; ws56trt87dfgxzaq=QVJFOUFIek1ZVnJGbUpVRGkrUG1xMVBKYjZpSVpDZXVuVUpzU1JWWUxNTDkydHkzSm1tZ09DYy9vRXNjekxzbzBtNnNsRTNicWRRM2VhZGFVSVk3d2xJTCswMFkxMTdGRm1RN05MYVk1aW5nNW9xWlFmci9qbnhvZFVHcHZOdzc4SGhMZkRrUWxUS0xBa1ZKVmh1Uzg5NzRWcmVkTXV5NGY3MDlLdzVrd1ZYdSs0UGZzRVkxMWZFaDJLRzllbk9PcHphbnlOY0JoaWZjKzJHMENUbTRhR0p5K2dEc3BKT2J2elAzMWlQTnV3ZEY1ZE9tc3lVMTIrYlRRUGtYUE1iZDlhSDltNHVzU3YwPTMwZTBiYTMy',
  'HTTP_UPGRADE_INSECURE_REQUESTS' => '1',
  'HTTP_PRIORITY' => 'u=1',
  'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin',
  'SERVER_SIGNATURE' => '<address>Apache/2.4.38 (Debian) Server at www.atriumarchitekti.loc Port 80</address>
',
  'SERVER_SOFTWARE' => 'Apache/2.4.38 (Debian)',
  'SERVER_NAME' => 'www.atriumarchitekti.loc',
  'SERVER_ADDR' => '127.0.0.1',
  'SERVER_PORT' => '80',
  'REMOTE_ADDR' => '127.0.0.1',
  'DOCUMENT_ROOT' => '/mnt/devel/Atrium/atriumstudio/www_root',
  'REQUEST_SCHEME' => 'http',
  'CONTEXT_PREFIX' => '',
  'CONTEXT_DOCUMENT_ROOT' => '/mnt/devel/Atrium/atriumstudio/www_root',
  'SERVER_ADMIN' => 'webmaster@localhost',
  'SCRIPT_FILENAME' => '/mnt/devel/Atrium/atriumstudio/www_root/index.php',
  'REMOTE_PORT' => '48648',
  'REDIRECT_URL' => '/admin/project/create',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'SERVER_PROTOCOL' => 'HTTP/1.1',
  'REQUEST_METHOD' => 'POST',
  'QUERY_STRING' => '',
  'REQUEST_URI' => '/admin/project/create',
  'SCRIPT_NAME' => '/index.php',
  'PHP_SELF' => '/index.php',
  'REQUEST_TIME_FLOAT' => 1720038784.108,
  'REQUEST_TIME' => 1720038784,
)

$_POST

array (
  'year_launch' => '2000',
  'year_completition' => '2000',
  'authors' => '',
  'collaborators' => '',
  'buildup_area' => '',
  'costs' => '',
  'videos' => '',
  'web' => '',
  'order' => '',
  'language' => 
  array (
    1 => 
    array (
      'name' => 'aaa',
      'description' => 'aaaa',
      'client' => '',
      'city' => '',
      'location' => '',
      'published' => '',
      'exhibitions' => '',
      'awards' => '',
      'note' => '',
    ),
    2 => 
    array (
      'name' => 'bbb',
      'description' => 'bbbb',
      'client' => '',
      'city' => '',
      'location' => '',
      'published' => '',
      'exhibitions' => '',
      'awards' => '',
      'note' => '',
    ),
  ),
  'categories' => 
  array (
    1 => 
    array (
      'order' => '',
    ),
    2 => 
    array (
      'order' => '',
    ),
    11 => 
    array (
      'order' => '',
    ),
    4 => 
    array (
      'order' => '',
    ),
    10 => 
    array (
      'order' => '',
    ),
    9 => 
    array (
      'order' => '',
    ),
    6 => 
    array (
      'order' => '',
    ),
    15 => 
    array (
      'order' => '',
    ),
    14 => 
    array (
      'order' => '',
    ),
    12 => 
    array (
      'order' => '',
    ),
    13 => 
    array (
      'order' => '',
    ),
  ),
  'gmaddress' => '',
  'token' => '1f786c003a417c094746bbe8a892a219',
  'id' => '',
  'mainphoto' => '',
  'tab' => 'zakladne-udaje',
  'photos' => '',
  'location_gm_lng' => '',
  'location_gm_lat' => '',
  'location_gm_zoom' => '',
  'streetview_lat' => '',
  'streetview_lng' => '',
  'streetview_heading' => '',
  'streetview_pitch' => '',
  'streetview_zoom' => '',
  'streetview_show' => '',
  'save' => '',
)

$_GET

array (
)