| View previous topic :: View next topic |
| Author |
Message |
Loki Expert


Joined: Apr 08, 2006 Posts: 976 Location: Cascadia
|
Posted: Sat Oct 07, 2006 7:30 pm Post subject: Last 24 hours doesn't work |
|
|
| Last 24 hours doesn't work. Please fix it. |
|
| Back to top |
|
 |
RonMN Fission


Joined: Mar 18, 2005 Posts: 2573 Location: Minnesota
|
Posted: Sat Oct 07, 2006 8:12 pm Post subject: Re: Last 24 hours doesn't work |
|
|
I'm a memebr of PO.com...but not a moderator nor an editor....but I AM a technical support analyst (in real life)...and i can tell you they need more info!!!
WHAT isn't working? What is the problem?
Please be a little more specific.
Both members & Mod's are here to help...but we need to know what exactly the problem is... _________________ Quis custodiet ipsos custodes. |
|
| Back to top |
|
 |
Shannymara Master


Joined: Oct 04, 2004 Posts: 5141 Location: Oklahoma
|
Posted: Sat Oct 07, 2006 8:22 pm Post subject: Re: Last 24 hours doesn't work |
|
|
Here's the error I'm getting:
| Quote: | Could not delete old search id sessions
SQL Error : 1153 Got a packet bigger than 'max_allowed_packet' bytes ...
Line : 170
File : /var/www/vhosts/peakoil.com/httpdocs/modules/Forums/getdaily.php |
|
|
| Back to top |
|
 |
Loki Expert


Joined: Apr 08, 2006 Posts: 976 Location: Cascadia
|
Posted: Sat Oct 07, 2006 8:26 pm Post subject: Re: Last 24 hours doesn't work |
|
|
I tried posting what I got, but for some reason it didn't work. Could only post what I did. But I'll try again. When I hit the "Last 24 hours" link, I get this:
| Quote: | Could not delete old search id sessions
DEBUG MODE
SQL Error : 1153 Got a packet bigger than 'max_allowed_packet' bytes |
I'd continue to quote what I get when I press the "Last 24 hours" link (basically a ton of random numbers and letters), but when I cut and paste it here, I get this when I hit "submit":
| Quote: | Not Acceptable
An appropriate representation of the requested resource /gate.html could not be found on this server. |
In other words, everything's all Fark up. That's my technical explanation. |
|
| Back to top |
|
 |
MonteQuest Elite


Joined: Sep 06, 2004 Posts: 13460 Location: Sedona, Arizona
|
Posted: Sat Oct 07, 2006 9:53 pm Post subject: Re: Last 24 hours doesn't work |
|
|
This happens every so often. I don't know why. Server overload perhaps.
The second is a HTTP Error 406 which has to do with some hacker safeguards we have installed. You will get this error message when our software notes something it doesn't like. May be a font, or a special character.
Aaron?
More on this? _________________ A Saudi saying, "My father rode a camel. I drive a car. My son flies a jet-plane. His son will ride a camel."
Live in Arizona? Check out: http://sustainablearizona.org and read my blog. |
|
| Back to top |
|
 |
AgentR Light Sweet Crude


Joined: Oct 06, 2006 Posts: 1011 Location: was rwwff
|
Posted: Sat Oct 07, 2006 10:03 pm Post subject: Re: Last 24 hours doesn't work |
|
|
| MonteQuest wrote: | | The second is a HTTP Error 406 which has to do with some hacker safeguards we have installed. You will get this error message when our software notes something it doesn't like. May be a font, or a special character. |
Mostly it has to do with the use of the word select.
Example, try to put the words: s*lect fr*m on the same line, replacing the asterisks with the correct letter.
Basically its looking for character strings that could be injected into the SQL server and cause it to do all sorts of horrible things. Look at an SQL manual for other combinations that are likely filtered. All the ones I've been hit on have used the word s*lect. _________________ Yes, we are. As we are.
And so shall we remain; Until the end. |
|
| Back to top |
|
 |
Aaron 800 lb Gorilla

Joined: Apr 15, 2004 Posts: 6392 Location: Houston
|
Posted: Sun Oct 08, 2006 5:28 am Post subject: Re: Last 24 hours doesn't work |
|
|
Yeah it's a SQL glitch/exploit.
I'll find it... _________________ "When you understand why you dismiss all the other possible gods, you will understand why I dismiss yours." - Stephen F Roberts.
Praise HawkMan |
|
| Back to top |
|
 |
Loki Expert


Joined: Apr 08, 2006 Posts: 976 Location: Cascadia
|
Posted: Sun Oct 15, 2006 5:48 pm Post subject: Re: Last 24 hours doesn't work |
|
|
Broke again. Same message:
| Quote: | Could not delete old search id sessions
DEBUG MODE
SQL Error : 1153 Got a packet bigger than 'max_allowed_packet' bytes |
|
|
| Back to top |
|
 |
o2ny Heavy Crude

![]()
Joined: Apr 27, 2005 Posts: 240 Location: new york city wacko
|
Posted: Mon Oct 16, 2006 8:12 am Post subject: Re: Last 24 hours doesn't work |
|
|
I'm getting this problem also... maybe you need to increase 'max_allowed_packet'? (a MySQL parameter). Although something tells me that will just be a bandaid, but it's worth a try. _________________ "If you're always looking for the invisible hand to guide you, you will find that the invisible hand often gives you the invisible finger." - some guy on CNBC |
|
| Back to top |
|
 |
Peakprepper Heavy Crude


Joined: Jun 15, 2006 Posts: 104
|
Posted: Mon Nov 27, 2006 4:08 pm Post subject: Re: Last 24 hours doesn't work |
|
|
I wasn't sure whether to tack this on to the previous thread or start a new one.
"Last 24 hours" is still not working - I think it's been like this for 3-4 days.
The error message is:
Could not delete old search id sessions
DEBUG MODE
SQL Error : 1153 Got a packet bigger than 'max_allowed_packet' bytes
etc.
Thanks. _________________ Turner: Do we have plans to invade the Middle East?
Higgins: Are you crazy?
Turner: Am I? |
|
| Back to top |
|
 |
JustinFrankl Intermediate Crude

![]()
Joined: Aug 22, 2005 Posts: 657
|
Posted: Mon Nov 27, 2006 9:54 pm Post subject: Re: Last 24 hours doesn't work |
|
|
Yes, happening again, last several days. Could not delete old search superego sessions, and all that. _________________ "We have seen the enemy, and he is us." -- Walt Kelly |
|
| Back to top |
|
 |
NEOPO permanently banned

Joined: May 15, 2005 Posts: 4144 Location: THE MATRIX
|
Posted: Mon Nov 27, 2006 10:06 pm Post subject: Re: Last 24 hours doesn't work |
|
|
yep me too and I am down to single digit VIEW POSTS SINCE LAST VISIT so this is like a code red for me!!  _________________ It is easier to enslave a people that wish to remain free then it is to free a people who wish to remain enslaved. |
|
| Back to top |
|
 |
MonteQuest Elite


Joined: Sep 06, 2004 Posts: 13460 Location: Sedona, Arizona
|
Posted: Mon Nov 27, 2006 10:32 pm Post subject: Re: Last 24 hours doesn't work |
|
|
I'll pass it upstairs. _________________ A Saudi saying, "My father rode a camel. I drive a car. My son flies a jet-plane. His son will ride a camel."
Live in Arizona? Check out: http://sustainablearizona.org and read my blog. |
|
| Back to top |
|
 |
Quicksilver Tar Sands


Joined: Jul 30, 2005 Posts: 80
|
Posted: Tue Nov 28, 2006 5:56 am Post subject: Re: Last 24 hours doesn't work |
|
|
| Is there a 'fix' for this? It seems to be an ongoing problem (at least since I've been a member) |
|
| Back to top |
|
 |
Aaron 800 lb Gorilla

Joined: Apr 15, 2004 Posts: 6392 Location: Houston
|
Posted: Tue Nov 28, 2006 10:24 am Post subject: Re: Last 24 hours doesn't work |
|
|
I promise this fix this today... <pant> _________________ "When you understand why you dismiss all the other possible gods, you will understand why I dismiss yours." - Stephen F Roberts.
Praise HawkMan |
|
| Back to top |
|
 |
|