Errors

Database Error

Error: SQLSTATE[HY000]: General error: 1364 Field 'shortdes_eg' doesn't have a default value

SQL Query: INSERT INTO `safewindow_db`.`products` (`view`, `modified`, `created`) VALUES (1, '2025-05-06', '2025-05-06')

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace

CORE/Cake/Model/Datasource/DboSource.php line 461 → PDOStatement->execute(array)

        try {
            $query = $this->_connection->prepare($sql, $prepareOptions);
            $query->setFetchMode(PDO::FETCH_LAZY);
            if (!$query->execute($params)) {
                $this->_results = $query;

array()

CORE/Cake/Model/Datasource/DboSource.php line 427 → DboSource->_execute(string, array)

        $options += array('log' => $this->fullDebug);

        $t = microtime(true);
        $this->_result = $this->_execute($sql, $params);

'INSERT INTO `safewindow_db`.`products` (`view`, `modified`, `created`) VALUES (1, '2025-05-06', '2025-05-06')'
array()

CORE/Cake/Model/Datasource/DboSource.php line 1009 → DboSource->execute(string)

            'values' => implode(', ', $valueInsert)
        );

        if ($this->execute($this->renderStatement('create', $query))) {
            if (empty($id)) {

'INSERT INTO `safewindow_db`.`products` (`view`, `modified`, `created`) VALUES (1, '2025-05-06', '2025-05-06')'

CORE/Cake/Model/Model.php line 1730 → DboSource->create(Product, array, array)

                    }
                }

                if (!$db->create($this, $fields, $values)) {
                    $success = $created = false;

object(Product) {
	name => 'Product'
	displayField => 'name'
	useDbConfig => 'default'
	useTable => 'products'
	id => false
	data => array(
		[maximum depth reached]
	)
	schemaName => 'safewindow_db'
	table => 'products'
	primaryKey => 'id'
	validate => array([maximum depth reached])
	validationErrors => array([maximum depth reached])
	validationDomain => null
	tablePrefix => ''
	alias => 'Product'
	tableToModel => array(
		[maximum depth reached]
	)
	cacheQueries => false
	belongsTo => array([maximum depth reached])
	hasOne => array([maximum depth reached])
	hasMany => array([maximum depth reached])
	hasAndBelongsToMany => array([maximum depth reached])
	actsAs => null
	Behaviors => object(BehaviorCollection) {}
	whitelist => array(
		[maximum depth reached]
	)
	cacheSources => true
	findQueryType => null
	recursive => (int) 1
	order => null
	virtualFields => array([maximum depth reached])
	__backAssociation => array([maximum depth reached])
	__backInnerAssociation => array([maximum depth reached])
	__backOriginalAssociation => array([maximum depth reached])
	__backContainableAssociation => array([maximum depth reached])
	findMethods => array(
		[maximum depth reached]
	)
}
array(
	(int) 0 => 'view',
	(int) 1 => 'modified',
	(int) 2 => 'created'
)
array(
	(int) 0 => (int) 1,
	(int) 1 => '2025-05-06',
	(int) 2 => '2025-05-06'
)

CORE/Cake/Model/Model.php line 1582 → Model->save(array, array)

        } else {
            $options = array('validate' => $validate, 'fieldList' => array($name));
        }
        return $this->save(array($this->alias => array($this->primaryKey => $id, $name => $value)), $options);
    }

array(
	'Product' => array(
		'id' => null,
		'view' => (int) 1
	)
)
array(
	'validate' => false,
	'fieldList' => array(
		(int) 0 => 'view'
	)
)

APP/Controller/ProductController.php line 144 → Model->saveField(string, integer)

        $nen=$this->Product->findById($id);
        $this->Product->id=$id;
        $view=++$nen['Product']['view'];
        $this->Product->saveField('view',$view);

'view'
(int) 1

[internal function] → ProductController->detail(string)
```
'truyen-thong'
```

CORE/Cake/Controller/Controller.php line 485 → ReflectionMethod->invokeArgs(ProductController, array)

                    'action' => $request->params['action']
                ));
            }
            return $method->invokeArgs($this, $request->params['pass']);

object(ProductController) {
	name => 'Product'
	uses => array(
		[maximum depth reached]
	)
	helpers => array([maximum depth reached])
	request => object(CakeRequest) {}
	response => object(CakeResponse) {}
	viewPath => 'Product'
	layoutPath => null
	viewVars => array(
		[maximum depth reached]
	)
	view => 'detail'
	layout => 'product'
	autoRender => true
	autoLayout => true
	Components => object(ComponentCollection) {}
	components => array(
		[maximum depth reached]
	)
	viewClass => 'View'
	View => null
	ext => '.ctp'
	plugin => null
	cacheAction => false
	passedArgs => array(
		[maximum depth reached]
	)
	scaffold => false
	methods => array(
		[maximum depth reached]
	)
	modelClass => 'Catproduct'
	modelKey => 'product'
	validationErrors => null
	Session => object(SessionComponent) {}
	News => object(News) {}
	Video => object(Video) {}
	Product => object(Product) {}
	Catproduct => object(Catproduct) {}
}
array(
	(int) 0 => 'truyen-thong'
)

CORE/Cake/Routing/Dispatcher.php line 186 → Controller->invokeAction(CakeRequest)

        $controller->startupProcess();

        $render = true;
        $result = $controller->invokeAction($request);
        if ($result instanceof CakeResponse) {

object(CakeRequest) {
	params => array(
		[maximum depth reached]
	)
	data => array([maximum depth reached])
	query => array([maximum depth reached])
	url => 'truyen-thong'
	base => ''
	webroot => '/'
	here => '/truyen-thong'
}

CORE/Cake/Routing/Dispatcher.php line 161 → Dispatcher->_invoke(ProductController, CakeRequest, CakeResponse)

            ));
        }

        $response = $this->_invoke($controller, $request, $response);
        if (isset($request->params['return'])) {

object(ProductController) {
	name => 'Product'
	uses => array(
		[maximum depth reached]
	)
	helpers => array([maximum depth reached])
	request => object(CakeRequest) {}
	response => object(CakeResponse) {}
	viewPath => 'Product'
	layoutPath => null
	viewVars => array(
		[maximum depth reached]
	)
	view => 'detail'
	layout => 'product'
	autoRender => true
	autoLayout => true
	Components => object(ComponentCollection) {}
	components => array(
		[maximum depth reached]
	)
	viewClass => 'View'
	View => null
	ext => '.ctp'
	plugin => null
	cacheAction => false
	passedArgs => array(
		[maximum depth reached]
	)
	scaffold => false
	methods => array(
		[maximum depth reached]
	)
	modelClass => 'Catproduct'
	modelKey => 'product'
	validationErrors => null
	Session => object(SessionComponent) {}
	News => object(News) {}
	Video => object(Video) {}
	Product => object(Product) {}
	Catproduct => object(Catproduct) {}
}
object(CakeRequest) {
	params => array(
		[maximum depth reached]
	)
	data => array([maximum depth reached])
	query => array([maximum depth reached])
	url => 'truyen-thong'
	base => ''
	webroot => '/'
	here => '/truyen-thong'
}
object(CakeResponse) {
	
}

APP/webroot/index.php line 92 → Dispatcher->dispatch(CakeRequest, CakeResponse)

App::uses('Dispatcher', 'Routing');

$Dispatcher = new Dispatcher();
$Dispatcher->dispatch(new CakeRequest(), new CakeResponse(array('charset' => Configure::read('App.encoding'))));

object(CakeRequest) {
	params => array(
		[maximum depth reached]
	)
	data => array([maximum depth reached])
	query => array([maximum depth reached])
	url => 'truyen-thong'
	base => ''
	webroot => '/'
	here => '/truyen-thong'
}
object(CakeResponse) {
	
}