Results 1 to 7 of 7

Thread: Data Base Error

  1. #1
    Join Date
    May 2009
    Posts
    3

    Default Data Base Error

    I'm getting this data base error after I've logged in from the cmps_index.php screen.

    Database error in vBulletin 4.0.1:

    Invalid SQL:
    SELECT COUNT(*) AS count FROM attachment WHERE visible = 0;

    MySQL Error : Unknown column 'visible' in 'where clause'
    Error Number : 1054
    Request Date : Saturday, January 16th 2010 @ 07:51:55 PM
    Error Date : Saturday, January 16th 2010 @ 07:51:55 PM
    Script : http://testftz/vb4.0.1/cmps_index.php
    Referrer : http://testftz/vb4.0.1/login.php


    Any help would be greatly appreciated.

    Thanks guys

  2. #2
    Join Date
    Jan 2008
    Posts
    14

    Default

    Hello Boso,

    i have here the same error - also on a vb 4.0.1
    Datenbankfehler in vBulletin 4.0.1:

    Invalid SQL:
    SELECT COUNT(*) AS count FROM attachment WHERE visible = 0;

    MySQL-Fehler : Unknown column 'visible' in 'where clause'
    Fehler-Nr. : 1054
    Fehler-Zeit : Saturday, 16.01.2010 @ 15:07:15
    Datum : Saturday, 16.01.2010 @ 15:07:15
    Skript : http://www.domain.de/vb4cms/cmps_index.php
    Referrer :
    ...
    Klassenname : vB_Database
    MySQL-Version : 5.0.26-log

  3. #3
    Join Date
    Jun 2007
    Posts
    49

    Default

    Try the search facility...... it works!
    http://www.vbadvanced.com/forum/showthread.php?t=38718

  4. #4
    Join Date
    Jan 2008
    Posts
    14

    Default

    yes- sorry, i have it now

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

    Default

    Thank you for pointing this out. I know I updated that query, but it seems my changes were lost somehow. I've just updated the modules/moderate.php file in the download package here to include the fix though, so if you will download the files from here again and update the modules/moderate.php file on your server with the new version that should take care of the issue.
    If anyone would rather apply the fix manually, just look in your modules/moderate.php file for this line:
    PHP Code:
        $attachments $db->query_first("SELECT COUNT(*) AS count FROM " TABLE_PREFIX "attachment WHERE visible = 0"); 
    And repalce with this:
    PHP Code:
        $attachments $db->query_first("SELECT COUNT(*) AS count FROM " TABLE_PREFIX "attachment WHERE state = 'moderation'"); 
    Frequently Asked Questions
    CMPS Users Manual

    For vBadvanced software assistance, please use the support forums.
    Unsolicted PMs, IMs, and email will not be responded to.
    If you have a non-software related question or problem with your account, please submit a support ticket.

  6. #6
    Join Date
    May 2009
    Posts
    3

    Default

    Thank you Brian.

  7. #7
    Join Date
    Jan 2010
    Posts
    7

    Default

    thank you brian, the mod module works fine now.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data base error removing Dynamics
    By werwolf in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 10-13-2009, 12:39 PM
  2. How to make the vbadvaced read the data base?
    By 7ooor-center in forum "How Do I..." Questions
    Replies: 9
    Last Post: 12-11-2007, 10:50 AM
  3. Data Base error 1064
    By shush in forum Troubleshooting / "How do I..." Questions
    Replies: 5
    Last Post: 03-21-2006, 08:31 PM
  4. Data Base Error Question
    By SARMX in forum Troubleshooting & Problems
    Replies: 0
    Last Post: 02-04-2006, 05:47 PM
  5. Data Base Question
    By Hairback357 in forum Troubleshooting / "How do I..." Questions
    Replies: 2
    Last Post: 02-17-2005, 08:37 AM

Posting Permissions

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