Unknown Error

Incorrect integer value: '' for column `atrium`.`projects`.`order` 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:34:22','2024-07-03 22:34:22',null,'2000','2000','','','','','123','0','','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' => '1252',
  '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=YmFWUDNnLzUvOVp0OWVENnBzZVlZM2ZSUVQ2Z2dya1EvL3Y0Vm4ySmFwYmhJYW9vdXJhdkM2WkNmclhBN29PeHowMHY0RVBMd1ZMVnNtRW4yZWk5NXd0Tm9ZNXZILzlaVXNFTlovNjA3TEx0ek53amF6TFFpSGpsUTIrRFdnRkRlZ2VrNmk4Si9KeGNtSk9nYXJ0QU1MOWNLRUtSdUhxb0JNMUhBUEVpSUFjVVhrOTFwQ0JjeXd5cXhaNDNXTXNUcVlrNWh3WXhwNy9kZEkyU1dKUVF5TTVMcDN2QUx0WlZNUEE2SXYvQlBpWHY2WXFTTVdXWUZVeXFpcGEwcDBxeFRhWVd1ak83MVE0PTIyMWRjZTkw',
  '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' => '37758',
  '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' => 1720038862.427,
  'REQUEST_TIME' => 1720038862,
)

$_POST

array (
  'year_launch' => '2000',
  'year_completition' => '2000',
  'authors' => '',
  'collaborators' => '',
  'buildup_area' => '123',
  'costs' => '0',
  '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 (
)