Fabrik has generated an incorrect query error 500

[Kordian]

Hello,
I have a bunch of lists, that I cannot see anymore (after upgrade to 4.5.1)
Joomla 5.2.4
Php 8.3.7
Fabrik 4.5.1
When I click View data for those lists, the 500 error comes up.
Fabrik has generated an incorrect query error for the list XXXXXX: <br />
The connection to the db is ok, I have other tables on these servers and they work fine.
Thank you in advance!

#	Function	Location
1	()	JROOT/components/com_fabrik/models/list.php:978
2	FabrikFEModelList->getData()	JROOT/components/com_fabrik/models/list.php:736
3	FabrikFEModelList->render()	JROOT/components/com_fabrik/views/list/view.base.php:437
4	FabrikViewListBase->display()	JROOT/components/com_fabrik/views/list/view.html.php:46
5	FabrikViewList->display()	JROOT/administrator/components/com_fabrik/controllers/list.php:157
6	FabrikAdminControllerList->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:730
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_fabrik/fabrik.php:104
8	require_once()	JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
9	Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}()	JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
10	Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch()	JROOT/libraries/src/Component/ComponentHelper.php:361
11	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/AdministratorApplication.php:150
12	Joomla\CMS\Application\AdministratorApplication->dispatch()	JROOT/libraries/src/Application/AdministratorApplication.php:205
13	Joomla\CMS\Application\AdministratorApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:306
14	Joomla\CMS\Application\CMSApplication->execute()	JROOT/administrator/includes/app.php:58
15	require_once()	JROOT/administrator/index.php:32

 

[troester]

Upgrade from which version?
What is the full error message?
Is it on all lists or special ones?

 

[Kordian]

Well, good question. I do not remember, it was definitely 4 version of Fabrik, I quess 4.1. Just edited the post to include the full error message.
No, it is only actually one list, because the db is duplicated on various servers and the lists that are not working is only one of the many. But this particular does not work on either server.

 

[troester]

Enable Fabrik Debug in Options. This should show additionally the MySQL error.

 

[Kordian]

Now I see...
SELECT command denied to user 'xxx' for table 'yyyy'
I guess it is the permission issue??? If so, I will check it later today.

 

[troester]

So this list is using a connection to an other DB?

This other DB must grant the access for the creditals (the DB user) set in your alternate Fabrik connection.

And (at least on my server) it must explicitely grant "Remote Database Access" to the IP/host your site is running on.

I don't think that this is related to the upgrade itself.
More likely it's about DB copies etc.

 

[Kordian]

OK, the problem seems solved.
However there is a chance it will be interesting for you, so here is the explanation:
I have 2 servers, name them Server1 and Server2
On Server1 I have joomla with fabrik and mysql - db1.
On server2 there is only mysql - db2.
Fabrik has connections to both db.
In Fabrik I used an existing list from db2 to add a new databasejoin element pointing to another list within DB1. The creation process was successfull - I got the connection, table and elements while selecting it.
However after successfull creation when I wanted to view the data, it stated SELECT is denied.
How come it was not denied, when I was creating the element? This is strange to me. I would expect Select being denied already during adding the element.
Do not know whether you as programmers agree.
Anyway the solution was removing this element from the list.
Regards

 

[troester]

Yes. Crossjoining is not supported ( I think it's mentioned somewhere in the WIKI).
And it's likely that it is not catched at element creation. I assume multiple databases are used very seldom.
Feel free to improve

 

[Kordian]

Thank you, this solves this issue.