Results 1 to 2 of 2

Thread: Database error when changing news cut off

  1. #1

    Default Database error when changing news cut off

    When i tried changing the number of days for the news cut off all i get is a database error displaying when i try and view the cmps_index page. If I leave it on the default it's fine.

    This is the error:

    PHP Code:
    Database error in vBulletin 4.0.1:

    Invalid SQL:

                    
    SELECT attachmentida.contentidfilenamea.datelinecounter, IF(fd.thumbnail_filesize 010) AS hasthumbnail
                    FROM attachment 
    AS a
                    LEFT JOIN filedata 
    AS fd ON (a.filedataid fd.filedataid)
                    
    WHERE contenttypeid 1
                        
    AND contentid IN(603457,357352)
                        AND 
    state 'visible'
                    
    GROUP BY attachment.contenttypeid
                    ORDER BY attachmentid
    ;

    MySQL Error   Unknown column 'attachment.contenttypeid' in 'group statement'
    Error Number  1054
    Request Date  
    SaturdayJanuary 16th 2010 @ 08:26:48 PM
    Error Date    
    SaturdayJanuary 16th 2010 @ 08:26:48 PM
    Script        
    http://*****.********.com/forum/cmps_index.php
    Referrer      
    IP Address    94.194.194.185
    Username      
    Admin
    Classname     
    vB_Database
    MySQL Version 
    5.0.45 

  2. #2
    Join Date
    Mar 2004
    Location
    A galaxy far, far away...
    Posts
    6,609

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. News - Database Error
    By shuffle in forum Troubleshooting & Problems
    Replies: 4
    Last Post: 09-23-2009, 01:15 PM
  2. News database error
    By lordozzy in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 03-19-2009, 01:34 PM
  3. Database Error from News Module
    By Levimatt in forum Bugs From 3.0.0
    Replies: 18
    Last Post: 03-15-2008, 02:20 PM
  4. Database Error when News Module Active
    By breamy in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 06-13-2007, 11:39 AM
  5. Replies: 38
    Last Post: 02-01-2007, 04:33 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
  •