- Posts: 7
- Thank you received: 0
All questions about EDocman extension
SOLVED !!! SQL Error edocman link
- Bernard
- Topic Author
- Offline
- New Member
-
Less
More
7 years 7 months ago - 7 years 7 months ago #103357
by Bernard
SOLVED !!! SQL Error edocman link was created by Bernard
Hello,
I kind of have a strange situation here.
Whenever I am using edocman shortcode more than 8 times in an article, the articles breaks with the following error:
Error 1064
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 '}
Here is the link to the page: s4gv.com/menu-test/test-1.html
How can I share with you the access to the website so you can take a look ?
THank you for your help
I kind of have a strange situation here.
Whenever I am using edocman shortcode more than 8 times in an article, the articles breaks with the following error:
Error 1064
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 '}
Here is the link to the page: s4gv.com/menu-test/test-1.html
How can I share with you the access to the website so you can take a look ?
THank you for your help
Last edit: 7 years 7 months ago by Mr. Dam.
Please Log in or Create an account to join the conversation.
- Mr. Dam
-
- Offline
- Administrator
-
Less
More
- Posts: 13021
- Thank you received: 1688
7 years 7 months ago #103358
by Mr. Dam
Replied by Mr. Dam on topic SQL Error 1064 when using more than 8 edocman link
Hi Bernard,
Please put each short code {edocmanlink ID} on one line to solve the issue.
Thanks
Dam
Please put each short code {edocmanlink ID} on one line to solve the issue.
Thanks
Dam
Please Log in or Create an account to join the conversation.
- Bernard
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 7
- Thank you received: 0
7 years 7 months ago #103360
by Bernard
Replied by Bernard on topic SQL Error 1064 when using more than 8 edocman link
Thanks Dang for your reply.
I actually have it on one line.
I am also checking the HTML code generated by JCE, and it is on one line in the generated code as well.
Any ideas?
I actually have it on one line.
I am also checking the HTML code generated by JCE, and it is on one line in the generated code as well.
Any ideas?
Please Log in or Create an account to join the conversation.
- Mr. Dam
-
- Offline
- Administrator
-
Less
More
- Posts: 13021
- Thank you received: 1688
7 years 7 months ago #103361
by Mr. Dam
Replied by Mr. Dam on topic SQL Error 1064 when using more than 8 edocman link
Hi Bernard,
Please submit ticket and send your site url with super admin account. I will check the issue for you
Thanks
Dam
Please submit ticket and send your site url with super admin account. I will check the issue for you
Thanks
Dam
The following user(s) said Thank You: Bernard
Please Log in or Create an account to join the conversation.
- Bernard
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 7
- Thank you received: 0
7 years 7 months ago #103364
by Bernard
Replied by Bernard on topic SQL Error 1064 when using more than 8 edocman link
Done, thanks !
Please Log in or Create an account to join the conversation.
- Mr. Dam
-
- Offline
- Administrator
-
Less
More
- Posts: 13021
- Thank you received: 1688
7 years 7 months ago #103442
by Mr. Dam
Replied by Mr. Dam on topic SQL Error 1064 when using more than 8 edocman link
Problem solved through ticket system
Dam
Dam
Please Log in or Create an account to join the conversation.
- Douglas Harry
- Offline
- New Member
-
Less
More
- Posts: 11
- Thank you received: 0
6 years 2 months ago #122421
by Douglas Harry
Replied by Douglas Harry on topic SOLVED !!! SQL Error edocman link
I am having the same problem, I also use JCE.
I created the module and the error is reported:
1064 - 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 =' 2 'OR groups LIKE' 2,% 'OR groups LIKE'%, 2,% 'OR groups LIKE'%, 2 ') ) 'at line 3
my version edcoman: 1.11.7
Could you explain how you solved it?
I created the module and the error is reported:
1064 - 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 =' 2 'OR groups LIKE' 2,% 'OR groups LIKE'%, 2,% 'OR groups LIKE'%, 2 ') ) 'at line 3
my version edcoman: 1.11.7
Could you explain how you solved it?
- Mr. Dam
-
- Offline
- Administrator
-
Less
More
- Posts: 13021
- Thank you received: 1688
6 years 2 months ago #122442
by Mr. Dam
Replied by Mr. Dam on topic SOLVED !!! SQL Error edocman link
Hi Douglas,
Your problem is difference, you need to submit ticket and provide your site url with super admin account. I will figure the problem for you.
Thanks
Dam
Your problem is difference, you need to submit ticket and provide your site url with super admin account. I will figure the problem for you.
Thanks
Dam
Please Log in or Create an account to join the conversation.
Moderators: Mr. Dam
Support
Documentation
Information
Copyright © 2025 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.