PDA


View Full Version : SQL Error When Editing Links


atDev
08-11-2008, 12:28 AM
We get this error:
SELECT linkid, name, dateline, userid, username
FROM vbadv_links
WHERE catid = 5
AND valid = 1
AND private = 0
ORDER BY dateline DESC;

MySQL Error : Unknown column 'private' in 'where clause'
Error Number : 1054

When trying to edit a link.

Brian
08-11-2008, 01:03 PM
Thank you for pointing this out. I'm not sure how that got added to the files, but I've just applied the fix to the forum/includes/vba_links_functions_savelink.php file in the download package here. If you will download the files from here again and replace that file on your server with the updated version, that should take care of the issue.
Or if you would rather apply the fix manually, just look in the file for 2 instances of this line and remove each:
AND private = 0