• 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.

BUG: usekey selecting column from a different list

aijosh

Member
There is a bug in the content plugin.
Following the instructions here http://fabrikar.com/forums/index.php?wiki/content-plugin/#searching-for-form-records-to-edit

{fabrik view=form id=1 usekey=user rowid=62}

I was trying to load a form.

If I use, usekey=columnname Fabrik tries to load a column from a totally unrelated table and throws and error

Unknown column 'falsetable.columnname' in 'where clause'

If I use an unexisting column name like
usekey=nonsensecolumnname
Fabrik throws an error
Unknown column 'CORRECTtable.nonsensecolumnname' in 'where clause'
 
is this on your site with multiple lists and forms?

Gesendet von meinem SM-G930F mit Tapatalk
 
hmmm... I was going to say no, that this page has only this form but I realized I have this account icon that is meant to be on all pages.
upload_2019-1-12_17-16-19.png The image is a fabrik list (without joins) but its the table displayed in the error.

So sadly, I do have another list on the page.

The reason why I decided to create a Menu item for this page is because clicking the edit link in the Fabrik list module throws "We cannot find this record" error to the user after the record has loaded. The record still loads correctly but the annoying error is there. I removed all other fabrik list or form from the page. I still get the error. Even though the record loads.
I've suppressed ACL&success messages. The error wont leave.

Found out creating a menu item doesn't throw this error so I decided to create one for every of the rows.
Only one of the rows load correctly using -1 as the user id so I have to add some extra query to produce the rest.

So I tried to create Fabrik Form Menu items but the Extra Query portion was not working (I was getting the same column errors).

So I tried using a joomla article as the menu item then adding a form in the article using content plugin (same type of column errors)

I'm now down to content plugin in custom detail view template.
Just wished I didn't have to be going round these circles.

My ISP is has been down for hours now and I'm on mobile so I cant really test with the user account icon disabled.

I'll do that as soon as I get a useable connection.

I'm guessing the usekey and Extra Query on the Menu item wont work on pages that have other fabrik stuff on it?

Yes?
 
Last edited:
Ok. so I found the guy causing the stoooopid error.

It was actually that icon.

The error appears on detail views belong to the same list. I guess the detail views dont have the clear filter settings to prevent this behavior like the modules have.... or whatever.

I just did another stoooopid custom list template:eek: (using the country table cos using the user table still throws the error) and manually called the database for the image.

Is there a Fabrik built-in way for me to just do a php in the module itself without having to install another extension. Or using JCE?

I really am skeptical about allowing php where there is a possibility of users getting to it since they have access to the same JCE forms.
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top