vBadvanced Forums  
Go Back   vBadvanced Forums > vBadvanced Products > vBadvanced Links Directory > vBa Links Directory v3.0 Support > Bugs & Issues > Bugs From 3.0 RC1

Reply
 
Thread Tools Display Modes
  #1  
Old 08-10-2008, 11:28 PM
atDev atDev is offline
Junior Member
 
Join Date: Aug 2008
Posts: 3
Default SQL Error When Editing Links

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.
Reply With Quote
  #2  
Old 08-11-2008, 12:03 PM
Brian's Avatar
Brian Brian is offline
Administrator
 
Join Date: Jan 2004
Location: Georgia, USA
Posts: 34,240
Default

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:
PHP Code:
                    AND private = 
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Error Editing Replies juinjuin Troubleshooting & Problems 1 05-02-2008 10:45 AM
SQL Error When Editing Entries Moonz0r Troubleshooting & Problems 3 12-20-2007 06:51 PM
Editing Page Identifier Links Snipa "How Do I..." Questions 3 07-16-2007 10:21 AM
Editing links on navbar dinesh Troubleshooting & Problems 2 05-18-2006 08:23 AM
Editing Module Error Lizard King Troubleshooting & Problems 6 06-06-2005 04:22 PM


All times are GMT -4. The time now is 11:50 AM.

Forums Powered by vBulletin, Copyright ©2000-2009, Jelsoft Enterprises Ltd.
Please note that vBadvanced is in no way affiliated with Jelsoft Enterprises Ltd, nor will Jelsoft be able to provide any support for our products.