[cherylferraro]

Originally Posted by Sherif

try this xml

Thank you for the suggestion. I installed the xml file you provided but unfortunately when I switch the selection from thread id to forum id it generates this error:

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  : Tuesday, July 19th 2011 @ 01:02:13 PM
Error Date    : Tuesday, July 19th 2011 @ 01:02:14 PM
Script        : http://www.mysite.com/forum/
Referrer      : http://www.mysite.com/forum/index.php
IP Address    : *
Username      : me
Classname     : vB_Database
MySQL Version : 5.1.56