User CP -> Database error

[Programmer]

Originally Posted by pooper200000

I'm getting this error when I try to view the index page. Is anyone else getting this problem?

Yep. Same error. vBulletin never did this to me, not sure why it's corrupting so often...

PS: Gotta love the hidden error messages.

NPC Code:

---

Database error in vBulletin 3.7.2:



Invalid SQL:



		SELECT eventid, userid, event.title, recurring, recuroption, dateline_from, dateline_to, event.calendarid, IF (dateline_to = 0, 1, 0) AS singleday, customfields,

			dateline_from AS dateline_from_user, dateline_to AS dateline_to_user, utc, dst

		FROM event AS event

		INNER JOIN calendar AS calendar USING (calendarid)

		WHERE ((dateline_to >= 1259989058 AND dateline_from < 1260334658) OR (dateline_to = 0 AND dateline_from >= 1259989058 AND dateline_from <= 1260334658 ))

			AND visible = 1

			AND calendar.options & 512

		ORDER BY dateline_from;



MySQL Error   : Can't create/write to file '/var/tmp/#sql_8e7_0.MYI' (Errcode: 30)

Error Number  : 1

Request Date  : Monday, December 7th 2009 @ 05:57:38 AM

Error Date    : Monday, December 7th 2009 @ 05:57:38 AM

Script        : http://forums.graalonline.com/forums/index.php

Referrer      : http://forums.graalonline.com/forums/showthread.php?p=1543047

IP Address    : Unknown

Username      : Programmer

Classname     : vB_Database

MySQL Version : 

---

[Liberated]

yeah, index broken for me aswell,
had quite alot of trouble getting into this thread,

where's my $10?! and im not taking the 2nd bet, just so you know.

[Admins]

Fixed it.

[WhiteDragon]

Originally Posted by Stefan

Fixed it.

If you don't mind disclosing, what was the problem and why did it exist?

[Demisis_P2P]

Good job

[fowlplay4]

My favorite part was when it felt like the forum was collapsing.

[Crono]

Originally Posted by fowlplay4

My favorite part was when it felt like the forum was collapsing.

u r the culprit

[Loriel]

Betting on a full hard drive.

[cbk1994]

Probably related to this.

[WhiteDragon]

Originally Posted by cbk1994

Probably related to this.

And how exactly would that happen without the tmp directory either being deleted, having permissions changed, or filling up?

I agree with Loriel's speculation.

[cbk1994]

Originally Posted by WhiteDragon

And how exactly would that happen without the tmp directory either being deleted, having permissions changed, or filling up?

I have no idea, but the error message is identical.

I agree with Loriel's speculation.

I doubt it, though from what I heard Stefan did have to backup the forums, so it's possible he moved them to a new web server or something. I doubt it, though, since it's hosted on the same site as the main website.