Previous Thread
Next Thread
Print Thread
Hop To
#129224 05/31/2006 2:43 PM
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
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;
}


- Allen
- ThreadsDev | PraiseCafe
#129225 05/31/2006 4:52 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Is that in your error log or are you getting that personally when you view the front page?

#129226 05/31/2006 10:01 PM
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
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 <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />


- Allen
- ThreadsDev | PraiseCafe
#129227 05/31/2006 11:18 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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 = '--'

<img src="https://www.ubbcentral.com/boards/images/graemlins/laugh.gif" alt="" />

#129228 06/01/2006 12:33 AM
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
Thank you very much... <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

A suggestion for threads 7.1 - useful queries like these are put somewhere in the cp <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

You can move this post to the eejit forum <img src="https://www.ubbcentral.com/boards/images/graemlins/wink.gif" alt="" />


- Allen
- ThreadsDev | PraiseCafe

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Version 7.7.5 Images suddenly not displaying
by Stovebolt - 05/04/2024 11:19 AM
Bots
by Outdoorking - 04/13/2024 5:08 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
Who's Online Now
1 members (Ruben), 807 guests, and 148 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240506)