?
avatar amithadkar
amithadkar
17 Oct 2014

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.screen shot 2014-10-17 at 02 03 02

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

Votes

# of Users Experiencing Issue
4/4
Average Importance Score
3.00

avatar amithadkar amithadkar - open - 17 Oct 2014
avatar roland-d roland-d - change - 17 Oct 2014
Priority Critical Medium
avatar roland-d
roland-d - comment - 17 Oct 2014

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

avatar jigarkg
jigarkg - comment - 17 Oct 2014

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.

avatar amithadkar
amithadkar - comment - 17 Oct 2014

Same issue exist in Edit case too.
Edit any access level and change the level title with existing one.screen shot 2014-10-17 at 04 09 18

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

avatar irfanmomin
irfanmomin - comment - 17 Oct 2014

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.

avatar atpatil11
atpatil11 - comment - 18 Oct 2014

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.

avatar zero-24 zero-24 - close - 18 Oct 2014
avatar zero-24 zero-24 - change - 18 Oct 2014
Status New Closed
avatar zero-24
zero-24 - comment - 18 Oct 2014

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

avatar jissues-bot
jissues-bot - comment - 18 Oct 2014

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

avatar jissues-bot jissues-bot - close - 18 Oct 2014
avatar jissues-bot jissues-bot - change - 18 Oct 2014
Closed_Date 0000-00-00 00:00:00 2014-10-18 13:19:14
avatar zero-24 zero-24 - change - 7 Jul 2015
Labels Added: ?

Add a Comment

Login with GitHub to post a comment