can you please show us your #__viewlevels table? as it should be there: https://github.com/joomla/joomla-cms/blob/staging/installation/sql/mysql/joomla.sql#L1989-L1994

And please also the #__usergroups table

Here are the screendumps of the requested tables.

So it looks like you installed sample data which one did you install?

Yes, it was a clean install of 3.6.3-dev with sample data 'Test English' (not sure about that name, but it is the last option).

Can you please retest and then confirm exactly which sample data set you installed and that the problem you have still exists

OK - i found the problem - I will do a PR for it shortly

Nope I can confirm the problem but I dont see what is causing it. It is only in the test sample data @zero-24 any ideas?

@brianteeman Okay, great you found it, I will test it when the PR is available.
I confirm it was the English Testdata, see screenshot, although in Dutch.

To me it looks like a mismatch with the ID of the usergroup Guest.
If referes to [9] in the rules-column, but there is no ID 9 in table #__usergroups.

In the backend I have set the access level Guest to usergroup Guest and now the #__viewlevels table shows [13].
Which is indeed the ID of the group Guest in table #__usergroups.

So I guess the sample data has a faulty ID in the install script?

My concern is that either it has always been broken - in which case a fix
is easy OR something broke it recently which I can not find.

It is a low priority though as the sample test data is not shipped with
Joomla it is only available from github

On 19 August 2016 at 11:14, BurtNL notifications@github.com wrote:

To me it looks like a mismatch with the ID of the usergroup Guest.
If referes to [9] in the rules-column, but there is no ID 9 in table
#__usergroups.

In the backend I have set the access level Guest to usergroup Guest and
now the #__viewlevels table shows [13].
Which is indeed the ID of the group Guest in table #__usergroups.

[image: screen shot 2016-08-19 at 05 12 52]
https://camo.githubusercontent.com/f7679b13ac8e0c49b1b00bb3a034d82d55ed99e6/68747470733a2f2f6973737565732e6a6f6f6d6c612e6f72672f75706c6f6164732f312f65643938663938393431323933316131623566306262376663666131653435322e706e67

So I guess the sample data has a faulty ID in the install script?

This comment was created with the J!Tracker Application
https://github.com/joomla/jissues at issues.joomla.org/joomla-cms/11660
https://issues.joomla.org/tracker/joomla-cms/11660.

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#11660 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/ABPH8VEtRgvoD-K8CzRFiyj7nTpmjMYDks5qhYIGgaJpZM4JnnEF
.

Brian Teeman
Co-founder Joomla! and OpenSourceMatters Inc.
http://brian.teeman.net/

@brianteeman yes it is on my list but i don't know if i get a PR ready today.

Here we add new usergroups but we need to fix the viewlevels than too
https://github.com/joomla/joomla-cms/blob/staging/installation/sql/mysql/sample_testing.sql#L775

This is an example how it should look like.
https://github.com/joomla/joomla-cms/blob/staging/installation/sql/mysql/sample_learn.sql#L761

Then we also need this line above in the sample_testing.sql file at line 16
https://github.com/joomla/joomla-cms/blob/staging/installation/sql/mysql/sample_learn.sql#L17

maybe the same for the other databases.

@zero-24 yes thats what I saw. Just surprised its "always" been broken for
that data set

On 19 August 2016 at 13:05, zero-24 notifications@github.com wrote:

@brianteeman https://github.com/brianteeman yes it is on my list but i
don't know if i get a PR ready today.

Here we add new usergroups but we need to fix the viewlevels than too
https://github.com/joomla/joomla-cms/blob/staging/
installation/sql/mysql/sample_testing.sql#L775

This is an example how it should look like.
https://github.com/joomla/joomla-cms/blob/staging/
installation/sql/mysql/sample_learn.sql#L761

Then we also need this line above in the sample_testing.sql file at line 16
https://github.com/joomla/joomla-cms/blob/staging/
installation/sql/mysql/sample_learn.sql#L17

maybe the same for the other databases.

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#11660 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/ABPH8TlBJMbOXSxbfRquzLSYzDcPm4-rks5qhZwJgaJpZM4JnnEF
.

Brian Teeman
Co-founder Joomla! and OpenSourceMatters Inc.
http://brian.teeman.net/

Don't be so surprised. That same sample data set had a broken JSON string for menu item parameters for years.

see: #11674

Closed as we have a pr.