Moodle MySQL and Login problem
Posted on 2011-10-13
We have a rather strange and urgent problem with moodle CMS and mysql since moving from one host to another.
Moodle works normally for guests and you can log into the front page as an admin but the moment we try to navigate we get logged out. In addition the moment you click turn editing on you immediately get logged out.
If we rebuild the site using the moodle installer all works fine (The installer creates a new database in INNODB utf8_unicode_ci. but the moment we try to restore our database it all goes belly up again.
When we look at the database structure phpmyadmin the restored database is in MyISAM format and Utf8_general_ci which i presume is the route of our problem.
We have tried converted the table structures to INNODB by exporting g the database and changing in notepad and reimporting (dropping the original database) but still no joy.
Short of editing the collation setting for each table is there a quick way of changing the collation setting for all tables.
Or am i up the wrong tree altogether, any other suggestions?