recent posts not working

If you have a version 3 forum (blue control panel) you should post your general questions here.
Forum rules
This forum is for version 2 (blue control panel) support only.

If your forum is version 3 (orange control panel) please click here here instead.

recent posts not working

Postby LPP on Mon Aug 06, 2007 12:14 am

Could not obtain search results

DEBUG MODE

SQL Error : 1054 Unknown column 't.k_id' in 'on clause'

SELECT t.*, f.forum_id, f.forum_name, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time, k.kategorie FROM lilpitterpatter_topics t, lilpitterpatter_forums f, lilpitterpatter_users u, lilpitterpatter_posts p, lilpitterpatter_posts p2, lilpitterpatter_users u2 LEFT JOIN lilpitterpatter_topic_cat as k ON t.k_id=k.k_id WHERE t.topic_id IN (107, 840, 842) AND t.topic_poster = u.user_id AND f.forum_id = t.forum_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id ORDER BY t.topic_type DESC,t.topic_status ASC, p2.post_time DESC LIMIT 0, 50

Line : 1207
File : search.php


this is what i am getting on board since being back up.

http://www.freepowerboards.com/lilpitterpatter

is there any quick fix for it?

TIA
Last edited by LPP on Mon Aug 06, 2007 5:10 pm, edited 1 time in total.
LPP
Active Member
 
Posts: 100
Joined: Tue May 08, 2007 5:31 pm
Location: Australia

Postby +zai@Unit on Mon Aug 06, 2007 12:22 am

Things are still being looked into.
Matthew A. N.
Support Tech & Live Chat Support Operator
Free Power Boards, Inc.
CrowdGather, Inc.
http://freepowerboards.com/support


Click [Here] for the FPBv3 knowledgebase.

FPBv3 Theme Showcase.
User avatar
+zai@Unit
Moderator
 
Posts: 5330
Joined: Tue Feb 27, 2007 2:29 am
Location: Your Soul

Postby Cheater on Mon Aug 06, 2007 12:31 am

+zai@Unit wrote:Things are still being looked into.

What do you mean still? I just found out about it. :P

LPP I had a little poke around and didnt get the error.
I assume you only get it when searching right?
Imagine if every Thursday your shoes exploded if you tied them the usual way. This happens to us all the time with computers, and nobody thinks of complaining. - Jef Raskin
User avatar
Cheater
Administrator
 
Posts: 965
Joined: Thu Feb 08, 2007 10:06 pm
Location: Brisbane, Australia

Postby LPP on Mon Aug 06, 2007 12:41 am

when i click on
View new posts (13)



that is the error i get
LPP
Active Member
 
Posts: 100
Joined: Tue May 08, 2007 5:31 pm
Location: Australia

Postby Cheater on Mon Aug 06, 2007 1:39 am

Try now.
Imagine if every Thursday your shoes exploded if you tied them the usual way. This happens to us all the time with computers, and nobody thinks of complaining. - Jef Raskin
User avatar
Cheater
Administrator
 
Posts: 965
Joined: Thu Feb 08, 2007 10:06 pm
Location: Brisbane, Australia

Postby LPP on Mon Aug 06, 2007 2:21 am

still doing it....
LPP
Active Member
 
Posts: 100
Joined: Tue May 08, 2007 5:31 pm
Location: Australia

Postby OnYourMark on Mon Aug 06, 2007 2:48 am

yeah, it still does it on mine too.

FPB Staff, thanks for all your help ^_^ seems like exhausting work.
User avatar
OnYourMark
Helpful Member
 
Posts: 42
Joined: Fri Apr 13, 2007 10:09 pm
Location: Honolulu

Postby Cheater on Mon Aug 06, 2007 3:09 am

Ok I've fixed it with a hammer. :)

OnYourMark, it is. The things we do for you guys... :wink:
Imagine if every Thursday your shoes exploded if you tied them the usual way. This happens to us all the time with computers, and nobody thinks of complaining. - Jef Raskin
User avatar
Cheater
Administrator
 
Posts: 965
Joined: Thu Feb 08, 2007 10:06 pm
Location: Brisbane, Australia

Postby LPP on Mon Aug 06, 2007 3:21 am

thanks heaps fpb staff....i really hate having to post complaints in here as i know you guys have enough on but i really lurveeee my recent posts bit  :wink:
LPP
Active Member
 
Posts: 100
Joined: Tue May 08, 2007 5:31 pm
Location: Australia

Postby SabbathD on Mon Aug 06, 2007 10:33 am

throwing my name in the pile too. We are having problems with this function as well.
SabbathD
New Member
 
Posts: 9
Joined: Wed May 23, 2007 11:08 pm

Postby Person on Mon Aug 06, 2007 2:29 pm

I'm having problems with it too... guessing it's with everyone then.
It doesn't work when you click new topcs or new replies from the dashboard either. In fact, I just noticed that all searches come up with an error. :(

However I know you guys will fix this eventually, so I'd like to thank you in advance for your future hard work. :D
Person
Member
 
Posts: 18
Joined: Sun May 06, 2007 6:26 pm

Postby +zai@Unit on Mon Aug 06, 2007 3:07 pm

This issue is known and being looked into, also as of the others.

Post your forum INDEX URL & any ERROR Messages that you get.

Thank you. :-D
Matthew A. N.
Support Tech & Live Chat Support Operator
Free Power Boards, Inc.
CrowdGather, Inc.
http://freepowerboards.com/support


Click [Here] for the FPBv3 knowledgebase.

FPBv3 Theme Showcase.
User avatar
+zai@Unit
Moderator
 
Posts: 5330
Joined: Tue Feb 27, 2007 2:29 am
Location: Your Soul

Postby LPP on Mon Aug 06, 2007 5:09 pm

http://www.freepowerboards.com/lilpitterpatter


It says there are new posts but when you click on it a blank box comes up with headings ie forum topics author etc etc but no listing of them for us to click on.
LPP
Active Member
 
Posts: 100
Joined: Tue May 08, 2007 5:31 pm
Location: Australia

Postby SabbathD on Mon Aug 06, 2007 6:05 pm

LPP wrote:www.freepowerboards.com/lilpitterpatter


It says there are new posts but when you click on it a blank box comes up with headings ie forum topics author etc etc but no listing of them for us to click on.


me too.

http://www.freepowerboards.com/unpopularparent
SabbathD
New Member
 
Posts: 9
Joined: Wed May 23, 2007 11:08 pm

Postby AKateisaKateisaKate on Mon Aug 06, 2007 7:25 pm

I've got the same problem as SabbathD and LPP.

Thanks for the help!
AKateisaKateisaKate
New Member
 
Posts: 5
Joined: Mon Apr 30, 2007 5:13 pm

Postby Advertisement on Wed Jan 07, 2009 9:55 pm

Advertisement
 

  • Users browsing this forum: Google [Bot] and 0 guests