Error: 1054 On Search - Question | JoomShaper
Black Friday sale is live with flat 50% OFF. Sale ends soon! Grab your deal now!

Error: 1054 On Search

S

scomil808

Template 3 years ago

Hello! I am having an issue with a search function on the following page: https://new.vernontwp.com/index.php/search

When I search using Oldest First, I receive the following error message: Error: 1054 1054 Unknown column 's.created_time' in 'order clause'

Any help would be greatly appreciated! Scott

0
7 Answers
Ariba
Ariba
Accepted Answer
Support Agent 3 years ago #67940

Hello

Apologies for your inconvenience.

Could you kindly follow the blog tutorial to solve this issue, please?

https://www.joomshaper.com/blog/how-to-fix-1054-unknown-column-t-published-after-joomla-migration

0
S
scomil808
Accepted Answer
3 years ago #67969

Hello! The issue is not caused after migration and only happens during a search using Oldest First.

Will this fix still work on my issue?

0
S
scomil808
Accepted Answer
3 years ago #67970

Also, that is for a migration from 2.5 to 3X.

I am using Joomla 4.

0
S
scomil808
Accepted Answer
3 years ago #68018

Good morning! Can someone please get back to me with an answer. I have 3 other sites with the same issue and would like to know a fix.

Thanks!

0
Ariba
Ariba
Accepted Answer
Support Agent 3 years ago #68074

Could you please provide your administrative access? Use the hidden mode to share the log in credentials, kindly.

0
DC
Douglas Chua
Accepted Answer
3 years ago #83726

Hello There , I am having the same issue.

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'

Any help would be hightly appreciated!

0
Ariba
Ariba
Accepted Answer
Support Agent 3 years ago #83729

Hello Douglas

Kindly make a new post regarding your issue, we will check it there. Don't worry!

0