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

Reply
 
Thread Tools Display Modes
  #1  
Old 08-04-2007, 01:09 PM
deezelpope deezelpope is offline
 
Join Date: Feb 2007
Posts: 1,272
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default DB error-MySQL error

I was 'repairing tables' etc. when this occurred...now I can't get into my site at all. Tried running the most recent backup to no avail. Anyone have an idea how this can be remedied?

Database error in vBulletin 3.6.4:
Invalid SQL:
SELECT COUNT(dateline) AS pcount
FROM post
WHERE dateline > 1186234174;
MySQL Error : Can't open file: 'post.MYI' (errno: 145)
Error Number : 1016
Date : Saturday, August 4th 2007 @ 01:55:42 PM
Script : http://badgirljammieclub.com/community/
Referrer : http://badgirljammieclub.com/
IP Address :
Username :
Classname : vb_database

I had 35 other DB errors before this...I can provide them if anyone would like to try and help me out...
Reply With Quote
  #2  
Old 08-04-2007, 02:31 PM
Zaiaku's Avatar
Zaiaku Zaiaku is offline
 
Join Date: Jul 2007
Location: 3rd Level of Hell
Posts: 502
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Error 1016 is usually can't open file. Which is the error that is displayed. Checc with your server admin to see if space on the server has been taking up. I've heard this can also be cause by a /TMP/ folder not being accessible.
Reply With Quote
  #3  
Old 08-04-2007, 02:34 PM
deezelpope deezelpope is offline
 
Join Date: Feb 2007
Posts: 1,272
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

<i>Thank you for your help...I will try your suggestion.</i>
Reply With Quote
  #4  
Old 08-10-2007, 10:25 PM
deezelpope deezelpope is offline
 
Join Date: Feb 2007
Posts: 1,272
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Actually, I found this today at vBulletin.com ... http://www.vbulletin.com/forum/showthread.php?t=69803

BUT, as helpful as this looks, I can't understand a word of it, and would be greatly appreciative of, possibly even indebted to, ANYONE willing to help me get my site back up and running.
Reply With Quote
  #5  
Old 08-10-2007, 10:28 PM
ZomgStuff ZomgStuff is offline
 
Join Date: Feb 2007
Posts: 469
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by deezelpope View Post
Actually, I found this today at vBulletin.com ... http://www.vbulletin.com/forum/showthread.php?t=69803

BUT, as helpful as this looks, I can't understand a word of it, and would be greatly appreciative of, possibly even indebted to, ANYONE willing to help me get my site back up and running.
If you have SSH access to your site, I can help you out.

MSN: twolvesfan624@msn.com

Edit: Helped her fix it, problem solved.
Reply With Quote
  #6  
Old 08-11-2007, 09:46 AM
deezelpope deezelpope is offline
 
Join Date: Feb 2007
Posts: 1,272
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I can never thank you enough, ZomgStuff, for the help you've given me. My members and I are truly grateful. Thank you again.
Reply With Quote
  #7  
Old 08-17-2007, 11:37 AM
DieselMinded's Avatar
DieselMinded DieselMinded is offline
 
Join Date: Mar 2007
Posts: 1,655
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

MEEE too but i dont have SSH access how do I fix it ?
Reply With Quote
  #8  
Old 08-17-2007, 11:45 AM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Simply repair the table, either via the ACP maintenance options or phpmyadmin.
Reply With Quote
  #9  
Old 08-17-2007, 11:51 AM
DieselMinded's Avatar
DieselMinded DieselMinded is offline
 
Join Date: Mar 2007
Posts: 1,655
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

How do i repair a table in phpmyadmin? The structure only popluated to right before the vbguest table and stops
Reply With Quote
  #10  
Old 08-17-2007, 11:53 AM
deezelpope deezelpope is offline
 
Join Date: Feb 2007
Posts: 1,272
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm pretty sure ZomgStuff used my phpmyadmin...he left his MSN IM addy here...utilize it, and ask him to help you. He's a really nice guy, and trustworthy.

DM, you sound a lot like me...all of that stuff looks Greek to me! And, contrary to what Paul says, it's NOT simple if you're not familiar with it.
Reply With Quote
Reply


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:26 AM.


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.05538 seconds
  • Memory Usage 2,249KB
  • 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)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)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