I am getting:

Script: /public_html/forums/ubbthreads.php - Line: 328
SELECT t1.Bo_Title,t1.Bo_Description,t1.Bo_Keyword,t1.Bo_Total,t1.Bo_Last,t1.Bo_Number,t1.Bo_Moderated,t1.Bo_Read_Perm,t1.Bo_Write_Perm,t1.Bo_Threads,t1.Bo_Sorter,t1.Bo_Posterid,t1.Bo_LastMain,t1.Bo_LastNumber,t2.U_Username,t3.B_Subject,t3.B_Icon,t3.B_Reged,t3.B_AnonName,t1.Bo_Image,t1.Bo_Cat
FROM w3t_Boards AS t1
LEFT JOIN w3t_Users AS t2 ON t1.Bo_Posterid = t2.U_Number
LEFT JOIN w3t_Posts AS t3 ON t1.Bo_LastNumber = t3.B_Number
WHERE t1.Bo_Active = '1'

AND ()
ORDER BY t1.Bo_Cat,t1.Bo_Sorter
- You have an error in your SQL syntax near ')
ORDER BY t1.Bo_Cat,t1.Bo_Sorter
' at line 8


Line 328 is in:

Code:

---

$boards = $dbh->do_query($query,__LINE__,__FILE__);
while ( $boardrow = $dbh -> fetch_array($boards)) {
	$catboards[$boardrow['Bo_Cat']][] = $boardrow;
}

---

Is that in your error log or are you getting that personally when you view the front page?

It's in the error log, not something I'd seen before, but I thought I'd check the log and there were 3-4 instances of this

Basically that query is failing because it looks like the person in question isn't assigned to any group. It builds your forum list off your groups, and for some reason this person isn't even getting into the anonymous groups, his groups are just null resulting in a bad query.

Is this on threadsdev? Maybe need to do a query and see if there is anyone with no groups.

Select U_Username from w3t_Users where U_Groups = '' or U_Groups = '-"

That should cover it unless their profile is really screwed up, in which case:

Select U_Username from w3t_Users where U_Groups = '' or U_Groups = '-" or U_Groups = '--'

Thank you very much...

A suggestion for threads 7.1 - useful queries like these are put somewhere in the cp

You can move this post to the eejit forum