Coffee2k3
Mon 10th Mar '03, 7:26am
Could anyone please would be so nice and enlighten me (i am a newbie) what could have happened?
I have a VDS (shared virtual dedicated server) and got vbulletin 2.3 forums installed on it.
I have been having some problems with my host for some time now, my VDS behaves strange. I got 300 MB webspace and regularly 2-3 days delete the mysql log file because it takes a lot of space. Recently my VDS's disk quote indicator been giving false information e.g. didn't free up space when i removed log file. If I reach 300 MB then my site stops working, I can't even restart VDS etc.
Saturday overnight my forums went down for some reason. The log file was removed on friday so I had plenty of space. I received lots of this report:
Database error in vBulletin 2.3.0:
Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,at tachmentid,pagetext,allowsmilie,showsignature,ipad dress,iconid,visible) VALUES (NULL,'958','','*Crash*','27','1047226924','0',':)
I wish u luck','1','1','80.194.73.51','0','1')
mysql error: Duplicate entry '17240' for key 1
mysql error number: 1062
Date: Sunday 09th of March 2003 05:22:04 PM
Script: http://www.ut2k3league.net/forums/forums/newreply.php
Referer:
Then, I tried repairing the tables but couldn't as my site stopped working because I was exceeding my 300 MB limit. Of course it couldn't be as I still had ftp excess to check my site and it was well far from 300 MB.
I contacted my host by writing them e-mail @ 20:00 GMT.
This morning I found my vbulletin tables half empty. In fact they all went apart from 4 survivor.
access
adminlog
adminutil
announcement
@ 23:19 i received the following e-mail:
Database error in vBulletin :
cannot use database ut2k3league
mysql error: Unknown database 'ut2k3league'
mysql error number: 1049
Date: Monday 10th of March 2003 12:18:40 AM
Script: /forums/index.php
Referer:
and since then i got 100's of :
Database error in vBulletin :
Invalid SQL: SELECT template FROM template WHERE title='options'
mysql error: Table 'ut2k3league.template' doesn't exist
mysql error number: 1146
Date: Monday 10th of March 2003 12:19:28 AM
Script: /forums/index.php
Referer:
I know that my forum needs re-installing etc but I would love to know what happened.
Has anyone got an idea? At this time I suspect my host did something or it was a fault of the server.
Thank you for your time, I realise it is quite a long thread :(
I have a VDS (shared virtual dedicated server) and got vbulletin 2.3 forums installed on it.
I have been having some problems with my host for some time now, my VDS behaves strange. I got 300 MB webspace and regularly 2-3 days delete the mysql log file because it takes a lot of space. Recently my VDS's disk quote indicator been giving false information e.g. didn't free up space when i removed log file. If I reach 300 MB then my site stops working, I can't even restart VDS etc.
Saturday overnight my forums went down for some reason. The log file was removed on friday so I had plenty of space. I received lots of this report:
Database error in vBulletin 2.3.0:
Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,at tachmentid,pagetext,allowsmilie,showsignature,ipad dress,iconid,visible) VALUES (NULL,'958','','*Crash*','27','1047226924','0',':)
I wish u luck','1','1','80.194.73.51','0','1')
mysql error: Duplicate entry '17240' for key 1
mysql error number: 1062
Date: Sunday 09th of March 2003 05:22:04 PM
Script: http://www.ut2k3league.net/forums/forums/newreply.php
Referer:
Then, I tried repairing the tables but couldn't as my site stopped working because I was exceeding my 300 MB limit. Of course it couldn't be as I still had ftp excess to check my site and it was well far from 300 MB.
I contacted my host by writing them e-mail @ 20:00 GMT.
This morning I found my vbulletin tables half empty. In fact they all went apart from 4 survivor.
access
adminlog
adminutil
announcement
@ 23:19 i received the following e-mail:
Database error in vBulletin :
cannot use database ut2k3league
mysql error: Unknown database 'ut2k3league'
mysql error number: 1049
Date: Monday 10th of March 2003 12:18:40 AM
Script: /forums/index.php
Referer:
and since then i got 100's of :
Database error in vBulletin :
Invalid SQL: SELECT template FROM template WHERE title='options'
mysql error: Table 'ut2k3league.template' doesn't exist
mysql error number: 1146
Date: Monday 10th of March 2003 12:19:28 AM
Script: /forums/index.php
Referer:
I know that my forum needs re-installing etc but I would love to know what happened.
Has anyone got an idea? At this time I suspect my host did something or it was a fault of the server.
Thank you for your time, I realise it is quite a long thread :(