• Hello Fabrik Community

    Fabrik is now in the hands of the development team that brought you Fabrik for Joomla 4. We have recently transitioned the Fabrik site over to a new server and are busy trying to clean it up. We have upgraded the site to Joomla 4 and are running the latest version of Fabrik 4. We have also upgraded the Xenforo forum software to the latest version. Many of the widgets you might have been used to on the forum are no longer operational, many abandoned by the developers. We hope to bring back some of the important ones as we have time.

    Exciting times to be sure.

    The Fabrik 4.0 Official release is now available. In addition, the Fabrik codebase is now available in a public repository. See the notices about these in the announcements section

    We wish to shout out a very big Thank You to all of you who have made donations. They have really helped. But we can always use more...wink..wink..

    Also a big Thank You to those of you who have been assisting others in the forum. This takes a very big burden off of us as we work on bugs, the website and the future of Fabrik.

List not accessible through joomla menu

chofra02

Certified try and error specialist
Hi,
I have a new issue since a couple of days on my website.
I have a list which I call over a menu.
I setup the menu using the menu admin module.
There I have chosen Menu item type Fabrik - List and chosen a list, with no pre-filters etc..
This worked for ages (4 years) but since a couple of days this does not work anymore..
If I click on the link in the menu I get an Error 500 Fabrik has generated an incorrect query for the list IRL Results - Team competition ...
If I use the direct URL (index.php?option=com_fabrik&view=list&listid=62) of the menu link, this works and the list is displayed correctly.
I'm on Joomla latest level 3.9.21 and latest Fabrik level 3.9.2

I have by the way the same problem with a form but only for some users .. wired ..

Thank you for your help.

Cheers
 
Last edited:
So which URL is generated via menu item?
Enable Fabrik debug (in Fabrik options/Debugging) and then add &fabrikdebug=1 to the menu URL. This should show the complete error.
 
So which URL is generated via menu item?
Enable Fabrik debug (in Fabrik options/Debugging) and then add &fabrikdebug=1 to the menu URL. This should show the complete error.

Hi Troester,

I cannot see the URL generated as the alias is shown in the browser (based on my SEO joomla global settings i think).
I turned on the the debug mode as you indicated and added the &fabrikdebug=1 to the url as a query extension.
I have 2 similar problems with 2 different type of Fabrik objects:

a) a list : IRL Results - Team Competition
When i click on the menu link to call the list I receive immediately an error 500 (see screenshot). No particular debug info is displayed (wired).
This error happens independently if i use a newly created user or not.
without alias the URL would be: https://indoorrowers.org/index.php?option=com_fabrik&view=list&listid=62.
The wired thing is if I use this one as a URL then the list is displayed correctly. The errors appears only after clicking twice on next page (to see the next entries in the list).

b) a form : IRL Results to enter the month results
When i click on the menu link to call the form, if I'm a newly registered user, i get the error 1064 and some debugging info, if I'm an older user it works ... this is really wired ..
Please find attached the debug info.
without alias the URL would be: https://indoorrowers.org/index.php?option=com_fabrik&view=form&formid=57
I use rowid = -1 and keyname = id as fabrik form option.

In both cases the error returned is : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1.
With error code 500 for the list, and 1064 for the form.

Thank your for your help!

Cheers
 

Attachments

  • Screenshot 2020-09-06 at 11.36.30.png
    Screenshot 2020-09-06 at 11.36.30.png
    70.5 KB · Views: 89
  • debug_form_enter_results.txt
    25.1 KB · Views: 81
I use rowid = -1 and keyname = id as fabrik form option
Keyname has to be a field/column storing the userid of the logged-in user which must not be the id element (the primary key of you list/table, autoincrement if it's Fabrik standard)
 
Keyname has to be a field/column storing the userid of the logged-in user which must not be the id element (the primary key of you list/table, autoincrement if it's Fabrik standard)
that's the case and as you can see from the debug output the id is correctly captured. Otherwise the older user won't see the form.
I don't really know what's the difference between newer and older user and why the older will see the form and the newer not.
Maybe it is due to the Group Field or something that changed in the juser plugin.

Cheers
 
Is there a way to generate log files in Fabrik and make the whole thing a bit more verbose so I would have a chance to investigate further?
 
I have by the way the same problem with a form but only for some users .. wired ..
Maybe it's related to your other thread. Which usergroup(s) do these users belong to?
 
They belong to the "registered" user group which is needed to see the menu and open the form.
 
Good Morning I would like to use this as an opportunity to invite you to join Sweaty Quid, a quality website for freelancers where you can hire freelancers for all your business needs as well as provide your own services at no cost. Get started right now and register at sweatyquid.com and give me a shout if you have any questions! Welcome to the mothership
 
Good Morning I would like to use this as an opportunity to invite you to join Sweaty Quid, a quality website for freelancers where you can hire freelancers for all your business needs as well as provide your own services at no cost. Get started right now and register at sweatyquid.com and give me a shout if you have any questions! Welcome to the mothership
[/QUOTE]
Sorry, but I can not offer myself a freelancer and neither the website does as it is a non-commercial community website to which I donate some of my free time voluntarily..
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top