|
Joined: May 2003
Posts: 94
Power User
|
Power User
Joined: May 2003
Posts: 94 |
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'
|
|
|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
Addict
Joined: Apr 2002
Posts: 1,768 |
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?
|
|
|
|
Joined: Jun 2003
Posts: 1,025
Junior Member
|
Junior Member
Joined: Jun 2003
Posts: 1,025 |
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.
|
|
|
|
Joined: May 2003
Posts: 94
Power User
|
Power User
Joined: May 2003
Posts: 94 |
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
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 417
Joined: November 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|