Simple joining of list gives error

[tmntmn]

Hi All

Trying to join the tables j25_users with j25_users_usergroup_map

see attached: Fabrik_1

however viewing list gives this error: Fabrik_2


It worked for a short while, then this suddenly appeared.

I've tried to delete the list and try from scratch, but the erroro keeps coming back.

Any ideas?

Thomas

 

[troester]

1.
Which exact fabrik and Joomla versions are you running (updates, GitHub...)?
2.
Linking fabrik lists to (Joomla or other components) core tables is risky, did you at least set "alter existing fields"=no in the list settings?

3.
I don't think you can link a fabrik list to j25_users_usergroup_map: fabrik lists need a PK element integer (autoincrement), j25_users_usergroup_map doesn't contain one

4.
your attachments are missing

 

[tmntmn]

1. Latest Github from today 3.07

2. Yes I know about the danger, never planning to "update" list just need it for sorting mailadresse on usergroups for a mail lists.

3. It seems I get same error joining other list.

4. sorry about the attachments, trying once more

Thank you for your quick reply

Thomas

 

[rob]

I made the same join and it worked for me, not sure what to suggest here.

It worked for a short while, then this suddenly appeared.

Any ideas what change of state trigger things not to work? Are you editing records via this list, or editing element properties?

 

[tmntmn]

OK it works now. Deleted everything and started over again. Never found out what caused it.

Thanks for your reply and testing.

Thomas