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

Previous Topic

Index

Next Topic

Hop to:

Latest Posts

[7.2.1] - Naked shoutbox
by bellaonline
05/05/12 05:00 PM

[7.x] Stop Forum Spam Integration v0.4
by bellaonline
05/05/12 03:53 PM

Shout Box

May
Su	M	Tu	W	Th	F	Sa
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31

(Views)Popular Topics

Known public proxy servers	1689885
Integrated Index Page (IIP) 5.3.1	555705
Finished-[6.5.2] Games Arcade Deluxe v1.9	501236
Integrated Index Page (IIP) 5.1.1	415112
TLD Bv2.1 Released - Threads Links Directory	396822
[6.0x] Who's Online 4.0.0 [Finished]	389412
Finished-[6.5.1] Integrated Index Page (IIP) 6.5	330423
Q & A	298663
Slash UBB	266936
[6.3.x] [beta] Hit Hack 2.0	227970

Forum Stats

13621 Members
59 Forums
37191 Topics
295716 Posts

Max Online: 686 @ 06/28/07 07:04 AM