UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support [6.4] New users logging in get this error:

[6.4] When a new user (only a new user) logs in for the first time and goes to the main index, they get an error message:

SQL ERROR: Fri, Dec 12 2003 14:19:54 -0600 Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/account/public_html/ubbthreads/mysql.inc.php on line 133
SQL ERROR: Fri, Dec 12 2003 14:19:54 -0600 Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/account/public_html/ubbthreads/mysql.inc.php on line 133
SQL ERROR: Fri, Dec 12 2003 14:19:54 -0600 Database error only visible to forum administrators

(repeated several times).


My error log tells me this:

Unable to do_query: 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 FROM im_Boards AS t1 LEFT JOIN im_Users AS t2 ON t1.Bo_Posterid = t2.U_Number LEFT JOIN im_Posts AS t3 ON t1.Bo_LastNumber = t3.B_Number WHERE t1.Bo_Cat = 8 AND () ORDER BY t1.Bo_Sorter - You have an error in your SQL syntax near ') ORDER BY t1.Bo_Sorter ' at line 7

(I added some spaces above so it would fit better in this post)

OK, I found my snag.

I found that after upgrading to 6.4, in my Admin--Edit Config Settings, where it asks: What groups do you want new users to belong to?, nothing was checked.

I checked "Users", and now new users don't have the problem any more.

I don't know why the check mark disappeared, but it might be worth noting.

Their data in the w3t_Users table all appear the same and all are listed with U_Status "Users", but the U_Groups data was missing the "-3-".