The LimeSurvey Fund-Raiser 2012 is complete. Thank you for donating a total of 25,000 USD!     List of donors »

Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Datenbankfehler

Datenbankfehler 4 months 2 weeks 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 4 months 2 weeks 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.

Re: Aw: Datenbankfehler 4 months 2 weeks ago #90768

  • mdekker
  • mdekker's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 254
  • Thank you received: 40
  • Karma: 25
You have insufficient rights on the database
---
Menno Dekker
The administrator has disabled public write access.
  • Page:
  • 1
Moderators: ITEd
Time to create page: 0.194 seconds
Donation Image