PlaysController::type() - APP/controllers/plays_controller.php, line 54
Object::dispatchMethod() - APP/cake/libs/object.php, line 116
Dispatcher::_invoke() - APP/cake/dispatcher.php, line 259
Dispatcher::dispatch() - APP/cake/dispatcher.php, line 213
[main] - APP/webroot/index.php, line 90
Notice (8): Undefined index: 0 [APP/controllers/plays_controller.php, line 56]
$type = $types['0']['Type']; $this->set('type', $type); foreach($types['0']['Play'] as $p) {
PlaysController::type() - APP/controllers/plays_controller.php, line 56
Object::dispatchMethod() - APP/cake/libs/object.php, line 116
Dispatcher::_invoke() - APP/cake/dispatcher.php, line 259
Dispatcher::dispatch() - APP/cake/dispatcher.php, line 213
[main] - APP/webroot/index.php, line 90
Warning (2): Invalid argument supplied for foreach() [APP/controllers/plays_controller.php, line 56]
$type = $types['0']['Type']; $this->set('type', $type); foreach($types['0']['Play'] as $p) {
PlaysController::type() - APP/controllers/plays_controller.php, line 56
Object::dispatchMethod() - APP/cake/libs/object.php, line 116
Dispatcher::_invoke() - APP/cake/dispatcher.php, line 259
Dispatcher::dispatch() - APP/cake/dispatcher.php, line 213
[main] - APP/webroot/index.php, line 90
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 [APP/cake/libs/model/datasources/dbo_source.php, line 521]
$sql = "SELECT COUNT(*) AS `count` FROM `plays` AS `Play` LEFT JOIN `genres` AS `Genre` ON (`Play`.`genre_id` = `Genre`.`id`) LEFT JOIN `categories` AS `Category` ON (`Play`.`category_id` = `Category`.`id`) WHERE `Play`.`enabled` = 1 AND `Play`.`id` in () "
$error = "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1"
$out = null
DboSource::showQuery() - APP/cake/libs/model/datasources/dbo_source.php, line 521
DboSource::execute() - APP/cake/libs/model/datasources/dbo_source.php, line 208
DboSource::fetchAll() - APP/cake/libs/model/datasources/dbo_source.php, line 344
DboSource::read() - APP/cake/libs/model/datasources/dbo_source.php, line 638
Model::find() - APP/cake/libs/model/model.php, line 1822
Controller::paginate() - APP/cake/libs/controller/controller.php, line 1002
PlaysController::type() - APP/controllers/plays_controller.php, line 63
Object::dispatchMethod() - APP/cake/libs/object.php, line 116
Dispatcher::_invoke() - APP/cake/dispatcher.php, line 259
Dispatcher::dispatch() - APP/cake/dispatcher.php, line 213
[main] - APP/webroot/index.php, line 90
Query: SELECT COUNT(*) AS `count` FROM `plays` AS `Play` LEFT JOIN `genres` AS `Genre` ON (`Play`.`genre_id` = `Genre`.`id`) LEFT JOIN `categories` AS `Category` ON (`Play`.`category_id` = `Category`.`id`) WHERE `Play`.`enabled` = 1 AND `Play`.`id` in ()
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY `Category`.`name` ASC, IF(LEFT(title,2)="A ",SUBSTRING(title FROM 3' at line 1 [APP/cake/libs/model/datasources/dbo_source.php, line 521]
$sql = "SELECT `Play`.`id`, `Play`.`title`, `Play`.`genre_id`, `Play`.`type`, `Play`.`featured`, `Play`.`age_range`, `Play`.`category_id`, `Play`.`min_runtime`, `Play`.`max_runtime`, `Play`.`num_male_search`, `Play`.`num_male_display`, `Play`.`num_female_search`, `Play`.`num_female_display`, `Play`.`num_either_search`, `Play`.`num_either_display`, `Play`.`max_total_characters`, `Play`.`min_total_characters`, `Play`.`royalty_theatrical_first`, `Play`.`royalty_theatrical_add`, `Play`.`royalty_forensics`, `Play`.`production_info`, `Play`.`synopsis`, `Play`.`synopsis_oneliner`, `Play`.`keywords`, `Play`.`external_order_link`, `Play`.`created`, `Play`.`enabled`, `Play`.`printable_perusal`, `Play`.`old_url`, `Genre`.`id`, `Genre`.`name`, `Category`.`id`, `Category`.`name`, `Category`.`position` FROM `plays` AS `Play` LEFT JOIN `genres` AS `Genre` ON (`Play`.`genre_id` = `Genre`.`id`) LEFT JOIN `categories` AS `Category` ON (`Play`.`category_id` = `Category`.`id`) WHERE `Play`.`enabled` = 1 AND `Play`.`id` in () ORDER BY `Category`.`name` ASC, IF(LEFT(title,2)="A ",SUBSTRING(title FROM 3),IF(LEFT(title,3)="An ",SUBSTRING(title FROM 4),IF(LEFT(title,4)="The ",SUBSTRING(title FROM 5),title))) LIMIT 999"
$error = "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY `Category`.`name` ASC, IF(LEFT(title,2)="A ",SUBSTRING(title FROM 3' at line 1"
$out = null
DboSource::showQuery() - APP/cake/libs/model/datasources/dbo_source.php, line 521
DboSource::execute() - APP/cake/libs/model/datasources/dbo_source.php, line 208
DboSource::fetchAll() - APP/cake/libs/model/datasources/dbo_source.php, line 344
DboSource::read() - APP/cake/libs/model/datasources/dbo_source.php, line 638
Model::find() - APP/cake/libs/model/model.php, line 1822
Controller::paginate() - APP/cake/libs/controller/controller.php, line 1019
PlaysController::type() - APP/controllers/plays_controller.php, line 63
Object::dispatchMethod() - APP/cake/libs/object.php, line 116
Dispatcher::_invoke() - APP/cake/dispatcher.php, line 259
Dispatcher::dispatch() - APP/cake/dispatcher.php, line 213
[main] - APP/webroot/index.php, line 90
Query: SELECT `Play`.`id`, `Play`.`title`, `Play`.`genre_id`, `Play`.`type`, `Play`.`featured`, `Play`.`age_range`, `Play`.`category_id`, `Play`.`min_runtime`, `Play`.`max_runtime`, `Play`.`num_male_search`, `Play`.`num_male_display`, `Play`.`num_female_search`, `Play`.`num_female_display`, `Play`.`num_either_search`, `Play`.`num_either_display`, `Play`.`max_total_characters`, `Play`.`min_total_characters`, `Play`.`royalty_theatrical_first`, `Play`.`royalty_theatrical_add`, `Play`.`royalty_forensics`, `Play`.`production_info`, `Play`.`synopsis`, `Play`.`synopsis_oneliner`, `Play`.`keywords`, `Play`.`external_order_link`, `Play`.`created`, `Play`.`enabled`, `Play`.`printable_perusal`, `Play`.`old_url`, `Genre`.`id`, `Genre`.`name`, `Category`.`id`, `Category`.`name`, `Category`.`position` FROM `plays` AS `Play` LEFT JOIN `genres` AS `Genre` ON (`Play`.`genre_id` = `Genre`.`id`) LEFT JOIN `categories` AS `Category` ON (`Play`.`category_id` = `Category`.`id`) WHERE `Play`.`enabled` = 1 AND `Play`.`id` in () ORDER BY `Category`.`name` ASC, IF(LEFT(title,2)="A ",SUBSTRING(title FROM 3),IF(LEFT(title,3)="An ",SUBSTRING(title FROM 4),IF(LEFT(title,4)="The ",SUBSTRING(title FROM 5),title))) LIMIT 999
foreach ($categories as $category) { $found=false; foreach($plays as $play) {
BuildJumpTo - APP/config/bootstrap.php, line 238
include - APP/views/plays/type.ctp, line 6
View::_render() - APP/cake/libs/view/view.php, line 654
View::render() - APP/cake/libs/view/view.php, line 372
Controller::render() - APP/cake/libs/controller/controller.php, line 744
Dispatcher::_invoke() - APP/cake/dispatcher.php, line 262
Dispatcher::dispatch() - APP/cake/dispatcher.php, line 213
[main] - APP/webroot/index.php, line 90
Jump to ...
Warning (2): Invalid argument supplied for foreach() [APP/views/plays/type.ctp, line 14]
include - APP/views/plays/type.ctp, line 14
View::_render() - APP/cake/libs/view/view.php, line 654
View::render() - APP/cake/libs/view/view.php, line 372
Controller::render() - APP/cake/libs/controller/controller.php, line 744
Dispatcher::_invoke() - APP/cake/dispatcher.php, line 262
Dispatcher::dispatch() - APP/cake/dispatcher.php, line 213
[main] - APP/webroot/index.php, line 90
Shopping Cart: 
