Unknown Error

Incorrect integer value: '' for column `atrium`.`projects_categories`.`show` at row 1 (1366) :: INSERT INTO `projects_categories` (`order`,`show`) VALUES ('1','')

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

Url/Visitor

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

Mozilla/5.0 (X11; Linux x86_64; rv:126.0) Gecko/20100101 Firefox/126.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

/mnt/devel/Atrium/atriumstudio/vendor/onionCMS/Modules/Projects/Controllers/AdminProjectsCategoryController.php ▾ (218) → onionCMS\Modules\Projects\Models\ProjectsCategoryModel->save(args ▾)

  199 			$where[] = array('projects_categories_contents.language', 1);
  200 			$where[] = array('projects_categories.id', $formData['id']);
  201 		}
  202 
  203 		try {
  204 			$projectsCategoryModel = $this->services->getFactory('projectsCategoryModel')->create($where);
  205 
  206 		} catch (\Onion\Database\ModelException $e) {
  207 			$this->returnToManage($e->getMessage(), 'error');
  208 		}
  209 
  210 		$projectsCategoryModel['show'] = $formData['show'];
  211 		$projectsCategoryModel['order'] = $formData['order'];
  212 
  213 		foreach ($formData['language'] as $languageId => $languageData) {
  214 			$projectsCategoryModel['language'] = $languageId;
  215 			$projectsCategoryModel['name'] = $languageData['name'];
  216 			$projectsCategoryModel['description'] = $languageData['description'];
  217 
  218 			$projectsCategoryModel->save();
  219 		}
  220 
  221 		$this->app->addFlash('Kategória bola uložená.');
  222 
  223 		if ($this->app->request->isAjax() === true
  224 			OR $return === true) {
  225 
  226 			return;
  227 		}
  228

array (
)

/mnt/devel/Atrium/atriumstudio/vendor/Onion/UI/Form.php ▾ (391) → call_user_func_array(args ▾)

  372 			}
  373 
  374 			$this->submitter = $button;
  375 
  376 			$arguments = array($this->getValues());
  377 			if (count($button['on_click']) === 4) {
  378 				$args = (array) array_pop($button['on_click']);
  379 				$arguments = array_merge($arguments, $args);
  380 			}
  381 
  382 			$onValidForm = true;
  383 			if (count($button['on_click']) === 3) {
  384 				$onValidForm = array_pop($button['on_click']);
  385 			}
  386 
  387 			if (($this->isValid === true
  388 				AND $onValidForm === true)
  389 				OR $onValidForm === false) {
  390 
  391 				call_user_func_array($button['on_click'], $arguments);
  392 			}
  393 		}
  394 	}
  395 
  396 	/**
  397 	 * Metóda na uloženie aktuálneho prvku do poľa s prvkami formulára
  398 	 * a vytvorenie nového prázdneho aktuálneho prvku
  399 	 *
  400 	 * @return void
  401 	 */

array (
  0 => 
  array (
    0 => 'object (onionCMS\\Modules\\Projects\\Controllers\\AdminProjectsCategoryController)',
    1 => 'save',
  ),
  1 => 
  array (
    0 => 
    array (
      'id' => '',
      'tab' => 'english',
      'show' => 'false',
      'order' => '1',
      'language' => 
      array (
        1 => 
        array (
          'name' => 'abc',
          'description' => '',
        ),
        2 => 
        array (
          'name' => 'abc',
          'description' => '',
        ),
      ),
    ),
  ),
)

/mnt/devel/Atrium/atriumstudio/vendor/Onion/UI/Form.php ▾ (763) → Onion\UI\Form->onSubmit(args ▾)

  744 				}
  745 			}
  746 
  747 			if (\Onion\Utils\Validators::isEmpty($element['value']) === true
  748 				AND $required === false
  749 				AND $ruleName !== 'callback') {
  750 
  751 				$element['error'] = null;
  752 				$validElement = true;
  753 			}
  754 
  755 			if ($validElement === false) {
  756 				$valid = false;
  757 			}
  758 		}
  759 
  760 		$this->isValid = $valid;
  761 
  762 		if ($this->isSubmitted() === true) {
  763 			$this->onSubmit();
  764 		}
  765 
  766 		return $valid;
  767 	}
  768 
  769 	/**
  770 	 * Metóda na overenie hodnoty položky pomocou vlastnej funkcie
  771 	 *
  772 	 * @param  array        metóda na overenie
  773 	 * @param  mixed        hodnota na overenie

array (
)

/mnt/devel/Atrium/atriumstudio/vendor/Onion/UI/Form.php ▾ (531) → Onion\UI\Form->validate(args ▾)

  512 			if (count($keys) === 1) {
  513 				$values[$element['name']] = $element['value'];
  514 
  515 			} else {
  516 				$v = &$values;
  517 				foreach ($keys as $key) {
  518 					$v = &$v[$key];
  519 				}
  520 
  521 				$v = $element['value'];
  522 			}
  523 		}
  524 
  525 		unset($values['token']);
  526 		return $values;
  527 	}
  528 
  529 	public function open($echo = true)
  530 	{
  531 		$this->validate();
  532 
  533 		$anchor = '';
  534 		if ($this->anchor !== null) {
  535 			$anchor = '#'.$this->anchor;
  536 		}
  537 
  538 		$out = '<form action="'.$this->action.$anchor.'" method="'.$this->method.'"';
  539 
  540 		if (empty($this->class) === false) {
  541 			$class = implode(' ', (array) $this->class);

array (
)

/mnt/devel/Atrium/atriumstudio/vendor/Onion/UI/Form.php ▾ (951) → Onion\UI\Form->open(args ▾)

  932 				$js .= '},'."\n";
  933 			}
  934 
  935 			$js = trim($js, ",\n")."\n";
  936 			$js .= '],'."\n";
  937 		}
  938 
  939 		$js = trim($js, ",\n");
  940 		$js .= '}'."\n";
  941 		$js .= '});'."\n";
  942 		$js .= '});'."\n";
  943 
  944 		return $js;
  945 	}
  946 
  947 	public function getArrayCopy()
  948 	{
  949 		$array = array();
  950 
  951 		$array['open'] = $this->open(false);
  952 		$array['close'] = $this->close(false);
  953 		$array['buttons'] = $this->buttons;
  954 
  955 		$elements = array();
  956 		$fieldsets = array();
  957 		$hidden = array();
  958 
  959 		foreach ($this->elements as $element) {
  960 			$attributes = array();
  961 			if (isset($element['attributes']) === true) {

array (
  0 => 'false',
)

/mnt/devel/Atrium/atriumstudio/vendor/onionCMS/Modules/Projects/Controllers/AdminProjectsCategoryController.php ▾ (169) → Onion\UI\Form->getArrayCopy(args ▾)

  150 			'on_click' => array($this, 'save'),
  151 			'class' => $saveClass
  152 			));
  153 
  154 		$form->addButton(array(
  155 			'name' => 'saveClose',
  156 			'value' => 'Uložiť a koniec',
  157 			'type' => 'submit',
  158 			'on_click' => array($this, 'saveClose')
  159 			));
  160 
  161 		$form->addButton(array(
  162 			'name' => 'close',
  163 			'value' => 'Koniec',
  164 			'type' => 'submit',
  165 			'on_click' => array($this, 'close', false)
  166 			));
  167 
  168 		$this->view['title'] = 'Kategória :: ' . $projectsCategoryModel['name'];
  169 		$this->view['form'] = $form->getArrayCopy();
  170 		$this->services->onionCMS->assets->js($this->view['form']['js']);
  171 
  172 		if ($this->app->request->isAjax() === false) {
  173 			foreach ($this->view['form']['errors'] as $error) {
  174 				$this->app->addFlash($error, 'error', 'current');
  175 			}
  176 
  177 			return;
  178 		}
  179

array (
)

/mnt/devel/Atrium/atriumstudio/vendor/onionCMS/Modules/Projects/Controllers/AdminProjectsCategoryController.php ▾ (46) → onionCMS\Modules\Projects\Controllers\AdminProjectsCategoryController->edit(args ▾)

   27 		$grid->addColumn('order', 'Poradie');
   28 		$grid->addColumn('show', 'Zobrazovať', array('select', $show), array($this->services->filters, 'bool'));
   29 
   30 		$grid->addAction('<i class="icon icon-pencil"></i>', 'adminEditProjectsCategory', 'Upraviť');
   31 		$grid->addAction('<i class="icon icon-trash"></i>', 'adminDeleteProjectsCategory', 'Zmazať');
   32 
   33 		$grid->addMultiaction('<i class="icon icon-trash"></i> Zmazať', array($this, 'deleteMulti'));
   34 
   35 		$this->view['title'] = 'Kategórie projektov';
   36 		$this->view['grid'] = $grid->getArrayCopy();
   37 
   38 		$this->view['new_item_text'] = 'Pridať kategóriu';
   39 		$url = $this->app->router->createUrl('adminCreateProjectsCategory');
   40 		$this->view['new_item_url'] = $url;
   41 	}
   42 
   43 
   44 	public function create()
   45 	{
   46 		$this->edit(null);
   47 	}
   48 
   49 
   50 	public function edit($projectsCategoryId)
   51 	{
   52 		$this->view->setTemplate(ONIONCMS_DIR.'/Core/Templates/Edit.html');
   53 
   54 		$where = array();
   55 
   56 		if ($projectsCategoryId !== null) {

array (
  0 => 'NULL',
)

/mnt/devel/Atrium/atriumstudio/vendor/Onion/Application/Application.php ▾ (170) → call_user_func_array(args ▾)

  151 
  152 		if ($this->actionName === null) {
  153 			$this->actionName = $this->currentRoute->action;
  154 		}
  155 		preg_match('/([A-Za-z0-9]+)Controller/', $this->controllerName, $match);
  156 		if (isset($match[1]) === true) {
  157 			$view->setTemplate(APP_DIR.'/Templates/'.$match[1].'.html');
  158 		}
  159 
  160 		$this->controller = new $this->controllerName($this->container);
  161 
  162 		$parameters = $this->currentRoute->getResource();
  163 
  164 		$this->runHooks('system.hooks.afterCreateController');
  165 
  166 		call_user_func_array(array($this->controller, 'before'), $parameters);
  167 
  168 		$this->runHooks('system.hooks.beforeControllerRun');
  169 
  170 		call_user_func_array(array($this->controller, $this->actionName), $parameters);
  171 
  172 		$this->runHooks('system.hooks.afterControllerRun');
  173 
  174 		call_user_func_array(array($this->controller, 'after'), $parameters);
  175 
  176 		if (is_object($this->controller->view) === true) {
  177 			$view['flash'] = $this->flash['current'];
  178 
  179 			$this->runHooks('system.hooks.beforeRenderView');
  180

array (
  0 => 
  array (
    0 => 'object (onionCMS\\Modules\\Projects\\Controllers\\AdminProjectsCategoryController)',
    1 => 'create',
  ),
  1 => 
  array (
  ),
)

/mnt/devel/Atrium/atriumstudio/vendor/onionCMS/bootstrap.dev.php ▾ (151) → Onion\Application->run(args ▾)

  132 				WWW_DIR.'/js/vendor/cookie.js',
  133 				WWW_DIR.'/js/vendor/scroll-top.js',
  134 				),
  135 			'less' => array(
  136 				)
  137 			),
  138 		'after' => array(
  139 			'js' => array(
  140 				WWW_DIR.'/js/main.js',
  141 				),
  142 			'less' => array(
  143 				WWW_DIR.'/less/main.less'
  144 				)
  145 			)
  146 		)
  147 	);
  148 
  149 $app = new \Onion\Application($configuration);
  150 
  151 $app->run();
  152 exit;

array (
)

/mnt/devel/Atrium/atriumstudio/www_root/index.php ▾ (32) → require(args ▾)

   13 // absolute filesystem path to the libraries
   14 define('LIBS_DIR', realpath(WWW_DIR.'/../vendor'));
   15 
   16 // absolute filesystem path to the web root
   17 define('ONION_DIR', LIBS_DIR.'/Onion');
   18 
   19 // absolute filesystem path to the application root
   20 define('APP_DIR', WWW_DIR.'/../app');
   21 
   22 // absolute filesystem path to the temporary files
   23 define('TEMP_DIR', realpath(WWW_DIR.'/../temp'));
   24 
   25 // absolute filesystem path to the cache
   26 define('CACHE_DIR', realpath(WWW_DIR.'/../cache'));
   27 
   28 define('ONIONCMS_DIR', realpath(ONION_DIR.'/../onionCMS'));
   29 
   30 // load bootstrap file
   31 if ($_SERVER["SERVER_ADDR"] === "127.0.0.1") {
   32 	require ONIONCMS_DIR.'/bootstrap.dev.php';
   33 } else {
   34 	require ONIONCMS_DIR.'/bootstrap.php';
   35 }

array (
  0 => '/mnt/devel/Atrium/atriumstudio/vendor/onionCMS/bootstrap.dev.php',
)

$_SERVER

array (
  'REDIRECT_STATUS' => '200',
  'HTTP_HOST' => 'www.atriumarchitekti.loc',
  'HTTP_USER_AGENT' => 'Mozilla/5.0 (X11; Linux x86_64; rv:126.0) Gecko/20100101 Firefox/126.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' => '196',
  'HTTP_ORIGIN' => 'http://www.atriumarchitekti.loc',
  'HTTP_CONNECTION' => 'keep-alive',
  'HTTP_REFERER' => 'http://www.atriumarchitekti.loc/admin/project-category/create',
  'HTTP_COOKIE' => 'language=sk; cookieconsent_dismissed=yes; ws56trt87dfgxzaq=YVNDWVpIYlFtZ2h1dlFtWE5nV09INkkwUFE4V3FMNGMzUmRjNFRXMXp1ejVjUU81Mm50WVhqMEs0TVd1Y3BYdm83TTRDTUd1OTI0RitPeXZZeGc4UDkraWxZWlBQbzNPOUNhZys2YmtQdVhBWjVzVHY2RHVqYkZWeUUwRkhqbHZzUHpVK3pVVUNHSDAzbThiRmx2MXowenR5a3JRMW9iSXI0U1MxSXEvQkJKcTdWMGFvcTlnbFdFeDZBRVNXZHB1MzIzZkc0VU0vWnVIYVV0VW5vWFQzTlVIMmprWWxDT0Z6YnVlMGtObnNMT3MyVVIvMzl2TmhEckduNkEybXZFZnVySy9RT1FDT2VzPTFjMjgzYzUx; qazfdrtygdfxsw=olaiin58tj630tkgkhgku1r3mp',
  'HTTP_UPGRADE_INSECURE_REQUESTS' => '1',
  'HTTP_PRIORITY' => 'u=1',
  'HTTP_PRAGMA' => 'no-cache',
  'HTTP_CACHE_CONTROL' => 'no-cache',
  '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' => '45520',
  'REDIRECT_URL' => '/admin/project-category/create',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'SERVER_PROTOCOL' => 'HTTP/1.1',
  'REQUEST_METHOD' => 'POST',
  'QUERY_STRING' => '',
  'REQUEST_URI' => '/admin/project-category/create',
  'SCRIPT_NAME' => '/index.php',
  'PHP_SELF' => '/index.php',
  'REQUEST_TIME_FLOAT' => 1717743071.351,
  'REQUEST_TIME' => 1717743071,
)

$_POST

array (
  'order' => '1',
  'language' => 
  array (
    1 => 
    array (
      'name' => 'abc',
      'description' => '',
    ),
    2 => 
    array (
      'name' => 'abc',
      'description' => '',
    ),
  ),
  'token' => '022d923986d0dcd657682cf9aeac67bf',
  'id' => '',
  'tab' => 'english',
  'save' => '',
)

$_GET

array (
)