CakePHP: the rapid development php framework: Errors

Warning (512): SQL Error: 1048: Column 'domain_id' cannot be null [CORE/cake/libs/model/datasources/dbo_source.php, line 681]

Code | Context

            $out = null;
            if ($error) {
                trigger_error('<span style="color:Red;text-align:left"><b>' . __('SQL Error:', true) . "</b> {$this->error}</span>", E_USER_WARNING);

$sql	=	"INSERT INTO `hits` (`domain_id`, `date`, `ip`, `direct`, `referer`, `search`, `domain`) VALUES (NULL, '2010-09-04', '3810719193', 1, 0, 0, 0)"
$error	=	"1048: Column 'domain_id' cannot be null"
$out	=	null

DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 681
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 266
DboSource::create() - CORE/cake/libs/model/datasources/dbo_source.php, line 749
Model::save() - CORE/cake/libs/model/model.php, line 1341
DomainsController::index() - APP/controllers/domains_controller.php, line 51
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83

Missing View

Error: The view for DomainsController::index() was not found.

Error: Confirm you have created the file: /data/web/dnparking.sk/parking/app/views/templates/index.ctp

Notice: If you want to customize this error message, create app/views/errors/missing_view.ctp

(default) 10 queries took 3 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	DESCRIBE `domains`		23	23	1
2	DESCRIBE `hits`		8	8	1
3	DESCRIBE `redirects`		3	3	0
4	DESCRIBE `templates`		4	4	0
5	DESCRIBE `ppc_ads`		10	10	1
6	DESCRIBE `searches`		3	3	0
7	SELECT `Domain`.`id`, `Domain`.`user_id`, `Domain`.`date`, `Domain`.`domain`, `Domain`.`language`, `Domain`.`category_id`, `Domain`.`type`, `Domain`.`type_id`, `Domain`.`template_id`, `Domain`.`keywords`, `Domain`.`hidden_keywords`, `Domain`.`etarget_id`, `Domain`.`status`, `Domain`.`ppc`, `Domain`.`affil`, `Domain`.`dns`, `Domain`.`title`, `Domain`.`headline_1`, `Domain`.`headline_2`, `Domain`.`affiliates`, `Domain`.`backlink_domain_id`, `Domain`.`for_sale`, `Domain`.`listing` FROM `domains` AS `Domain` WHERE `Domain`.`domain` = 'cz.gely.sk' LIMIT 1		0	0	0
8	INSERT INTO `hits` (`domain_id`, `date`, `ip`, `direct`, `referer`, `search`, `domain`) VALUES (NULL, '2010-09-04', '3810719193', 1, 0, 0, 0)	1048: Column 'domain_id' cannot be null			0
9	SELECT `Ppc_ad`.`id`, `Ppc_ad`.`domain_id`, `Ppc_ad`.`title`, `Ppc_ad`.`description`, `Ppc_ad`.`anchor`, `Ppc_ad`.`url`, `Ppc_ad`.`clicks`, `Ppc_ad`.`rank`, `Ppc_ad`.`check`, `Ppc_ad`.`status` FROM `ppc_ads` AS `Ppc_ad` WHERE `Ppc_ad`.`domain_id` IS NULL AND UNIX_TIMESTAMP(`Ppc_ad`.`check`) >= 1283510975 ORDER BY `Ppc_ad`.`clicks` desc, `Ppc_ad`.`rank` desc LIMIT 8		0	0	0
10	SELECT `Template`.`id`, `Template`.`name`, `Template`.`layout`, `Template`.`page` FROM `templates` AS `Template` WHERE `Template`.`id` IS NULL LIMIT 1		0	0	0

(default) 10 queries took 3 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `domains`

DESCRIBE `hits`

DESCRIBE `redirects`

DESCRIBE `templates`

DESCRIBE `ppc_ads`

DESCRIBE `searches`

SELECT `Domain`.`id`, `Domain`.`user_id`, `Domain`.`date`, `Domain`.`domain`, `Domain`.`language`, `Domain`.`category_id`, `Domain`.`type`, `Domain`.`type_id`, `Domain`.`template_id`, `Domain`.`keywords`, `Domain`.`hidden_keywords`, `Domain`.`etarget_id`, `Domain`.`status`, `Domain`.`ppc`, `Domain`.`affil`, `Domain`.`dns`, `Domain`.`title`, `Domain`.`headline_1`, `Domain`.`headline_2`, `Domain`.`affiliates`, `Domain`.`backlink_domain_id`, `Domain`.`for_sale`, `Domain`.`listing` FROM `domains` AS `Domain` WHERE `Domain`.`domain` = 'cz.gely.sk' LIMIT 1

INSERT INTO `hits` (`domain_id`, `date`, `ip`, `direct`, `referer`, `search`, `domain`) VALUES (NULL, '2010-09-04', '3810719193', 1, 0, 0, 0)

1048: Column 'domain_id' cannot be null

SELECT `Ppc_ad`.`id`, `Ppc_ad`.`domain_id`, `Ppc_ad`.`title`, `Ppc_ad`.`description`, `Ppc_ad`.`anchor`, `Ppc_ad`.`url`, `Ppc_ad`.`clicks`, `Ppc_ad`.`rank`, `Ppc_ad`.`check`, `Ppc_ad`.`status` FROM `ppc_ads` AS `Ppc_ad` WHERE `Ppc_ad`.`domain_id` IS NULL AND UNIX_TIMESTAMP(`Ppc_ad`.`check`) >= 1283510975 ORDER BY `Ppc_ad`.`clicks` desc, `Ppc_ad`.`rank` desc LIMIT 8

SELECT `Template`.`id`, `Template`.`name`, `Template`.`layout`, `Template`.`page` FROM `templates` AS `Template` WHERE `Template`.`id` IS NULL LIMIT 1