Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 03-30-2006, 12:04 PM
SpanishHarlem SpanishHarlem is offline
 
Join Date: Feb 2005
Location: Ontario, Canada
Posts: 154
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Problem with Database

Hello, There seem's to be a problem with my database. I went to bed last night and everything was fine. Got a couple of msn's and pm's that they get an error when trying to post.

I tried this morning to post and this is what I get.

Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT posthash.threadid
FROM posthash AS posthash
WHERE posthash.userid = 3 AND
posthash.dupehash = 'e79e05e50fbfea41d716068331748119' AND
posthash.dateline > 1143725245;

MySQL Error : Can't open file: 'posthash.MYI' (errno: 145)
Error Number : 1016
Date : Thursday, March 30th 2006 @ 08:32:25 AM
Script : http://canadian-freebies-n-stuff.com.../newthread.php
Referrer :
IP Address : 74.12.40.96
Username : CherBear
Classname : vb_database

I don't know stuff that has to do with the upgrading or even installing and neither does the person who has allowed me to host through his server. He is just a guy who has allowed me to run off of his server as a favour.

The tech guy I used to have told me that he would help teach me this stuff but when he sold his hosting business he but all up and disapeared. Is there anything I can do. I have over 2,000 member's who are driving me nuts.

Thank's in Advance.
Reply With Quote
  #2  
Old 03-30-2006, 12:10 PM
TTG's Avatar
TTG TTG is offline
 
Join Date: May 2004
Location: Sth London
Posts: 1,042
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Run the Repair Utility at the bottom of the admincp in the Import and Maintenance section.
Reply With Quote
  #3  
Old 03-30-2006, 12:15 PM
SpanishHarlem SpanishHarlem is offline
 
Join Date: Feb 2005
Location: Ontario, Canada
Posts: 154
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thank you. That seemed to work.
Reply With Quote
  #4  
Old 07-24-2007, 05:22 PM
Strike3ForumsMH Strike3ForumsMH is offline
 
Join Date: May 2005
Posts: 437
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I had the same error, panicked and then remembered vbulletin.org so thanks to TTG as well!

Working fine again.

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 12:00 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03573 seconds
  • Memory Usage 2,179KB
  • Queries Executed 11 (?)
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
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)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_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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete