Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #30  
Old 08-18-2007, 12: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
 


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 03:39 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.13270 seconds
  • Memory Usage 3,512KB
  • Queries Executed 12 (?)
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
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (40)post_thanks_box
  • (40)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (40)post_thanks_postbit_info
  • (40)postbit
  • (40)postbit_onlinestatus
  • (40)postbit_wrapper
  • (1)showthread_list
  • (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_threadedmode.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_threaded
  • showthread_threaded_construct_link
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete