Hi,

I do not really understand why this error message appears now but I got it and wanted to ask you if you have any idea about this:

user warning: 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 '' at line 1 query: SELECT orig_url FROM shorturl_link WHERE lid= in /srv/www/vhosts/mysite/httpdocs/sites/all/modules/shorturl/shorturl.module on line 16.

Greez,
Tobias

Comments

seanr’s picture

seanr
he/him
commented

What were you doing when you got that URL? Did that happen when you attempted to follow a link you had previously shortened? Please post the URL(s) if you can.

tobiberlin’s picture

tobiberlin
Primary language German
Location Berlin, Germany
commented

The strange thing is that this error message appeared when I did not public any content. I felt as if just another user created a node - anyway this message did not appear again. I would suggest to postpone this issue in case that this error message appears again with my or any other drupal project.

tobiberlin’s picture

tobiberlin
Primary language German
Location Berlin, Germany
commented

A user of my project wanted to save a new node when this error message appeared again:

user warning: 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 '' at line 1 query: SELECT orig_url FROM shorturl_link WHERE lid= in /srv/www/vhosts/diaet-clique.de/httpdocs/sites/all/modules/shorturl/shorturl.module on line 16.

Maybe it appears when characters like " are used in the node title? It appeared with following node: http://www.diaet-clique.de/expertenblogs/anne-hoenicke/vom-vorgaukeln-de... which title is: Vom Vorgaukeln des "guten Geschmacks"...

This content type is published with Twitter automatically by Twitter module. Once in an overall twitter account where all node of this content type are published by a rule using Shorten Url! The second possibility is that a user integrated his own twitter account - but then it is used with the original Drupal Twitter module field in the add form which uses the Tinyurl service API.

I wonder if it might be that ShortenUrl uses the original title to create the shorten url - and not the original URL alias which filters character like ". So this might causes problems with such characters in the node title... is it that way????

Greez,
Tobias

tobiberlin’s picture

tobiberlin
Primary language German
Location Berlin, Germany
commented

PS: in the end everything works fine - you can see the shorten url functioning on th twitter account http://twitter.com/foodexperts

irakli’s picture

irakli commented
Status: Active » Postponed (maintainer needs more info)

How were you using ShortURL? Were you also using Shorten module?

tobiberlin’s picture

tobiberlin
Primary language German
Location Berlin, Germany
commented

Yes I also use Shorten module... and got this error a few minutes ago again although I did not work on any node... :-/

irakli’s picture

irakli commented
Status: Postponed (maintainer needs more info) » Fixed

I believe this should be fixed in CVS now. Please reopen if you see this again.

Thank you.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.