Aussieveedubbers · General Chit Chat

Great work Andrew

https://forums.aussieveedubbers.com/threads/5839/great-work-andrew

vw54 ·

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

vanderaj ·

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 ·

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 ·

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 ·

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 ·

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

Cheers

Adam:thumb

pyr0 ·

as i stated before: I LOVE THIS SITE.

just thought i say it again.

vanderaj ·

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 ·

Well done Andrew

:thumb

Cheers big ears

kafer70 ·

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

baybuscamperkid ·

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

Yogibear ·

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 ·

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

Andrew

The_Bronze. ·

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 ·

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 ·

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