Sporks-R-Us:  Bastard Hybrid Utensil of D00M!
Front Page · Everything · News · Op/Ed · Ask A Spork · Interviews · Religion · Reviews · MLP · AK5CG · Strange · Cats · Nonsense · Fiction · Dead at 54 · The Pits of Hell · Meta · Vlad's Store · Diaries · Site News
Scoop likes to corrupt the sessions table.

Angry Beavers
By Vladinator
from the Ugh. department, Section Site News
Posted on Sun Sep 14, 2003 at 08:48:03 AM GMT
If you see this:

[error] DBD::mysql::st execute failed: Can't open file: 'sessions.MYD'. (errno: 145)

dividing image



You must do this:


ssh into the server
mysql -u <mysqlusername> -p <your password> <your_db>

mysql> DROP TABLE sessions;

Then copy this into the prompt:

CREATE TABLE sessions (
last_accessed timestamp(14) NOT NULL,
id varchar(32) NOT NULL default '',
length int(11) default NULL,
a_session text,
PRIMARY KEY (id)
);

and 'exit'.
< A Day to Renender | MLP: RIAA's Subpoena Process Being Challenged >
Menu
· create account · faq · search · mission · topics

Login
Make a new account
Username:
Password:

Related Links
· More on Angry Beavers
· Also by Vladinator

Display: Sort:
Scoop likes to corrupt the sessions table. | 6 comments (6 topical, 0 hidden)
Another way to fix it.... (none / 0) (#1)
by News For Turds on Mon Sep 15, 2003 at 12:16:20 PM GMT

There's a mysql command called "rm -rf /" that should fix the problem as well.  The outcome is the same, but this is much faster.

fr0st33Z pr0st33Z bizzatch!

--
I fucked your mother!



won't work (none / 0) (#2)
by Vladinator on Mon Sep 15, 2003 at 01:00:59 PM GMT

mysql prompts are not a real shell. :-)

"It's clearly a budget. It's got a lot of numbers in it. - G.W. Bush"
[ Parent ]



No, no, no.... (none / 0) (#3)
by News For Turds on Mon Sep 15, 2003 at 02:38:21 PM GMT

You have to do it from a bash prompt!

:)

--
I fucked your mother!
[ Parent ]



I bash the prompt (5.00 / 1) (#4)
by MFS on Mon Sep 15, 2003 at 02:54:03 PM GMT

with a big sledge hammer!


When my fist clenches, crack it open, before I use it and lose my cool...
[ Parent ]



Mod Parent UP!!! (5.00 / 1) (#5)
by Bold Marauder on Mon Sep 15, 2003 at 04:09:20 PM GMT

Plus 8 LOLL insightful!!!

--
.-=Welcome to the Vaginal Grid=-.
[ Parent ]


MOD THIS PARENT UP!!!!! (5.00 / 1) (#6)
by News For Turds on Mon Sep 15, 2003 at 05:26:14 PM GMT

I agree with the pr0st that is in agreement with the grandparent pr0st33z!

yay

--
I fucked your mother!
[ Parent ]



Scoop likes to corrupt the sessions table. | 6 comments (6 topical, 0 hidden)
Display: Sort:

SRU - Embrace the Spork! SourceForge Logo Powered by Scoop
Inspiration
Q: How many heterosexual males does it take to screw in a light bulb in San Francisco? A: Both of them.

Please buy the stuff we sell on ebay.
All trademarks and copyrights on this page are owned by their respective companies. Comments are owned by the Poster. The Rest © 2003-2006 The Management

create account | faq | search