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

            mattgibson Matt Gibson created issue -
            mudrd8mz David Mudrák made changes -
            Field Original Value New Value
            Assignee Martin Dougiamas [ dougiamas ] David Mudrák [ mudrd8mz ]
            mudrd8mz David Mudrák made changes -
            Status Open [ 1 ] Closed [ 6 ]
            Resolution Inactive [ 10000 ]

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: