[rwallen]

Sometimes I get this error when submitting stories and sometimes I don't, I'm not sure why:

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 'AND `link_author` = 1 ORDER BY `link_date` DESC LIMIT 1' at line 1 in /home/content/l/i/n/linkbin/html/libs/db.php on line 233

[graphicsguru]

Originally Posted by rwallen

Sometimes I get this error when submitting stories and sometimes I don't, I'm not sure why:

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 'AND `link_author` = 1 ORDER BY `link_date` DESC LIMIT 1' at line 1 in /home/content/l/i/n/linkbin/html/libs/db.php on line 233

I just submitted a new story on your site you can delete it did you get the error fixed ?

[rwallen]

Originally Posted by graphicsguru

I just submitted a new story on your site you can delete it did you get the error fixed ?

No I just found that the error is my fault somewhere. I have in the header.tpl put this:

</div></center>
<center><div id="mydiv3" style="display:none; overflow: hidden; height: 75px;">

	<form action="{$URL_submit}" method="post" id="thisform">
		<label for="url">Submit your URL:</label>
		<input type="text" name="url" id="url" value="http://" size="55" />
		<input type="hidden" name="phase" value=1>
		<input type="hidden" name="randkey" value="{$submit_rand}">
		<input type="hidden" name="id" value="c_1">
		<input type="submit" value="{#PLIGG_Visual_Submit1_Continue#}" class="submit-s" />
	</form>
	<br />{if $Submit_Require_A_URL neq 1}{#PLIGG_Visual_Submit_Editorial#}{/if}

</div></center>

It is a collapsable div that has the submit box for links. If links are submitted this way they error sometimes, if you go to submit.php and do it that way they are fine.

So I probably left something important out.

[bbrian017]

I get this error randomly it's unknown why so far

[rwallen]

Originally Posted by bbrian017

I get this error randomly it's unknown why so far

Well the error doesnt appear if the user goes to submit.php to submit the links.

I have a submit box appear in the header of every page that always displays this error now if used. So maybe there is something included in the submit.php that I missed or somthing. I only included the submit form in my header. It makes it through step-2 this way and gives that error on step 3.

[xiesi]

i have this error too.

[rubber2002]

Originally Posted by xiesi

i have this error too.

I use 9.6 & dont get this error.

[xiesi]

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 'AND `link_author` = 3 ORDER BY `link_date` DESC LIMIT 1' at line 1 in /home/sxy366/public_html/libs/db.php on line 233

[xiesi]

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 'AND `link_author` = 90 ORDER BY `link_date` DESC LIMIT 1' at line 1 in /home/sxy366/public_html/libs/db.php on line 236

[coreyvf]

This error appears for me also sometimes. It seems to appear whenever I try to submit some YouTube videos... very strange.

EDIT: Seems to happen when I submit youtube video URLs, with stuff at the end of it like
YouTube - Jermaine O'Neal Mix by DZ

But if I remove all the fluff and insert the true URL YouTube - Jermaine O'Neal Mix by DZ
it works fine and I don't get the error.

It seems the characters are causing errors.