Hello there. We recently migrated to a new server and now that we have migrated when we try to deactivate surveys we get a very strange error. When we click on deactivate we get the error below and instead of our mysql server showing up after the @, it is showing the webserver (names changed to protect the innocent of course). It never did this before but now the software thinks it should be deleting tables from the webserver. Any help would be appreciated. We were on version 2.0, I upgraded to 2.05+ and then to 2.06+ today and it still has not resolved the issue. So I did a fresh installation and with a new config file and it still hasn't fixed the issue. Any help would be greatly appreciated. I can't find anything that would cause it to think the sql server was the webserver.

Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1142 DROP command denied to user 'surveys'@'webserver' for table 'surveys_survey_116271'

An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

Thank you.

the database handler is defined in the file application/config/config.php, at the first lines :

Check the config file. Maybe the server IP has changed and/or the new server doesn't connect to MySQL using "localhost" but a different setting or port.