Keyword

SQL syntax error with k2 extra fields

  • Langagemachine
  • Langagemachine's Avatar Topic Author
  • Offline
  • Junior Member
More
1 month 1 week ago #183336 by Langagemachine
SQL syntax error with k2 extra fields was created by Langagemachine
Hi, For no reason I have an error message appearing on my home page that I don't understand.
I deactivated the k2 field groups and the extra field but it is still present.

Here the message :
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups LEFT JOIN #__k2_extra_fields AS field ON field.group = groups.id WHERE' at line 1

If you go to the site you have this with a link with debug
myntis.be/fr/
Th link of the debur error :
myntis.be/fr/?view=featured&layout=default&igsource=plugin&iguniqueid=M119&ig-145=1&igid=1&igpid=3&igtype=category&igchild=1&igaddlinks=0&iglimit=150&igplugincalled=1&debug=1

Thank for help me

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

More
1 month 6 days ago #183349 by JoomlaWorks
Replied by JoomlaWorks on topic SQL syntax error with k2 extra fields
This doesn't come directly from K2, it's most likely a hardcoded query or some 3rd party module/plugin.

The issue comes from the use of the name "groups" as a table name, which is now a reserved word in MySQL 8.

If you want to call specific K2 extra fields anywhere in your K2 template overrides (sub-templates), there's a much simpler way: getk2.org/documentation/tips-a-tricks/display-single-extra-fields-anywhere-in-your-k2-content

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

  • Langagemachine
  • Langagemachine's Avatar Topic Author
  • Offline
  • Junior Member
More
1 month 6 days ago #183352 by Langagemachine
Replied by Langagemachine on topic SQL syntax error with k2 extra fields
Hi,
Thank,
can you help me to identify the modul or plugin wich cause prob ?
I'm not specialist for this genre of problem.

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

More
1 month 6 days ago #183353 by JoomlaWorks
Replied by JoomlaWorks on topic SQL syntax error with k2 extra fields
The popup is inside a container called "sm-pusher". If this identifies to some plugin, module or component, that's your issue. For anything else, you should probably talk to the person who built your site.

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

  • Langagemachine
  • Langagemachine's Avatar Topic Author
  • Offline
  • Junior Member
More
1 month 2 days ago #183708 by Langagemachine
Replied by Langagemachine on topic SQL syntax error with k2 extra fields
Hi, thanks you.
Yes the prob come from old plugin system nextend smartslider3 extension.
I check for update.

Regards :)

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

More
1 month 2 days ago #183709 by JoomlaWorks
Replied by JoomlaWorks on topic SQL syntax error with k2 extra fields
Good to know :)

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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


Powered by Kunena Forum