vb.org Archive - Req: User decides post direction

Page 2 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)

- - Req: User decides post direction (https://vborg.vbsupport.ru/showthread.php?t=44726)

Logician

10-18-2002 09:11 PM

Quote:

Originally posted by TundraSoul
Well I'm screwed.

The good 'ole VB database error.

Database error in vBulletin 2.2.7:

Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='10938' mysql error: Can't open file: 'userfield.MYD'. (errno: 145)

mysql error number: 1016

Time for a SQL restore... ?

Try "repair user" first.. Also try repairing other related tables before taking further steps.. It's sounds like a trivial db corruption, repair should fix it..

TundraSoul

10-18-2002 09:17 PM

I should use VB's repair.php in the admin directory?

Quote:

Originally posted by Logician

Try "repair user" first.. Also try repairing other related tables before taking further steps.. It's sounds like a trivial db corruption, repair should fix it..

TundraSoul

10-18-2002 09:18 PM

What repair do you mean?

NTLDR

10-18-2002 09:20 PM

Quote:

Originally posted by TundraSoul
What repair do you mean?

repair.php is found in the extras folder of your vBulletin Zip file, upload it to your forum/admin directory and run from your browser :)

TundraSoul

10-18-2002 09:23 PM

Thanks, I found it, and did, but it was of little help.

I got the same error when running it.

There seems to have been a slight problem with the Tundra Solutions database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Quote:

Originally posted by NTLDR

repair.php is found in the extras folder of your vBulletin Zip file, upload it to your forum/admin directory and run from your browser :)

TundraSoul

10-18-2002 09:24 PM

TundraSoul

10-18-2002 09:25 PM

Any way to close the forum, without logging into the control panel? I'm getting hundreds of email notices.

NTLDR

10-18-2002 09:25 PM

Try running the following query via phpMyAdmin:

[sql]REPAIR TABLE `user`[/sql]

TundraSoul

10-18-2002 09:39 PM

I tried to repair both user and userfield, but no luck.

vbulletin.user repair error 28 when writing to datafile
vbulletin.userfield repair error 28 when writing to datafile

Quote:

Originally posted by NTLDR
Try running the following query via phpMyAdmin:

[sql]REPAIR TABLE `user`[/sql]

TundraSoul

10-18-2002 10:20 PM

I'm in the process of uploading the restore file. A 200 MB upload will take a while.

All times are GMT. The time now is 08:10 PM.

Page 2 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01713 seconds Memory Usage 1,732KB 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 (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)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
Messages: