Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-29580

Problems (DDL sql execution error) with new installtion of 2.1.1+

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Not a bug
    • 2.1.1
    • None
    • Database SQL/XMLDB
    • Webhosting www.hoststar.ch (webserver Apache, DB mySQl, Script PHP)
    • MySQL
    • MOODLE_21_STABLE
    • Hide

      no way - I am blocked. Please help

      Show
      no way - I am blocked. Please help

    Description

      want to do "a fresh" install of 2.1.1+ with on a professional webhost server.

      1.) After downloaded an encrypted files,
      2.) I transfered it onto the folder /html/moodle
      3.) created a blank database with mysql (db-name automatically from the systems, user-name from the system & password could change
      4.) no php.ini changes possible -> created standard .htaccess and puted in the mainfolder "moodle"
      5.) Start of installation with www.bkwin.ch/moodle
      6.) could do some steps, then blocked with error message "DDL sql execution error" (see attament)

      It's said:

      Debug info: INDEX command denied to user 'web69'@'localhost' for table 'config'
      CREATE UNIQUE INDEX conf_nam_uix ON config (name)
      Stack trace: 
      •	line 400 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
      •	line 655 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      •	line 88 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
      •	line 75 of /lib/ddl/database_manager.php: call to database_manager->execute_sql()
      •	line 456 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
      •	line 408 of /lib/ddl/database_manager.php: call to database_manager->install_from_xmldb_structure()
      •	line 1361 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
      •	line 182 of /admin/index.php: call to install_core()

      Why it's denied?

      Attachments

        1. .htaccess
          2 kB
        2. config.php
          0.7 kB
        3. Problem with installation 2.docx
          1.10 MB

        Issue Links

          Activity

            People

              skodak Petr Skoda
              fib@gmx.ch Bernhard Finger
              Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: