Thread: View your posts problem

holy jesus
that just gave you a list of sids. hahahaha. /me uses.

looking at the problems people are getting recently, i'd say your sessions table is corrupted, or you didn't patch search.php right.

I got the same thing, and it doesn't look like corruption of the database
The phpbb search for 'view own posts' includes a delete statement that removes previous search results for old sessions sessions (or something like that)
But it does it in one massive delete statement, using delete were WHERE session_id NOT IN <shitlong list>

Heres the full error:

--------------------------------------------
Could not delete old search id sessions

DEBUG MODE

SQL Error : 1153 Got a packet bigger than 'max_allowed_packet'

DELETE FROM phpbb_search_results WHERE session_id NOT IN ('<number>', ... shitloads of numbers... ,'<number>')

Line : 814
File : /usr/local/apache/htdocs/forum/search.php
--------------------------------------------

A few members had said thay have had the same problem along with myself.
So what is the problem? In laymen terms!

who knows, perhaps it is the worm that's trying to get through and it somehow disrupts it?

the reasoning behind the problem is in regards to the session table. old entries are cleared automatically but when we're assailed by thousands of guests within the span of only one day, those old entries remain. anyway, i've cleared the sessions table just now and everything is fine again.

not for long, if you done it that way, i assume. sloppy.

Techboy, icedawg works on the site in his spare time. Why you have abundances of that stuff, and don't have to go out and work to get money so you can keep food on the table, he can't sit down and spend time rewriting a bunch of phpBB code, testing it and then deploying it for one thing that can just as easily be fixed temporarily in a few seconds with a click of a button or two. So don't expect him to perform mini miracles for you, k?

there's a good reason why there are so many guest sessions (note, i said sessions and not actual guests), and that has to do with a search engine modification i read about and then implemented, and it works very well.

but anyway, thanks again for being so inconsiderate techboy.

hey, i wasn't being inconsiderate, i was just suggesting that perhaps it would be a better idea to look into what was going on a bit more. and after i read that post, you should probably look at wtf that mod is doing.

i know, from looking at other larger forums such as the actual phpbb.com forums that it can cope with large amounts of users, and that something seems to have gone wrong.

-tech

Originally posted by Techboy
hey, i wasn't being inconsiderate, i was just suggesting that perhaps it would be a better idea to look into what was going on a bit more. and after i read that post, you should probably look at wtf that mod is doing.

really. please tell me, what else should i be doing? it seems to me every week i get multiple PMs from you telling me what i should be doing, with an escalating level of attitude from you as of late. why don't you just chill out alright? you don't know anything about the mod that is installed, specifically what it is accomplishing...it's doing exactly what is intended, and i already knew about the by-product regarding the number of guest sessions; this time was an anomaly due to that worm attack still lurking around. this mod has otherwise been working perfectly for the past 8 or so months.

yay problem fixed. thanks ice :D

i dont know what i would do without my precious "view your posts" button :P

Originally posted by nightowl
yay problem fixed. thanks ice *

i dont know what i would do without my precious \"view your posts\" button *

same