Too late. I created an empty db on the new server, backed up my old one, imported it, installed GL1.8, copied across some of my images etc, did the migrate option. Seemed to work ok.
It was going pretty well except I have a lot of customisations and glmenu. I was working through the customisations and installing menu plugin 1.1 when suddenly every stopped working and I got that error about not being able to render. I forced root debug on as recommended elsewhere on here by changing if( function_exists('set_error_handler'
) to force it on.
The error I get now is Fatal error: An SQL error has occurred. Please see error.log for details. in /home/wfnews/system/databases/mysql.class.php on line 260
and the error log shows:
Sun 08 Jun 2014 10:07:41 CST - 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (perm_anon >= 2) ORDER BY topic ASC' at line 1. SQL in question: SELECT tid,topic,imageurl FROM gl_topics AND (perm_anon >= 2) ORDER BY topic ASC
Now I'm pretty lost. I hadn't made any changes to the db in the few hours before it broke.