Solved UserGroup Element error

[jj-pilot]

Just wanted to let you know about this (from another thread)

"
But I tested what you mentioned, relating a record to two groups, and got this error:

An error has occurred.

500 Store row failed: Incorrect integer value: '["3","10"]' for column 'owner' at row 1 ; Please inform your web-site owner

Furthermore I experience another problem: when I first relate the record to a group and hit save - everything is ok - but then, when coming back later to edit the record, the relation in the UserGroup element is gone, and I have to remember to set the group relation again.

So this didn't work at all for me - but I wonder if this is an error, or a limitation?"

 

[troester]

A usergroup element is created with column text.
Did you change the element type (plugin) of your 'owner' element at some point
e.g. from a dbjoin or a field with INT set?

Or do you have additionally a jUser form plugin with maybe wrong settings (linking your usergroup element to userid/'owner' or so)?

 

[jj-pilot]

No, I took the element "off the shelf" - so to speak.

Haven't changed anything, and the List is a stand alone list (no linking)

 

[jj-pilot]

Got this error when I closed the element (after taking the screenshot above)

 

[troester]

You can't use the usergroup element itself as "User element"

User element is an element holding the userid.

 

[jj-pilot]

Yes I know. And I then want the following pre-filter, to use the info, being kept in the Usergroup element.

WHERE
Field: owner
Condition: IN
Value: {$my->groups}
Type: query
Apply to: Public

And initially it works, but then:

• if a record is ticked with more than one user group, the pre-filter fails
• next, when I open a record to edit it, the marked UserGroup element goes blank

 

[troester]

I don't understand your setup.
Is owner your element storing the userid
or the usergroup element?

Sureley this prefilter query will fail if 'owner' (whatever it is) is no single value.

But this is not a topic here for "UserGroup Element error"

 

[jj-pilot]

I get that.

"Owner" is just a name I gave the UserGroup element.

My idea was to pick the Joomla UserGroup value and place it in the Owner field - for later filtering. To allow the user to open to which he/she has access to.
So that I can manage.

But I still think there must be a bug, when the chosen value is deleted, when opening the record for editing.
The member "StartPoint" told me, that he had had the same problem...

 

[troester]

In your screenshot you set "Owner" as User element, this doesn't make any sense and may be the reason for this "incorrect int" error.
If you select an element there it must be an element holding a userid.

 

[jj-pilot]

I may be confused by the FABRIK terms, but isn't the plugin a "usergroup"?

Frontend is showing User Groups. And I would think that this type of field would be useful for filtering (even if more than one UserGroup were chosen) - and the other problem I have mentioned, is shown here as well: before opening the record for editing, the usergroup "144-seemand" was ticked of - but now this has been deleted (which leads to a lot of confusion if someone forgets to re-tick the field before saving).

So if I get this all wrong, do you know of anywhere in the WIKI where I can learn what this type of fields is for, and how I can use it?

 

[troester]

You must not set "Owner" as "User element" in the usergroups element settings.

 

[jj-pilot]

I have deleted this element and given up on my attempt to filter by UserGroups - I'm simply not sufficiently skilled to comprehend this (which irritates me a bit, because I find that the idea of a tool like FABRIK is just what JOOMLA needs - for people who wants to build information platforms anyway- but it's too complicated for no-coders, and the documentation is, well, so and so)

 

[troester]

It's no problem to set up the pre-filter (you can use queries or php code if simple conditions won't do).
And yes, if you want to use more than the "out of the box" features of Fabrik you'll need some coding and DB understanding.

But this thread is about UserGroup Element error which is not replicatable with correct settings.

You can't mix up user element (holding a userID) and usergroup element (holding user groups).
And it doesn't make sense to use a usergroup element if it's throwing errors, so this has to be fixed before.