
07-17-2011, 04:19 AM
|
|
|
Join Date: Jun 2010
Location: India
Posts: 505
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
Originally Posted by cherylferraro
Great mod thank you for sharing it. It works well with the thread id however when I try to use a forum id instead of the thread id loading the forum page generates the following error:
Code:
Database error in vBulletin 4.1.4:
Invalid SQL:
SELECT forum.forumid as forumidd, thread.threadid, thread.pollid, thread.forumid, thread.open, thread.lastpost FROM vb_forum
LEFT join vb_thread ON thread.forumid = forum.forumid where forum.forumid = 64 ORDER BY thread.pollid DESC LIMIT 1;
MySQL Error : Unknown column 'forum.forumid' in 'field list'
Error Number : 1054
Request Date : Saturday, July 16th 2011 @ 11:23:12 AM
Error Date : Saturday, July 16th 2011 @ 11:23:13 AM
Script : http://www.mysite.com/forum/
Referrer : http://www.mysite.com/forum/
IP Address : 98.164.244.76
Username : me
Classname : vB_Database
MySQL Version : 5.1.56
|
try this xml
|