Datenbankfehler

More
4 years 2 months ago #90766 by bethaarea
Hallo an alle,

ich habe da mal folgendes Problem:

Wenn ich versuche die Umfrage online zu schalten, dann bekomme ich die Fehlermedlung:

Datenbankfehler
Die Umfragetabellen konnten nicht erzeugt werden (Sinngemäß).

Es kann allerdings nicht daran liegen, dass die Umfrage zu umfangreich ist, weil ich die Fehlermeldung auch bei einer Umfrage mit nur einer Frage bekomme.


Hilfe!!!!

Please Log in to join the conversation.

More
4 years 2 months ago #90767 by bethaarea
habe nun folgende Fehlermeldung ausmachen können:
Executing: create index `answers_idx2` on `lime_answers` (`sortorder`); failed! Reason: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1142 INDEX command denied to user 'web594'@'localhost' for table 'lime_answers'' in /var/www/web594/html/limesurvey/framework/db/CDbCommand.php:354 Stack trace: #0 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(921): CDbCommand->execute() #1 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(891): InstallerController->_executeSQLFile('/var/www/web594...', 'lime_') #2 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(555): InstallerController->_setup_tables('/var/www/web594...') #3 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(78): InstallerController->stepPopulateDb() #4 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(276): InstallerController->run('populatedb') #5 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(135): CWebApplication->runController('installer/popul...') #6 /var/www/web594/html/limesurvey/framework/base/CApplication.php(162): CWebApplication->processRequest() #7 /var/www/web594/html/limesurvey/index.php(178): CApplication->run() #8 {main}
Executing: create index `assessments_idx2` on `lime_assessments` (`sid`); failed! Reason: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1142 INDEX command denied to user 'web594'@'localhost' for table 'lime_assessments'' in /var/www/web594/html/limesurvey/framework/db/CDbCommand.php:354 Stack trace: #0 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(921): CDbCommand->execute() #1 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(891): InstallerController->_executeSQLFile('/var/www/web594...', 'lime_') #2 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(555): InstallerController->_setup_tables('/var/www/web594...') #3 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(78): InstallerController->stepPopulateDb() #4 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(276): InstallerController->run('populatedb') #5 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(135): CWebApplication->runController('installer/popul...') #6 /var/www/web594/html/limesurvey/framework/base/CApplication.php(162): CWebApplication->processRequest() #7 /var/www/web594/html/limesurvey/index.php(178): CApplication->run() #8 {main}
Executing: create index `assessments_idx3` on `lime_assessments` (`gid`); failed! Reason: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1142 INDEX command denied to user 'web594'@'localhost' for table 'lime_assessments'' in /var/www/web594/html/limesurvey/framework/db/CDbCommand.php:354 Stack trace: #0 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(921): CDbCommand->execute() #1 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(891): InstallerController->_executeSQLFile('/var/www/web594...', 'lime_') #2 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(555): InstallerController->_setup_tables('/var/www/web594...') #3 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(78): InstallerController->stepPopulateDb() #4 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(276): InstallerController->run('populatedb') #5 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(135): CWebApplication->runController('installer/popul...') #6 /var/www/web594/html/limesurvey/framework/base/CApplication.php(162): CWebApplication->processRequest() #7 /var/www/web594/html/limesurvey/index.php(178): CApplication->run() #8 {main}
Executing: create index `conditions_idx2` on `lime_conditions` (`qid`); failed! Reason: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1142 INDEX command denied to user 'web594'@'localhost' for table 'lime_conditions'' in /var/www/web594/html/limesurvey/framework/db/CDbCommand.php:354 Stack trace: #0 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(921): CDbCommand->execute() #1 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(891): InstallerController->_executeSQLFile('/var/www/web594...', 'lime_') #2 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(555): InstallerController->_setup_tables('/var/www/web594...') #3 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(78): InstallerController->stepPopulateDb() #4 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(276): InstallerController->run('populatedb') #5 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(135): CWebApplication->runController('installer/popul...') #6 /var/www/web594/html/limesurvey/framework/base/CApplication.php(162): CWebApplication->processRequest() #7 /var/www/web594/html/limesurvey/index.php(178): CApplication->run() #8 {main}
Executing: create index `conditions_idx3` on `lime_conditions` (`cqid`); failed! Reason: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1142 INDEX command denied to user 'web594'@'localhost' for table 'lime_conditions'' in /var/www/web594/html/limesurvey/framework/db/CDbCommand.php:354 Stack trace: #0 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(921): CDbCommand->execute() #1 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(891): InstallerController->_executeSQLFile('/var/www/web594...', 'lime_') #2 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(555): InstallerController->_setup_tables('/var/www/web594...') #3 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(78): InstallerController->stepPopulateDb() #4 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(276): InstallerController->run('populatedb') #5 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(135): CWebApplication->runController('installer/popul...') #6 /var/www/web594/html/limesurvey/framework/base/CApplication.php(162): CWebApplication->processRequest() #7 /var/www/web594/html/limesurvey/index.php(178): CApplication->run() #8 {main}
Executing: create index `groups_idx2` on `lime_groups` (`sid`); failed! Reason: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1142 INDEX command denied to user 'web594'@'localhost' for table 'lime_groups'' in /var/www/web594/html/limesurvey/framework/db/CDbCommand.php:354 Stack trace: #0 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(921): CDbCommand->execute() #1 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(891): InstallerController->_executeSQLFile('/var/www/web594...', 'lime_') #2 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(555): InstallerController->_setup_tables('/var/www/web594...') #3 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(78): InstallerController->stepPopulateDb() #4 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(276): InstallerController->run('populatedb') #5 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(135): CWebApplication->runController('installer/popul...') #6 /var/www/web594/html/limesurvey/framework/base/CApplication.php(162): CWebApplication->processRequest() #7 /var/www/web594/html/limesurvey/index.php(178): CApplication->run() #8 {main}
Executing: create index `question_attributes_idx2` on `lime_question_attributes` (`qid`); failed! Reason: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1142 INDEX command denied to user 'web594'@'localhost' for table 'lime_question_attributes'' in /var/www/web594/html/limesurvey/framework/db/CDbCommand.php:354 Stack trace: #0 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(921): CDbCommand->execute() #1 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(891): InstallerController->_executeSQLFile('/var/www/web594...', 'lime_') #2 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(555): InstallerController->_setup_tables('/var/www/web594...') #3 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(78): InstallerController->stepPopulateDb() #4 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(276): InstallerController->run('populatedb') #5 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(135): CWebApplication->runController('installer/popul...') #6 /var/www/web594/html/limesurvey/framework/base/CApplication.php(162): CWebApplication->processRequest() #7 /var/www/web594/html/limesurvey/index.php(178): CApplication->run() #8 {main}
Executing: create index `question_attributes_idx3` on `lime_question_attributes` (`attribute`); failed! Reason: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1142 INDEX command denied to user 'web594'@'localhost' for table 'lime_question_attributes'' in /var/www/web594/html/limesurvey/framework/db/CDbCommand.php:354 Stack trace: #0 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(921): CDbCommand->execute() #1 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(891): InstallerController->_executeSQLFile('/var/www/web594...', 'lime_') #2 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(555): InstallerController->_setup_tables('/var/www/web594...') #3 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(78): InstallerController->stepPopulateDb() #4 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(276): InstallerController->run('populatedb') #5 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(135): CWebApplication->runController('installer/popul...') #6 /var/www/web594/html/limesurvey/framework/base/CApplication.php(162): CWebApplication->processRequest() #7 /var/www/web594/html/limesurvey/index.php(178): CApplication->run() #8 {main}
Executing: create index `questions_idx2` on `lime_questions` (`sid`); failed! Reason: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1142 INDEX command denied to user 'web594'@'localhost' for table 'lime_questions'' in /var/www/web594/html/limesurvey/framework/db/CDbCommand.php:354 Stack trace: #0 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(921): CDbCommand->execute() #1 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(891): InstallerController->_executeSQLFile('/var/www/web594...', 'lime_') #2 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(555): InstallerController->_setup_tables('/var/www/web594...') #3 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(78): InstallerController->stepPopulateDb() #4 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(276): InstallerController->run('populatedb') #5 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(135): CWebApplication->runController('installer/popul...') #6 /var/www/web594/html/limesurvey/framework/base/CApplication.php(162): CWebApplication->processRequest() #7 /var/www/web594/html/limesurvey/index.php(178): CApplication->run() #8 {main}
Executing: create index `questions_idx3` on `lime_questions` (`gid`); failed! Reason: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1142 INDEX command denied to user 'web594'@'localhost' for table 'lime_questions'' in /var/www/web594/html/limesurvey/framework/db/CDbCommand.php:354 Stack trace: #0 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(921): CDbCommand->execute() #1 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(891): InstallerController->_executeSQLFile('/var/www/web594...', 'lime_') #2 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(555): InstallerController->_setup_tables('/var/www/web594...') #3 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(78): InstallerController->stepPopulateDb() #4 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(276): InstallerController->run('populatedb') #5 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(135): CWebApplication->runController('installer/popul...') #6 /var/www/web594/html/limesurvey/framework/base/CApplication.php(162): CWebApplication->processRequest() #7 /var/www/web594/html/limesurvey/index.php(178): CApplication->run() #8 {main}
Executing: create index `questions_idx4` on `lime_questions` (`type`); failed! Reason: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1142 INDEX command denied to user 'web594'@'localhost' for table 'lime_questions'' in /var/www/web594/html/limesurvey/framework/db/CDbCommand.php:354 Stack trace: #0 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(921): CDbCommand->execute() #1 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(891): InstallerController->_executeSQLFile('/var/www/web594...', 'lime_') #2 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(555): InstallerController->_setup_tables('/var/www/web594...') #3 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(78): InstallerController->stepPopulateDb() #4 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(276): InstallerController->run('populatedb') #5 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(135): CWebApplication->runController('installer/popul...') #6 /var/www/web594/html/limesurvey/framework/base/CApplication.php(162): CWebApplication->processRequest() #7 /var/www/web594/html/limesurvey/index.php(178): CApplication->run() #8 {main}
Executing: create index `quota_idx2` on `lime_quota` (`sid`); failed! Reason: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1142 INDEX command denied to user 'web594'@'localhost' for table 'lime_quota'' in /var/www/web594/html/limesurvey/framework/db/CDbCommand.php:354 Stack trace: #0 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(921): CDbCommand->execute() #1 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(891): InstallerController->_executeSQLFile('/var/www/web594...', 'lime_') #2 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(555): InstallerController->_setup_tables('/var/www/web594...') #3 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(78): InstallerController->stepPopulateDb() #4 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(276): InstallerController->run('populatedb') #5 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(135): CWebApplication->runController('installer/popul...') #6 /var/www/web594/html/limesurvey/framework/base/CApplication.php(162): CWebApplication->processRequest() #7 /var/www/web594/html/limesurvey/index.php(178): CApplication->run() #8 {main}
Executing: create index `saved_control_idx2` on `lime_saved_control` (`sid`); failed! Reason: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1142 INDEX command denied to user 'web594'@'localhost' for table 'lime_saved_control'' in /var/www/web594/html/limesurvey/framework/db/CDbCommand.php:354 Stack trace: #0 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(921): CDbCommand->execute() #1 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(891): InstallerController->_executeSQLFile('/var/www/web594...', 'lime_') #2 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(555): InstallerController->_setup_tables('/var/www/web594...') #3 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(78): InstallerController->stepPopulateDb() #4 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(276): InstallerController->run('populatedb') #5 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(135): CWebApplication->runController('installer/popul...') #6 /var/www/web594/html/limesurvey/framework/base/CApplication.php(162): CWebApplication->processRequest() #7 /var/www/web594/html/limesurvey/index.php(178): CApplication->run() #8 {main}
Executing: create index `parent_qid_idx` on `lime_questions` (`parent_qid`); failed! Reason: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1142 INDEX command denied to user 'web594'@'localhost' for table 'lime_questions'' in /var/www/web594/html/limesurvey/framework/db/CDbCommand.php:354 Stack trace: #0 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(921): CDbCommand->execute() #1 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(891): InstallerController->_executeSQLFile('/var/www/web594...', 'lime_') #2 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(555): InstallerController->_setup_tables('/var/www/web594...') #3 /var/www/web594/html/limesurvey/application/controllers/InstallerController.php(78): InstallerController->stepPopulateDb() #4 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(276): InstallerController->run('populatedb') #5 /var/www/web594/html/limesurvey/framework/web/CWebApplication.php(135): CWebApplication->runController('installer/popul...') #6 /var/www/web594/html/limesurvey/framework/base/CApplication.php(162): CWebApplication->processRequest() #7 /var/www/web594/html/limesurvey/index.php(178): CApplication->run() #8 {main}

Please Log in to join the conversation.

More
4 years 2 months ago #90768 by mdekker
You have insufficient rights on the database

---
Menno Dekker

Please Log in to join the conversation.