bespokeappstt
Hubstaff freelancer
I built a list that works fine. I would like to know the sql that is being used by Fabrikar to produce that list. How can I get the sql that is being used?
-
New Commercial Services Section
We have now opened a commercial services section here on the forum for registered users. If you have a Fabrik project that you wish to have someone work on for you, post it under Help Wanted. If you are an application developer and wish to earn some money helping others, post your details under Fabrik Application Developers.
Both of these are unmoderated. It will be up to both parties to work out the details and come to an agreement.
-
Joomla 5.1
For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
Viewing SQL for list?
- Thread starter bespokeappstt
- Start date
What do you mean with "produce that list"?
The SQL to create the table? This can be found in e.g. phpMyAdmin.
Or the SELECT to fetch the list data? Enable "Fabrik debug" in Fabrik Options and then append fabrikdebug=1 to your listURL. The SELECT statement can be found in "List GetData"
The SQL to create the table? This can be found in e.g. phpMyAdmin.
Or the SELECT to fetch the list data? Enable "Fabrik debug" in Fabrik Options and then append fabrikdebug=1 to your listURL. The SELECT statement can be found in "List GetData"
bespokeappstt
Hubstaff freelancer
Yes I want the SELECT statement used to generate the list. I followed your instructions but am getting an error in phpmyadmin when I run the same sql statement.
When I run this same sql in phpmyadmin I get the following:
When I run this same sql in phpmyadmin I get the following:
Terminology: SELECT does not "generate" a database table (that would be CREATE), but indeed fetches data from it.
The good news is, however, that the SELECT is what you wanted, and you found it.
Now, most error messages are true, and so is this. When directly in phpMyAdmin, you cannot use "#__" in a table name but must replace it with the table prefix.