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 MariaDB server version for the right syntax to use near 's In A Number: Take One"' IN NATURAL LANGUAGE MODE) AS scoreTitle, MATCH (ref...' at line 1
SQL Query: SELECT `ArchiveItem`.*, MATCH (title) AGAINST ('"What's In A Number: Take One"' IN NATURAL LANGUAGE MODE) AS scoreTitle, MATCH (ref, title, subtitle, author, author_organisation, author_interviewee, author_designer, author_photographer, author_writer, author_editor, pdf_text, location) AGAINST ('"What's In A Number: Take One"' IN NATURAL LANGUAGE MODE) AS scoreAll, `ArchiveItem`.`id` FROM `fourcornersarchive_live`.`archive_items` AS `ArchiveItem` WHERE `ArchiveItem`.`status` = '1' AND MATCH (ref, title, subtitle, author, author_organisation, author_interviewee, author_designer, author_photographer, author_writer, author_editor, pdf_text, location) AGAINST ('"What's In A Number: Take One"' IN NATURAL LANGUAGE MODE) ORDER BY (scoreTitle*10) + (scoreAll) DESC LIMIT 20
Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp
Stack Trace
- CORE/Cake/Model/Datasource/DboSource.php line 502 → PDOStatement->execute()
- CORE/Cake/Model/Datasource/DboSource.php line 468 → DboSource->_execute()
- CORE/Cake/Model/Datasource/DboSource.php line 715 → DboSource->execute()
- CORE/Cake/Model/Datasource/DboSource.php line 1226 → DboSource->fetchAll()
- CORE/Cake/Model/Model.php line 3053 → DboSource->read()
- CORE/Cake/Model/Model.php line 3025 → Model->_readDataSource()
- ROOT/Plugin/App/Model/AppModel.php line 45 → Model->find()
- CORE/Cake/Controller/Component/PaginatorComponent.php line 212 → AppModel->find()
- CORE/Cake/Controller/Controller.php line 1107 → PaginatorComponent->paginate()
- APP/Plugin/Project/Controller/ArchiveItemsController.php line 76 → Controller->paginate()
- [internal function] → ArchiveItemsController->index()
- CORE/Cake/Controller/Controller.php line 499 → ReflectionMethod->invokeArgs()
- CORE/Cake/Routing/Dispatcher.php line 193 → Controller->invokeAction()
- CORE/Cake/Routing/Dispatcher.php line 167 → Dispatcher->_invoke()
- APP/webroot/index.php line 101 → Dispatcher->dispatch()