Awaiting an answer General

1054 Unknown column 's.created_time' in 'order clause'

Asked by Douglas Chua 4 years ago Last activity 4 years ago

Hello There ,

We are having issue on search page when apply to ordering oldest .
when I hit search and applying the ordering oldest it is redireting to the the error page 1054 Unknown column 's.created_time' in 'order clause'

please help us to resolve this asap.
Thanks

7 replies

Oldest first Newest first Most helpful
Ariba Staff
4 years ago

Hello Douglas

Thank you for your query. Have you tried the following solution?

  • Check what database prefix using your "broken" Joomla.
  • Download this file >> tags_1054_Unknown_column_error.zip
  • Unzip and using simple html editor replace all "XXXXX" tags with your current prefix for example "jos3". Save changes.
  • Now login into PHPMyAdmin or use Adminer script - using database login and password.
  • Then please use import option and upload changed file.
Douglas Chua Asked this
4 years ago

Hello @Ariba

We just tried it the above solution and it does not work for our case.

can you please help in this regard.

Douglas Chua Asked this
4 years ago

Hi Ariba,

Any update on this? We have tried the method but i am still getting the 1054 Unknown Column 's.created_time' In 'order Clause' when i search and sort by oldest date

Douglas Chua Asked this
4 years ago

Hi Ariba,

can you assist us on this? is this a theme bug or a joomla 4 bug?

Ariba Staff
4 years ago

Can you please share your admin access? Use the hidden mode to share the log in credentials.

Douglas Chua Asked this
4 years ago

admin access

Ariba Staff
4 years ago

Thank you Douglas

I have shared the issue with my Senior Agent and he will get back to you as soon as possible. We appreciate your cooperation very much.

Log in to reply.