Database Errors

Tempest Stormwin

Kweisatz Haderach
OP
Former Staff
Joined
Oct 29, 2002
Messages
5,834
Trophies
0
Age
39
Location
On temporary hiatus.
Website
Visit site
XP
191
Country
Canada
Having my post edited by you Tempest is a bit irksome. I hope I don't engage in any malicious activities that would warrant such an activity in the future.Â
smile.gif


Back on topic...are we aware of the physical makeup that pushes the site? i.e. 1, 2, 3 servers? Load balancers?
Okay, I'm sorry about that, KotaInka. It's late here, I've been awake about... 65 hours now (insomnia combined with a party where Soul Calibur and Smash Bros were played = no sleep for Tempest), and I'm holding together worse than the forum is, so to speak. At the time it seemed like a good idea to show that it was just a mistype, but now I think it may have been rude. Sorry again, and considering how this is the first time that's ever happened, I'm certain it won't happen again.

All I know about the physical makeup is that it's hosted on the M4D server, which is run by Omero I believe, in Milan, Italy. I don't know more than that.

I'm going to nod off for a while, then. Hopefully both I and the forum will be in better condition when I wake up.
 

KotaInka2

Fanboy Educator
Member
Joined
Jun 12, 2003
Messages
1,718
Trophies
0
Age
46
Website
Visit site
XP
206
Country
United States
Oh no, it's not a problem. Perhaps irksome wasn't the best word choice. It was however psychologically unexpected. In any event, you should probably lay off these Soul Calibur parties if you're supposed to be handling school work anyways. I didn't get up until 8:30 PM, just in time to catch the end of the Roy Jones Jr retelecast and Carnivale at 9. So, I'll be up all night. These are my crazy hours. I wouldn't worry too much about the forum. Sooner or later, it will be worked out.
 

Dragonlord

Linux-Dragon of quick wit and sharp tongue
Member
Joined
Sep 17, 2003
Messages
3,519
Trophies
2
Age
43
Location
Switzerland
Website
www.indiedb.com
XP
2,572
Country
Swaziland
Well... back for bad...
What excatly happened to the DB? A forum doesn`t tip over like this if not somebody tried fixing or changing something on the system. Perhaps you should click the down the page for a major workover.
Might be better than trying to fix things while members are posting and modifying the DB.
 

LuxFerous

Well-Known Member
Member
Joined
Nov 2, 2002
Messages
57
Trophies
0
Website
Visit site
XP
226
Country
United States
Well... back for bad...
What excatly happened to the DB? A forum doesn`t tip over like this if not somebody tried fixing or changing something on the system. Perhaps you should click the down the page for a major workover.
Might be better than trying to fix things while members are posting and modifying the DB.
Actually a database could mess up on its own.

Something like this could have been caused by a number of things. Upgrade to server software, database bug, forum bug. There are alot more other things that could cause a database error.

As for fixing a database, it would most likely be fairly easy. Possibly just uploading the file with the error in it.
 

NeoBahamut

Dragon King of GBATemp
Member
Joined
Dec 15, 2002
Messages
1,109
Trophies
0
Age
36
Website
Visit site
XP
225
Country
Taiwan
seems like the site is back...(YAY!!!)
But I'm still getting the SQL error.... Oh well... *waits*

-Bahamut Unsummoned-

[EDIT] What IS this SQL anyways??? anyone can explain that thing?
 

Tempest Stormwin

Kweisatz Haderach
OP
Former Staff
Joined
Oct 29, 2002
Messages
5,834
Trophies
0
Age
39
Location
On temporary hiatus.
Website
Visit site
XP
191
Country
Canada
OKAY, WE GOT IT.

Error 28, the error we're all getting, means "The disk is full."

Our server got overloaded. We're out of space.

My guess is they're working on getting a new hard drive or something.

ALSO: The portal loads slow. Link directly to a topic (say, this one, since it has the workaround as part of it) instead of to GBATemp.net for the next little while.

-Tempest out.-
 

Kyoji

ウッーウッーウマ
Member
Joined
Apr 15, 2003
Messages
5,475
Trophies
2
Age
36
Location
:'(
Website
Visit site
XP
307
Country
United States
Full HD eh? I see that as an accomplishment! FREE GROG FOR EVERYONE! Pull out the kegs Tempest, its goign to be a loooong night
biggrin.gif
 

Tempest Stormwin

Kweisatz Haderach
OP
Former Staff
Joined
Oct 29, 2002
Messages
5,834
Trophies
0
Age
39
Location
On temporary hiatus.
Website
Visit site
XP
191
Country
Canada
The portal loads slow for some people. Try bookmarking a topic and you'll see that the forum's still at the same old speed.

Actually, djnaff on the channel pointed this out to me, but I can't remember his forum name (or even if he has one...). If you see him, pass kudos to him, mmkay?

-Tempest out.-
 

Saria

The Sage Of The Forest Temple
Member
Joined
Oct 25, 2002
Messages
813
Trophies
0
Location
London UK
Website
Visit site
XP
75
Country
[OffTopic]
KotaInka2 - I got your PM - lemme know if you still want it...
So i can get on IRC - or email it to you even

[OnTopic]
Do PM's work?
I wasnt sure when KotaInka2 sent it... so I didn't try...

If the HDD is full, how come Posts are saved... (?)

unsure.gif
 

Tempest Stormwin

Kweisatz Haderach
OP
Former Staff
Joined
Oct 29, 2002
Messages
5,834
Trophies
0
Age
39
Location
On temporary hiatus.
Website
Visit site
XP
191
Country
Canada
PM's do indeed work. It seems the place is going fine.

As for the database, I'm no SQL expert (though I'm talking to Mole about it and possible solutions), so I can't answer. The best guess I can get is that we're just using ascii, and that compresses well, so they're being logged. In the meantime, no one upload stuff on the galleries, okay?
biggrin.gif


-Tempest out.-
 

KotaInka2

Fanboy Educator
Member
Joined
Jun 12, 2003
Messages
1,718
Trophies
0
Age
46
Website
Visit site
XP
206
Country
United States
BTW, SQL, often prounounced Sequel is a language for programming databases. Unfortunately, that was the first course I had to take in Graduate School. Fortunately or unfortunately, the professor allowed us to use MS Access instead of actually doing the coding ourselves. From there, after having created the databases, we could have Access generate the SQL code for us as he still wanted that. So, in short, I should know more about it than I do.
tongue.gif
 

CCDART

Member
Newcomer
Joined
Aug 4, 2003
Messages
9
Trophies
0
XP
27
Country
United States
I believe the reason people can still post is because while posting with the 1030 error code it's using GZIP compression to keep disk space low.. You should just try contacting the host for more MySQL Disc space.
 

Site & Scene News

Popular threads in this forum

General chit-chat
Help Users
  • No one is chatting at the moment.
  • BigOnYa @ BigOnYa:
    Biomutant looks cool tho, may have to try that
  • Quincy @ Quincy:
    Usually when such a big title leaks the Temp will be the first to report about it (going off of historical reports here, Pokemon SV being the latest one I can recall seeing pop up here)
  • K3Nv2 @ K3Nv2:
    I still like how a freaking mp3 file hacks webos all that security defeated by text yet again
  • BigOnYa @ BigOnYa:
    They have simulators for everything nowdays, cray cray. How about a sim that shows you playing the Switch.
  • K3Nv2 @ K3Nv2:
    That's called yuzu
    +1
  • BigOnYa @ BigOnYa:
    I want a 120hz 4k tv but crazy how more expensive the 120hz over the 60hz are. Or even more crazy is the price of 8k's.
  • K3Nv2 @ K3Nv2:
    No real point since movies are 30fps
  • BigOnYa @ BigOnYa:
    Not a big movie buff, more of a gamer tbh. And Series X is 120hz 8k ready, but yea only 120hz 4k games out right now, but thinking of in the future.
  • K3Nv2 @ K3Nv2:
    Mostly why you never see TV manufacturers going post 60hz
  • BigOnYa @ BigOnYa:
    I only watch tv when i goto bed, it puts me to sleep, and I have a nas drive filled w my fav shows so i can watch them in order, commercial free. I usually watch Married w Children, or South Park
  • K3Nv2 @ K3Nv2:
    Stremio ruined my need for nas
  • BigOnYa @ BigOnYa:
    I stream from Nas to firestick, one on every tv, and use Kodi. I'm happy w it, plays everything. (I pirate/torrent shows/movies on pc, and put on nas)
  • K3Nv2 @ K3Nv2:
    Kodi repost are still pretty popular
  • BigOnYa @ BigOnYa:
    What the hell is Kodi reposts? what do you mean, or "Wut?" -xdqwerty
  • K3Nv2 @ K3Nv2:
    Google them basically web crawlers to movie sites
  • BigOnYa @ BigOnYa:
    oh you mean the 3rd party apps on Kodi, yea i know what you mean, yea there are still a few cool ones, in fact watched the new planet of the apes movie other night w wifey thru one, was good pic surprisingly, not a cam
  • BigOnYa @ BigOnYa:
    Damn, only $2.06 and free shipping. Gotta cost more for them to ship than $2.06
  • BigOnYa @ BigOnYa:
    I got my Dad a firestick for Xmas and showed him those 3rd party sites on Kodi, he loves it, all he watches anymore. He said he has got 3 letters from AT&T already about pirating, but he says f them, let them shut my internet off (He wants out of his AT&T contract anyways)
  • K3Nv2 @ K3Nv2:
    That's where stremio comes to play never got a letter about it
  • BigOnYa @ BigOnYa:
    I just use a VPN, even give him my login and password so can use it also, and he refuses, he's funny.
  • BigOnYa @ BigOnYa:
    I had to find and get him an old style flip phone even without text, cause thats what he wanted. No text, no internet, only phone calls. Old, old school.
    K3Nv2 @ K3Nv2: @BigOnYa...