Bug #72743
closed
cache_pages doesn't exist
0%
Description
After an upgrade to TYPO3 6.2 an error message is caused in the Front End.
exec_SELECTquery caller TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTquery ERROR Table 'demo-typo3-7.cache_pages' doesn't exist lastBuiltQuery SELECT id,page_id,tstamp FROM cache_pages WHERE page_id=16 debug_backtrace require(typo3_src-6.2.17/typo3/sysext/cms/tslib/index_ts.php),typo3_src-6.2.17/index.php#28 // TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->getFromCache#169 // TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->headerNoCache#2403 // TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction#2496 // call_user_func_array#4309 // tx_watchwords_tslibfe->headerNoCache# // TYPO3\CMS\Core\Database\DatabaseConnection->exec_SELECTquery#48 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#305
I have gone through all steps in the Install Tool. The Install Tool does not offer to generate a table called "cache_pages".
Updated by Andreas Kienast almost 9 years ago
- Status changed from New to Needs Feedback
The only occurrence in 6.2 is in indexed_search. I see tx_watchwords_tslibfe in your stack trace, does this extension do something with cache_pages?
Never mind my comment, PhpStorm trolled me.
Updated by Andreas Kienast almost 9 years ago
- Status changed from Needs Feedback to New
Updated by Wouter Wolters almost 9 years ago
- Status changed from New to Needs Feedback
Can you show me the place where the 6.2 core use the table cache_pages?
Updated by Wouter Wolters almost 9 years ago
I found your problem already and that is https://github.com/TYPO3-svn-archive/watchwords/blob/master/inc/class.tx_watchwords_tslibfe.php there is code in there that queries the cache_pages table that does not exist anymore in the core. Conclusion is that this is not a core problem but a problem in ext:watchwords.
Updated by Franz Holzinger almost 9 years ago
Indeed, the wrong call comes from the extension watchwords.
class.tx_watchwords_tslibfe.php:
// Get the cache of the current page
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('id,page_id,tstamp', 'cache_pages', 'page_id='.$reference->id);
Do you have any idea, where the table cache_pages is now?
Updated by Wouter Wolters almost 9 years ago
- Status changed from Needs Feedback to Closed
cache_pages table is now done with the Caching framework. Looks like the check in that extension is failing to use the code from the if-statement. That uses the caching framework to fetch the cache for a page. So I close this ticket as it is not a core problem. If you need further assistance you can join the #typo3-cms channel om Slack to get support or try the forums.