Last 24 hours doesn't work

FishAreBest · Posted: Wed Nov 29, 2006 9:32 am Post subject: Re: Last 24 hours doesn't work

<<I promise this fix this today...>>

It is now tomorrow, and I haven't been able to get in all week :-(

<<SQL Error : 1153 Got a packet bigger than 'max_allowed_packet' bytes>> followed by a SQL statement that is a little over 1MB long.

I guess from this that you've got "max_allowed_packet" set to 1M or lower.

You can increase the value of this parameter in a number of places:

1) In the mysql command line, using the parameter "--max_allowed_packet=8M"

2) In the my.cnf configuration file "SET max_allowed_packet=8M;"

Alternatively, modify modules/Forums/getdaily.php to process a few values at a time, rather than all at once??

Sorry if I'm speaking out of turn here - I'm just a frustrated user trying to be helpful!!!

JustinFrankl · Intermediate Crude Joined: Aug 22, 2005 Posts: 657

Still broken.
_________________
"We have seen the enemy, and he is us." -- Walt Kelly

Peakprepper · Heavy Crude Joined: Jun 15, 2006 Posts: 104

HHHgnnnnnnnnnnnnnnnnnnnnnnnrrrrrrrrrrrrrrrrrrrr.....

This is really annoying as it's the only function I use to access this site - I pop in, check the "last 24 hours", then have a quick read, and am on my way again.

I'm not complaining (well I am really, I suppose), but without this function, I haven't been here for over a week. I just don't have the time to trawl through all the forum headers, particularly as the site can be extremely slow at times.

"Last 24 hours" is such a brilliant idea, I have suggested it to a few other forums I visit occasionally - please get it working!!!!!!!!!!
_________________
Turner: Do we have plans to invade the Middle East?
Higgins: Are you crazy?
Turner: Am I?

Arkwright · Tar Sands Joined: Jan 01, 2005 Posts: 89 Location: Finland

I can smell a conspiracy here!
The last 24 hours is the most used method for browsing the forums.
Some threads have content they don't want the public notice too much.
The last 24 hours search gets disabled till those topics fall behind. No-one reads beyond first page anyway.

Now the question we should be asking is, are the culprits bribed admins, advertisers or them cracking the database when thread about [insert something witty] gets a bump. Wink

Honestly, get and keep it working! pretty please.

Peakprepper · Heavy Crude Joined: Jun 15, 2006 Posts: 104

Lol Arkwright.

Can I suggest therefore that we ask for a

"Last 48 hours" and
"Last 96 hours" and...

... I'm sure you'll guess the rest of the sequence.
_________________
Turner: Do we have plans to invade the Middle East?
Higgins: Are you crazy?
Turner: Am I?

admin · Posted: Thu Nov 30, 2006 1:21 pm Post subject: Re: Last 24 hours doesn't work

It's fixed. Again.

I just hope it stays fixed Rolling Eyes

Peakprepper · Heavy Crude Joined: Jun 15, 2006 Posts: 104

Sweet.

Thanks.
_________________
Turner: Do we have plans to invade the Middle East?
Higgins: Are you crazy?
Turner: Am I?

Cobra_Strike · Posted: Thu Nov 30, 2006 3:57 pm Post subject: Re: Last 24 hours doesn't work

I am glad it is working again, thanks for the fix...I hope it hold up for a while.
_________________
We stand here, as the light of other days surrounds us.
"Hail the Dead"

FoolYap · Posted: Thu Oct 18, 2007 11:07 am Post subject: Re: Last 24 hours doesn't work

Seems to be broken again, for me anyway. Sad

--Steve

Tanada · Posted: Thu Oct 18, 2007 6:21 pm Post subject: Re: Last 24 hours doesn't work

Ferretlover · Posted: Thu Oct 18, 2007 6:59 pm Post subject: Re: Last 24 hours doesn't work

When asking for 'last 24 hours,' I get either the debug screen as mentioned earlier, a sorry server problem, or just a white screen.
Also, I tried to send a pm to Threadbear: clicked submit, then the screen went to white.

Talk about feeling cutoff from the world! lol
_________________
"RRrrruuuunnnn!!!" ~Apocalypto

kmann · Heavy Crude Joined: Jul 25, 2005 Posts: 318

It's broke!

Ferretlover · Posted: Fri Oct 19, 2007 7:06 pm Post subject: Re: Last 24 hours doesn't work

How si the "last 24 hours" repair going, Aaron?
_________________
"RRrrruuuunnnn!!!" ~Apocalypto

Shannymara · Master Joined: Oct 04, 2004 Posts: 5432 Location: Oklahoma

I don't have access to the files so I can't fix it, but FYI staff is aware of the problem and I'm sure Aaron or admin will get to it asap. Thanks for your patience, meanwhile.

I use "View posts since last visit" myself, because it shows the Open Discussion and Hall of Flames as well. It is still working, unlike Last 24 hours.
_________________
"Every junkie's like a setting sun..." - Neil Young

Ferretlover · Posted: Fri Oct 19, 2007 7:19 pm Post subject: Re: Last 24 hours doesn't work

Thanks for the idea, Shanny.. I've been going through the Forum Index to get anywhere..
I know they are trying to figure it out-didn't mean to sound pushy! Smile

_________________
"RRrrruuuunnnn!!!" ~Apocalypto