Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: May 2003
Posts: 94
K
kestral Offline OP
Power User
OP Offline
Power User
K
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'

Sponsored Links
Joined: Apr 2002
Posts: 1,768
D
Addict
Offline
Addict
D
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
S
Junior Member
Offline
Junior Member
S
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
K
kestral Offline OP
Power User
OP Offline
Power User
K
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


Link Copied to Clipboard
Donate Today!
Donate via PayPal

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.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
AllenAyres
AllenAyres
Texas
Posts: 21,079
Joined: March 2000
Forum Statistics
Forums63
Topics37,552
Posts293,830
Members13,842
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online 219
Topics Created 0
Posts Made 0
Users Online 1
Birthdays 8
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,809
Greg Hard 4,625
Top Posters(30 Days)
stell 3
Morgan 1
isaac 1
Gizmo 1
Top Likes Received
isaac 66
Gizmo 12
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2021 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Snapshot build 20201211)
Responsive Width:

PHP: 5.4.45 Page Time: 0.045s Queries: 23 (0.017s) Memory: 3.2786 MB (Peak: 3.6359 MB) Data Comp: Zlib Server Time: 2021-03-08 10:03:00 UTC
Valid HTML 5 and Valid CSS