PDA

View Full Version : Working on the forum database this weekend...please post new errors/issues here


CheapyD
03-19-2005, 06:48 PM
We are trying to stop those damned dirty critical errors that have been happening so frequently...thanks for your patience.

We just made some changes that hopefully will fix the problem.
Kindly let us know (in this thread) any errors or issues that spring up that may be database related.

zewone
03-19-2005, 06:51 PM
About 20 minutes ago I got a PHB error. :(

CheapyD
03-19-2005, 06:54 PM
About 20 minutes ago I got a PHB error. :(
Ya, thats fine...we were working on the changes then.

Moxio
03-19-2005, 07:31 PM
Woo! I've been getting tired of those stupid PHP errors... screws up every time I'm about to post. >=(

sblymnlcrymnl
03-19-2005, 07:42 PM
Yay.

Kaijufan
03-19-2005, 08:05 PM
That sounds good. Those PHP errors are pretty annoying.

CheapyD
03-19-2005, 10:59 PM
Nothing major in terms of functionality, just switching some stuff around and doing some (search engine friendly) cleanup.

You'll notice that that the last post icons will be swapped out for a text link with the date/time of the last post. Right now, i've only made a few changes to the index, but more will follow.

tornadomann
03-19-2005, 11:02 PM
Awesome! cant wait to see the changes!

Trakan
03-19-2005, 11:02 PM
You'll notice that that the last post icons will be swapped out for a text link with the date/time of the last post.

I knew something was different. I'm not going crazy...

Moxio
03-19-2005, 11:04 PM
Whoa, those seem small, but it changes the entire interface of the boards! O_O

sblymnlcrymnl
03-20-2005, 12:55 AM
Noted.

WhipSmartBanky
03-20-2005, 01:01 AM
You'll notice that that the last post icons will be swapped out for a text link with the date/time of the last post.

I knew something was different. I'm not going crazy...

Short trip, either way...

clockworkvictim
03-20-2005, 01:03 AM
I like it.

FriskyTanuki
03-20-2005, 01:32 AM
O.o o.O o.o O.O Weeeeeiiiiird, it's blowing my mind man! It'll take some getting used to, since I'm waiting for that little icon to appear and it never does. :(

sblymnlcrymnl
03-20-2005, 04:12 AM
Bah, now you can't click on the name of the last poster to see their profile. I actually used that fairly often, but it's no big loss.

Trakan
03-20-2005, 05:13 AM
Cheapy, is there any way to make it easier to get to certain pages/posts in huge threads like this? (http://www.cheapassgamer.com/forum/viewtopic.php?t=26624)

The way it is now only lets you go to the first 3 pages and the last 3 pages, and then 1 page at a time. Like if I wanted to go directly to page 50 in that thread. Sorry if it's confusing.

It could be useful when new users are looking through feedback, etc.

CheapyD
03-20-2005, 05:20 AM
i dont think there is an easy fix for that, but I will take a look. Advanced users can use this format to make their lives easier.

"start" is the number of the post you want to start with.
http://www.cheapassgamer.com/forum/viewtopic.php?t=26624&start=120

Scrubking
03-20-2005, 10:46 AM
Cheapy, is there any way to make it easier to get to certain pages/posts in huge threads like this? (http://www.cheapassgamer.com/forum/viewtopic.php?t=26624)

The way it is now only lets you go to the first 3 pages and the last 3 pages, and then 1 page at a time. Like if I wanted to go directly to page 50 in that thread. Sorry if it's confusing.

It could be useful when new users are looking through feedback, etc.

I agree. That is something that is desperately needed and should be included in every forum. The other day I was searching for something, but had to suffer through page after page instead of easily getting to page X that I wanted to see.

Frankly the way it is now doesn't make sense. Why would we be interested in only the first and last few pages - especially in a search??

sblymnlcrymnl
03-20-2005, 11:03 AM
The time seems to be one hour fast for me. And yes, my timezone is set correctly.

Wshakspear
03-20-2005, 11:13 AM
View your posts gets a

"General Error"
"Could not insert search results"

Admiral Ackbar
03-20-2005, 11:24 AM
Huzzah!

CheapyD
03-20-2005, 12:14 PM
The time seems to be one hour fast for me. And yes, my timezone is set correctly.
Doh...you are correct.

View your posts gets a

"General Error"
"Could not insert search results"
Anyone else getting this...I don't.

Wshakspear
03-20-2005, 12:16 PM
The time seems to be one hour fast for me. And yes, my timezone is set correctly.
Doh...you are correct.

View your posts gets a

"General Error"
"Could not insert search results"
Anyone else getting this...I don't.

I dont get it anymore either

moiety
03-20-2005, 01:23 PM
I noticed you can't click on usernames in the forums anymore. Is this a permanent change or just due to all the upgrading? Thanks!

WhipSmartBanky
03-20-2005, 01:47 PM
I noticed you can't click on usernames in the forums anymore. Is this a permanent change or just due to all the upgrading? Thanks!

http://cheapassgamer.com/forum/viewtopic.php?t=55349

zewone
03-20-2005, 04:10 PM
I miss being able to click on someones profile from the forum and no last-post button and its only been 5 minutes. :( I'm not to happy with the changes, but if it makes the site run better its worth it.

defender
03-20-2005, 05:42 PM
There are mods to make the pagination better.

http://phpbbhacks.com/download/249

That's an example but there are others too.

Search phpbb for pagination

CheapyD
03-20-2005, 06:06 PM
Yeah, I looked through all of them. That is the best one.
I'll take a look...

masha
03-20-2005, 07:06 PM
Two days, ZERO errors. So far, so good.

Keep my middle fingerS crossed :D


EDit: Spoke too soon. Error is back :?

Gothic Walrus
03-20-2005, 07:13 PM
Two days, ZERO errors. So far, so good.

Keep my middle finger crossed :D

Crossed...with what, exactly?

CheapyD
03-21-2005, 02:26 AM
I increased the font of the topic titles and forum navigation

AngellicLulu
03-21-2005, 02:32 AM
I increased the font of the topic titles and forum navigation
I noticed.. I think it's perfect!

Rig
03-21-2005, 02:37 AM
Cheapy, is there any way to make it easier to get to certain pages/posts in huge threads like this? (http://www.cheapassgamer.com/forum/viewtopic.php?t=26624)

The way it is now only lets you go to the first 3 pages and the last 3 pages, and then 1 page at a time. Like if I wanted to go directly to page 50 in that thread. Sorry if it's confusing.

It could be useful when new users are looking through feedback, etc.

I agree. That is something that is desperately needed and should be included in every forum. The other day I was searching for something, but had to suffer through page after page instead of easily getting to page X that I wanted to see.

Frankly the way it is now doesn't make sense. Why would we be interested in only the first and last few pages - especially in a search??

I too, am going to voice and say that this is something I hope is changed. It would make things a lot easier to find!

sblymnlcrymnl
03-21-2005, 03:32 AM
I increased the font of the topic titles and forum navigation
I noticed.. I think it's perfect!

I didn't notice, but thanks anyway!

FriskyTanuki
03-21-2005, 05:31 AM
I increased the font of the topic titles and forum navigation
I noticed.. I think it's perfect!

I didn't notice, but thanks anyway!

It kind of bugs me because it's pretty big, but I guess I'll get used to it soon enough.

CheapyD
03-21-2005, 12:13 PM
Damn...another critical error.
Anyone catch any specific error messages, other than the ever so helpful, "can't connect, critical error" message?

edit: I think I know the problem...I think we are very close to solving these annoying errors.

JSweeney
03-21-2005, 12:20 PM
Damn...another critical error.
Anyone catch any specific error messages, other than the ever so helpful, "can't connect, critical error" message?

edit: I think I know the problem...

I think you got it.
I was trying to replicate the error to get you the error message, but could not get the error to replicate.

CheapyD
03-21-2005, 12:28 PM
Ok...I made another change...lets see if those errors spring up again.

sblymnlcrymnl
03-21-2005, 02:38 PM
I increased the font of the topic titles and forum navigation
I noticed.. I think it's perfect!

I didn't notice, but thanks anyway!

It kind of bugs me because it's pretty big, but I guess I'll get used to it soon enough.

Ok, now I see it. It is pretty big.

AngellicLulu
03-21-2005, 03:17 PM
I increased the font of the topic titles and forum navigation
I noticed.. I think it's perfect!

I didn't notice, but thanks anyway!

It kind of bugs me because it's pretty big, but I guess I'll get used to it soon enough.

Ok, now I see it. It is pretty big.
I personally like the large number at the bottom where it shows what page of a topic you are on.

Wshakspear
03-21-2005, 03:25 PM
I increased the font of the topic titles and forum navigation
I noticed.. I think it's perfect!

I didn't notice, but thanks anyway!

It kind of bugs me because it's pretty big, but I guess I'll get used to it soon enough.

Ok, now I see it. It is pretty big.
I personally like the large number at the bottom where it shows what page of a topic you are on.

When i get home and use my laptop at 1600x1200 i will thank you greatly :)

zewone
03-21-2005, 03:27 PM
Nevermind, I see it now.

Scrubking
03-21-2005, 03:42 PM
Don't forget the background color. :wink:

sblymnlcrymnl
03-21-2005, 04:41 PM
I got a PHB error about 2 minutes ago.

CheapyD
03-21-2005, 04:46 PM
Yup, I am on it....getting closer to DB nirvana (hopefully)

Scrubking
03-21-2005, 04:55 PM
I just got a couple of critical errors.

One was trying to send some pm's the other was just trying to access the site.

zewone
03-21-2005, 07:39 PM
Just got it.

WhipSmartBanky
03-21-2005, 08:24 PM
I got one around 4pm. Critical Error, but it was "Error Creatiing New Session" or something like that. Refreshed a couple of times and it was gone.

AdamInPlaidum
03-21-2005, 08:32 PM
Under the posts, it says "Goto" instead of "Go to". Has it always been this way? Is this intentional? Am I terribly anal to even mention it?

Rig
03-21-2005, 08:40 PM
Under the posts, it says "Goto" instead of "Go to". Has it always been this way? Is this intentional? Am I terribly anal to even mention it?

I didn't notice this until now. Has it always been that way?

CheapyD
03-21-2005, 09:05 PM
I got one around 4pm. Critical Error, but it was "Error Creatiing New Session" or something like that. Refreshed a couple of times and it was gone.

Thanks...please post stuff like that. It helps!

Under the posts, it says "Goto" instead of "Go to". Has it always been this way? Is this intentional? Am I terribly anal to even mention it?
1. yes (but not as large...unintended side effect from something else).
2. i dont know.
3. probably

AdamInPlaidum
03-21-2005, 09:11 PM
I got one around 4pm. Critical Error, but it was "Error Creatiing New Session" or something like that. Refreshed a couple of times and it was gone.

Thanks...please post stuff like that. It helps!

Under the posts, it says "Goto" instead of "Go to". Has it always been this way? Is this intentional? Am I terribly anal to even mention it?
1. yes (but not as large...unintended side effect from something else).
2. i dont know.
3. probably

Well, that pretty much covers all the bases then.

masha
03-22-2005, 12:36 AM
phpBB : Critical Error

Error creating new session

CheapyD
03-22-2005, 12:44 AM
Ok....lets try this
***goes behind curtain***

The Successful Dropout
03-22-2005, 12:53 AM
Ok....lets try this
***goes behind curtain***

be careful back there

i went back there once and never was the same :cry:

Lina
03-22-2005, 01:50 AM
I get the occasional script screw up where all the pretty background and fonts mess up.

Wshakspear
03-22-2005, 02:13 AM
Ok....lets try this
***goes behind curtain***

be careful back there

i went back there once and never was the same :cry:

Its amazing how well it can be hidden...

masha
03-22-2005, 03:10 AM
I get the occasional script screw up where all the pretty background and fonts mess up.

Same here. (FireFox)

Msia
03-22-2005, 01:07 PM
phpBB : Critical Error

Could not connect to the database

Just got it when I came to the front page on Firefox.

CheapyD
03-22-2005, 01:10 PM
Thanks...anyone catch a more specific error message?

evilmax17
03-22-2005, 02:14 PM
phpbb Fetch All error: database query failed

SQL: SELECT f.*, p.*, pt.*, t.*, u.* FROM phpbb_topics AS t, phpbb_users AS u, phpbb_posts_text AS pt, phpbb_posts AS p, phpbb_forums AS f WHERE t.forum_id IN (6,11,15,16,24,26) AND t.topic_last_post_id = pt.post_id AND t.topic_last_post_id = p.post_id AND p.post_time <= 1111515154 AND t.topic_status <> 1 AND t.topic_status <> 2 AND t.forum_id = f.forum_id AND u.user_id = p.poster_id ORDER BY p.post_time DESC LIMIT 0,6

Rig
03-22-2005, 02:17 PM
phpbb Fetch All error: database query failed

SQL: SELECT f.*, p.*, pt.*, t.*, u.* FROM phpbb_topics AS t, phpbb_users AS u, phpbb_posts_text AS pt, phpbb_posts AS p, phpbb_forums AS f WHERE t.forum_id IN (6,11,15,16,24,26) AND t.topic_last_post_id = pt.post_id AND t.topic_last_post_id = p.post_id AND p.post_time <= 1111515154 AND t.topic_status <> 1 AND t.topic_status <> 2 AND t.forum_id = f.forum_id AND u.user_id = p.poster_id ORDER BY p.post_time DESC LIMIT 0,6

WhipSmartBanky
03-22-2005, 02:19 PM
About ten minutes ago, another couldn't connect to d'base error.

jetblac
03-22-2005, 02:22 PM
It is nice knowing you are working at fixing this horrible horrible occurance.

masha
03-22-2005, 02:43 PM
"Failed obtaining forum access control lists"

Rig
03-22-2005, 03:42 PM
phpBB : Critical Error

Could not connect to the database

Happened a few minutes ago... :( (sigh...)

Tricky
03-22-2005, 03:52 PM
phpBB : Critical Error

Could not connect to the database

CheapyD
03-22-2005, 03:57 PM
thanks guys...working on it...

Cornfedwb
03-22-2005, 03:59 PM
Well this hasn't been since the fix, but it won't log my cookie correctly for some reason. I cannot ever stay logged in if I close the window.

Rig
03-22-2005, 04:00 PM
Well this hasn't been since the fix, but it won't log my cookie correctly for some reason. I cannot ever stay logged in if I close the window.

That was happening to me too, but it was a few weeks ago. I haven't had any problems since then...

SteveMcQ
03-22-2005, 04:02 PM
Failed to create a new session error a while ago after lunch. The address bar was all weird, too, but I didn't note what it said.

Cornfedwb
03-22-2005, 04:03 PM
Well this hasn't been since the fix, but it won't log my cookie correctly for some reason. I cannot ever stay logged in if I close the window.

That was happening to me too, but it was a few weeks ago. I haven't had any problems since then...

This has been like 4 months running for me. I need to try deleting my cookies and seeing if that fixes it, but I hate doing that.

zewone
03-22-2005, 04:06 PM
Well this hasn't been since the fix, but it won't log my cookie correctly for some reason. I cannot ever stay logged in if I close the window.

That was happening to me too, but it was a few weeks ago. I haven't had any problems since then...

This has been like 4 months running for me. I need to try deleting my cookies and seeing if that fixes it, but I hate doing that.

I was having the same problem, but as soon as I deleted my cookies it worked again. It is a pain though having to re-enter all your info for every site you visit regularly.

cdeener
03-22-2005, 05:14 PM
phpbb Fetch All error: database query failed

SQL: SELECT f.*, p.*, pt.*, t.*, u.* FROM phpbb_topics AS t, phpbb_users AS u, phpbb_posts_text AS pt, phpbb_posts AS p, phpbb_forums AS f WHERE t.forum_id IN (6,11,15,16,24,26) AND t.topic_last_post_id = pt.post_id AND t.topic_last_post_id = p.post_id AND p.post_time <= 1111525560 AND t.topic_status <> 1 AND t.topic_status <> 2 AND t.forum_id = f.forum_id AND u.user_id = p.poster_id ORDER BY p.post_time DESC LIMIT 0,6

at /usr/home/cheapas/public_html/forum/mods/phpbb_fetch_all/common.php:337

WhipSmartBanky
03-22-2005, 05:14 PM
I just saw a new one:

phpBB : Critical Error

Could not obtain ban information

Trakan
03-22-2005, 05:16 PM
message_die() was called multiple times. This isn't supposed to happen. Was message_die() used in page_tail.php?

CheapyD
03-22-2005, 07:39 PM
Ok...made some more changes around 4PM EST today...lets see how they do.

Mike23
03-22-2005, 09:02 PM
General Error

Could not obtain post/user information.

Got that error...not sure if it has to do with anything. It was in the politics forum.

CheapyD
03-22-2005, 09:07 PM
That was probably just a general fart (I hope).
I'm looking for session related problems and db connect stuff.

Backlash
03-22-2005, 09:17 PM
Just got this:

Could not select canned_custom_count

Moxio
03-22-2005, 09:18 PM
Just got that critical PHP error thing. :/

Rig
03-22-2005, 09:18 PM
phpbb Fetch All error: database query failed

SQL: SELECT f.*, p.*, pt.*, t.*, u.* FROM phpbb_topics AS t, phpbb_users AS u, phpbb_posts_text AS pt, phpbb_posts AS p, phpbb_forums AS f WHERE t.forum_id IN (6,11,15,16,24,26) AND t.topic_last_post_id = pt.post_id AND t.topic_last_post_id = p.post_id AND p.post_time <= 1111540440 AND t.topic_status <> 1 AND t.topic_status <> 2 AND t.forum_id = f.forum_id AND u.user_id = p.poster_id ORDER BY p.post_time DESC LIMIT 0,6

Backlash
03-22-2005, 09:19 PM
Got this when making my post about another error :)

message_die() was called multiple times. This isn't supposed to happen. Was message_die() used in page_tail.php?

CheapyD
03-22-2005, 09:19 PM
ya...it got served again. :bomb:
I think we are close though...

WhipSmartBanky
03-22-2005, 10:41 PM
ya...it got served again. :bomb:
I think we are close though...

phpBB : Critical Error

Could not connect to the database

Moxio
03-22-2005, 10:46 PM
ya...it got served again. :bomb:
I think we are close though...

phpBB : Critical Error

Could not connect to the database

Yeah, couldn't connect to CAG for about 10-15 minutes.

CheapyD
03-23-2005, 12:04 AM
I think we are close though...
So much for that theory...
Man, this is ultra lame!

FriskyTanuki
03-23-2005, 12:35 AM
I think we are close though...
So much for that theory...
Man, this is ultra lame!

:lol: That sucks. Just when you think your out, they keep pulling you back in!

CheapyD
03-23-2005, 12:41 AM
ok...another change...10:40PM

evilmax17
03-23-2005, 10:43 AM
8:20 AM EST to 8:40 AM EST

phpBB : Critical Error

Could not connect to the database

CheapyD
03-23-2005, 10:43 AM
yeah...wonderful.
Did it survive the night?
Back to the drawing board.

The Successful Dropout
03-23-2005, 10:52 AM
im not sure about the night, but as evilmax said....it crapped out again just a little bit ago

cdeener
03-23-2005, 11:50 AM
phpBB : Critical Error

Could not connect to the database

Sorry CheapyD just happened two minutes ago

CheapyD
03-23-2005, 11:53 AM
Ok...*pops the hood and tinkers*

lets see how that goes...

Mr.Answer
03-23-2005, 12:03 PM
Seems to be like clockwork, usually around 8:30 central time I get the critical error.

punqsux
03-23-2005, 01:07 PM
whenever i clicked any forum board i got this:

Sorry, but this board is currently unavailable. Please try again later.

punqsux
03-23-2005, 01:09 PM
the boards are posting backwards! my head is about to explode!

smalien1
03-23-2005, 01:11 PM
There hasn't been a CC five doller deal recently, can you fix that in the server?

sblymnlcrymnl
03-23-2005, 01:26 PM
whenever i clicked any forum board i got this:

Sorry, but this board is currently unavailable. Please try again later.

I keep getting that too ... also the time is now 4 hours off instead of just the one.

moiety
03-23-2005, 01:42 PM
All the posts are messed up. For example the first five topics in the OT have last posts from around noon, and the newer ones are under those. I tried posting in another thread and it showed a post time of like 1230 (and its 440 now).

Edit: It did it with this post too! It is actually 440 right now and my post should've come after cdeener's, but yet it inserted it before Punq's. I'm so confused!

Rig!
03-23-2005, 01:50 PM
I can't post in the forums under my regular name! (I hope you know who this is! ;) )

I get the:

You cannot make another post so soon after your last; please try again in a short while.

Any help?

SteveMcQ
03-23-2005, 01:54 PM
"You cannot make a post so soon after your last one. Please try again later." Or something to that effect. Except I had just signed on and hadn't made any posts.

Edit: Just made a post on the Deals board and it posted as the OP. It seems my time has also been altered. I'll have to change that.

sblymnlcrymnl
03-23-2005, 01:54 PM
It seems that some people's posts are going in at the correct time while others (such as myself) are about 4 hours off (12pm instead of 4pm).

road3283
03-23-2005, 02:06 PM
All the posts are messed up. For example the first five topics in the OT have last posts from around noon, and the newer ones are under those. I tried posting in another thread and it showed a post time of like 1230 (and its 440 now).

Edit: It did it with this post too! It is actually 440 right now and my post should've come after cdeener's, but yet it inserted it before Punq's. I'm so confused!

Something similar to this happened to my post in the Gamerush thread. The time was off and it ended up about tem post up instead of being last. :shock:

Msia
03-23-2005, 04:16 PM
phpbb Fetch All error: database query failed

SQL: SELECT f.*, p.*, pt.*, t.*, u.* FROM phpbb_topics AS t, phpbb_users AS u, phpbb_posts_text AS pt, phpbb_posts AS p, phpbb_forums AS f WHERE t.forum_id IN (6,11,15,16,24,26) AND t.topic_last_post_id = pt.post_id AND t.topic_last_post_id = p.post_id AND p.post_time <= 1111608899 AND t.topic_status <> 1 AND t.topic_status <> 2 AND t.forum_id = f.forum_id AND u.user_id = p.poster_id ORDER BY p.post_time DESC LIMIT 0,6

at

evilmax17
03-23-2005, 04:18 PM
PHPizzle couldn't connizzle to the databizzle

punqsux
03-23-2005, 04:21 PM
phpbb Fetch All error: database query failed

SQL: SELECT f.*, p.*, pt.*, t.*, u.* FROM phpbb_topics AS t, phpbb_users AS u, phpbb_posts_text AS pt, phpbb_posts AS p, phpbb_forums AS f WHERE t.forum_id IN (6,11,15,16,24,26) AND t.topic_last_post_id = pt.post_id AND t.topic_last_post_id = p.post_id AND p.post_time <= 1111608610 AND t.topic_status <> 1 AND t.topic_status <> 2 AND t.forum_id = f.forum_id AND u.user_id = p.poster_id ORDER BY p.post_time DESC LIMIT 0,6

at

Backlash
03-23-2005, 04:52 PM
The programmer in me cringes at SELECT * :(

Not mention the joins aren't ANSI standard.

Backlash
03-23-2005, 05:23 PM
I keep getting "Error deleting post" when I try to edit my double-post in that "Ever think about making a porno?" thread.

The double post was caused when I got the "Cannot obtain ban list" error..

punqsux
03-23-2005, 05:24 PM
phpbb Fetch All error: database query failed

SQL: SELECT f.*, p.*, pt.*, t.*, u.* FROM phpbb_topics AS t, phpbb_users AS u, phpbb_posts_text AS pt, phpbb_posts AS p, phpbb_forums AS f WHERE t.forum_id IN (6,11,15,16,24,26) AND t.topic_last_post_id = pt.post_id AND t.topic_last_post_id = p.post_id AND p.post_time <= 1111612561 AND t.topic_status <> 1 AND t.topic_status <> 2 AND t.forum_id = f.forum_id AND u.user_id = p.poster_id ORDER BY p.post_time DESC LIMIT 0,6

at

Latest Message Board Posts
Cheap Ass Deals & Shopping Discussions (refresh)
phpBB : Critical Error

Could not connect to the database

Gaming, Trading & Cheap Ass Lifestyle (refresh)
phpBB : Critical Error

Could not connect to the database



and i got this error when i went to "view my posts" from the front page.

General Error

Could not delete old search id sessions

cdeener
03-23-2005, 05:25 PM
phpBB : Critical Error

Could not connect to the database

masha
03-24-2005, 10:54 AM
phpbb Fetch All error: database query failed

SQL: SELECT f.*, p.*, pt.*, t.*, u.* FROM phpbb_topics AS t, phpbb_users AS u, phpbb_posts_text AS pt, phpbb_posts AS p, phpbb_forums AS f WHERE t.forum_id IN (6,11,15,16,24,26) AND t.topic_last_post_id = pt.post_id AND t.topic_last_post_id = p.post_id AND p.post_time <= 1111675801 AND t.topic_status <> 1 AND t.topic_status <> 2 AND t.forum_id = f.forum_id AND u.user_id = p.poster_id ORDER BY p.post_time DESC LIMIT 0,6

at /usr/home/cheapas/public_html/forum/mods/phpbb_fetch_all/common.php:337

CheapyD
03-24-2005, 11:09 AM
Ok...you can stop posting the errors now guys...say adios to PHPBB.

Thanks.

Scorch
03-24-2005, 12:42 PM
Ok...you can stop posting the errors now guys...say adios to PHPBB.

Thanks.

ADIOS.. finally!

SQL: SELECT f.*, p.*, pt.*, t.*, u.* FROM phpbb_topics AS t, phpbb_users AS u, phpbb_posts_text AS pt, phpbb_posts AS p, phpbb_forums AS f WHERE t.forum_id IN (6,11,15,16,24,26) AND t.topic_last_post_id = pt.post_id AND t.topic_last_post_id = p.post_id AND p.post_time <= 1111675801 AND t.topic_status <> 1 AND t.topic_status <> 2 AND t.forum_id = f.forum_id AND u.user_id = p.poster_id ORDER BY p.post_time DESC LIMIT 0,6

That's not an error, that's the uber secret code to get Sheng Long! *writes down*

WhipSmartBanky
03-24-2005, 12:43 PM
Are we there ye...oh.

Wshakspear
03-24-2005, 01:51 PM
Are we there ye...oh.

We'll get there when we get there!!! :)

And thanks for the fix cheapy!