All questions about EDocman extension

SOLVED !!! SQL Error edocman link

  • Bernard
  • Topic Author
  • Offline
  • New Member
  • New Member
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
Last edit: 7 years 7 months ago by Mr. Dam.

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

More
7 years 7 months ago #103358 by Mr. Dam
Hi Bernard,
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
  • New Member
More
7 years 7 months ago #103360 by Bernard
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?

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

More
7 years 7 months ago #103361 by Mr. Dam
Hi Bernard,
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
  • New Member
More
7 years 7 months ago #103364 by Bernard
Done, thanks !

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

More
7 years 7 months ago #103442 by Mr. Dam
Problem solved through ticket system
Dam

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

More
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?
Attachments:

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

More
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

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

Moderators: Mr. Dam