Bug - List primary key changed to element id

[PvN94]

Everytime I try to save a list, fabrik gives an error that the key column doesn't exist. Instead of using tablename.id as the primary key, it tries to use the id of the internalid element (eg. 1197).

In the fabrik_lists table I can see that every list I try to edit changes the value of db_primary_key from tablename.id to the element id.

Manually changing back the info in the fabrik_lists table makes everything work again, but this is ofcourse not a permanent solution.

 

[troester]

I can't replicate but it's ringing a bell...
Which exact Joomla and Fabrik version are you running?
Do you have multiple Fabrik connections?
Is connection with id=1 going to the Joomla DB with correct parameters?

Was this site updated from former Joomla/Fabrik versions?

 

[cheesegrits]

This sounds like something which was a bug for a very short time in github, several years ago.

-- hugh

 

[PvN94]

I'm on Joomla version 3.4.0 and Fabrik version 3.3.3. Only have 1 connection, with id 1 going to the right database. I did update the fabrik components to 3.3.3 recently (yesterday), so that may be it. I assume i'll have to update to Joomla 3.4.4??

 

[PvN94]

Ok i've updated joomla to 3.4.4 and the problem persists. Any ideas on how to fix this??

 

[cheesegrits]

Can you check the file ./administrator/components/com_fabrik/models/forms/list.xml, around line 129 should be where we define the db_primary_key field, and make sure that valueformat="tableelement", not valueformat="id".

-- hugh

 

[PvN94]

I updated everything with the latest version from github, and it seems to be working properly again. Thanks for your help!