import list csv frontend

[pevomjt]

hi,
when I try to import a list from the frontend I get error 1146 Table 'xxxx.usr_fabrik_lists' doesn't exist, if instead I try from the backend I have no problems.

Joomla 4.3.1
Fabrik 4 gamma 3

 

[troester]

Maybe an access level issue?

 

[pevomjt]

No, it doesn't! I also tried with super user...
debug:

 

[troester]

Strange.
Is 'usr' your Joomla-DB-prefix, 'usrGps' your Joomla database name?

Is your Fabrik connection pointing to the correct database?

 

[pevomjt]

Strange.
Is 'usr' your Joomla-DB-prefix, 'usrGps' your Joomla database name?

yes it is

Is your Fabrik connection pointing to the correct database?

 

[troester]

Where are you using the multiple connections?
Is the list you are trying to import to also in the default Joomla database?

Edit:
Tested to import in lists in frontend and backend, even with multiple Fabrik connections.
I can't replicate your issue.

 

[pevomjt]

The list is not in the Joomla database, just the usrGps database. The problem occurs when I press the import csv button from the frontend, if instead I press the same button from the backend it opens the import window

 

[pevomjt]

solved by selecting the joomla database as the default connection.

 

[troester]

The issue can be fixed with
$db = FabrikWorker::getDbo(true);
in components\com_fabrik\views\import\view.html.php line 86

But working with multiple connections may have issues anyway (e.g. you can't do joins between lists with different connections, dbjoin elements to other databases etc).
And if the connection to the J! DB doesn't have id=1 and/or isn't the default - no idea what may happen somewhere else.

I didn't test but I'm pretty sure this frontend import doesn't do in Fabrik 3, too.

 

[pevomjt]

I tested also in Fabrik3 some problem!