Results 1 to 2 of 2

Thread: News Module - Thread Display Order Error

  1. #1
    Join Date
    Feb 2008
    Posts
    1

    Default News Module - Thread Display Order Error

    Hello guys, I'm sorry my first post is to report an error but nevertheless . . .

    I get the following Database error after setting the Thread Display Order in the News Module to Rating.
    When reverting back to Date Created all is in order, only with this setting everything breaks.

    Is this my fault or what? I did a clean install of the vBadvanced.

    Code:
    Invalid SQL:
    
    			SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg, votetotal, user.*, thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, sticky, thread.attach, thread.lastpostid, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext
    			, allowsmilie, pagetext_html, postparsed.hasimages, thread.iconid AS threadiconid, iconpath AS threadiconpath, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
    			FROM vb_thread AS thread
    			LEFT JOIN vb_post AS post ON (post.postid = thread.firstpostid)
    			LEFT JOIN vb_user AS user ON (user.userid = post.userid)
    			 LEFT JOIN vb_postparsed AS postparsed ON (postparsed.postid = post.postid AND postparsed.styleid = 6 AND postparsed.languageid = 1) LEFT JOIN vb_icon AS icon ON (icon.iconid = thread.iconid) LEFT JOIN vb_subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '11')
    			WHERE thread.threadid IN(977,982,868,964)
    			
    			
    			ORDER BY thread.voteavg DESC
    			LIMIT 7;
    
    MySQL Error  : Unknown column 'thread.voteavg' in 'order clause'
    Error Number : 1054

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

    Default Re: News Module - Thread Display Order Error

    Thank you for pointing this out. I've just applied the fix for this to the modules/news.php file in the download package here, so if you will download the files again and replace your current modules/news.php file with the updated version, that should take care of the problem.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. change module display order on certin pages only
    By way2low in forum "How Do I..." Questions
    Replies: 2
    Last Post: 01-15-2007, 11:36 AM
  2. [Suggestion] New News Module Display Order
    By KW802 in forum Feedback & Suggestions
    Replies: 1
    Last Post: 05-25-2006, 12:47 AM
  3. Module Display Order problem
    By khul`Shalkrum in forum Troubleshooting & Problems
    Replies: 4
    Last Post: 11-01-2005, 05:14 PM
  4. Replies: 3
    Last Post: 10-28-2005, 12:00 PM
  5. Replies: 3
    Last Post: 08-12-2005, 05:18 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
  •