Error 1054 Unknown column 'a.category' in 'where clause

This forum is for general questions about extensions for Joomla! 3.x.

Moderators: pe7er, General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
bugg
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Sat Aug 12, 2017 5:35 pm

Error 1054 Unknown column 'a.category' in 'where clause

Postby bugg » Sat Aug 12, 2017 6:08 pm

Hello,
Since switching to version 3.7 I have this error
Error 1054 Unknown column 'a.category' in 'where clause' with search and when I select components "search" same error
I tried to manage database correction, and find out, but it does not find anything

I specify that I am in multilanguage
(language deault is french, and other, english and breton)

and that until version 3.6.5 I had no problem.and all is update...

thanks for your help
You do not have the required permissions to view the files attached to this post.
Last edited by toivo on Sun Aug 13, 2017 8:50 pm, edited 2 times in total.
Reason: mod note: moved to 3.x Extensions

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 23346
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Error 1054 Unknown column 'a.category' in 'where clause

Postby Per Yngve Berg » Sun Aug 13, 2017 7:21 am

Run Extensions->Extension Manager->Database->Fix

bugg
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Sat Aug 12, 2017 5:35 pm

Re: Error 1054 Unknown column 'a.category' in 'where clause

Postby bugg » Sun Aug 13, 2017 8:38 am

hello,
As shown in the pictures above, this is what I did, but he finds nothing to correct

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 23346
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Error 1054 Unknown column 'a.category' in 'where clause

Postby Per Yngve Berg » Sun Aug 13, 2017 9:31 am

Enable Debug in Global Configuration and try to find the SQL Query where 'a.category' is occurring.

bugg
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Sat Aug 12, 2017 5:35 pm

Re: Error 1054 Unknown column 'a.category' in 'where clause

Postby bugg » Sun Aug 13, 2017 10:30 am

thanks for your help !
I attach the debug files, if you could enlighten me

the 2nd file is too big, I can't attach this...
You do not have the required permissions to view the files attached to this post.

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 23346
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Error 1054 Unknown column 'a.category' in 'where clause

Postby Per Yngve Berg » Sun Aug 13, 2017 11:21 am

You must have a file that is not updated.

Components->Joomla Update

Click check for Updates
Click Reinstall Core Joomla Files.

bugg
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Sat Aug 12, 2017 5:35 pm

Re: Error 1054 Unknown column 'a.category' in 'where clause

Postby bugg » Sun Aug 13, 2017 11:36 am

I just do it but I still have the same errors....

I copied the places where the word category appeared in the attached file.
Thank you again for your help !
You do not have the required permissions to view the files attached to this post.

bugg
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Sat Aug 12, 2017 5:35 pm

Re: Error 1054 Unknown column 'a.category' in 'where clause

Postby bugg » Sun Aug 13, 2017 4:06 pm

Resolved!
It's your idea of debug that helped me,
On the 3rd line I had error
JDatabasedriver-> LoadObjectlist ()
jroot / plugins / searches / easytimetable / easytimetable.php: 126
And the following line:
PlgSearchEasytimetable-> onContentSearch
So I switched off easytimetable then I got the "span class highlight" error (which I was too glad to have!) But I had seen on the forum how to solve this so it's solved and still a big thanks !

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 23346
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Error 1054 Unknown column 'a.category' in 'where clause

Postby Per Yngve Berg » Sun Aug 13, 2017 5:02 pm


bugg
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Sat Aug 12, 2017 5:35 pm

Re: Error 1054 Unknown column 'a.category' in 'where clause

Postby bugg » Sun Aug 13, 2017 5:16 pm

I confirm that this plugin is the guilty one!
I install the new version of the plugin, and again the error !
when the plugin is off, no problem...

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 23346
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Error 1054 Unknown column 'a.category' in 'where clause

Postby Per Yngve Berg » Sun Aug 13, 2017 5:22 pm

Talk to the developer about it.
The release note says compatibility with 3.7 fixed.



Return to “Extensions for Joomla! 3.x”

Who is online

Users browsing this forum: No registered users and 8 guests