COMMUNITY FORUM

Keyword
  1. Forum
  3. K2 Community Forum
  5. English K2 Community
  7. SQL syntax error with k2 extra fields

SQL syntax error with k2 extra fields

  • Langagemachine
  • Langagemachine's Avatar Topic Author
  • Offline
  • Junior Member
More
5 months 3 weeks 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
5 months 3 weeks 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

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

  • Langagemachine
  • Langagemachine's Avatar Topic Author
  • Offline
  • Junior Member
More
5 months 3 weeks 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
5 months 3 weeks 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.

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

  • Langagemachine
  • Langagemachine's Avatar Topic Author
  • Offline
  • Junior Member
More
5 months 2 weeks 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
5 months 2 weeks ago #183709 by JoomlaWorks
Replied by JoomlaWorks on topic SQL syntax error with k2 extra fields
Good to know :)

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

More
4 months 3 days ago #184387 by JoomlaWorks
Replied by JoomlaWorks on topic SQL syntax error with k2 extra fields
The SQL error you get will reveal the problem. Share it back :)

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

  1. Forum
  3. K2 Community Forum
  5. English K2 Community
  7. SQL syntax error with k2 extra fields

Powered by Kunena Forum