error on import view from Mariadb

[troester]

Do you have existing lists pointing to this view from your tests?
Please delete (trash + empty trash) them and try again.

(Fabrik is trying to create child elements if there's already a list linked to the table/view you are selecting. Not sure what is happening in case of non-existing or deleted elements)

 

[pevomjt]

I always delete lists, forms, groups, and elements from the trash can. The problem remains; I have identified that the list is created on xxx_fabrik_lists, but the elements that make up the list are not created on xxx_fabrik_elements.

 

[troester]

No idea what is going on on your site.
Can you create a normal new list? Add elements etc?
Can you create a new list linked to a database table (not view)?
Can you create a new list link to an other view?

Is this a new J!4/F4 installation or an updated one?
Anything showing up in the J! "System" dashboard (e.g. Maintanace Database)?
Anything in error logs?

 

[pevomjt]

No idea what is going on on your site.
Can you create a normal new list? Add elements etc?

Yes I can.

Can you create a new list linked to a database table (not view)?

Yes I can.

Can you create a new list link to an other view?

yes I can create a view, but with some it only creates the structure without elements, these must be added one at a time, and assigning the PK to one of them

Is this a new J!4/F4 installation or an updated one?

it is upgrade from J!3/F3

Anything showing up in the J! "System" dashboard (e.g. Maintanace Database)?
Anything in error logs?

 

[troester]

but with some it only creates the structure without elements

So you have views you can use for a list and the elements are created?
What is the difference between views which are creating elements and the ones which don't?

 

[troester]

Ok, I may have found it:
In #_fabrik_elements what are the settings for column `default`?
It should be nullable.
https://fabrikar.com/forums/index.p...ault-doesnt-have-a-default-value-error.53743/

 

[pevomjt]

I send you screenshot

 

[pevomjt]

ok perfect I selected the flag not null of the default column.
Thank you very much