Unoffical empeg BBS

Quick Links: Empeg FAQ | RioCar.Org | Hijack | BigDisk Builder | jEmplode | emphatic
Repairs: Repairs

Topic Options
#105907 - 18/07/2002 17:55 SQL ERROR
wfaulk
carpal tunnel

Registered: 25/12/2000
Posts: 16706
Loc: Raleigh, NC US
People in the know have noticed that SQL ERROR that's towards the top of every page, right?
_________________________
Bitt Faulk

Top
#105908 - 18/07/2002 18:01 Re: SQL ERROR [Re: wfaulk]
tfabris
carpal tunnel

Registered: 20/12/1999
Posts: 31565
Loc: Seattle, WA
Oh, THAT?

I thought it was just a new style. Kind of retro-hacker-tech.
_________________________
Tony Fabris

Top
#105909 - 18/07/2002 18:14 Re: SQL ERROR [Re: tfabris]
wfaulk
carpal tunnel

Registered: 25/12/2000
Posts: 16706
Loc: Raleigh, NC US
Maybe we could get all the errors to show up in pixellated green on black, like this.
_________________________
Bitt Faulk

Top
#105910 - 18/07/2002 18:24 Re: SQL ERROR [Re: wfaulk]
tfabris
carpal tunnel

Registered: 20/12/1999
Posts: 31565
Loc: Seattle, WA
I've always gotten a kick out of JWZ's site. His camo-netting-cubicle page is still in my bookmarks, and my friend Tod actually DID the camo-netting thing in his home office once.
_________________________
Tony Fabris

Top
#105911 - 18/07/2002 23:17 Re: SQL ERROR [Re: wfaulk]
drakino
carpal tunnel

Registered: 08/06/1999
Posts: 7868
Nope, didn't notice it, and I certenly didn't just fix it either.

The underlying problem was this:
145 = Table was marked as crashed and should be repaired

Not sure what in the code is causing the online table to break it's self every week or so at most. Watching it overtime, it's overhead will grow to a huge ammount, and I think eventually just cause problems due to it. Anyone know any easy ways of dealing with a relativily small table in mySQL that gets changed quite a bit, and also deleted from? To me, this shouldn't be normal, and I don't like the idea that I need a repair statement in my crontab for the BBS. But I've never had to do this with RioCar.org, and it has a similar online table...

Top
#105912 - 19/07/2002 10:03 Re: SQL ERROR [Re: drakino]
tfabris
carpal tunnel

Registered: 20/12/1999
Posts: 31565
Loc: Seattle, WA
You know what, now that you mention it, I could swear that, a long time ago, PaulH had a similar problem on the original server where this BBS was hosted. Have you asked him if he knows about it?
_________________________
Tony Fabris

Top
#105913 - 19/07/2002 11:08 Re: SQL ERROR [Re: wfaulk]
loren
carpal tunnel

Registered: 23/08/2000
Posts: 3826
Loc: SLC, UT, USA
Thank you for reminding why the web was once great.
_________________________
|| loren ||

Top
#105914 - 19/07/2002 12:30 Re: SQL ERROR [Re: loren]
wfaulk
carpal tunnel

Registered: 25/12/2000
Posts: 16706
Loc: Raleigh, NC US
Because of SQL errors??
_________________________
Bitt Faulk

Top