
01-02-2012, 11:32 PM
|
|
|
Join Date: Jan 2007
Posts: 1,158
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
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:
Code:
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 ?
|