Creating a list on a view

[johnonorvic]

A few years ago, I had a problem creating lists from views, getting error 1347 “...is not BASE TABLE”. I found a forum post indicating the problem was solved, but giving a work-around in case it reappeared. Applying the work-around solved my problem and I used it several times. Some time later, probably after an update or two, I needed to create lists from views again; by then I had forgotten the problem and it did not re-occur. I have since created more lists without problem, probably in both Fabrik 3 and 4, but since upgrading to Epsilon, it has re-occurred on the two lists I have created.

The original post is Cannot make list from database view.

The creation sequence for the second list was:

Create list based on a view and save.
Messages:

A join or a list has been added which has no Primary Key. ...
Item saved.​

Re-open new list for editing.
In data section

select ID field as Primary key​

and save.
Messages:

An error has occurred.
1347 'databasename.viewname' is not BASE TABLE
Call stack

...​

Previous Error
'databasename.viewname' is not BASE TABLE
Call stack

…
(I have omitted the call stacks, but could post them if useful.)​

In Joomla data connection, open jos_fabrik_lists
In record for new table, params field is

{"show-table-filters":"1",
...
"isview":"0"}​

Change

"isview":"0"​

to

"isview":"1"​

Re-open new list for editing.
In data section

select ID field as Primary key​

and save
No error.
Message: Item saved.​

Parts of he old forum post seem to suggest that the setting of isview may be a bit sensitive; perhaps something in Epsilon has upset it again.

Fabrik 4.0Epsilon, Joomla 4.3.4, PHP 8.1.24, MySQL 5.7.42.