vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   DB error-MySQL error (https://vborg.vbsupport.ru/showthread.php?t=154291)

deezelpope 08-04-2007 12:09 PM

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...

Zaiaku 08-04-2007 01:31 PM

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.

deezelpope 08-04-2007 01:34 PM

<i>Thank you for your help...I will try your suggestion.</i>

deezelpope 08-10-2007 09:25 PM

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.

ZomgStuff 08-10-2007 09:28 PM

Quote:

Originally Posted by deezelpope (Post 1314809)
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.

deezelpope 08-11-2007 08:46 AM

I can never thank you enough, ZomgStuff, for the help you've given me. My members and I are truly grateful. Thank you again.:)

DieselMinded 08-17-2007 10:37 AM

MEEE too but i dont have SSH access how do I fix it ?

Paul M 08-17-2007 10:45 AM

Simply repair the table, either via the ACP maintenance options or phpmyadmin.

DieselMinded 08-17-2007 10:51 AM

How do i repair a table in phpmyadmin? The structure only popluated to right before the vbguest table and stops

deezelpope 08-17-2007 10:53 AM

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.


All times are GMT. The time now is 05:10 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.01672 seconds
  • Memory Usage 1,728KB
  • 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
  • (1)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
  • (10)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