storiesController::story() - APP/Controller/StoriesController.php, line 73
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117
Notice (8): Trying to access array offset on value of type null [APP/Controller/StoriesController.php, line 73]
storiesController::story() - APP/Controller/StoriesController.php, line 73
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117
Notice (8): Undefined index: Story [APP/Controller/StoriesController.php, line 86]
storiesController::story() - APP/Controller/StoriesController.php, line 86
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117
Notice (8): Trying to access array offset on value of type null [APP/Controller/StoriesController.php, line 86]
storiesController::story() - APP/Controller/StoriesController.php, line 86
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117
Notice (8): Undefined index: Story [APP/Controller/StoriesController.php, line 86]
storiesController::story() - APP/Controller/StoriesController.php, line 86
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117
Notice (8): Trying to access array offset on value of type null [APP/Controller/StoriesController.php, line 86]
storiesController::story() - APP/Controller/StoriesController.php, line 86
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117
Notice (8): Undefined index: Story [APP/Controller/StoriesController.php, line 97]
storiesController::story() - APP/Controller/StoriesController.php, line 97
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117
Notice (8): Trying to access array offset on value of type null [APP/Controller/StoriesController.php, line 97]
storiesController::story() - APP/Controller/StoriesController.php, line 97
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117
Notice (8): Undefined index: Story [APP/Controller/StoriesController.php, line 122]
storiesController::story() - APP/Controller/StoriesController.php, line 122
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117
Notice (8): Trying to access array offset on value of type null [APP/Controller/StoriesController.php, line 122]
storiesController::story() - APP/Controller/StoriesController.php, line 122
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117
Notice (8): Undefined index: Story [APP/Controller/StoriesController.php, line 124]
storiesController::story() - APP/Controller/StoriesController.php, line 124
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117
Notice (8): Trying to access array offset on value of type null [APP/Controller/StoriesController.php, line 124]
storiesController::story() - APP/Controller/StoriesController.php, line 124
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117
Short Stories Collection, Read Short Stories Online, Short Stories Portal
Error:
SQLSTATE[42000]: Syntax error or access violation: 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 'AND `reply_id` = 0 ORDER BY comment_date Desc' at line 1
SQL Query:
SELECT * FROM `comments` LEFT JOIN users on comments.user_id=users.id WHERE `story_id`= AND `reply_id` = 0 ORDER BY comment_date Desc
Notice:
If you want to customize this error message, create app/View/Errors/pdo_error.ctp
'SELECT * FROM `comments` LEFT JOIN users on comments.user_id=users.id WHERE `story_id`= AND `reply_id` = 0 ORDER BY comment_date Desc'
array(
'log' => true
)
array()
if (!is_array($user_tree_array))
$user_tree_array = array();
$sql = $this->Comment->query("SELECT * FROM `comments` LEFT JOIN users on comments.user_id=users.id WHERE `story_id`=$story_id AND `reply_id` = $parent ORDER BY comment_date Desc");
'SELECT * FROM `comments` LEFT JOIN users on comments.user_id=users.id WHERE `story_id`= AND `reply_id` = 0 ORDER BY comment_date Desc'