$sql = "SELECT `Product`.`id`, `Product`.`slug`, `Product`.`artist_first`, `Product`.`artist_last`, `Product`.`title`, `Product`.`tracks`, `Product`.`label_id`, `Product`.`catalogue_number`, `Product`.`mode`, `Product`.`origin`, `Product`.`year`, `Product`.`cover_condition`, `Product`.`record_condition`, `Product`.`comment`, `Product`.`keywords`, `Product`.`quantity`, `Product`.`reserved`, `Product`.`price`, `Product`.`auction`, `Product`.`auction_end`, `Product`.`modified`, `Product`.`created`, `Product`.`weight`, (CONCAT_WS(" ", `Product`.`artist_first`, `Product`.`artist_last`,"-", `Product`.`title`, "-", `Product`.`mode`, "- Year:", `Product`.`year`, "- £", `Product`.`price`)) AS `Product__full_name`, (CONCAT_WS(" ", `Product`.`artist_first`, `Product`.`artist_last`,"-", `Product`.`title`, "-", `Product`.`mode`, "- Year:", `Product`.`year`)) AS `Product__email_name`, (CONCAT_WS(", ", `Product`.`artist_last` ,`Product`.`artist_first`)) AS `Product__artist`, `Label`.`id`, `Label`.`slug`, `Label`.`name`, `Label`.`products_count` FROM `products` AS `Product` INNER JOIN genres_products AS `GenresProduct` ON (`GenresProduct`.`product_id` = `Product`.`id`) LEFT JOIN `labels` AS `Label` ON (`Product`.`label_id` = `Label`.`id`) WHERE `GenresProduct`.`genre_id` = 1 ORDER BY `Product`.`title` asc LIMIT 8220, 20"
$error = "3: Error writing file '/tmp/MYV1e0IY' (Errcode: 122)"
$out = null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 684
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 266
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 410
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 823
Model::find() - CORE/cake/libs/model/model.php, line 2127
Controller::paginate() - CORE/cake/libs/controller/controller.php, line 1224
GenresController::view() - APP/controllers/genres_controller.php, line 56
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 97
Query: SELECT `Product`.`id`, `Product`.`slug`, `Product`.`artist_first`, `Product`.`artist_last`, `Product`.`title`, `Product`.`tracks`, `Product`.`label_id`, `Product`.`catalogue_number`, `Product`.`mode`, `Product`.`origin`, `Product`.`year`, `Product`.`cover_condition`, `Product`.`record_condition`, `Product`.`comment`, `Product`.`keywords`, `Product`.`quantity`, `Product`.`reserved`, `Product`.`price`, `Product`.`auction`, `Product`.`auction_end`, `Product`.`modified`, `Product`.`created`, `Product`.`weight`, (CONCAT_WS(" ", `Product`.`artist_first`, `Product`.`artist_last`,"-", `Product`.`title`, "-", `Product`.`mode`, "- Year:", `Product`.`year`, "- £", `Product`.`price`)) AS `Product__full_name`, (CONCAT_WS(" ", `Product`.`artist_first`, `Product`.`artist_last`,"-", `Product`.`title`, "-", `Product`.`mode`, "- Year:", `Product`.`year`)) AS `Product__email_name`, (CONCAT_WS(", ", `Product`.`artist_last` ,`Product`.`artist_first`)) AS `Product__artist`, `Label`.`id`, `Label`.`slug`, `Label`.`name`, `Label`.`products_count` FROM `products` AS `Product` INNER JOIN genres_products AS `GenresProduct` ON (`GenresProduct`.`product_id` = `Product`.`id`) LEFT JOIN `labels` AS `Label` ON (`Product`.`label_id` = `Label`.`id`) WHERE `GenresProduct`.`genre_id` = 1 ORDER BY `Product`.`title` asc LIMIT 8220, 20
Warning (2): Invalid argument supplied for foreach() [APP/models/product.php, line 233]
//mail('nick@totallyvinyl.com', 'test', print_r($results,true)); //we want to remove the whitespace at the beginning of the concatenated artist foreach ($results as $key => $val) {
$results = false
Product::afterFind() - APP/models/product.php, line 233
Model::__filterResults() - CORE/cake/libs/model/model.php, line 2377
Model::find() - CORE/cake/libs/model/model.php, line 2131
Controller::paginate() - CORE/cake/libs/controller/controller.php, line 1224
GenresController::view() - APP/controllers/genres_controller.php, line 56
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 97
include - APP/views/genres/view.ctp, line 17
View::_render() - CORE/cake/libs/view/view.php, line 731
View::render() - CORE/cake/libs/view/view.php, line 426
Controller::render() - CORE/cake/libs/controller/controller.php, line 909
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 207
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 97
Page 412 of 662, showing 1 records out of 13239 total, starting on record 8221, ending on 8240