I have been getting a 500 error in the admin area after upgrading from 4.4 to 5 with the PiTech template.

I reached out to you but got no answer.

So I contacted my hosting company and they have said this:

Your Joomla installation is generating a MySQL error regarding a missing column:

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

This seems to be a known upgrade issue. You may want to backup your database first and try to implement the fix here:

https://gist.github.com/Yiannistaos/8e955d8f772b91508896cc8ca7d31e1c

I know its not something that you are in control of but might help further problems reported

Although it has not worked for me and it throwing up this error:

SQL query: Copy

ALTER TABLE #__menu_types ADD COLUMN ordering int NOT NULL DEFAULT 0 AFTER client_id / CAN FAIL /; MySQL said: Documentation

1146 - Table 'nigel302_demo2.#__menu_types' doesn't exist