Mysql error, and a lot of it

You are not logged in. [Log In] ubbDev » Forums » Community Development » HTML, CSS, Programming and MySQL
» MySQL and Server Configuration » Mysql error, and a lot of it

Topic Options

#285391 - 05/23/05 01:32 PM

Mysql error, and a lot of it

Kordegnen Offline

Member

Registered: 04/23/01
Posts: 184
Loc: 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

Top

#285392 - 05/23/05 04:37 PM Re: Mysql error, and a lot of it [Re: shame4me]
scroungr Old Hand Registered: 10/17/03 Posts: 2409 Loc: 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... _________________________ Couchtomatoe - www.couch-tomatoe.cc My abilities are for hire for installs, upgrades, custom themes and custom modifications.
Top

#285393 - 05/24/05 12:25 AM Re: Mysql error, and a lot of it [Re: 234234]
Kordegnen Member Registered: 04/23/01 Posts: 184 Loc: Denmark, the country vith all ...	i run 6,4
Top

#285394 - 05/24/05 09:53 AM Re: Mysql error, and a lot of it [Re: shame4me]
scroungr Old Hand Registered: 10/17/03 Posts: 2409 Loc: Richmond, VA	well open the showflat.php and look for a line that says SELECT B_Number and post it here _________________________ Couchtomatoe - www.couch-tomatoe.cc My abilities are for hire for installs, upgrades, custom themes and custom modifications.
Top

#285395 - 05/24/05 10:43 AM Re: Mysql error, and a lot of it [Re: 234234]
scroungr Old Hand Registered: 10/17/03 Posts: 2409 Loc: 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.. _________________________ Couchtomatoe - www.couch-tomatoe.cc My abilities are for hire for installs, upgrades, custom themes and custom modifications.
Top