Database

[Joshua John]

Hey Guys

Weird thing about an hour ago on our front page errors started to appear such as

Warning: Invalid argument supplied for foreach() in /home/virginat/public_html/lib/skins/virgin/frontpage_recentpilots.tpl on line 3

and this would appear for everything like Latest News, Flights in progress etc so I knew it was something to do with the database and when I checked I got this error for every table. This is just from the acarsdata

#1033 - Incorrect information in file: './virginat_vms/phpvms_acarsdata.frm'

SELECT *

FROM `phpvms_acarsdata`

LIMIT 0 , 30

[ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]

Error

SQL query: Edit

SHOW FULL FIELDS FROM `phpvms_acarsdata` ;

MySQL said: Documentation

#1033 - Incorrect information in file: './virginat_vms/phpvms_acarsdata.frm'

Open new phpMyAdmin window

Now I really have no idea what to do or how to correct it as this is the first time I've had this. This there a way to correct this as I don't have a recent backup

Thanks

[Joshua John]

Stange...a few minutes ago everything came back and everythings back in the database. Any ideas what caused this?

[Guest lorathon]

More then likely your host was doing something to the server.

[mark1million]

Yes i had this on shared hosts and they screwed up my database, make sure you have backups.

[Joshua John]

Thanks guys!

I do usually make daily backups but kept forgetting and haven't done one for a week or so. Better make sure I do backup daily after this!