Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: Datenbankfehler

Datenbankfehler 3 years 10 months ago #90766

  • bethaarea
  • bethaarea's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
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!!!!
The administrator has disabled public write access.

Aw: Datenbankfehler 3 years 10 months ago #90767

  • bethaarea
  • bethaarea's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
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}
The administrator has disabled public write access.

Aw: Datenbankfehler 3 years 10 months ago #90768

  • mdekker
  • mdekker's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 344
  • Thank you received: 68
  • Karma: 38
You have insufficient rights on the database
---
Menno Dekker
The administrator has disabled public write access.
Time to create page: 0.311 seconds
Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form