CE Cache - if page not yet cached, error: Base table or view not found

Question

If a not cached page is accessed for the first time, give an error message (EE cache is disabled from the control panel).

When this same page is accessed one more time, the page is well displayed, no error message.

How this problem could be solved ?

Using this CE Cache syntax for the main template:

    {exp:ce_cache:it id="ce_principal" global="no" seconds="604800"}
        {exp:stash:get name='main_content'}
    {/exp:ce_cache:it}

(EE cache is disabled from the control panel)

Inside the CE Cache control panel page, if i want to see a cached page appears this error message:

Fatal error: Uncaught Error: Call to a member function hasModule() on null in /home/mysite/system/ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php:1179 Stack trace: #0 /home/mysite/system/ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php(943): EllisLab\ExpressionEngine\Controller\Addons\Addons->getModule('ce_cache&S=1c17...')

1 [internal function]: EllisLab\ExpressionEngine\Controller\Addons\Addons->settings('ce_cache&S=1c17...',

'view_item', 'file&item=ce_ca...', '663b4b', 'global', 'js_main') #2 /home/mysite/system/ee/EllisLab/ExpressionEngine/Core/Core.php(241): call_user_func_array(Array, Array) #3 /home/mysite/system/ee/EllisLab/ExpressionEngine/Core/Core.php(110): EllisLab\mysite\Core\Core->runController(Array) #4 /home/mysite/system/ee/EllisLab/ExpressionEngine/Boot/boot.php(151): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))

5 /home/mysite/www/admin.php(147): require_once('/home/cistosara.. in

/home/mysite/system/ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php on line 1179

Answer 1

It looks from the last error you reported that the CP issue is being caused by a configuration error - EE is trying to delete an entry from a table that doesn't exist (the table exp_ce_cache_tagged_items).

The table is installed by CE-Cache during initial install and / or updates if it does not exist. The table is defined both in CE-Cache 1.10.1 (EE2) and CE-Cache 2.0.2 (EE3), so whether your install is a new build or an update from an earlier version, this table should be present.

If it is absent (you could check by having a look at the MySQL database for the site using a MySQL utility such as SequelPro or phpMyAdmin) you probably need to add it back... either doing so manually in the MySQL or uninstalling / reinstalling the add-on from a clean copy of the add-on code (the install code will recreate the table if it is not present when the install routine runs). Reinstalling is probably the better option here, as the absent table may not be the only issue with the install.

If fixing the missing table doesn't do the job, post back with info on whether the errors change after the table is back in the MySQL, and also things like which version of the add-on and EE you are using and so on.

HTH