First noticed in the control panel that I had Approval Requests pending but when I clicked to view them I saw nothing.<br /><br />Looked into it further and found that if an entry in w3t_Posts has a B_PosterId of 1 (ubbthreads default 'anonymous') the message won't show. This is happening in the forum and pending requests and anywhere else anonymous user posts are displayed.<br /><br />Here is the code from the approveposts.php in the admin directory that is not functioning properly. <br /><br /> <br /><br />remove these two parts from the query above and I at least see registered users pending posts.<br />SELECT ... t2.U_Username<br />AND t1.B_PosterId = t2.U_Number<br /><br />* Looks to me like the mysql linking(?) (t1,t2,t3) is not working but I'm not sure if it's a problem with the MySQL version I have or if there's some setting I need to enable .<br /><br />Here are my system specs<br />- Linux RHLE 4<br />- MySQL 4.1.12<br />- UBBThreads 6.5 <br /><br />Any help or ideas would be greatly appreciated.<br /><br />Thanks,<br /><br />- Simon

I haven't seen that bug before and can't find any info on it here or at http://www.ubbcentral.com/boards/ubbthreads.php - it makes me think it may be something else besides threads. Are you running 6.5 or 6.5.2? There's no difference between the 2 versions of the approveposts.php file, but maybe the bug is in a different file.