Uploaded image for project: 'Moodle Community Sites'
  1. Moodle Community Sites
  2. MDLSITE-1217

ddlexecuteerror documentation is inadequate

          Details

          • Type: Task
          • Status: Closed
          • Priority: Minor
          • Resolution: Fixed
          • Component/s: docs.moodle.org
          • Labels:
            None

            Description

            While trying to install Moodle 2.0 against PostgreSQL I received the below error.

            DDL sql execution error
            More information about this error

            "More information about this error" is a link to http://docs.moodle.org/en/error/moodle/ddlexecuteerror
            The page tells you nothing about the error or what you're meant to do about it.

              Gliffy Diagrams

                Attachments

                  Issue Links

                  has been marked as being related by

                  Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-21874 Moodle 2.0 clean install against PostgreSQL fails with DDL error

                  • Blocker - Blocks development and/or testing, prevents Moodle from running (applicable to bugs only)
                  • Closed

                  Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-23121 CLONE -Moodle 2.0 clean install fails with DDL error

                  • Blocker - Blocks development and/or testing, prevents Moodle from running (applicable to bugs only)
                  • Closed

                    Activity

                    Ascending order - Click to sort in descending order
                    Hide
                    Permalink
                    skodak Petr Skoda added a comment -

                    The problem is we can not display the raw sql and error messages because it could leak sensitive information or could simplify attacks. If you enable debug mode it tells you a lot more.

                    Maybe we could add some info that more info is dispalyed only in debug mode...

                    Show
                    skodak Petr Skoda added a comment - The problem is we can not display the raw sql and error messages because it could leak sensitive information or could simplify attacks. If you enable debug mode it tells you a lot more. Maybe we could add some info that more info is dispalyed only in debug mode...
                    Hide
                    Permalink
                    andyjdavis Andrew Davis added a comment -

                    More info in debug mode would be handy. Beyond that it feels like the page at http://docs.moodle.org/en/error/moodle/ddlexecuteerror should be giving more information. For a user getting there theyll want to know roughly what a "DDL execution error" is and what they should do now. At the moment the error message and associated help doco don't give the user any clue of what went wrong and what they should do.

                    Show
                    andyjdavis Andrew Davis added a comment - More info in debug mode would be handy. Beyond that it feels like the page at http://docs.moodle.org/en/error/moodle/ddlexecuteerror should be giving more information. For a user getting there theyll want to know roughly what a "DDL execution error" is and what they should do now. At the moment the error message and associated help doco don't give the user any clue of what went wrong and what they should do.
                    Hide
                    Permalink
                    tsala Helen Foster added a comment -

                    Andrew, thanks for your report. Unfortunately I don't know anything about DDL sql execution errors so I can't write any documentation. Reassigning to moodle.com and hoping someone can help out.

                    Show
                    tsala Helen Foster added a comment - Andrew, thanks for your report. Unfortunately I don't know anything about DDL sql execution errors so I can't write any documentation. Reassigning to moodle.com and hoping someone can help out.
                    Hide
                    Permalink
                    libertymoodle Luis de Vasconcelos added a comment -

                    I got the same error while testing a 1.9 to 2 Windows upgrade so I went looking for answers. I added some notes to that page based on what I found. It probably needs a review by an expert...

                    Show
                    libertymoodle Luis de Vasconcelos added a comment - I got the same error while testing a 1.9 to 2 Windows upgrade so I went looking for answers. I added some notes to that page based on what I found. It probably needs a review by an expert...
                    Hide
                    Permalink
                    tsala Helen Foster added a comment -

                    Luis, thanks a lot for adding your notes to http://docs.moodle.org/20/en/error/moodle/ddlexecuteerror

                    I'm resolving the issue as fixed, though further improvements to the documentation are always welcome.

                    Show
                    tsala Helen Foster added a comment - Luis, thanks a lot for adding your notes to http://docs.moodle.org/20/en/error/moodle/ddlexecuteerror I'm resolving the issue as fixed, though further improvements to the documentation are always welcome.

                      People

                      • Votes:
                        0 Vote for this issue
                        Watchers:
                        2 Start watching this issue

                        Dates

                        • Created:
                          Updated:
                          Resolved: