Author |
Message |
|
lothario
|
Posted: Sun Sep 03, 2006 7:09 pm |
|
|
CorporalPosts: 354Location: DenmarkJoined: Sat Sep 02, 2006 11:57 pm
|
When i click the recent topics link at the bottom, i get this:
Code: could not obtain main information.
DEBUG MODE
SQL Error : 1054 Unknown column 't.topic_first_post_id' in 'on clause'
SELECT t.*, p.poster_id, p.post_username AS last_poster_name, p.post_id, p.post_time, f.forum_name, f.forum_id, u.username AS last_poster, u.user_id AS last_poster_id, u2.username AS first_poster, u2.user_id AS first_poster_id, p2.post_username AS first_poster_name FROM phpbb_topics t, phpbb_posts p LEFT OUTER JOIN phpbb_posts p2 ON p2.post_id = t.topic_first_post_id LEFT OUTER JOIN phpbb_forums f ON p.forum_id = f.forum_id LEFT OUTER JOIN phpbb_users u ON p.poster_id = u.user_id LEFT OUTER JOIN phpbb_users u2 ON u2.user_id = t.topic_poster WHERE t.forum_id NOT IN (15) AND p.post_id = t.topic_last_post_id AND FROM_UNIXTIME(p.post_time,'%Y%m%d') - FROM_UNIXTIME(unix_timestamp(NOW()),'%Y%m%d') = 0 ORDER BY t.topic_last_post_id DESC LIMIT 0, 10
Line : 127 File : recent.php
|
Top
|
|
BRAINKILLER
|
Posted: Sun Sep 03, 2006 7:13 pm |
|
|
GeneralPosts: 2744Location: ItalyJoined: Thu Aug 24, 2006 11:58 pm
|
yes I know, working on it
_________________ Stay on top but remain from the underground |
|
Top
|
|
FLAME-XIII
|
Posted: Sun Sep 03, 2006 8:00 pm |
|
|
Majestic 13Posts: 2640Location: RussiaJoined: Tue Aug 29, 2006 6:52 pm
|
LoL...Lothario not admin anymore ?!
_________________ The Fucking Voodoo |
|
Top
|
|
BRAINKILLER
|
Posted: Sun Sep 03, 2006 8:03 pm |
|
|
GeneralPosts: 2744Location: ItalyJoined: Thu Aug 24, 2006 11:58 pm
|
FLAME-XIII wrote: LoL...Lothario not admin anymore ?!
he's the admin on bk-recordings dude
:chillpill:
_________________ Stay on top but remain from the underground |
|
Top
|
|
TMWKTM
|
Posted: Tue Sep 05, 2006 7:55 pm |
|
|
|
Iridium wrote: 2. There is a bug with the "oops" smiley (in the "more emoticons" section).
thanks, fixed.
|
Top
|
|
Mika
|
Posted: Tue May 27, 2008 1:53 pm |
|
|
ColonelPosts: 868Location: FinlandJoined: Sat Sep 02, 2006 12:48 pm
|
I don't know should I report this, but when I just logged in I got this error:
Quote: Could not query forums information
DEBUG MODE
SQL Error : 2013 Lost connection to MySQL server during query
SELECT f.*, p.post_time, p.post_username, u.username, u.user_id FROM (( phpbb_forums f LEFT JOIN phpbb_posts p ON p.post_id = f.forum_last_post_id ) LEFT JOIN phpbb_users u ON u.user_id = p.poster_id ) ORDER BY f.cat_id, f.forum_order
Line : 170 File : index.php
|
Top
|
|
Cogglesz
|
Posted: Sun Jul 27, 2008 4:46 pm |
|
|
GeneralPosts: 6933Location: Scotland UKJoined: Wed May 23, 2007 2:57 pm
|
had this one a few times:
Code: CGI Error The specified CGI application misbehaved by not returning a complete set of HTTP headers.
_________________ "THERE WILL BE NO RETURNS" |
|
Top
|
|
*PinHead*
|
Posted: Wed Aug 06, 2008 3:14 pm |
|
|
GeneralPosts: 3303Location: DoglandJoined: Thu Jan 17, 2008 7:49 pm
|
|
Top
|
|
Nuno
|
Posted: Wed Aug 06, 2008 3:32 pm |
|
|
|
Pinhead wrote: http://www.brainkiller.it/public/forum/viewtopic.php?p=76867#76867i keep seeing there's a new message in the thread but when i click on it it says Quote: No posts exist for this topic
that was caused when Big Sugar deleted all the spam members. all you got to do is go for the page before the last one. example; 38 go to 37.
|
Top
|
|
*PinHead*
|
Posted: Thu Aug 07, 2008 12:23 am |
|
|
GeneralPosts: 3303Location: DoglandJoined: Thu Jan 17, 2008 7:49 pm
|
yeah but i even got the message on some posts of erika.and she isn't a spam memeber i think.or maybe i don't understand the term
|
Top
|
|
erika
|
Posted: Thu Aug 07, 2008 12:47 pm |
|
|
Hot ChickPosts: 1943Joined: Thu Sep 07, 2006 9:46 pm
|
wft
|
Top
|
|
feelthy
|
Posted: Fri Aug 08, 2008 1:58 am |
|
|
A.K.A. feelxPosts: 3059Location: Montréal, QCJoined: Sun Jul 15, 2007 11:32 pm
|
exactly
WHAT FUCK THE
think he means he see last message was yours, clicks on last page but see the "No post" thing.
_________________ Fuck you and your heart attack |
|
Top
|
|
erika
|
Posted: Fri Aug 08, 2008 9:32 am |
|
|
Hot ChickPosts: 1943Joined: Thu Sep 07, 2006 9:46 pm
|
oh, thats what he thought
ftw
|
Top
|
|
*PinHead*
|
Posted: Fri Aug 08, 2008 3:37 pm |
|
|
GeneralPosts: 3303Location: DoglandJoined: Thu Jan 17, 2008 7:49 pm
|
psycho_feel XD wrote: exactly WHAT FUCK THE think he means he see last message was yours, clicks on last page but see the "No post" thing.
exactly
|
Top
|
|
|