Welcome to the LimeSurvey Community Forum

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

Server migrated getting a database error

  • jacobcameron
  • jacobcameron's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 7 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
  • LouisGac's Avatar
  • Visitor
  • Visitor
8 years 7 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
  • Mazi's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
8 years 6 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
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source