Menu
▾
▴
#2809 (ok 3.1.2) Escaping special characters
When adding rights for a user to access views in the database (schema) vsa_test, the special character will be escaped properly.
When adding additional rights for that user to access the tables, the special character will NOT be escaped and one will get a second database entry in the list of specific rights.
Discussion
There is a bug but I want to verify something with you. The first db-specific GRANT should be on 'vsa\_test' but it's wrongly given to 'vsa_test'. Please confirm.
In older versions this part worked well.
Should be fixed now (for 3.1.2), patch available on http://phpmyadmin.svn.sourceforge.net/viewvc/phpmyadmin/branches/QA_3_1/phpMyAdmin/server_privileges.php?r1=11817&r2=12167
Please confirm with this patch or simply take the attached server_privileges.php.
patched server_privileges.php for 3.1.1
To lem9 at 2009-01-04 14:23
I can't confirm due to change of version, Sorry.
The intitial grant had been done with version 2.11.9.3, then we upgraded to 3.1.1 (because we want to update a view; in older versions the basic select went wrong) and after that I tried to change view specific rights.
To lem9 at 2009-01-04 21:31
We tried out server_privileges.php and it worked! Thanks.
Right now the are still some screens where special characters like underscore are being escaped (e.g.: Change rights screen) - on all others it is shown without escaping. But this it's just blemish ...
Case closed, R.J.
I'll have a look on those screens. Please don't close this entry, I'll close it when the corresponding version is released (we want to avoid duplicate bug entries).
Won't have time to look at other "blemish" cases.