[Zachery]

Originally Posted by CarolinaKid

Can Anyone help me with this. Did not have till i upgraded to 1.1 amd yes i added the function.php edit

Database error in vBulletin 3.0.0 Release Candidate 3:
 
Invalid SQL: SELECT thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
   , thread.iconid AS threadiconid
    ,thread.forumid, forum.title AS forumtitle
    , post.pagetext AS preview
    , NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
    FROM thread as thread
    LEFT JOIN forum AS forum ON (thread.forumid = forum.forumid)
    LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
    LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
     LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 175)
    WHERE open <> '10' AND forumid NOT IN(76) AND deletionlog.primaryid IS NULL
    ORDER BY lastpost DESC
    LIMIT 10
mysql error: Column: 'forumid' in where clause is ambiguous
 
mysql error number: 1052

did you just upgrade from vB2 ?