Edit Link

[simsnet]

Just tried to Edit a link,

I get taken to the edit page and then when i click on save link i get the following error:

Database error in vBulletin 3.7.1:

Invalid SQL:

SELECT linkid, name, catid, linkurl, valid
FROM adv_links
WHERE linkurl LIKE '%linkname%'
AND linkid !=
LIMIT 100;

MySQL Error : 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 'LIMIT 100' at line 5
Error Number : 1064
Request Date : Monday, June 9th 2008 @ 10:55:10 PM
Error Date : Monday, June 9th 2008 @ 10:55:10 PM
Script : http://www.mydomaindotcom/links/addlink.php
Referrer : http://www.mydomaindotcom/links/addlink.php?do=editlink&l=141
IP Address : ***.***.**.***
Username : myusername
Classname : vB_Database
MySQL Version : 5.0.27

[Brian]

Have you modified your 'ADV_LINKS_ADDEDIT' template at all? If so, try reverting it.

[simsnet]

Nope its the original code. I've just tried reuploading the latest links package and i get the same error.

Any ideas?

[Brian]

I'm not really sure what else could cause an error like that, so would you mind submitting a support ticket via the Members' Area here so I can take a look at things for you?

[simsnet]

Sure no probs. Have opened a support tkt

[qG ThaLiX]

I'm having this bug aswell. Just found out. Original code aswell.

[Brian]

The fix for this issue has been applied to the forum/includes/vba_links_functions_savelink.php file in the download package here. If you will download the files again and replace that file on your server with the updated version, that should take care of the problem.

[Betablocker]

The fix for this issue has been applied to the forum/includes/vba_links_functions_savelink.php file in the download package here. If you will download the files again and replace that file on your server with the updated version, that should take care of the problem.


Thank you Brian.

I had the same problem and this fixed it.

[qG ThaLiX]

Thanks a lot Brian