The Arcive of Official vBulletin Modifications Site.

410 · #1 10-21-2002, 01:49 AM

My Cpanel works, but when I go to my index.php it gives me this error. I didn't do anything to cause this, my server went down, and when it came back up, this happened....

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=7
mysql error: Can't open file: 'privatemessage.MYD'. (errno: 145)

mysql error number: 1016

Date: Sunday 20th of October 2002 05:10:33 PM
Script: http://www..com/forums//forums/index.php?s=
Referer:

Xenon · #2 10-21-2002, 07:27 AM

go into PHPmyadmin and run this:
[sql]REPAIR privatemessage[/sql]

Dean C · #3 10-21-2002, 07:43 AM

and if you haven't got any hacks installed i'd reccomend upgrading to 2.2.8 anyway as it fixes lots of bugs..

- miSt

410 · #4 10-21-2002, 01:10 PM

I ran that and now it says this...

Error

SQL-query :

REPAIR privatemessage

MySQL said:

You have an error in your SQL syntax near 'privatemessage' at line 1

Back

Thanks for your help!

Xenon · #5 10-21-2002, 04:43 PM

hmm, you can also upload the file repair.php in your vb-zip and run it, i think this could also do the queryie

DrkFusion · #6 10-21-2002, 05:05 PM

How exactly does the REPAIR sql actually repair a table?
-Arunan

Chris M · #7 10-21-2002, 05:09 PM

It recreates any missing tables...

Satan

Steve Machol · #8 10-21-2002, 05:12 PM

Upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:

http://www.yourdomain/forum/admin/repair.php?html=1&check=1

[Of course change the exact URL as appropriate for your forums.]

If everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok. See if this fixes the problem.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03841 seconds Memory Usage 2,218KB 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 (8)post_thanks_box (8)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (8)post_thanks_postbit_info (8)postbit (8)postbit_onlinestatus (8)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 tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!