Welcome, Guest
Username: Password: Remember me

TOPIC: Datenbankfehler

Datenbankfehler 1 year 7 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 1 year 7 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.

Re: Aw: Datenbankfehler 1 year 7 months ago #90768

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