Hi
I have finally resolved this issue. It seems there are some required changes to the database when upgrading to 2+ as stated here http://docs.moodle.org/20/en/Upgrading_to_Moodle_2.0#Required_changes_in_database_privileges
After trying for hourse to fix this with the following advice ...
the command to execute by one database admin user would be:
GRANT
CREATE TEMPORARY TABLES ON `moodle` . * TO 'moodleuser'@'localhost';
■DATABASENAME:
Specify the name of the database ('moodle' given the error you pasted
above).
■USERNAME: Specify the name of the database user ('moodleuser' given
the error you pasted above).
■HOST: Specify the hosts from which that user
can connect ('localhost' given the error pasted above).
However, when I
try this on my database I get the following error ...
#1044 - Access
denied for user 'web167-course22'@'%'
to database 'web167-course22'
I contacted my hosting providers and it seems they needed to be the ones to grant the permissions.
I hope this information helps anyone else who is having the same problem.