Solved - Fabrik + Visual SQL query builder

[mbeley]

Hi,

I'm trying to use a visual SQL query builder.
https://skyvia.com/query/
The builder is supposed to be able to write join statements automatically.
Unfortunately, it cannot see the joins in my Joomla/Fabrik database.

I got the following answer from their customer support : "The issue is related to the fact that you are using MYISAM engine. The MYISAM engine doesn't support foreign keys. In your DLL scripts you are not creating FOREIGN KEY, but creating KEY (INDEX)."

Is there any way to make it work?
Or can you guys suggest an alternative visual query builder that could work with Fabrik?
I'm also trying MySQL Workbench, which helps, but is not a visual builder (and does not automatically write join statements).

Thanks,
Mathieu

 

[cheesegrits]

Nope, we don't support Innodb / FK constraints. I've never used any visual query builders, I always do it the old fashioned way (in the Visual Query Builder module in my brain).

-- hugh