1054 - Unknown column 'system' in 'field list' after upgrade

[neveryonas]

After upgrading from Joomla 3.10.10 to 3.10.11 I ran into a bunch of problems (mostly front end menu related). I restored site back to previous version so I could sort out the issue. Now the front end is down, with error 1054 - Unknown column 'system' in 'field list'. I can get into admin, but there are no menu options, just the error and a button to go back to the control panel (but doesn't do anything).

I uploaded the FA file to my root directory, but I am getting a Forbidden error when trying to access it. I do not know why it is doing that.

Any suggestions on what next step should be?

[toivo]

How did you restore the website? Did you clear the filesystem first and create a new database schema before restoring?

[neveryonas]

Hi Toivo,

Thanks for the reply. I used the tool that my host provides to restore site. I did not clear filesystem or do anything with the database.

[toivo]

More information is needed. Use FTP or File Manager from the cPanel provided by your host to write enable and then edit the file configuration.php in the main Joomla folder. The following changes should produce a detailed error message that will identify the script where the error occurs:

Code: Select all

	public $debug = '1';
	public $error_reporting = 'maximum';

[neveryonas]

Hi Toivo,

Here is the list of errors

Unknown column 'system' in 'field list'

Call stack
# Function Location
1 () JROOT/libraries/joomla/database/driver/mysqli.php:668
2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506
3 JDatabaseDriver->loadAssocList() JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:95
4 Nextend\Framework\Database\Joomla\JoomlaConnectorTable->findAllByAttributes() JROOT/libraries/smartslider3/src/Framework/Model/Section.php:77
5 Nextend\Framework\Model\Section::getAll() JROOT/libraries/smartslider3/src/Framework/Settings.php:30
6 Nextend\Framework\Settings->__construct() JROOT/libraries/smartslider3/src/Framework/Settings.php:67
7 require() JROOT/libraries/smartslider3/src/Autoloader.php:194
8 Nextend\Autoloader->requireFile() JROOT/libraries/smartslider3/src/Autoloader.php:175
9 Nextend\Autoloader->loadMappedFile() JROOT/libraries/smartslider3/src/Autoloader.php:128
10 Nextend\Autoloader->loadClass()
11 spl_autoload_call() JROOT/libraries/smartslider3/src/Framework/ResourceTranslator/ResourceTranslator.php:26
12 Nextend\Framework\ResourceTranslator\ResourceTranslator->init() JROOT/libraries/smartslider3/src/Framework/Pattern/SingletonTrait.php:16
13 Nextend\Framework\ResourceTranslator\ResourceTranslator->__construct() JROOT/libraries/smartslider3/src/Framework/Pattern/SingletonTrait.php:12
14 Nextend\Framework\ResourceTranslator\ResourceTranslator::getInstance() JROOT/libraries/smartslider3/src/Framework/ResourceTranslator/ResourceTranslator.php:171
15 require() JROOT/libraries/smartslider3/src/Autoloader.php:194
16 Nextend\Autoloader->requireFile() JROOT/libraries/smartslider3/src/Autoloader.php:175
17 Nextend\Autoloader->loadMappedFile() JROOT/libraries/smartslider3/src/Autoloader.php:128
18 Nextend\Autoloader->loadClass()
19 spl_autoload_call() JROOT/libraries/smartslider3/src/Framework/Application/AbstractApplicationType.php:47
20 Nextend\Framework\Application\AbstractApplicationType->__construct() JROOT/libraries/smartslider3/src/SmartSlider3/Application/ApplicationSmartSlider3.php:30
21 Nextend\SmartSlider3\Application\ApplicationSmartSlider3->init() JROOT/libraries/smartslider3/src/Framework/Pattern/SingletonTrait.php:16
22 Nextend\Framework\Application\AbstractApplication->__construct() JROOT/libraries/smartslider3/src/Framework/Pattern/SingletonTrait.php:12
23 Nextend\Framework\Application\AbstractApplication::getInstance() JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/compat.php:7
24 nextend_smartslider3() JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:162
25 Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3::prepare()
26 preg_replace_callback() JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:87
27 Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->displaySliders() JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:116
28 Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->onNextendBeforeCompileHead() JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:128
29 Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->onAfterRender() JROOT/libraries/joomla/event/event.php:70
30 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
31 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108
32 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118
33 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778
34 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231
35 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49

[toivo]

The error comes from Smart Slider 3, a paid third party extension. According to its entry in JED, the latest version 3.5.1.0 has a component and a module, but the call stack shows an event driven plugin.

Contact the developer of this extension and report the issue.

[neveryonas]

Will do, thank you!