Well, my day has just been made. I just recently moved to a new webhost (MDDHosting) about half a month ago. My forum has run flawlessly up until about an hour ago when it simply stopped rendering. I got the following from my webhost after about an hour. The site is back up but showing posts from half a month ago. I am deeply despondent as I was thrilled with my new host and how fast everything was running. Can anybody clue me in as to what if anything I can do or even what happened? I had made no changes whatsoever to my site in weeks. Thanks! (running XF 1.2.4)
I was able to restore an older backup of the database but, that said, I'm unable to restore a newer copy due to this error:
ERROR 1005 (HY000) at line 539: Can't create table 'domain_name.xf_admin_template_modification_log' (errno: -1)
My research indicates that this is due to a column name in the table matching the name of an internal InnoDB column:
Cannot create table. If the error message refers to error 150, table creation failed because a foreign key constraint was not correctly formed. If the error message refers to error –1, table creation probably failed because the table includes a column name that matched the name of an internal InnoDB table.
I have placed the 'domain_name.sql' file within your home directory - you will need to get with your script developer for assistance with restoring this file as you will likely need to conduct database modifications and the software will likely need modified as well.