- Posts: 20
COMMUNITY FORUM
SQL syntax error with k2 extra fields
- Langagemachine
- Topic Author
- Offline
- Junior Member
Less
More
4 weeks 1 day 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
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.
- JoomlaWorks
- Offline
- Admin
Less
More
- Posts: 6219
3 weeks 6 days ago #183349
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
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
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
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 20
3 weeks 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.
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.
- JoomlaWorks
- Offline
- Admin
Less
More
- Posts: 6219
3 weeks 6 days ago #183353
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
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
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 20
3 weeks 1 day 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 :)
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.
- JoomlaWorks
- Offline
- Admin
Less
More
- Posts: 6219
3 weeks 1 day ago #183709
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
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.