PDA

View Full Version : database error


eXhale
5th December 2003, 11:29 AM
sorry if the message board was unaccessible for some time (don't know how long), the table which stores the name of users on the chatroom somehow got corrupted, i had to delete it and recreate it.

LEVLHED
5th December 2003, 01:07 PM
it was a terrifying couple of hours but we held together..thank goodness the precious vjchat is on a different server ;)

eXhale
9th December 2003, 07:45 AM
another database problem... the member table got corrupted and was displaying errors all over vjcentral. luckily i could repair it with a single command (sometimes, but rarely, you love technology :alien: )

loboy
10th December 2003, 11:45 AM
i receieved this error today:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in/home/virtual/site1/fst/var/www/html/_includes/bar/latestall.phpon line 16

maybe part of the same problem??

just wanted to let you know.

I am using a Mac, Safari 1.1.1, OS 10.3.1

This error occured in the right side bar. Otherwise no other errors occured through the forums.

krezrock
10th December 2003, 11:55 AM
all the reviews are showing up as sql errors.

eXhale
10th December 2003, 11:40 PM
grrr now it's the software table which got corrupted, repaired it... i'm getting a bit worried, why so many corruptions now when there was hardly any before? i've not enough knowledge about MySQL/linux to be able to answer that question :( hopefully it's not an hard drive problem...

neoteo
10th December 2003, 11:54 PM
yep .. i had all those erros .. and my profile is missing

are we under atack by hackers ? ....

if you need help reading log files ... feel free to send it to neoteo@timedivision.tv

neoteo
10th December 2003, 11:57 PM
just one question ...

you make backups ... dont you ?

i think this is like a VJ bible .... backups are really a must have

eXhale
11th December 2003, 12:06 AM
yes i make backups, did one yesterday and the week before for both vjforums and vjcentral. when vjforums started, we lost 3000 posts due to a lack of backups so it's a lesson well learnt...

i highly doubt it's an hacker.

neoteo
11th December 2003, 12:27 AM
ok ...

i have a friend that knows preaty much about MySQL/linux ....

bpedro@wetserver.com

neoteo
11th December 2003, 12:56 AM
my carma was 33 btw .....

julez
11th December 2003, 08:40 PM
hmm...vjc is still showing a million errors. I think neone who is stupid enough to hack a vj forum should be shot.

eXhale
12th December 2003, 02:39 AM
still the same problem, tables index being corrupted, i've really no time to look at the problem at the moment, hopefully next week. in the meanwhile i've explained other vjc developers how to repair the tables so that vjc can keep on functionning even when i'm away.

neoteo
14th December 2003, 07:13 PM
my VJC still 0 ... and was 33 .... :(