Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #31  
Old 08-17-2007, 01:12 PM
DieselMinded's Avatar
DieselMinded DieselMinded is offline
 
Join Date: Mar 2007
Posts: 1,655
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #32  
Old 08-18-2007, 01:29 PM
DieselMinded's Avatar
DieselMinded DieselMinded is offline
 
Join Date: Mar 2007
Posts: 1,655
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #33  
Old 08-18-2007, 01:46 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #34  
Old 08-18-2007, 02:11 PM
DieselMinded's Avatar
DieselMinded DieselMinded is offline
 
Join Date: Mar 2007
Posts: 1,655
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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)
Reply With Quote
  #35  
Old 08-18-2007, 02:35 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Have you tried repairing/optimizing ALL the tables several times until you are told they are all OK?
Reply With Quote
  #36  
Old 08-18-2007, 07:50 PM
DieselMinded's Avatar
DieselMinded DieselMinded is offline
 
Join Date: Mar 2007
Posts: 1,655
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #37  
Old 08-18-2007, 07:54 PM
DieselMinded's Avatar
DieselMinded DieselMinded is offline
 
Join Date: Mar 2007
Posts: 1,655
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #38  
Old 08-18-2007, 07:55 PM
G0F0RBR0KE G0F0RBR0KE is offline
 
Join Date: Mar 2005
Posts: 987
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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...
Reply With Quote
  #39  
Old 08-18-2007, 07:57 PM
DieselMinded's Avatar
DieselMinded DieselMinded is offline
 
Join Date: Mar 2007
Posts: 1,655
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #40  
Old 08-18-2007, 07:59 PM
G0F0RBR0KE G0F0RBR0KE is offline
 
Join Date: Mar 2005
Posts: 987
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I believe it's an issue on their side.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:14 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.02534 seconds
  • Memory Usage 2,306KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete