Results 1 to 2 of 2

Thread: SQL Error When Editing Links

  1. #1
    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.

  2. #2
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    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 = 

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Error Editing Replies
    By juinjuin in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 05-02-2008, 11:45 AM
  2. SQL Error When Editing Entries
    By Moonz0r in forum Troubleshooting & Problems
    Replies: 3
    Last Post: 12-20-2007, 07:51 PM
  3. Editing Page Identifier Links
    By Snipa in forum "How Do I..." Questions
    Replies: 3
    Last Post: 07-16-2007, 11:21 AM
  4. Editing links on navbar
    By dinesh in forum Troubleshooting & Problems
    Replies: 2
    Last Post: 05-18-2006, 09:23 AM
  5. Editing Module Error
    By Lizard King in forum Troubleshooting & Problems
    Replies: 6
    Last Post: 06-06-2005, 05:22 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •