[TheSupportForum]

Originally Posted by erosolmi

First of all thanks for taking care of this fantastic mod and thanks for your work.

I've installed Mod-System under VB 4.1.8 and all was fine until I activated MOTM.
As soon as I've setup all needed fields and forum and activated MOTM I've got this SQL error:

Database error in vBulletin 4.1.8:

Invalid SQL:
SELECT
        SUM(un.mod_nominated) AS ncount,un.threadid,ms.author,t.title
        FROM modsys_user_notification AS un
        LEFT JOIN modsys_settings as ms ON(ms.threadid=un.mod_threadid)
        LEFT JOIN thread AS t ON(t.threadid=un.mod_threadid)
        WHERE un.nominate_date BETWEEN 1325372400 AND 1328050799
        AND ms.motm=0
        GROUP BY un.mod_threadid
        ORDER BY ncount DESC
        LIMIT 5;

MySQL Error   : Unknown column 'un.threadid' in 'field list'
Error Number  : 1054
Request Date  : Monday, January 2nd 2012 @ 02:31:43 PM
Error Date    : Monday, January 2nd 2012 @ 02:31:43 PM
Script        : http://www.thinbasic.com/community/forumdisplay.php?383-Application-of-the-month-(AOTM)
Referrer      : http://www.thinbasic.com/community/forum.php
IP Address    : 79.40.142.97
Username      : ErosOlmi
Classname     : vB_Database
MySQL Version : 4.1.12-nt

I've de-activated MOTM and forum is up and running again (fortunately)
I've tried to get the reason but not able.

I'm the only one having this problem?

Thanks
Eros

have you set the right Forum ID for MOTM, also not installing or modifying it in debug mode ?