1054 Unknown column 'i.published' in 'order clause'

MinneMicha
Topic Author
Offline
New Member

3 years 3 weeks ago #79836 by MinneMicha

1054 Unknown column 'i.published' in 'order clause' was created by MinneMicha

Hello,

When trying to sort the Felxicontent fields according to the publication status, the following error occurred.
"1054 Unknown column 'i.published' in 'order clause'"

The Fields-page is currently no longer usable.

I tried clearing cache an reinstalling then latest Flexicontentversion (3.3.9).

Joomla: 3.9.25
Flexicontent: 3.3.9

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

micker
Offline
Administrator

3 years 3 weeks ago #79837 by micker

Replied by micker on topic 1054 Unknown column 'i.published' in 'order clause'

hello can you check you database ?
extensions > manage > database
maybe you need to fix it

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

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

MinneMicha
Topic Author
Offline
New Member

3 years 3 weeks ago #79838 by MinneMicha

Replied by MinneMicha on topic 1054 Unknown column 'i.published' in 'order clause'

Thanks for the hint. "Repairing" Database solved the problem.
However, the error is repeatable. This means that, at least in the given environment, it is not possible to sort the fields by publication status.

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