Notice (8): Undefined offset: 0 [APP/Controller/UsersController.php, line 137]
Notice (8): Trying to access array offset on value of type null [APP/Controller/UsersController.php, line 137]
Notice (8): Trying to access array offset on value of type null [APP/Controller/UsersController.php, line 137]
Notice (8): Undefined offset: 0 [APP/Controller/UsersController.php, line 139]
Notice (8): Trying to access array offset on value of type null [APP/Controller/UsersController.php, line 139]
Notice (8): Trying to access array offset on value of type null [APP/Controller/UsersController.php, line 139]
Notice (8): Undefined offset: 0 [APP/Controller/UsersController.php, line 141]
Notice (8): Trying to access array offset on value of type null [APP/Controller/UsersController.php, line 141]
Notice (8): Trying to access array offset on value of type null [APP/Controller/UsersController.php, line 141]
Short Stories Collection, Read Short Stories Online, Short Stories Portal

Database Error

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 'group by stories.id order by STR_TO_DATE(stories.post_date, '%m/%d/%Y %h:%i') DE' at line 1

SQL Query: SELECT stories.* ,users.*,categories.name FROM `stories` left join story_categories on story_categories.story_id=stories.id left join categories on categories.id=stories.category_id left join users on stories.post_author=users.id WHERE stories.post_status='publish' AND categories.id= group by stories.id order by STR_TO_DATE(stories.post_date, '%m/%d/%Y %h:%i') DESC limit 6 offset 0

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace

Download the Short Story Lovers App

Read and write stories anytime, anywhere with the Short Story Lovers app