Fix Unknown column 'a.ordering' error after upgrade from Joomla! 4.4 to Joomla! 5

gistfile1.md

Fix Unknown column 'a.ordering' error after upgrade from Joomla! 4.4 to Joomla! 5

Unknown column 'a.ordering' in 'order clause'

Unknown column 'a.ordering' in 'order clause'
$results = $db->setQuery($query)->loadObjectList();

Solution:

Open PhpMyAdmin > SQL and type this:

ALTER TABLE `#__menu_types` ADD COLUMN `ordering` int NOT NULL DEFAULT 0 AFTER `client_id` /** CAN FAIL **/;
UPDATE `#__menu_types` SET `ordering` = `id` WHERE `client_id` = 0;

You saved me ! You have my eternal gratitude!
Do you know why this column is missing ??

Thanks a lot !!!!

You're welcome, @sirius82 😊
I have no idea why it was missing.