I need Help. [Archive] - vb.org Archive

Slynderdale

04-14-2002, 09:00 PM

I went to use phpmyadmin to optomized a table and now there messed up, is there any way i could fix them without losing every thing? This is really important. Its the search and templateset table.

Table Action Records Type Size
access Browse Select Insert Properties Drop Empty 0 MyISAM 1.0 KB
adminlog Browse Select Insert Properties Drop Empty 1,865 MyISAM 163.3 KB
adminutil Browse Select Insert Properties Drop Empty 1 MyISAM 2.0 KB
announcement Browse Select Insert Properties Drop Empty 3 MyISAM 5.4 KB
attachment Browse Select Insert Properties Drop Empty 34 MyISAM 1.5 MB
avatar Browse Select Insert Properties Drop Empty 0 MyISAM 1.0 KB
award Browse Select Insert Properties Drop Empty 1 MyISAM 2.1 KB
bbcode Browse Select Insert Properties Drop Empty 28 MyISAM 5.7 KB
calendar_events Browse Select Insert Properties Drop Empty 0 MyISAM 1.0 KB
customavatar Browse Select Insert Properties Drop Empty 29 MyISAM 119.5 KB
forum Browse Select Insert Properties Drop Empty 59 MyISAM 71.2 KB
forumpermission Browse Select Insert Properties Drop Empty 55 MyISAM 5.4 KB
icon Browse Select Insert Properties Drop Empty 14 MyISAM 4.8 KB
modapp Browse Select Insert Properties Drop Empty 6 MyISAM 3.8 KB
modappuser Browse Select Insert Properties Drop Empty 7 MyISAM 2.2 KB
moderator Browse Select Insert Properties Drop Empty 15 MyISAM 3.6 KB
poll Browse Select Insert Properties Drop Empty 12 MyISAM 3.7 KB
pollvote Browse Select Insert Properties Drop Empty 63 MyISAM 4.3 KB
post Browse Select Insert Properties Drop Empty 1,669 MyISAM 484.3 KB
privatemessage Browse Select Insert Properties Drop Empty 120 MyISAM 37.6 KB
profilefield Browse Select Insert Properties Drop Empty 9 MyISAM 4.8 KB
replacement Browse Select Insert Properties Drop Empty 131 MyISAM 10.2 KB
replacementset Browse Select Insert Properties Drop Empty 5 MyISAM 3.2 KB
search Browse Select Insert Properties Drop Empty in use
searchindex Browse Select Insert Properties Drop Empty 14,141 MyISAM 352.9 KB
session Browse Select Insert Properties Drop Empty 19 HEAP 156.0 KB
setting Browse Select Insert Properties Drop Empty 176 MyISAM 44.9 KB
settinggroup Browse Select Insert Properties Drop Empty 32 MyISAM 5.3 KB
smilie Browse Select Insert Properties Drop Empty 21 MyISAM 6.8 KB
style Browse Select Insert Properties Drop Empty 3 MyISAM 2.8 KB
subscribeforum Browse Select Insert Properties Drop Empty 1 MyISAM 3.0 KB
subscribethread Browse Select Insert Properties Drop Empty 105 MyISAM 4.5 KB
template Browse Select Insert Properties Drop Empty 719 MyISAM 924.1 KB
templateset Browse Select Insert Properties Drop Empty in use
thread Browse Select Insert Properties Drop Empty 195 MyISAM 28.0 KB
threadrate Browse Select Insert Properties Drop Empty 2 MyISAM 3.0 KB
user Browse Select Insert Properties Drop Empty 89 MyISAM 35.3 KB
user_rate Browse Select Insert Properties Drop Empty 84 MyISAM 4.2 KB
useractivation Browse Select Insert Properties Drop Empty 36 MyISAM 4.2 KB
useraward Browse Select Insert Properties Drop Empty 15 MyISAM 3.4 KB
userfield Browse Select Insert Properties Drop Empty 89 MyISAM 198.0 KB
usergroup Browse Select Insert Properties Drop Empty 12 MyISAM 8.1 KB
usernotepad Browse Select Insert Properties Drop Empty 4 MyISAM 1.1 KB
usertitle Browse Select Insert Properties Drop Empty 3 MyISAM 2.7 KB
vbstats_counter Browse Select Insert Properties Drop Empty 19 MyISAM 1.4 KB
vbstats_countries Browse Select Insert Properties Drop Empty 247 MyISAM 9.8 KB
vbstats_date Browse Select Insert Properties Drop Empty 17 MyISAM 1.6 KB
vbstats_exclude Browse Select Insert Properties Drop Empty 0 MyISAM 1.0 KB
vbstats_options Browse Select Insert Properties Drop Empty 1 MyISAM 1.1 KB
vbstats_referrer Browse Select Insert Properties Drop Empty 14 MyISAM 2.6 KB
word Browse Select Insert Properties Drop Empty 5,519 MyISAM 417.4 KB
51 table(s) Sum 25,689 -- 4.6 MB

Heres the errors:

Templateset:

Invalid SQL: SELECT templatesetid,title FROM templateset
mysql error: Can't open file: 'templateset.MYD'. (errno: 144)

mysql error number: 1016

Heres what it says on php my admin:

SQL-query :

SHOW KEYS FROM `templateset`

MySQL said:

Can't open file: 'templateset.MYD'. (errno: 144)

Search:

Invalid SQL: SELECT searchid,dateline FROM search WHERE userid=1 ORDER BY dateline DESC LIMIT 1
mysql error: Can't open file: 'search.MYD'. (errno: 144)

mysql error number: 1016

Heres what it says on php my admin:

Error

SQL-query :

SHOW KEYS FROM `search`

MySQL said:

Can't open file: 'search.MYD'. (errno: 144)

Steve Machol

04-14-2002, 09:04 PM

Close your forums and upload repair.php (from the 'extras' folder of the zip file) to your admin folder. Then run it from your browser with this syntax:

http://www.yoursite.com/forums/admin/repair.php?html=1&check=1

Slynderdale

04-14-2002, 09:06 PM

Originally posted by smachol
Close your forums and upload repair.php (from the 'extras' folder of the zip file) to your admin folder. Then run it from your browser with this syntax:

http://www.yoursite.com/forums/admin/repair.php?html=1&check=1

Ill try that, thanks

Slynderdale

04-14-2002, 09:29 PM

ok now this is bad, i ran the rapair scripted like ypi said, now instead just those two having an error, 90% of my database has errors now

Slynderdale

04-14-2002, 09:31 PM

Table Action Records Type Size
access Browse Select Insert Properties Drop Empty 0 MyISAM 1.0 KB
adminlog Browse Select Insert Properties Drop Empty in use
adminutil Browse Select Insert Properties Drop Empty in use
announcement Browse Select Insert Properties Drop Empty in use
attachment Browse Select Insert Properties Drop Empty in use
avatar Browse Select Insert Properties Drop Empty 0 MyISAM 1.0 KB
award Browse Select Insert Properties Drop Empty in use
bbcode Browse Select Insert Properties Drop Empty in use
calendar_events Browse Select Insert Properties Drop Empty 0 MyISAM 1.0 KB
customavatar Browse Select Insert Properties Drop Empty in use
forum Browse Select Insert Properties Drop Empty in use
forumpermission Browse Select Insert Properties Drop Empty in use
icon Browse Select Insert Properties Drop Empty in use
modapp Browse Select Insert Properties Drop Empty in use
modappuser Browse Select Insert Properties Drop Empty in use
moderator Browse Select Insert Properties Drop Empty in use
poll Browse Select Insert Properties Drop Empty in use
pollvote Browse Select Insert Properties Drop Empty in use
post Browse Select Insert Properties Drop Empty in use
privatemessage Browse Select Insert Properties Drop Empty in use
profilefield Browse Select Insert Properties Drop Empty in use
replacement Browse Select Insert Properties Drop Empty in use
replacementset Browse Select Insert Properties Drop Empty in use
search Browse Select Insert Properties Drop Empty in use
searchindex Browse Select Insert Properties Drop Empty in use
session Browse Select Insert Properties Drop Empty 21 HEAP 156.0 KB
setting Browse Select Insert Properties Drop Empty in use
settinggroup Browse Select Insert Properties Drop Empty in use
smilie Browse Select Insert Properties Drop Empty in use
style Browse Select Insert Properties Drop Empty in use
subscribeforum Browse Select Insert Properties Drop Empty in use
subscribethread Browse Select Insert Properties Drop Empty in use
template Browse Select Insert Properties Drop Empty in use
templateset Browse Select Insert Properties Drop Empty in use
thread Browse Select Insert Properties Drop Empty 195 MyISAM 28.0 KB
threadrate Browse Select Insert Properties Drop Empty 2 MyISAM 3.0 KB
user Browse Select Insert Properties Drop Empty 89 MyISAM 35.3 KB
user_rate Browse Select Insert Properties Drop Empty 84 MyISAM 4.2 KB
useractivation Browse Select Insert Properties Drop Empty 36 MyISAM 4.2 KB
useraward Browse Select Insert Properties Drop Empty 15 MyISAM 3.4 KB
userfield Browse Select Insert Properties Drop Empty 89 MyISAM 198.0 KB
usergroup Browse Select Insert Properties Drop Empty 12 MyISAM 8.1 KB
usernotepad Browse Select Insert Properties Drop Empty 4 MyISAM 1.1 KB
usertitle Browse Select Insert Properties Drop Empty 3 MyISAM 2.7 KB
vbstats_counter Browse Select Insert Properties Drop Empty 19 MyISAM 1.4 KB
vbstats_countries Browse Select Insert Properties Drop Empty 247 MyISAM 9.8 KB
vbstats_date Browse Select Insert Properties Drop Empty 17 MyISAM 1.6 KB
vbstats_exclude Browse Select Insert Properties Drop Empty 0 MyISAM 1.0 KB
vbstats_options Browse Select Insert Properties Drop Empty 1 MyISAM 1.1 KB
vbstats_referrer Browse Select Insert Properties Drop Empty 14 MyISAM 2.6 KB
word Browse Select Insert Properties Drop Empty 5,519 MyISAM 417.4 KB
51 table(s) Sum 6,367 -- 882.1 K

Slynderdale

04-14-2002, 09:38 PM

now all i get is

There seems to have been a slight problem with the 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.

Steve Machol

04-14-2002, 09:44 PM

It sounds like your server is running an older version of MySQL. See eva2000's message here, specifically suggestion #3:

http://www.vbulletin.com/forum/showthread.php?s=&threadid=42663

You may have to contact you host to help fix the problem. Good luck!

Slynderdale

04-14-2002, 10:02 PM

MySQL 3.23.45

Steve Machol

04-14-2002, 10:10 PM

That should be fine for repair.php then. Have you installed any hacks that make changes to the database?
What was the content of the latest error email you got?

Slynderdale

04-14-2002, 10:28 PM

i tried to run a repair query and it failed and got an error, i installed some hacks, but they worked fine and didnt cause any problems.

Slynderdale

04-14-2002, 10:50 PM

Database error in vBulletin :

Invalid SQL: SELECT template FROM template WHERE title='options'
mysql error: Can't open file: 'template.MYD'. (errno: 144)

mysql error number: 1016

Database error in vBulletin :
Invalid SQL: SELECT template FROM template WHERE title='options'
mysql error: Can't open file: 'template.MYD'. (errno: 144)

mysql error number: 1016

Steve Machol

04-14-2002, 10:54 PM

What 'repair query' did you run? Just run repair.php exactly as I told you. If any tables do not show 'ok' run it again. Make sure your forums are off when you run this! If all errors don;t go away after the second run, post the results here.

Slynderdale

04-14-2002, 10:57 PM

heres what i get when i try to run it

Warning: MySQL Connection Failed: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug in /home/darktech/public_html/slynderdale/forum/admin/db_mysql.php on line 40

There seems to have been a slight problem with the 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.

i have the memory too, i checked the account control panel

Steve Machol

04-14-2002, 11:14 PM

I don't see how running repair.php could possibly generate that kind of an error since it's not attempting to create a thread.

Error code 11: Resource temporarily unavailable

This is a server problem.

Slynderdale

04-15-2002, 07:22 PM

The server problem was fixed, but my mysql database is still messed up and when i try to tun the repair scripted thos shows up:

There seems to have been a slight problem with the 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.

the repair scripted shows up:

repair.php for mysql 3.23 or greater

This script will attempt to repair corrupted databases. While it can repair most common errors, it can not repair everything. As a side benefit it will also optimize your tables. This script is unsupported by jelsoft.

Usage:

iterations=x (x is the number of times you wish for the script to attempt to repair a broken table)
nohtml=1 (Output text only no html. Useful for cronjobs and you wish to receive text only)
forum=x (x is the name of the database to check. Leave it off to use the default database of your vBulletin forum)
check=1 (without this you will get this screen and no checking)

Example Usage:

repair.php?html=1&check=1 (most common usage, will check a forum and return html results)
repair.php?check=1&iterations=4&forum=vbdatabase (check the database "vbdatabase", try to repair damaged tables 4 times)

is there a way to have it check the mysql database without having it use the forums?

Steve Machol

04-15-2002, 07:44 PM

I'm not sure what your question is. Since the forums are, in effect, the database I don't see what you're getting at.

I recommend you use the 'repair.php?html=1&check=1' syntax when running repair.php.

Slynderdale

04-15-2002, 07:46 PM

Originally posted by smachol
I'm not sure what your question is. Since the forums are, in effect, the database I don't see what you're getting at.

I recommend you use the 'repair.php?html=1&check=1' syntax when running repair.php.

i tried that and all i got is

There seems to have been a slight problem with the 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.

Slynderdale

04-15-2002, 07:58 PM

i checked the repair files source and thats what it said

Slynderdale

04-15-2002, 08:17 PM

would it be possible to make the repair.php a standalone scripted and doesnt need to get global.php? i think its not working because how the forums tables are messed up, i was wondering if you could edit it so i could put it in my sites root directory and run it and have it check the database that way

Slynderdale

04-15-2002, 10:04 PM

Nevermind smachol, i fixed the tables myself, i didnt need the repair.php, thanks for the help though

Steve Machol

04-15-2002, 10:27 PM

Glad you got it working. Just out of curiousity, how did you fix it?

Slynderdale

04-15-2002, 10:46 PM

i went on phpmyadmin and manualy ran REPAIR TABLE query's for each table and it fixed them up and now they work, i lost a couple new posts but overall every thing is back to normal

eoc_Jason

04-17-2002, 02:51 AM

Whew.... glad to hear you were able to fix it...

This is one of the many reasons I have my forum do a dump every night.... just incase of something bad.... hehe..

Slynderdale

04-18-2002, 12:14 AM

ok im getting tired of my web host always being down for some unknown reason, and right when in a middle of testing a hack, im getting a new webhost with a d3 45mps connection, php, mysql, the works, and it has iphp, iphp is real cool

Tim Wheatley

08-23-2002, 06:14 PM

I'm now trying what you said as I have the same problem. When someone tries to access my stats it gives a search.myd error.

Slynderdale

08-24-2002, 02:33 AM

Originally posted by Tim Wheatley
I'm now trying what you said as I have the same problem. When someone tries to access my stats it gives a search.myd error.

I hope it works.

WCW Fan

07-15-2003, 03:08 AM

04-17-02 at 04:51 AM eoc_Jason said this in Post #23 (https://vborg.vbsupport.ru/showthread.php?postid=241514#post241514)
Whew.... glad to hear you were able to fix it...

This is one of the many reasons I have my forum do a dump every night.... just incase of something bad.... hehe..

How do you dumb your db would that be just backing up Im confused, Im sorry if this is an old topic I just signed up :/