Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-27

MySQL admin browse view cannot be altered

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Inactive
    • Affects Version/s: 1.7, 1.7.1, 1.8
    • Fix Version/s: None
    • Labels:
      None
    • Environment:
      Win2k3, Apache, MySQL 5.0.18, PHP 5.1.1, MySQL Admin version 2.8.2
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_17_STABLE, MOODLE_18_STABLE

      Description

      Going into any table and then selecting browse works OK, but when trying to alter the number of rows displayed, or the page you are looking at, than clicking 'show' gives an error like this:

      There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

      ERROR: Unknown Punctuation String @ 7
      STR: +%
      SQL: SELECT+%2A+FROM+%60mdl_cache_text%60

      SQL query: Documentation

      SELECT+%2A+FROM+%60mdl_cache_text%60

      MySQL said: Documentation
      #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%2A+FROM+%60mdl_cache_text%60' at line 1

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            mattgibson Matt Gibson added a comment -

            additionally, when trying to alter a value via the edit button, the dialogue comes up, but pressing the save button gives this error:

            Error

            SQL query: Edit

            INSERT INTO `mdl_config` ( )
            VALUES (
            ), (
            )

            MySQL said: Documentation
            #1062 - Duplicate entry '' for key 2

            Show
            mattgibson Matt Gibson added a comment - additionally, when trying to alter a value via the edit button, the dialogue comes up, but pressing the save button gives this error: Error SQL query: Edit INSERT INTO `mdl_config` ( ) VALUES ( ), ( ) MySQL said: Documentation #1062 - Duplicate entry '' for key 2
            Hide
            mudrd8mz David Mudrák added a comment -

            This issue is now being closed as a part of massive bulk operation. Please read on.

            Summary:

            • If you still want to use this Moodle Tracker for your plugin (you don't need to), and you request a new component be created here, then please comment on this issue so that we can re-open it and process.
            • If you decided to use other tracking system (such as Github Issues) for your plugin, no action is needed.
            • If this issue was closed by accident and has nothing to do with requesting a new component for your plugin, and it is still relevant and valid issue, then please comment here.

            Details:

            This issue has a component set to "Add a new project here". It was supposed to be used for requesting a new CONTRIB component for the plugin. It turned out that the documentation for this workflow was not that clear and there were multiple irrelevant issues created due to misunderstanding. Additionally, many issues were forgotten in Unresolved status. It is difficult to see which issues are still valid and relevant.

            To move on with the backlog, I am now closing all unresolved CONTRIB issues of this component. If you are the reporter of the issue and you believe it should be reopened as still valid, please comment here.

            This will allow us to clean up the queue of the requests and focus on those valid ones only. I will also improve the Plugin contribution documentation to make the whole workflow a bit easier to follow and understand.

            Thanks a lot for your understanding and co-operation.

            Show
            mudrd8mz David Mudrák added a comment - This issue is now being closed as a part of massive bulk operation. Please read on. Summary: If you still want to use this Moodle Tracker for your plugin (you don't need to), and you request a new component be created here, then please comment on this issue so that we can re-open it and process. If you decided to use other tracking system (such as Github Issues) for your plugin, no action is needed. If this issue was closed by accident and has nothing to do with requesting a new component for your plugin, and it is still relevant and valid issue, then please comment here. Details: This issue has a component set to "Add a new project here". It was supposed to be used for requesting a new CONTRIB component for the plugin. It turned out that the documentation for this workflow was not that clear and there were multiple irrelevant issues created due to misunderstanding. Additionally, many issues were forgotten in Unresolved status. It is difficult to see which issues are still valid and relevant. To move on with the backlog, I am now closing all unresolved CONTRIB issues of this component. If you are the reporter of the issue and you believe it should be reopened as still valid, please comment here. This will allow us to clean up the queue of the requests and focus on those valid ones only. I will also improve the Plugin contribution documentation to make the whole workflow a bit easier to follow and understand. Thanks a lot for your understanding and co-operation.

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: