Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Server migrated getting a database error

jacobcameron
Topic Author
Offline
New Member

More

9 years 11 months ago #125945 by jacobcameron

Server migrated getting a database error was created by jacobcameron

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 topic has been locked.

LouisGac
New Member

More

9 years 11 months ago #125954 by LouisGac

Replied by LouisGac on topic Server migrated getting a database error

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

Code:

    'db' => array(
      'connectionString' => 'mysql:host=[YOUR SERVER];port=3306;dbname=[YOUR DATABASE];',
      'emulatePrepare' => true,
      'username' => '[YOUR USERNAME]',
      'password' => '[YOUR PASSWORD]',
      'charset' => 'utf8',
      'tablePrefix' => 'lime_',
    ),

The topic has been locked.

Mazi
Offline
LimeSurvey Community Team

More

9 years 11 months ago #126064 by Mazi

Replied by Mazi on topic Server migrated getting a database error

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.

Best regards/Beste Grüße,
Dr. Marcel Minke
survey-consulting.com
offlinesurveys.com
Feel free to contact me by email for professional LimeSurvey support!

The topic has been locked.