Add-ons
  1. Add-ons
  2. CONTRIB-27

MySQL admin browse view cannot be altered

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 1.7, 1.7.1, 1.8
    • Fix Version/s: None
    • Component/s: Add a project here
    • 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
    • Rank:
      21219

      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

        Activity

        Hide
        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
        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

          People

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

            Dates

            • Created:
              Updated:

              Development