Express Engine cache breaking suddenly stopped working
Development and Programming
Hi there,
I have inheritated express engine site to do some support and recently. Content team reported problem regarding, any new entry to site they create, it doesnt appear on front end until cache get refreshed (20 mins). previously editor mentioned it was appearing straightaway. I saw there is cache breaking rules in CE cache and nothing has changed but I suspect the cache breaking is not working.
I also noticed on channel_images addon, while clicking on setting it result on error. I checked the table and on exp_channel_fields there is no group_id column
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cf.group_id' in 'on clause':
SELECT `cf`.`field_id`, `cf`.`field_label`, `fg`.`group_name` FROM (`exp_channel_fields` cf) LEFT JOIN `exp_field_groups` fg ON `fg`.`group_id` = `cf`.`group_id` WHERE `cf`.`site_id` = 1 AND `cf`.`field_type` = 'channel_images'
ee/legacy/database/drivers/mysqli/mysqli_connection.php:116
Stack Trace: Please include when reporting this error
#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(111): CI_DB_mysqli_connection->query('SELECT `cf`.`fi...')
#1 ee/legacy/database/DB_driver.php(269): CI_DB_mysqli_driver->_execute('SELECT `cf`.`fi...')
#2 ee/legacy/database/DB_driver.php(179): CI_DB_driver->simple_query('SELECT `cf`.`fi...')
#3 ee/legacy/database/DB_active_rec.php(1137): CI_DB_driver->query('SELECT `cf`.`fi...')
#4 user/addons/channel_images/mcp.channel_images.php(86): CI_DB_active_record->get()
#5 user/addons/channel_images/mcp.channel_images.php(60): Channel_images_mcp->batch_actions()
#6 [internal function]: Channel_images_mcp->index()
#7 ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php(1661): call_user_func_array(Array, Array)
#8 ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php(945): EllisLab\ExpressionEngine\Controller\Addons\Addons->getModuleSettings('channel_images', 'index', Array)
#9 [internal function]: EllisLab\ExpressionEngine\Controller\Addons\Addons->settings('channel_images')
#10 ee/EllisLab/ExpressionEngine/Core/Core.php(240): call_user_func_array(Array, Array)
#11 ee/EllisLab/ExpressionEngine/Core/Core.php(109): EllisLab\ExpressionEngine\Core\Core->runController(Array)
#12 ee/EllisLab/ExpressionEngine/Boot/boot.php(146): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))
#13 admin.php(147): require_once('...')
#13 admin.php(147): require_once('...')our setup is following:
ExpressEngine : 4.3.4 channel_images: 6.0.2 CE Cache: 2.0.2
Any help/pointer would be apperciated.
Regards,
Gut reaction is the check and see if mysql version of the server got upgraded.
I believe your running CE cache on an unsupported version of ExpressionEngine as well… Might need to change to a newer add-on.
Thanks,
-Tom Jaeger