$sql = "SHOW FULL COLUMNS FROM `genres_products`"
$error = "1030: Got error 122 from storage engine"
$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::query() - CORE/cake/libs/model/datasources/dbo_source.php, line 287
DboMysqlBase::describe() - CORE/cake/libs/model/datasources/dbo/dbo_mysql.php, line 125
Model::schema() - CORE/cake/libs/model/model.php, line 929
Model::setSource() - CORE/cake/libs/model/model.php, line 780
Model::__construct() - CORE/cake/libs/model/model.php, line 474
LazyModel::__construct() - APP/plugins/lazy_model/libs/lazy_model.php, line 68
Model::__generateAssociation() - CORE/cake/libs/model/model.php, line 742
Model::__createLinks() - CORE/cake/libs/model/model.php, line 631
Model::__construct() - CORE/cake/libs/model/model.php, line 482
LazyModel::__construct() - APP/plugins/lazy_model/libs/lazy_model.php, line 68
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 658
LazyModel::__constructLinkedModel() - APP/plugins/lazy_model/libs/lazy_model.php, line 84
Model::__createLinks() - CORE/cake/libs/model/model.php, line 629
Query: SHOW FULL COLUMNS FROM `genres_products`
Warning (2): Invalid argument supplied for foreach() [CORE/cake/libs/model/datasources/dbo/dbo_mysql.php, line 127]
DboMysqlBase::describe() - CORE/cake/libs/model/datasources/dbo/dbo_mysql.php, line 127
Model::schema() - CORE/cake/libs/model/model.php, line 929
Model::setSource() - CORE/cake/libs/model/model.php, line 780
Model::__construct() - CORE/cake/libs/model/model.php, line 474
LazyModel::__construct() - APP/plugins/lazy_model/libs/lazy_model.php, line 68
Model::__generateAssociation() - CORE/cake/libs/model/model.php, line 742
Model::__createLinks() - CORE/cake/libs/model/model.php, line 631
Model::__construct() - CORE/cake/libs/model/model.php, line 482
LazyModel::__construct() - APP/plugins/lazy_model/libs/lazy_model.php, line 68
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 658
LazyModel::__constructLinkedModel() - APP/plugins/lazy_model/libs/lazy_model.php, line 84
Model::__createLinks() - CORE/cake/libs/model/model.php, line 629
Model::__construct() - CORE/cake/libs/model/model.php, line 482
LazyModel::__construct() - APP/plugins/lazy_model/libs/lazy_model.php, line 68
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 142
Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 658
LazyModel::__constructLinkedModel() - APP/plugins/lazy_model/libs/lazy_model.php, line 84
Query: SHOW FULL COLUMNS FROM `genres_products`
Query: SHOW FULL COLUMNS FROM `genres_products`
Query: SHOW FULL COLUMNS FROM `genres_products`
Query: SHOW FULL COLUMNS FROM `genres_products`
Query: SHOW FULL COLUMNS FROM `orders`
Query: SHOW FULL COLUMNS FROM `orders_products`
Query: SHOW FULL COLUMNS FROM `orders_products`
Query: SHOW FULL COLUMNS FROM `orders_products`
Query: SHOW FULL COLUMNS FROM `orders_products`
Query: SHOW FULL COLUMNS FROM `orders_products`
Query: SHOW FULL COLUMNS FROM `artists_products`
Query: SHOW FULL COLUMNS FROM `artists_products`
Query: SHOW FULL COLUMNS FROM `artists_products`
Query: SHOW FULL COLUMNS FROM `artists_products`
Query: SHOW FULL COLUMNS FROM `artists_products`
Query: SHOW FULL COLUMNS FROM `genres_products`
Query: SHOW FULL COLUMNS FROM `orders_products`
Query: SHOW FULL COLUMNS FROM `artists_products`
Warning (2): Cannot modify header information - headers already sent by (output started at /var/www/totallyvinyl.com/web/shop/cake/libs/debugger.php:673) [CORE/cake/libs/controller/components/request_handler.php, line 759]
header - [internal], line ??
RequestHandlerComponent::_header() - CORE/cake/libs/controller/components/request_handler.php, line 759
RequestHandlerComponent::respondAs() - CORE/cake/libs/controller/components/request_handler.php, line 743
RequestHandlerComponent::startup() - CORE/cake/libs/controller/components/request_handler.php, line 244
Component::triggerCallback() - CORE/cake/libs/controller/component.php, line 186
Controller::startupProcess() - CORE/cake/libs/controller/controller.php, line 523
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 187
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 97
Query: SHOW FULL COLUMNS FROM `artists_products`
Warning (2): array_keys() expects parameter 1 to be array, boolean given [CORE/cake/libs/model/model.php, line 2917]
array_keys - [internal], line ??
Model::joinModel() - CORE/cake/libs/model/model.php, line 2917
DboSource::generateAssociationQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 1337
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 814
Model::find() - CORE/cake/libs/model/model.php, line 2127
Controller::paginate() - CORE/cake/libs/controller/controller.php, line 1204
ArtistsController::view() - APP/controllers/artists_controller.php, line 74
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 97
Query: SHOW FULL COLUMNS FROM `artists_products`
Query: SHOW FULL COLUMNS FROM `artists_products`
Query: SHOW FULL COLUMNS FROM `artists_products`
Query: SHOW FULL COLUMNS FROM `artists_products`
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 artists_products AS `ArtistsProduct` ON (`ArtistsProduct`.`product_id` = `Product`.`id`) LEFT JOIN `labels` AS `Label` ON (`Product`.`label_id` = `Label`.`id`) WHERE `ArtistsProduct`.`artist_id` = '6456' ORDER BY (CONCAT_WS(", ", `Product`.`artist_last` ,`Product`.`artist_first`)) ASC LIMIT 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
ArtistsController::view() - APP/controllers/artists_controller.php, line 74
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/artists/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 1 of 1, showing 1 records out of 1 total, starting on record 1, ending on 1