?
avatar diddipoeler
diddipoeler
16 Sep 2020

I got this error in update form 4dev to 5dev:

Unknown column 's.inheritable' in 'field list'

DatabaseDriver->setQuery(object(MysqliQuery)) in /www/htdocs/w0086dfc/joomla40/libraries/src/Application/AdministratorApplication.php (line 264)

            )
                ->bind(':style', $admin_style, ParameterType::INTEGER);
        }
        $query->order($db->quoteName('s.home'));
        $db->setQuery($query);
        $template = $db->loadObject();
        $template->template = InputFilter::getInstance()->clean($template->template, 'cmd');
        $template->params = new Registry($template->params);
avatar diddipoeler diddipoeler - open - 16 Sep 2020
avatar joomla-cms-bot joomla-cms-bot - change - 16 Sep 2020
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 16 Sep 2020
avatar HLeithner HLeithner - change - 16 Sep 2020
Status New Closed
Closed_Date 0000-00-00 00:00:00 2020-09-16 10:25:50
Closed_By HLeithner
avatar HLeithner HLeithner - close - 16 Sep 2020
avatar wetken
wetken - comment - 31 Aug 2022

I'm between a rock and a hard place with this. I'm trying to update from 3.10 to 4.1
When I try the update I get an error message telling me "Unknown column 's.inheritable' in 'field list'".
If I follow the suggested workaround and add the column and try the update again, it fails trying to implement 3.10.0-2020-08-10.sql which wants to add this field, but it is now already there.
It would be recoverable if only I had a list of the other .sql files that remain to be implemented.
Is the only way to compare the before database with a virgin 4.1 database and make the changes by hand?


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/30661.

Add a Comment

Login with GitHub to post a comment