| 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: 2533 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 Semi-retired Admin


Joined: Oct 04, 2004 Posts: 4641 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: 12896 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 Intermediate Crude


Joined: Oct 06, 2006 Posts: 943 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. _________________ Who is in the mirror, Mr. Johnson. |
|
| Back to top |
|
 |
Aaron 800 lb Gorilla

Joined: Apr 15, 2004 Posts: 6310 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... _________________ "We shall not cease from exploration
And the end of all our exploring
Will be to arrive where we started
And know the place for the first time." - TS Eliot* |
|
| 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: 103
|
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: 12896 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: 6310 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> _________________ "We shall not cease from exploration
And the end of all our exploring
Will be to arrive where we started
And know the place for the first time." - TS Eliot* |
|
| Back to top |
|
 |
|