PDA


View Full Version : Database error when edit link


Silvio
06-29-2008, 08:19 PM
if I edit and save (happen in anycase - even if settings or if no-settings are modified).

the reported error is


Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT linkid, name, catid, linkurl, valid
FROM vB_adv_links
WHERE linkurl LIKE '%php.net%'
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 30th 2008 @ 01:12:13 AM
Error Date : Monday, June 30th 2008 @ 01:12:14 AM
Script : http://www.myurl.com/links/addlink.php
Referrer : http://www.myurl.com/links/addlink.php?do=editlink&l=3
IP Address : xx.xxx.xx.xxx
Username : myUserName
Classname : vB_Database
MySQL Version : 5.0.51


can you please help me on solving this matter?


regards

ciao

Silvio
06-30-2008, 11:42 AM
AND linkid !=

it seems that a part of SQL statement is missing (after linkid !=)

what should I put as condition for linkid?


thanks & byebye

Brian
06-30-2008, 08:26 PM
Looks like the same bug as reported here:
http://www.vbadvanced.com/forum/showthread.php?t=29743

Silvio
07-02-2008, 08:23 AM
Brian, I'm sorry but i did not saw that b4 asking :(

yeah! is that one!!! Now is fxed ty so much

ty a lot and take care
ciao