Great work Andrew

vw54 · 1 May 2003, 10:22 am

Mate i had to actually work ( for a change ) cause the forum was DOWN

vanderaj · 1 May 2003, 10:30 am

all fixed.

If the other admins come in and it says something about xmb_threads.myi, you need to log on to the box using ssh, fire up the mysql client, and type:

use aussievw_xmb1;
repair table xmb_threads;

This gets the place back on its feet. We lost two threads, and I think I've found one of them.

Andrew

vanderaj · 1 May 2003, 12:06 pm

There's actually a deeper problem at work - our SQL server is corrupting data. I'm working with our hoster to find a solution.

If you're into tech stuff:
http://www.vbulletin.com/forum/showthread.php?s=9c1b5855742665e3180b0f483b3230a3&threadid=69803

Andrew

5PL1TDCS10N · 1 May 2003, 12:12 pm

Hey Vanderaj,

The site looks A1 mate and is a credit to your hard work.
Thank you on behalf of all those that are addicted to this forum!

W

:thumb:thumb:thumb:thumb

vw54 · 1 May 2003, 12:34 pm

Yeah well i read all that ... n those dots n dashes still mean nuthin to me....

keep it up as i hate havin to work.

Yogibear · 1 May 2003, 1:22 pm

Andrew,
Great site mate, especially for a newbie? Are you having stability problems with mySQL?

Cheers

Adam:thumb

pyr0 · 1 May 2003, 3:16 pm

as i stated before: I LOVE THIS SITE.

just thought i say it again.

vanderaj · 1 May 2003, 6:09 pm

Yogibear wrote:Andrew,
Great site mate, especially for a newbie? Are you having stability problems with mySQL?

Newbie? You or me? 🙂

Yep, there seems to be a data corruption bug with mysql that affects heavy concurrent mysql uses, like bulletin boards with lots of concurrent users.

So I've scheduled backups once per day, and hopefully, this will allow us to recover if the worst happens with only a day's loss of posts (max).

I'm monitoring the situation, and I'll let everyone know how things go.

Andrew

56astro · 1 May 2003, 6:13 pm

Well done Andrew

:thumb

Cheers big ears

1 May 2003, 7:13 pm

Congrats on the site
It looks great Now all I have to do is get some sunnies.:thumb:thumb:thumb:

baybuscamperkid · 1 May 2003, 9:40 pm

yeah, cant let anything happen to our sacred forum or id have spare time at night!!!

Yogibear · 1 May 2003, 10:01 pm

Newbie? You or me

Definately me Andrew...😉

Just asked you about mysql cause I run a forum as well and use XMB 😎

Cheers

Adam

vanderaj · 2 May 2003, 12:42 am

Hhehehe - make sure you are using XMB 1.8 SP1. There's quite a bad XMB security hole until that version.

Andrew

The_Bronze. · 2 May 2003, 2:50 pm

Yeah - whatever.

Basaltic synclines, transgressive paleozoic dunes and domino theory are some of the things I crap on about. Your jargon loses me.

If its as confusing as a teenagers mind then you also deserve a medal.

Good Job! :thumb

Yogibear · 2 May 2003, 4:10 pm

Hhehehe - make sure you are using XMB 1.8 SP1. There's quite a bad XMB security hole until that version.

Yeah one of my mates learnt about that one the hard way!!! 😀

helbus · 3 May 2003, 1:44 am

I post on quite a few forums for different things, and I must say the XMB is quite a handy setup.:o