Board Logo

Great work Andrew
vw54 - May 1st, 2003 at 10:22 AM

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


vanderaj - May 1st, 2003 at 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 - May 1st, 2003 at 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=9c1b5855742665e3180b0f483b323...

Andrew


5PL1TDCS10N - May 1st, 2003 at 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 - May 1st, 2003 at 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 - May 1st, 2003 at 01:22 PM

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

Cheers

Adam:thumb


pyr0 - May 1st, 2003 at 03:16 PM

as i stated before: I LOVE THIS SITE.

just thought i say it again.


vanderaj - May 1st, 2003 at 06:09 PM

Quote:
Originally posted by Yogibear
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 - May 1st, 2003 at 06:13 PM

Well done Andrew

:thumb

Cheers big ears


kafer70 - May 1st, 2003 at 07:13 PM

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


baybuscamperkid - May 1st, 2003 at 09:40 PM

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


Yogibear - May 1st, 2003 at 10:01 PM

Quote:

Newbie? You or me



Definately me Andrew...;)

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

Cheers

Adam


vanderaj - May 2nd, 2003 at 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. - May 2nd, 2003 at 02: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 - May 2nd, 2003 at 04:10 PM

Quote:

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!!! :D


helbus - May 3rd, 2003 at 01:44 AM

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