|
|
|
Environment:
|
Win2k3, Apache, MySQL 5.0.18, PHP 5.1.1, MySQL Admin version 2.8.2
|
|
| Database: |
MySQL
|
| Participants: |
Martin Dougiamas and Matt Gibson
|
| Security Level: |
None
|
| Affected Branches: |
MOODLE_17_STABLE, MOODLE_18_STABLE
|
|
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
|
|
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 |
Show » |
|
Bug
Open
Major
MySQL admin browse view cannot be altered
Error
SQL query: Edit
INSERT INTO `mdl_config` ( )
VALUES (
), (
)
MySQL said: Documentation
#1062 - Duplicate entry '' for key 2