UBB.Developers Forums UBB.threads 7 Development How Do I? How do I real these errors (and hopefully stop them from happening ) ?

Tue, Oct 14 2003 12:48:14 -0400 /ubbthreads/login.php 207.30.244.182
Unable to do_query: SELECT w3t_Favorites.F_Thread,w3t_Posts.B_Subject,w3t_Favorites.F_Number,w3t_Posts.B_Board,w3t_Favorites.F_LastPost,w3t_Posts.B_Main FROM w3t_Posts,w3t_Favorites WHERE w3t_Favorites.F_Owner = '389' AND w3t_Favorites.F_Type = 'r' AND w3t_Favorites.F_Thread = w3t_Posts.B_Number ORDER BY w3t_Favorites.F_Number LIMIT 11 - Unknown column 'w3t_Posts.B_Subject' in 'field list'

Tue, Oct 14 2003 12:48:14 -0400 /ubbthreads/login.php 207.30.244.182
Unable to do_query: SELECT w3t_Posts.B_Last_Post,w3t_Favorites.F_Thread,w3t_Posts.B_Subject,w3t_Favorites.F_Number,w3t_Posts.B_Board,w3t_Favorites.F_LastPost FROM w3t_Posts,w3t_Favorites WHERE w3t_Favorites.F_Owner = '389' AND w3t_Favorites.F_Type = 'f' AND w3t_Favorites.F_Thread = w3t_Posts.B_Number AND w3t_Posts.B_Approved = 'yes' ORDER BY w3t_Posts.B_Last_Post LIMIT 11 - Unknown column 'w3t_Posts.B_Last_Post' in 'field list'

That's odd.

Try this query and verify that the B_Subject and B_Last_Post columns are present: SHOW COLUMNS FROM w3t_Posts

What version is this?

What exactly were you doing when you got those errors?

Are you running a vanilla install, or have you modified it?

You seem to be having a pleatra of SQL problems. And if I understand correctly, you started getting the errors at about the same time you upgraded from 6.3.1 to 6.3.2. I can't imagine what would be causing SQL errors in that bug fix upgrade. Usually when someone gets as many SQL errors as you are getting, it is because thier host changed something with thier MySQL or PHP settings.

Dave I have no idea who did it, it's listed as an IP, however I have other errors it claims I did, but don't know what I could have done.

This is version 6.3.1 We had orginally installed this (right from IP, only slight modifications to remove [ ]mark as edited, and remove thread ratings column. Far as *I* know, host has done nothing 'different'.

Field Type Null Key Default Extra
B_Board varchar(100) MUL
B_Number int(11) unsigned PRI NULL auto_increment
B_Parent int(11) unsigned MUL 0
B_Main int(11) unsigned MUL 0
B_Posted int(11) unsigned MUL 0
B_Last_Post int(11) unsigned 0
B_IP varchar(60) YES NULL
B_Subject text YES NULL
B_Body text YES NULL
B_File varchar(100) YES NULL
B_Kept char(1)
B_Status char(1)
B_Approved char(3) MUL yes
B_Icon varchar(30) YES NULL
B_Reged char(1) YES y
B_Counter int(9) unsigned YES 0
B_Sticky int(1) unsigned YES 0
B_Replies int(4) unsigned YES 0
B_Poll varchar(200) YES NULL
B_Topic int(1) unsigned MUL 0
B_Convert varchar(10) YES markup
B_LastEdit int(9) unsigned YES NULL
B_LastEditBy varchar(64) YES NULL
B_PosterId int(9) unsigned MUL 0
B_Rating varchar(5) YES 0
B_Rates int(4) YES 0
B_RealRating int(1) unsigned YES NULL
B_FileCounter int(9) unsigned YES 0
B_AnonName varchar(64) YES NULL
B_ParentUser int(9) unsigned YES NULL
B_LastPosterId int(9) unsigned YES NULL
B_LastPostNum int(11) unsigned YES NULL