Hi,
I am updating a joomla 3 website to joomla 4. I want to change the template to Gantry5.
I have a modul position type "SEBLOD - List". If I add this modul position to my template I get this error:
An exception has been thrown during the rendering of a template ("Unknown column 'a.storage_key' in 'SELECT'").
Previous exceptions
- Unknown column 'a.storage_key' in 'SELECT' (1054)
- An exception has been thrown during the rendering of a template ("Unknown column 'a.storage_key' in 'SELECT'"). (0)
- Unknown column 'a.storage_key' in 'SELECT' (1054)
I just deteced that I have the same problem in the menu item "List & search".
Error:
1054 Unknown column 'a.storage_key' in 'SELECT'
| Call stack | ||
| # | Function | Location |
| 1 | () | JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:137 |
| 2 | mysqli->prepare() | JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:137 |
| 3 | Joomla\Database\Mysqli\MysqliStatement->__construct() | JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1089 |
| 4 | Joomla\Database\Mysqli\MysqliDriver->prepareStatement() | JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1912 |
| 5 | Joomla\Database\DatabaseDriver->setQuery() | JROOT/libraries/cck/_/database.php:106 |
| 6 | JCckDatabase::loadObjectListArray() | JROOT/libraries/cck/base/list/list.php:180 |
| 7 | CCK_List::getFields() | JROOT/libraries/cck/base/list/list_inc.php:89 |
| 8 | include() | JROOT/components/com_cck/views/list/view.html.php:107 |
| 9 | CCKViewList->prepareDisplay() | JROOT/components/com_cck/views/list/view.html.php:38 |
| 10 | CCKViewList->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:660 |
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_cck/controller.php:126 |
| 12 | CCKController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:693 |
| 13 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_cck/cck.php:20 |
| 14 | require_once() | JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71 |
| 15 | Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() | JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73 |
| 16 | Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() | JROOT/libraries/src/Component/ComponentHelper.php:361 |
| 17 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:208 |
| 18 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:249 |
| 19 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:293 |
| 20 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/includes/app.php:61 |
| 21 | require_once() | JROOT/index.php:32 |
Can someone help?
Thanks
Nadja
Hi,
Could it be a PHP or MySQL server version issue? Joomla 3 supported up to PHP 7.4, and Joomla 4 may not work as well with that version. In fact, PHP 8.0 or 8.1 is recommended. I don't know if Gantry still works with PHP 7.4.
Best regards
PHP was 8.1. I changed it to PHP 8.3 but nothing changed.
The database is up to date too. Joomla 4 is working fine, and the sites without seblod has no problem.
I searched in the com_cck and libraries/cck folder for "a.storage_key". But I didn't find it.
Regards
Nadja
Have you checked in System -> Database? It’s possible that a change to the database structure was left unapplied after an update that didn’t complete properly. Did you follow these steps when updating? -> https://www.seblod.com/community/blog/seblod-4-0-series-4-4
Also review the List & Search configuration and the related content type to check if it's using invalid storage or fields.
Best regards
Adonay