Improper validation message is displayed while adding existing name in User manage Viewing access Level.

[amithadkar]

Steps to reproduce the issue

1.Go to User Manager: Add New Viewing Access Level
2. Enter public in name field(existing name)
3. Click save button verify the result
4. Following error is displayed.
Error
Save failed with the following error: Duplicate entry
'Public' for key 'idx_assetgroup_title_lookup' SQL=INSERT INTO
b12lm_viewlevels
(id,title,rules) VALUES
('0','Public','[]')

Expected result

Proper validation message should display.

Actual result

Validation message with sql query is displayed.

System information (as much as possible)

PHP Built On Windows NT 6.2 build 9200
Database Version 5.6.12-log
Database Collation utf8_general_ci
PHP Version 5.4.12
Web Server Apache/2.4.4 (Win64) PHP/5.4.12
WebServer to PHP Interface apache2handler
Joomla! Version Joomla! 3.3.7-dev Development [ Ember ] 01-October-2014 02:00 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 6.1; rv:32.0) Gecko/20100101 Firefox/32.0

Additional comments

[roland-d]

Changed status to Medium since this is not critical. However I do agree the message should be more userfriendly.

[ghost]

I have also tested this issue in joomla 3.7-dev.

This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4727.

[amithadkar]

Same issue exist in Edit case too.
Edit any access level and change the level title with existing one.

This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4727.

[irfanmomin]

I have tested with Joomla! 3.3.7-dev version
I have also found same issue which is described by @amithadkar .

This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4727.

[atpatil11]

Yes. Replicated issue on my side as well & added patch. Please find the patch for this issue here. #4838

This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4727.

[jissues-bot]

Set to "closed" on behalf of @zero-24 by The JTracker Application at issues.joomla.org/joomla-cms/4727

[zero-24]

Closing as we have a PR by @atpatil11 for this #4838