When trying to use the checkintegrity funcion in Limesurvey, i get the following error message :
Couldn't make backup of the survey table. Please try again. The database reported the following error:
exception 'CDbException' with message 'CDbCommand n'a pas pu exécuter la commande SQL : SQLSTATE[42000]: Syntax error or access violation: 1142 DROP command denied to user 'limesurvey'@'localhost' for table 'lime_tokens_677162'' in /var/www/webenquetes/framework/db/CDbCommand.php:358 Stack trace: #0 /var/www/webenquetes/framework/db/CDbCommand.php(1336): CDbCommand->execute() #1 /var/www/webenquetes/application/controllers/admin/checkintegrity.php(394): CDbCommand->renameTable('{{tokens_677162...', '{{old_tokens_67...') #2 /var/www/webenquetes/application/controllers/admin/checkintegrity.php(40): CheckIntegrity->_checkintegrity() #3 [internal function]: CheckIntegrity->index() #4 /var/www/webenquetes/framework/web/actions/CAction.php(108): ReflectionMethod->invokeArgs(Object(CheckIntegrity), Array) #5 /var/www/webenquetes/application/core/Survey_Common_Action.php(99): CAction->runWithParamsInternal(Object(CheckIntegrity), Object(ReflectionMethod), Array) #6 /var/www/webenquetes/framework/web/CController.php(308): Survey_Common_Action->runWithParams(Array) #7 /var/www/webenquetes/framework/web/CController.php(286): CController->runAction(Object(CheckIntegrity)) #8 /var/www/webenquetes/framework/web/CController.php(265): CController->runActionWithFilters(Object(CheckIntegrity), Array) #9 /var/www/webenquetes/application/controllers/AdminController.php(164): CController->run('checkintegrity') #10 /var/www/webenquetes/framework/web/CWebApplication.php(282): AdminController->run('checkintegrity') #11 /var/www/webenquetes/framework/web/CWebApplication.php(141): CWebApplication->runController('admin/checkinte...') #12 /var/www/webenquetes/framework/base/CApplication.php(184): CWebApplication->processRequest() #13 /var/www/webenquetes/index.php(211): CApplication->run() #14 {main}