Details

    Description

      Each error code should have its own page, with details and links to ways to overcome it

      Attachments

        Issue Links

          Activity

            ralf.gebhardt Ralf Gebhardt added a comment -

            Could we have an URL with the error a redirect to the same page with an URL using the error code?

            The page could include some history about when an error code was added. Like ER_STORAGE_ENGINE_DISABLED , which was added only with 10.6. To not need to maintain this content manually an idea could be to get such details from the release notes, somehow like done for CVEs

            Will the table https://mariadb.com/kb/en/mariadb-error-code-reference/ be built from these pages that the content only needs to be maintained on one page?

            ralf.gebhardt Ralf Gebhardt added a comment - Could we have an URL with the error a redirect to the same page with an URL using the error code? The page could include some history about when an error code was added. Like ER_STORAGE_ENGINE_DISABLED , which was added only with 10.6. To not need to maintain this content manually an idea could be to get such details from the release notes, somehow like done for CVEs Will the table https://mariadb.com/kb/en/mariadb-error-code-reference/ be built from these pages that the content only needs to be maintained on one page?
            greenman Ian Gilfillan added a comment -

            When you say "URL with the error", can you give a specific example?

            Currently there's https://mariadb.com/kb/en/e1006/, which I think is easiest as it just uses the error number, and https://mariadb.com/kb/en/error-1006-cant-create-database/ (generated from the title).

            Regarding building https://mariadb.com/kb/en/mariadb-error-code-reference/ from these pages, it's more the other way round, as the individual pages should be automatically generated, and then populated with more details, examples, ways to overcome etc.

            greenman Ian Gilfillan added a comment - When you say "URL with the error", can you give a specific example? Currently there's https://mariadb.com/kb/en/e1006/ , which I think is easiest as it just uses the error number, and https://mariadb.com/kb/en/error-1006-cant-create-database/ (generated from the title). Regarding building https://mariadb.com/kb/en/mariadb-error-code-reference/ from these pages, it's more the other way round, as the individual pages should be automatically generated, and then populated with more details, examples, ways to overcome etc.

            And now with a 2-line change I have

            MariaDB [test]> select (select 1 union select 2);
            ERROR 1242 (21000): Subquery returns more than 1 row
            More information:  https://mariadb.com/kb/en/e1242/
             
            MariaDB [test]> select foo;
            ERROR 1054 (42S22): Unknown column 'foo' in 'field list'
            More information:  https://mariadb.com/kb/en/e1054/
            

            serg Sergei Golubchik added a comment - And now with a 2-line change I have MariaDB [test]> select (select 1 union select 2); ERROR 1242 (21000): Subquery returns more than 1 row More information: https://mariadb.com/kb/en/e1242/   MariaDB [test]> select foo; ERROR 1054 (42S22): Unknown column 'foo' in 'field list' More information: https://mariadb.com/kb/en/e1054/
            ralf.gebhardt Ralf Gebhardt added a comment -

            When you say "URL with the error", can you give a specific example?

            Currently there's https://mariadb.com/kb/en/e1006/, which I think is easiest as it just uses the error number, and https://mariadb.com/kb/en/error-1006-cant-create-database/ (generated from the title).

            With "URL with the error" I meant https://mariadb.com/kb/en/ER_CANT_CREATE_DB. But after some checks I see that ER_CANT_CREATE_DB more or less never. would be shown to a user. That said, I think that https://mariadb.com/kb/en/e1006/ should be good enough. the generated URL https://mariadb.com/kb/en/error-1006-cant-create-database/ only would add some value to me if it would be the URL displayed in the browser. But key will be to find the page easily (google search) and to have a short URL which can be added to tools (like Serg did - "nice") or server log. Nobody will guess the URL to find the error code description.

            Regarding building https://mariadb.com/kb/en/mariadb-error-code-reference/ from these pages, it's more the other way round, as the individual pages should be automatically generated, and then populated with more details, examples, ways to overcome etc.

            So if I understand correctly you would generate error pages from https://mariadb.com/kb/en/mariadb-error-code-reference/, which you edit manually, correct? I thought about getting the error codes from the source, therefore my comment about an automated creation of https://mariadb.com/kb/en/mariadb-error-code-reference/

            ralf.gebhardt Ralf Gebhardt added a comment - When you say "URL with the error", can you give a specific example? Currently there's https://mariadb.com/kb/en/e1006/ , which I think is easiest as it just uses the error number, and https://mariadb.com/kb/en/error-1006-cant-create-database/ (generated from the title). With "URL with the error" I meant https://mariadb.com/kb/en/ER_CANT_CREATE_DB . But after some checks I see that ER_CANT_CREATE_DB more or less never. would be shown to a user. That said, I think that https://mariadb.com/kb/en/e1006/ should be good enough. the generated URL https://mariadb.com/kb/en/error-1006-cant-create-database/ only would add some value to me if it would be the URL displayed in the browser. But key will be to find the page easily (google search) and to have a short URL which can be added to tools (like Serg did - "nice") or server log. Nobody will guess the URL to find the error code description. Regarding building https://mariadb.com/kb/en/mariadb-error-code-reference/ from these pages, it's more the other way round, as the individual pages should be automatically generated, and then populated with more details, examples, ways to overcome etc. So if I understand correctly you would generate error pages from https://mariadb.com/kb/en/mariadb-error-code-reference/ , which you edit manually, correct? I thought about getting the error codes from the source, therefore my comment about an automated creation of https://mariadb.com/kb/en/mariadb-error-code-reference/
            greenman Ian Gilfillan added a comment -

            Error pages are created. Unfortunately I can't link to the individual pages from the index page due to the currently broken KB.

            greenman Ian Gilfillan added a comment - Error pages are created. Unfortunately I can't link to the individual pages from the index page due to the currently broken KB.

            People

              greenman Ian Gilfillan
              greenman Ian Gilfillan
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.