Fixed 1054 Unknown column in 'field list' on details view since the last update

[7webcreator]

Hello,

Since the last Fabrik update to V4.4.1, I've encountered error 1054 when clicking the details view. However, the form view displays without any issues. The element mentioned in the error is a date (d-m-Y)

The Joomla call stack

Any idea why?

 

[troester]

Does this table and column exist

Is this your original site or a site copy? i.e. wrong Fabrik connection settings?

 

[7webcreator]

It is the original site. It was working fine before the update with the same connection settings. The column exists because the row displays correctly in form view.

 

[troester]

The column exists because the row displays correctly in form view.

You are using the paginate form plugin which can be enabled only in details view.

What are your "Order by" list settings?

 

[7webcreator]

The "Order by" list settings are day and hour

 

[7webcreator]

I have unpublished the paginate form plugin, and the details are displayed correctly now.

 

[troester]

Try in plugins\fabrik_form\paginate\paginate.php
set this

back to

 

[7webcreator]

Yes, it works when I revert to "buildQueryJoin($query);" for line 119.