Backend Fields filter: 1054 Unknown column 'i.published' in 'order clause'

nikitagupta2106
Topic Author
Offline
Premium Member

3 years 3 months ago - 3 years 3 months ago #80645 by nikitagupta2106

Backend Fields filter: 1054 Unknown column 'i.published' in 'order clause' was created by nikitagupta2106

Hi,

I'm using Joomla 3.10.0 and FC 3.3.11

See screenshot. Clicking on "Status" at the backend in the "Fields" gives me an error: 1054 Unknown column 'i.published' in 'order clause'.

I found this on the LIVE website but luckily, I had a backup to restore! Crazy.

Hope this bug gets fixed.

Regards,
NIkita

Attachments:

Last edit: 3 years 3 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

3 years 3 months ago #80649 by ggppdk

Replied by ggppdk on topic Backend Fields filter: 1054 Unknown column 'i.published' in 'order clause'

Hello

this was a past issue it should not occur in v3.3.11

you did not need to restore backup

if you logout from backend and re-login
then ordering of items manager should go to the default setting (configured in Flexicontent component parameters)

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

nikitagupta2106
Topic Author
Offline
Premium Member

3 years 3 months ago #80653 by nikitagupta2106

Replied by nikitagupta2106 on topic Backend Fields filter: 1054 Unknown column 'i.published' in 'order clause'

Okay.

The issue remains in v3.3.11 but yes, as you suggested, logout and logging back in seems to solve the problem.

I still feel this is a bug that needs fixing!

Regards,
Nikita

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

3 years 3 months ago #80670 by ggppdk

Replied by ggppdk on topic Backend Fields filter: 1054 Unknown column 'i.published' in 'order clause'

Hello

i see now that you refer to fields manager , and not "fields filter" or status column in items manager
i have made a fix in github for next release

Please Log in or Create an account to join the conversation.