Previous Thread
Next Thread
Print Thread
Rate Thread
Mysql error, and a lot of it #285391
05/23/2005 1:32 PM
05/23/2005 1:32 PM
Joined: Apr 2001
Posts: 184
Denmark, the country vith all ...
K
Kordegnen Offline OP
Member
Kordegnen  Offline OP
Member
K

Joined: Apr 2001
Posts: 184
Denmark, the country vith all ...
Hi

i get a lot of errors like this
Code
 [ERROR][Mon, May 23 2005 19:52:00 +0200] [/ubbthreads/showflat.php] [80.164.xxx.xxx] Unable to do_query: <br />         SELECT B_Number<br />         FROM  w3t_Posts<br />         WHERE B_Topic = 1<br />         AND   B_Board  = 'arfism'<br />         <br />         AND B_Approved = 'yes'<br />         ORDER BY B_Sticky DESC,t2.U_Username DESC<br />         LIMIT 12<br />       - Unknown table 't2' in order clause 


What do i have to look for in my code ???

Thomas

Sponsored Links
Re: Mysql error, and a lot of it [Re: shame4me] #285392
05/23/2005 4:37 PM
05/23/2005 4:37 PM
Joined: Oct 2003
Posts: 2,409
Richmond, VA
scroungr Offline
Old Hand
scroungr  Offline
Old Hand

Joined: Oct 2003
Posts: 2,409
Richmond, VA
I would look into showflat.php and see why there is a t2 on that statement.. and thats NOT 6.5 so what version you running...

Re: Mysql error, and a lot of it [Re: 234234] #285393
05/24/2005 12:25 AM
05/24/2005 12:25 AM
Joined: Apr 2001
Posts: 184
Denmark, the country vith all ...
K
Kordegnen Offline OP
Member
Kordegnen  Offline OP
Member
K

Joined: Apr 2001
Posts: 184
Denmark, the country vith all ...
i run 6,4

Re: Mysql error, and a lot of it [Re: shame4me] #285394
05/24/2005 9:53 AM
05/24/2005 9:53 AM
Joined: Oct 2003
Posts: 2,409
Richmond, VA
scroungr Offline
Old Hand
scroungr  Offline
Old Hand

Joined: Oct 2003
Posts: 2,409
Richmond, VA
well open the showflat.php and look for a line that says SELECT B_Number and post it here

Re: Mysql error, and a lot of it [Re: 234234] #285395
05/24/2005 10:43 AM
05/24/2005 10:43 AM
Joined: Oct 2003
Posts: 2,409
Richmond, VA
scroungr Offline
Old Hand
scroungr  Offline
Old Hand

Joined: Oct 2003
Posts: 2,409
Richmond, VA
ok thats an error in 6.4 I would upgrade to 6.4.2 which was the fix to 6.4 or if you don't have access to 6.4.2 then you will have to upgrade to 6.5 or send me a PM so I can take a look at your site and fix it for you since ya can't send complete code..

Sponsored Links

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
· Blue Host
· Interserver.net
Visit us on Facebook
Member Spotlight
Posts: 70
Joined: January 2007
Show All Member Profiles 
Forum Statistics
Forums64
Topics37,453
Posts293,495
Members13,799
Most Online1,498
Mar 17th, 2017
Top Posters(All Time)
AllenAyres 25,587
JoshPet 11,330
Rick 8,373
LK 7,396
Lord Dexter 6,503
Gizmo 5,941
Greg Hard 5,533
Top Posters(30 Days)
isaac 8
Gizmo 3
Today's Statistics
Currently Online 882
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 18
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2018 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.6.3
(Snapshot build 20180915.dev)
Page Time: 0.093s Queries: 15 (0.058s) Memory: 3.2648 MB (Peak: 3.4853 MB) Zlib enabled. Server Time: 2018-09-18 21:04:56 UTC