1054 Unknown Column 's.created_time' In 'order Clause' - Question | JoomShaper

1054 Unknown Column 's.created_time' In 'order Clause'

DC

Douglas Chua

General 1 year 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

0
7 Answers
Ariba
Ariba
Accepted Answer
Support Agent 1 year ago #83733

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.
0
DC
Douglas Chua
Accepted Answer
1 year ago #83745

Hello @Ariba

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

can you please help in this regard.

0
DC
Douglas Chua
Accepted Answer
1 year ago #83829

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

0
DC
Douglas Chua
Accepted Answer
1 year ago #84085

Hi Ariba,

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

0
Ariba
Ariba
Accepted Answer
Support Agent 1 year ago #84246

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

0
DC
Douglas Chua
Accepted Answer
1 year ago #84590

admin access

0
Ariba
Ariba
Accepted Answer
Support Agent 1 year ago #84697

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.

0