I am getting the following database error with this enabled:

Database error in vBulletin 4.1.1:

Invalid SQL:

SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,post.thankscache,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
thread.prefixid, thread.taglist, hiddencount, deletedcount,
user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadread.readtime AS threadread
, threadredirect.expires
, firstpostid,modification.mod_installcount,usermod. mod_tagged,usermod.mod_installed,usermod.mod_downl oaded,modification.last_update
FROM vbthread AS thread
LEFT JOIN vbuser AS user ON (user.userid = thread.lastposterid)
LEFT JOIN vbuserlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 3)
LEFT JOIN vbdeletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN vbsubscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 3 AND canview = 1)
LEFT JOIN vbthreadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 3)
LEFT JOIN vbpost AS post ON(post.postid = thread.firstpostid)

LEFT JOIN vbthreadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
WHERE thread.forumid = 223
ORDER BY lastpost DESC
LIMIT 5;

MySQL Error : Unknown column 'modification.mod_installcount' in 'field list'
Error Number : 1054
Request Date : Tuesday, February 1st 2011 @ 05:38:58 AM
Error Date : Tuesday, February 1st 2011 @ 05:38:58 AM
Script : http://creativx.net/forums/forumdisplay.php?f=25
Referrer : http://creativx.net/forums/
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.1.54

Please help.

Installed on 4.04pl1 for testing with thanks ... :up:

Regards,
Doug

Edit: Set-up as per instructions (see attached pic), added "Global Messages Forum" and ENABLED mod.

Created a post in the new "Global Messages Forum" and hit submit ....

Nothing appears in any of the forums specified, however post appears in "Global Messages Forum". :confused:

Hi, I see the problem... I forgot to remove 1 hook from the code and another modification you have is interfering with the query.

I will release an update to fix this bug shortly. In the mean time if you want to fix it you can go to Plugin Manager -> Edit the plugin titled: Query Global Threads
Find this line:
And simply erase it, hit save, and it should work.

Or wait for my next update later today.

Is the mod still enabled? If so please give me the forumid of your global forum. I will take a look.

My guess off hand is you have the permissions set wrong- users need to be able to view the forum and threads... here is a screenshot of proper forum permissions:

Thank you very very much!! Works perfectly now!!! You ROCK big time mate!!

Thanks for the quick response ... :up:

Yes, enabled and I checked forum permissions and they are fine...

In fact, I'm an Admin who created the seed post and all permissions for the forum are on, yet I can't see any of the posts. :confused:

Can I send you AdminCP access privately to have a look?

Regards,
Doug

You can PM me access info but please first try this new version, 2.01 I just released just in case your problem is related to the bug fix. :up:

The new version also ads an option where you can display global threads above or below a sticky divider if you have one.

Downloaded and installed v2.01 on our v4.04pl1. :)

Re-checked all settings ....

Deleted old test post from "Global Messages Forum" and created a new one... submitted it ...

It doesn't show up in any of the forums listed in the "included" listing.

Should there be spaces in list? ie: 1, 2, 3 versus 1,2,3 the way I have it?

I'll get you the login information. Sure like to get this working as it could add a lot of value to the nature of how we operate our forums.

Thanks for your help ... :up:

Regards,
Doug

1,2,3 or 1, 2, 3 both work, I tested it both ways... will take a look when you PM me info.

Thanks ... :)

Sent you a PM ....

Also, sent you a PayPal donation for this, as well as other mods and work you've done that we've started using. Been meaning to do that for a while now ... :D

Regards,
Doug

Awesome Joe, I like how you updated this quite handy imo!