vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Sites Down VB Database (https://vborg.vbsupport.ru/showthread.php?t=155479)

DieselMinded 08-17-2007 09:53 AM

Sites Down VB Database
 
My sites down with Can't open file: 'vbguest.MYI' (errno: 145)

How do i acess the Admin CP if my sites down ?

and where do i repair this? Help Please

DM

I cant get in to me admin CP whats the Path directly to it?

Hopw do i repair the vb guest table via phpmyadmin

Thanks

Eikinskjaldi 08-17-2007 10:25 AM

Quote:

Originally Posted by DiesellMinded (Post 1319460)
My sites down with Can't open file: 'vbguest.MYI' (errno: 145)

How do i acess the Admin CP if my sites down ?

and where do i repair this? Help Please

DM

I cant get in to me admin CP whats the Path directly to it?

Hopw do i repair the vb guest table via phpmyadmin

Thanks

yoursite/admincp/index.php

repair table vbguest

DieselMinded 08-17-2007 10:34 AM

It wont let me in I get an error screen The same one you get when trying to access any page , How can i do a repair W/O Access to AdminCP?

Eikinskjaldi 08-17-2007 10:41 AM

Quote:

Originally Posted by DiesellMinded (Post 1319484)
It wont let me in I get an error screen The same one you get when trying to access any page , How can i do a repair W/O Access to AdminCP?

Do you have whm or cpanel or ssh access? you can run the repair through any of them

DieselMinded 08-17-2007 11:01 AM

Host dont allow connection threw ssh ect...

ARGH !!

deezelpope 08-17-2007 11:08 AM

Hey DM, the same thing just happened to me...if Eikinskjaldi can't help you resolve this issue, PM ZomgStuff here.

https://vborg.vbsupport.ru/showthread.php?t=154291

Eikinskjaldi 08-17-2007 11:18 AM

If you dont have phpmyadmin, cpanel, whm, ssh or admincp, then you are going to have to ask your host to repair the file.

DieselMinded 08-17-2007 11:34 AM

I have phpmyadmin ! I try to run the quirey

Repair Table vbguest.MYI and it says i dont have permission

I have contacted my host and begged them to run the repair on the guest table

This is an outbreak i think its connected with the track guests Mod

How can i repair Via Php my admin ?

DM

G0F0RBR0KE 08-17-2007 11:39 AM

I suggest you go through ur Admin CP before going to the next level.

nico_swd 08-17-2007 11:40 AM

Select the database from the dropdown ->Select the table on the left -> Operations -> And "Repair table" on the bottom.

DieselMinded 08-17-2007 11:42 AM

I cant get into my Admin cp on VB to Run a Repair Tables

I cant connect Via SSH telnet or Putty and when i execute the Repair Command in phpmyadmin i get Acess Denined , I have contacted my host and am waiting for them to repair the table , I tried to export it and re import it and my browser timed out on the import so i dont know what happened .

What does this table hold? anything important ?

When looking at the database structure in phpmyadmin it only goes to the table above vbguest and stops and says .....

Error

SQL query: DocumentationEdit

SELECT COUNT( * ) AS num
FROM `dieselbombersforum`.`vbguest`

MySQL said: Documentation
#1016 - Can't open file: 'vbguest.MYI' (errno: 145)

in operations tab i only see the following options

Structure only
Structure and data
Data only
CREATE DATABASE before copying
Add DROP TABLE
Add AUTO_INCREMENT value
Add constraints
Switch to copied database

This is whats on the bottom of the operations tab

Error
The additional features for working with linked tables have been deactivated. To find out why click here.

G0F0RBR0KE 08-17-2007 11:46 AM

I went to your Admin Page and it asks for a username/password.

DieselMinded 08-17-2007 11:48 AM

On the side collum it says this on top

Warning: Cannot modify header information - headers already sent by (output started at /usr/services/mysql/phpmyadmin/left.php:92) in /usr/services/mysql/phpmyadmin/libraries/ob.lib.php on line 61

I went to your Admin Page and it asks for a username/password.

What Link are you using ?

G0F0RBR0KE 08-17-2007 11:52 AM

I sent you a PM'ed

DieselMinded 08-17-2007 11:53 AM

Im getting the VB error page with the link you sent me


???

Well it opened in IE but once i logged in it went to the vb error page

Database error
The Diesel Bombers database has encountered a problem.

--------------------------------------------------------------------------------

Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www.dieselbombers.com home page, then try to open another page.
Click the Back button to try another link.

The www.dieselbombers.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

G0F0RBR0KE 08-17-2007 11:58 AM

Private Message me your log-in to myphpadmin and i'll attempt to repair your database. I sugguest you have a backup.

DieselMinded 08-17-2007 12:06 PM

So Do i trust a guy with Evil in his name ?

nico_swd 08-17-2007 12:08 PM

Create a backup of the database and save it on your computer. So IF he really messes with anything, you can restore it anytime.

DieselMinded 08-17-2007 12:09 PM

I have a back up from the 15th

G0F0RBR0KE 08-17-2007 12:09 PM

EvilAkuma is my username from an online game. Decided to use it on site/forum and whatever I joined.

I wish I can go by Alexander, but than again, I'll lost my 600+ post and vBulletin.org don't change username.

It's up to you to trust. If you don't trust me because of "Evil." Than it's cool.

DieselMinded 08-17-2007 12:11 PM

PM Sent Thanks for looking at it

G0F0RBR0KE 08-17-2007 12:16 PM

Thanks,

I'll need the modification that was use.

deezelpope 08-17-2007 12:48 PM

Quote:

Originally Posted by DiesellMinded (Post 1319580)
So Do i trust a guy with Evil in his name ?

Yes, you can trust him...he's a member of my board and a good friend!:)

In case you're wondering why I didn't ask EvilAkuma to help me, it's because I didn't know he was proficient in this, plus ZomgStuff came forward and offered help.

G0F0RBR0KE 08-17-2007 12:54 PM

Thank deezelope

Just went through his phpmyadmin and it won't load the whole page. The only option he has left is on the hands of his support.

If they can't fixs it Disellminded

Please link me to download the whole database and I'll remove the whole vBguest database so when you import it (a fresh database) you won't have the issue again.

Eikinskjaldi 08-17-2007 01:00 PM

Quote:

Originally Posted by EvilAkuma (Post 1319614)
If they can't fixs it Disellminded

Please link me to download the whole database and I'll remove the whole vBguest database so when you import it (a fresh database) you won't have the issue again.

A bad idea mate. Firstly if he gets a mysqldump then by definition the problem is gone. The error is because of a crashed index file, which wont replicate in a data restore from mysqldump. Also, all the php from whatever hack uses the table will die.

DieselMinded 08-17-2007 01:02 PM

Ok Thanks for the help and if they cant fix it them Im moving to a VPS ASAP Im done messing with things like this

Need a VPS With best speeds Supprt and price PM ME

I will be dropping the guests Table and Uninstalling the Guest Tracker To ensure this dont happen again

DM

Eikinskjaldi 08-17-2007 01:04 PM

Quote:

Originally Posted by DiesellMinded (Post 1319620)
Ok Thanks for the help and if they cant fix it them Im moving to a VPS ASAP Im done messing with things like this

Need a VPS With best speeds Supprt and price PM ME

I will be dropping the guests Table and Uninstalling the Guest Tracker To ensure this dont happen again

DM

You got a crashed index, it's not the table's fault. Sounds like something went wrong in the middle of a repair. In future, don't repair or optimise your tables unless they are broken.

DieselMinded 08-17-2007 01:09 PM

I Didnt repair or optimize the tables I haven't done that in weeks

Eikinskjaldi 08-17-2007 01:10 PM

Apologies, I misread your OP. In that case sure, kill it.

G0F0RBR0KE 08-17-2007 01:10 PM

Yes, only repair if they are broken.

Another note is, test modification on a test board and see if they cause any changes.

DieselMinded 08-17-2007 01:12 PM

I havent moded in weeks either nothing changed it just went currupt I guess , Whats going to be required here a Back up from the 15th or can it be fixed with out me having to revert the site Back in Time ? ,,, Can i keep all the posts made? What tables are the important ones ?

Thanks To Everyone for there help

DM

Whats Screwing me is that the Main Structure list on phpmyadmin stops before the vbguests table so i cant get to it to fix it , it stops Right before that table ....like the window needs to scroll down futher but wont

DM

DieselMinded 08-18-2007 01:29 PM

Well it just went down AGAIN

What is causing this ?

I ran into myphpmyadmin and repiared the table , when i went back to structure another one was bad had to do like 5 or 6 of them whats crashing my database ?

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT subscriptionlog.userid, subscriptionlog.status, subscriptionlog.regdate, subscriptionlog.expirydate,
user.userid, user.username, user.usergroupid, displaygroupid,
usergroup.usergroupid, usergroup.title,
groupa.opentag as opentaga, groupa.closetag as closetaga,
groupb.opentag as opentagb, groupb.closetag as closetagb
FROM vbsubscriptionlog AS subscriptionlog
LEFT JOIN vbuser as user ON (subscriptionlog.userid = user.userid)
LEFT JOIN vbusergroup as usergroup ON(user.usergroupid = usergroup.usergroupid)
LEFT JOIN vbusergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN vbusergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
WHERE subscriptionlog.status != '0' ORDER BY subscriptionlog.regdate DESC LIMIT 0, 3;

MySQL Error : Can't open file: 'vbuser.MYI' (errno: 145)
Error Number : 1016
DM

nvalid SQL:

SELECT post.pagetext AS preview,
thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid, thread.dateline, thread.forumid,
thread.replycount, IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.sticky,
thread.pollid, thread.open, thread.lastpost AS postdateline, thread.visible, thread.hiddencount, thread.deletedcount,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.attach, thread.postusername, thread.forumid,

deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,

user.userid AS postuserid
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed

FROM vbthread AS thread
LEFT JOIN vbuser AS user ON(user.userid = thread.postuserid)

LEFT JOIN vbdeletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')

LEFT JOIN vbsubscribethread AS subscribethread
ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
LEFT JOIN vbpost AS post ON(post.postid = thread.firstpostid)

WHERE thread.threadid IN
(4101, 4156, 2342, 3474, 4165, 3854, 4149, 4164, 4158, 4161, 3978);

MySQL Error : Can't open file: 'vbsubscribethread.MYI' (errno: 144)
Error Number : 1016

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT IF(visible = 2, 1, 0) AS isdeleted,

NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed, emailupdate, folderid,
thread.*

FROM vbthread AS thread

LEFT JOIN vbsubscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND subscribethread.canview = 1)

WHERE thread.threadid = 4156;

MySQL Error : Can't open file: 'vbsubscribethread.MYI' (errno: 144)
Error Number : 1016

I ran the suspect file versions and found

Payment API
File version mismatch: found 3.6.6, expected 3.6.8

MOD CP
File version mismatch: found 3.6.7, expected 3.6.8

Does this Matter if it does how do i just update these 2 pages ? FTP ?

The Only thing diffrent on my site from last week is I have VBseo Sitemaps Running

0 2007-08-09 02:01 43.87 s 32,933 - Yes Yes View details | Remove record
1 2007-08-10 02:00 46.72 s 33,190 +257 Yes Yes View details | Remove record
2 2007-08-11 02:00 48.86 s 33,412 +222 Yes Yes View details | Remove record
3 2007-08-12 02:01 86,401.57 s 33,623 +211 Yes Yes View details | Remove record
4 2007-08-14 02:00 79.22 s 34,028 +405 Yes Yes View details | Remove record
5 2007-08-15 02:00 48.23 s

It hasnt generated a new once since the 15Th could it be crashing the database when making the site map?

Need some insite here

Thanks

DM

Marco van Herwaarden 08-18-2007 01:46 PM

MySQL Error : Can't open file: 'vbuser.MYI' (errno: 145)MySQL error code 145: Table was marked as crashed and should be repaired

MySQL Error : Can't open file: 'vbsubscribethread.MYI' (errno: 144)
MySQL error code 144: Table is crashed and last repair failed

Repair the tables a few times. If this keeps happening, there is something wrong with the server as tables should not crash on a regular basis. Please contact your host for a solution.

DieselMinded 08-18-2007 02:11 PM

I repair them and the sites back up , Glad to hear this isnt normal

I will contact them for the 100th time this mth

DM

Just went down again

vbattachmentviews

And

vbuser

SQL query: DocumentationEdit

SELECT COUNT( * ) AS num
FROM `dieselbombersforum`.`vbattachmentviews`

MySQL said: Documentation
#1016 - Can't open file: 'vbattachmentviews.MYI' (errno: 145)

Lynne 08-18-2007 02:35 PM

Have you tried repairing/optimizing ALL the tables several times until you are told they are all OK?

DieselMinded 08-18-2007 07:50 PM

Yes they did say that then 15 mins later they crash again.,... I just fixed it 3 more times what the heck am i suppose to do ?

First these Crashed.......

vbmailqueue
vbthread
vbuser



Then

vbadminlog
vbattachmentviews
vbeditlog
vbpmtext
vbposthash
vbpost_thanks
vbregimage
vbsigparsed
vbthreadviews

Then
vbcron
vbpm
vbsearch

When i try to repair they all say ok then when i go back to the structure list there errors

DM

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT COUNT(*) AS total, folderid
FROM vbpm AS pm
LEFT JOIN vbpmtext AS pmtext USING(pmtextid)
WHERE userid = 1
GROUP BY folderid;

MySQL Error : Can't open file: 'vbpmtext.MYI' (errno: 144)
Error Number : 1016
Date : Saturday, August 18th 2007 @ 04:35:36 PM
Script : http://www.dieselbombers.com/private.php
Referrer : http://www.dieselbombers.com/showthread.php?p=47337

dieselbombersforum.vbaccess optimize status Table is already up to date
dieselbombersforum.vbadminhelp optimize status Table is already up to date
dieselbombersforum.vbadministrator optimize status Table is already up to date
dieselbombersforum.vbadminlog optimize error Found 7383 keys of 7392
dieselbombersforum.vbadminlog optimize status Operation failed
dieselbombersforum.vbadminmessage optimize status Table is already up to date
dieselbombersforum.vbadminutil optimize status Table is already up to date
dieselbombersforum.vbannouncement optimize status Table is already up to date
dieselbombersforum.vbannouncementread optimize status Table is already up to date
dieselbombersforum.vbattachment optimize status Table is already up to date
dieselbombersforum.vbattachmentpermission optimize status Table is already up to date
dieselbombersforum.vbattachmenttype optimize status Table is already up to date
dieselbombersforum.vbattachmentviews optimize error Found 5 keys of 10
dieselbombersforum.vbattachmentviews optimize status Operation failed
dieselbombersforum.vbautomediaembed optimize status Table is already up to date
dieselbombersforum.vbavatar optimize status Table is already up to date
dieselbombersforum.vbbbcode optimize status Table is already up to date
dieselbombersforum.vbcalendar optimize status Table is already up to date
dieselbombersforum.vbcalendarcustomfield optimize status Table is already up to date
dieselbombersforum.vbcalendarmoderator optimize status Table is already up to date
dieselbombersforum.vbcalendarpermission optimize status Table is already up to date
dieselbombersforum.vbcpsession optimize note The storage engine for the table doesn't support o...
dieselbombersforum.vbcron optimize status Table is already up to date
dieselbombersforum.vbcronlog optimize status Table is already up to date
dieselbombersforum.vbcustomavatar optimize status Table is already up to date
dieselbombersforum.vbcustomprofilepic optimize status Table is already up to date
dieselbombersforum.vbdatastore optimize status OK
dieselbombersforum.vbdeletionlog optimize status Table is already up to date
dieselbombersforum.vbdonation_buttons optimize status Table is already up to date
dieselbombersforum.vbdonation_currency_exchange optimize status Table is already up to date
dieselbombersforum.vbdonation_donors optimize status Table is already up to date
dieselbombersforum.vbdonation_goals optimize status Table is already up to date
dieselbombersforum.vbdonation_paypalipn optimize status Table is already up to date
dieselbombersforum.vbeditlog optimize error Found 1867 keys of 1868
dieselbombersforum.vbeditlog optimize status Operation failed
dieselbombersforum.vbevent optimize status Table is already up to date
dieselbombersforum.vbexternalcache optimize status Table is already up to date
dieselbombersforum.vbfaq optimize status Table is already up to date
dieselbombersforum.vbforum optimize status OK
dieselbombersforum.vbforumpermission optimize status Table is already up to date
dieselbombersforum.vbforumread optimize status Table is already up to date
dieselbombersforum.vbholiday optimize status Table is already up to date
dieselbombersforum.vbicon optimize status Table is already up to date
dieselbombersforum.vbimagecategory optimize status Table is already up to date
dieselbombersforum.vbimagecategorypermission optimize status Table is already up to date
dieselbombersforum.vbinfraction optimize status Table is already up to date
dieselbombersforum.vbinfractionban optimize status Table is already up to date
dieselbombersforum.vbinfractiongroup optimize status Table is already up to date
dieselbombersforum.vbinfractionlevel optimize status Table is already up to date
dieselbombersforum.vbitrader optimize status Table is already up to date
dieselbombersforum.vbitrader_comments optimize status Table is already up to date
dieselbombersforum.vblanguage optimize status OK
dieselbombersforum.vbmailqueue optimize status OK
dieselbombersforum.vbmoderation optimize status Table is already up to date
dieselbombersforum.vbmoderator optimize status Table is already up to date
dieselbombersforum.vbmoderatorlog optimize status Table is already up to date
dieselbombersforum.vbpasswordhistory optimize status OK
dieselbombersforum.vbpaymentapi optimize status Table is already up to date
dieselbombersforum.vbpaymentinfo optimize status Table is already up to date
dieselbombersforum.vbpaymenttransaction optimize status Table is already up to date
dieselbombersforum.vbphrase optimize status OK
dieselbombersforum.vbphrasetype optimize status Table is already up to date
dieselbombersforum.vbplugin optimize status OK
dieselbombersforum.vbpm optimize status Table is already up to date
dieselbombersforum.vbpmreceipt optimize status Table is already up to date
dieselbombersforum.vbpmtext optimize error Found 7217 keys of 7218
dieselbombersforum.vbpmtext optimize status Operation failed
dieselbombersforum.vbpodcast optimize status Table is already up to date
dieselbombersforum.vbpodcastitem optimize status Table is already up to date
dieselbombersforum.vbpoll optimize status Table is already up to date
dieselbombersforum.vbpollvote optimize status Table is already up to date
dieselbombersforum.vbpost optimize status OK
dieselbombersforum.vbposthash optimize error Found 5 keys of 12
dieselbombersforum.vbposthash optimize status Operation failed
dieselbombersforum.vbpostindex optimize status Table is already up to date
dieselbombersforum.vbpostparsed optimize warning Duplicate key for record at 673800 against record ...
dieselbombersforum.vbpostparsed optimize warning Duplicate key for record at 675056 against record ...
dieselbombersforum.vbpostparsed optimize warning Duplicate key for record at 675188 against record ...
dieselbombersforum.vbpostparsed optimize warning Duplicate key for record at 675488 against record ...
dieselbombersforum.vbpostparsed optimize warning Duplicate key for record at 675616 against record ...
dieselbombersforum.vbpostparsed optimize warning Duplicate key for record at 676464 against record ...
dieselbombersforum.vbpostparsed optimize warning Duplicate key for record at 676492 against record ...
dieselbombersforum.vbpostparsed optimize warning Duplicate key for record at 676568 against record ...
dieselbombersforum.vbpostparsed optimize warning Duplicate key for record at 676712 against record ...
dieselbombersforum.vbpostparsed optimize warning Duplicate key for record at 676740 against record ...
dieselbombersforum.vbpostparsed optimize warning Duplicate key for record at 677044 against record ...
dieselbombersforum.vbpostparsed optimize warning Duplicate key for record at 677080 against record ...
dieselbombersforum.vbpostparsed optimize warning Duplicate key for record at 677108 against record ...
dieselbombersforum.vbpostparsed optimize warning Duplicate key for record at 677256 against record ...
dieselbombersforum.vbpostparsed optimize warning Duplicate key for record at 677532 against record ...
dieselbombersforum.vbpostparsed optimize warning Duplicate key for record at 659080 against record ...
dieselbombersforum.vbpostparsed optimize warning Duplicate key for record at 680364 against record ...
dieselbombersforum.vbpostparsed optimize warning Duplicate key for record at 680916 against record ...
dieselbombersforum.vbpostparsed optimize warning Duplicate key for record at 658620 against record ...
dieselbombersforum.vbpostparsed optimize warning Number of rows changed from 1775 to 1756
dieselbombersforum.vbpostparsed optimize status OK
dieselbombersforum.vbpost_thanks optimize error Found 1984 keys of 1985
dieselbombersforum.vbpost_thanks optimize status Operation failed
dieselbombersforum.vbproduct optimize status OK
dieselbombersforum.vbproductcode optimize status OK
Table Op Msg_type Msg_text
dieselbombersforum.vbproductdependency optimize status OK
dieselbombersforum.vbprofilefield optimize status Table is already up to date
dieselbombersforum.vbprofilefieldcategory optimize status Table is already up to date
dieselbombersforum.vbranks optimize status Table is already up to date
dieselbombersforum.vbregimage optimize error Found 309 keys of 777
dieselbombersforum.vbregimage optimize status Operation failed
dieselbombersforum.vbreminder optimize status Table is already up to date
dieselbombersforum.vbreputation optimize status Table is already up to date
dieselbombersforum.vbreputationlevel optimize status Table is already up to date
dieselbombersforum.vbrssfeed optimize status Table is already up to date
dieselbombersforum.vbrsslog optimize status Table is already up to date
dieselbombersforum.vbscwho optimize status Table is already up to date
dieselbombersforum.vbsearch optimize warning Duplicate key for record at 5508 against record at...
dieselbombersforum.vbsearch optimize warning Duplicate key for record at 7252 against record at...
dieselbombersforum.vbsearch optimize warning Duplicate key for record at 16464 against record a...
dieselbombersforum.vbsearch optimize warning Number of rows changed from 23 to 20
dieselbombersforum.vbsearch optimize status OK
dieselbombersforum.vbsession optimize note The storage engine for the table doesn't support o...
dieselbombersforum.vbsetting optimize status OK
dieselbombersforum.vbsettinggroup optimize status OK
dieselbombersforum.vbsigparsed optimize error Found 261 keys of 263
dieselbombersforum.vbsigparsed optimize status Operation failed
dieselbombersforum.vbsigpic optimize status Table is already up to date
dieselbombersforum.vbsmilie optimize status Table is already up to date
dieselbombersforum.vbstats optimize status Table is already up to date
dieselbombersforum.vbstrikes optimize status Table is already up to date
dieselbombersforum.vbstyle optimize status Table is already up to date
dieselbombersforum.vbsubscribeevent optimize status Table is already up to date
dieselbombersforum.vbsubscribeforum optimize status Table is already up to date
dieselbombersforum.vbsubscribethread optimize status OK
dieselbombersforum.vbsubscription optimize status Table is already up to date
dieselbombersforum.vbsubscriptionlog optimize status Table is already up to date
dieselbombersforum.vbsubscriptionpermission optimize status Table is already up to date
dieselbombersforum.vbsweepstakes optimize status Table is already up to date
dieselbombersforum.vbsweepstakes_entry optimize status Table is already up to date
dieselbombersforum.vbtachyforumpost optimize status Table is already up to date
dieselbombersforum.vbtachythreadpost optimize status Table is already up to date
dieselbombersforum.vbtemplate optimize status OK
dieselbombersforum.vbtemplatehistory optimize status Table is already up to date
dieselbombersforum.vbthread optimize status OK
dieselbombersforum.vbthreadrate optimize status Table is already up to date
dieselbombersforum.vbthreadread optimize status Table is already up to date
dieselbombersforum.vbthreadredirect optimize status Table is already up to date
dieselbombersforum.vbthreadviews optimize error Found 120 keys of 246
dieselbombersforum.vbthreadviews optimize status Operation failed
dieselbombersforum.vbupgradelog optimize status Table is already up to date
dieselbombersforum.vbuser optimize status OK
dieselbombersforum.vbuseractivation optimize status Table is already up to date
dieselbombersforum.vbuserban optimize status Table is already up to date
dieselbombersforum.vbuserfield optimize status OK
dieselbombersforum.vbusergroup optimize status Table is already up to date
dieselbombersforum.vbusergroupleader optimize status Table is already up to date
dieselbombersforum.vbusergrouprequest optimize status Table is already up to date
dieselbombersforum.vbuserlist optimize status Table is already up to date
dieselbombersforum.vbusernote optimize status Table is already up to date
dieselbombersforum.vbuserpromotion optimize status Table is already up to date
dieselbombersforum.vbusertextfield optimize status OK
dieselbombersforum.vbusertitle optimize status Table is already up to date
dieselbombersforum.vbvbay_categories optimize status Table is already up to date
dieselbombersforum.vbvbay_items optimize status Table is already up to date
dieselbombersforum.vbword optimize status Table is already up to date

DieselMinded 08-18-2007 07:54 PM

Table Op Msg_type Msg_text
dieselbombersforum.vbaccess check status OK
dieselbombersforum.vbadminhelp check status OK
dieselbombersforum.vbadministrator check status OK
dieselbombersforum.vbadminlog check status OK
dieselbombersforum.vbadminmessage check status OK
dieselbombersforum.vbadminutil check status OK
dieselbombersforum.vbannouncement check status OK
dieselbombersforum.vbannouncementread check status OK
dieselbombersforum.vbattachment check status OK
dieselbombersforum.vbattachmentpermission check status OK
dieselbombersforum.vbattachmenttype check status OK
dieselbombersforum.vbattachmentviews check status OK
dieselbombersforum.vbautomediaembed check status OK
dieselbombersforum.vbavatar check status OK
dieselbombersforum.vbbbcode check status OK
dieselbombersforum.vbcalendar check status OK
dieselbombersforum.vbcalendarcustomfield check status OK
dieselbombersforum.vbcalendarmoderator check status OK
dieselbombersforum.vbcalendarpermission check status OK
dieselbombersforum.vbcpsession check note The storage engine for the table doesn't support c...
dieselbombersforum.vbcron check error Checksum for key: 3 doesn't match checksum for re...
dieselbombersforum.vbcron check error Corrupt
dieselbombersforum.vbcronlog check status OK
dieselbombersforum.vbcustomavatar check status OK
dieselbombersforum.vbcustomprofilepic check status OK
dieselbombersforum.vbdatastore check warning 2 clients are using or haven't closed the table pr...
dieselbombersforum.vbdatastore check status OK
dieselbombersforum.vbdeletionlog check status OK
dieselbombersforum.vbdonation_buttons check status OK
dieselbombersforum.vbdonation_currency_exchange check status OK
dieselbombersforum.vbdonation_donors check status OK
dieselbombersforum.vbdonation_goals check status OK
dieselbombersforum.vbdonation_paypalipn check status OK
dieselbombersforum.vbeditlog check status OK
dieselbombersforum.vbevent check status OK
dieselbombersforum.vbexternalcache check status OK
dieselbombersforum.vbfaq check status OK
dieselbombersforum.vbforum check status OK
dieselbombersforum.vbforumpermission check status OK
dieselbombersforum.vbforumread check status OK
dieselbombersforum.vbholiday check status OK
dieselbombersforum.vbicon check status OK
dieselbombersforum.vbimagecategory check status OK
dieselbombersforum.vbimagecategorypermission check status OK
dieselbombersforum.vbinfraction check status OK
dieselbombersforum.vbinfractionban check status OK
dieselbombersforum.vbinfractiongroup check status OK
dieselbombersforum.vbinfractionlevel check status OK
dieselbombersforum.vbitrader check status OK
dieselbombersforum.vbitrader_comments check status OK
dieselbombersforum.vblanguage check status OK
dieselbombersforum.vbmailqueue check status OK
dieselbombersforum.vbmoderation check status OK
dieselbombersforum.vbmoderator check status OK
dieselbombersforum.vbmoderatorlog check status OK
dieselbombersforum.vbpasswordhistory check status OK
dieselbombersforum.vbpaymentapi check status OK
dieselbombersforum.vbpaymentinfo check status OK
dieselbombersforum.vbpaymenttransaction check status OK
dieselbombersforum.vbphrase check status OK
dieselbombersforum.vbphrasetype check status OK
dieselbombersforum.vbplugin check status OK
dieselbombersforum.vbpm check warning 3 clients are using or haven't closed the table pr...
dieselbombersforum.vbpm check error Found 8637 keys of 8638
dieselbombersforum.vbpm check error Corrupt
dieselbombersforum.vbpmreceipt check status OK
dieselbombersforum.vbpmtext check status OK
dieselbombersforum.vbpodcast check status OK
dieselbombersforum.vbpodcastitem check status OK
dieselbombersforum.vbpoll check status OK
dieselbombersforum.vbpollvote check status OK
dieselbombersforum.vbpost check status OK
dieselbombersforum.vbposthash check status OK
dieselbombersforum.vbpostindex check status OK
dieselbombersforum.vbpostparsed check status OK
dieselbombersforum.vbpost_thanks check status OK
dieselbombersforum.vbproduct check status OK
dieselbombersforum.vbproductcode check status OK
dieselbombersforum.vbproductdependency check status OK
dieselbombersforum.vbprofilefield check status OK
dieselbombersforum.vbprofilefieldcategory check status OK
dieselbombersforum.vbranks check status OK
dieselbombersforum.vbregimage check status OK
dieselbombersforum.vbreminder check status OK
dieselbombersforum.vbreputation check status OK
dieselbombersforum.vbreputationlevel check status OK
dieselbombersforum.vbrssfeed check status OK
dieselbombersforum.vbrsslog check status OK
dieselbombersforum.vbscwho check status OK
dieselbombersforum.vbsearch check error Found 23 keys of 20
dieselbombersforum.vbsearch check error Corrupt
dieselbombersforum.vbsession check note The storage engine for the table doesn't support c...
dieselbombersforum.vbsetting check status OK
dieselbombersforum.vbsettinggroup check status OK
dieselbombersforum.vbsigparsed check status OK
dieselbombersforum.vbsigpic check status OK
dieselbombersforum.vbsmilie check status OK
dieselbombersforum.vbstats check status OK
dieselbombersforum.vbstrikes check status OK
dieselbombersforum.vbstyle check warning 1 client is using or hasn't closed the table prope...
Table Op Msg_type Msg_text
dieselbombersforum.vbstyle check status OK
dieselbombersforum.vbsubscribeevent check status OK
dieselbombersforum.vbsubscribeforum check status OK
dieselbombersforum.vbsubscribethread check status OK
dieselbombersforum.vbsubscription check status OK
dieselbombersforum.vbsubscriptionlog check status OK
dieselbombersforum.vbsubscriptionpermission check status OK
dieselbombersforum.vbsweepstakes check status OK
dieselbombersforum.vbsweepstakes_entry check status OK
dieselbombersforum.vbtachyforumpost check status OK
dieselbombersforum.vbtachythreadpost check status OK
dieselbombersforum.vbtemplate check status OK
dieselbombersforum.vbtemplatehistory check status OK
dieselbombersforum.vbthread check status OK
dieselbombersforum.vbthreadrate check status OK
dieselbombersforum.vbthreadread check status OK
dieselbombersforum.vbthreadredirect check status OK
dieselbombersforum.vbthreadviews check status OK
dieselbombersforum.vbupgradelog check status OK
dieselbombersforum.vbuser check warning 2 clients are using or haven't closed the table pr...
dieselbombersforum.vbuser check error Checksum for key: 6 doesn't match checksum for re...
dieselbombersforum.vbuser check error Corrupt
dieselbombersforum.vbuseractivation check status OK
dieselbombersforum.vbuserban check status OK
dieselbombersforum.vbuserfield check status OK
dieselbombersforum.vbusergroup check status OK
dieselbombersforum.vbusergroupleader check status OK
dieselbombersforum.vbusergrouprequest check status OK
dieselbombersforum.vbuserlist check status OK
dieselbombersforum.vbusernote check status OK
dieselbombersforum.vbuserpromotion check status OK
dieselbombersforum.vbusertextfield check status OK
dieselbombersforum.vbusertitle check status OK
dieselbombersforum.vbvbay_categories check status OK
dieselbombersforum.vbvbay_items check status OK
dieselbombersforum.vbword check status OK

G0F0RBR0KE 08-18-2007 07:55 PM

I believe this has nothing to do with the hack(s) you have install but mySQL being run on your host provider keeps crashing on their side.

I suggest you use the backup from August 15th and move to another host and see how it goes from there.

PM me if you want a decent price to pay every 3 months, 6 months, 1 year, etc...

DieselMinded 08-18-2007 07:57 PM

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT post.pagetext AS preview,
thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid, thread.dateline, thread.forumid,
thread.replycount, IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.sticky,
thread.pollid, thread.open, thread.lastpost AS postdateline, thread.visible, thread.hiddencount, thread.deletedcount,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.attach, thread.postusername, thread.forumid,


deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,

user.userid AS postuserid
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed


FROM vbthread AS thread
LEFT JOIN vbuser AS user ON(user.userid = thread.postuserid)

LEFT JOIN vbdeletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')

LEFT JOIN vbsubscribethread AS subscribethread
ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
LEFT JOIN vbpost AS post ON(post.postid = thread.firstpostid)


WHERE thread.threadid IN
(4139, 4159, 3722, 2211, 4161);

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Saturday, August 18th 2007 @ 04:56:44 PM
Script : http://www.dieselbombers.com/search.php?searchid=56971
Referrer : http://www.dieselbombers.com/showthread.php?p=47337
IP Address :
Username : DieselMinded
Classname : vb_database

vbuser just crashed again

G0F0RBR0KE 08-18-2007 07:59 PM

I believe it's an issue on their side.


All times are GMT. The time now is 01:35 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01439 seconds
  • Memory Usage 1,935KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete