vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)
-   -   I need Help. (https://vborg.vbsupport.ru/showthread.php?t=37428)

Slynderdale 04-14-2002 08:00 PM
I need Help.
 
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.

Code:
  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:
Code:
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:

Code:
SQL-query : 

SHOW KEYS FROM `templateset`

MySQL said:


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

Search:
Code:
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:
Code:
Error

SQL-query : 

SHOW KEYS FROM `search`

MySQL said:


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

Steve Machol 04-14-2002 08: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...html=1&check=1

Slynderdale 04-14-2002 08:06 PM
Quote:
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...html=1&check=1
Ill try that, thanks

Slynderdale 04-14-2002 08: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 08:31 PM
Code:
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 08: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 08: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/showt...threadid=42663

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

Slynderdale 04-14-2002 09:02 PM
MySQL 3.23.45

Steve Machol 04-14-2002 09: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 09: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 09: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 09: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 09: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 10: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 06: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:

Code:
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:
Code:
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 06: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 06:46 PM
Quote:
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 06:58 PM
Code:
<!-- Database error in vBulletin Control Panel :

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

mysql error number: 1016

Date: Monday 15th of April 2002 08:42:50 PM
Script: /forum/admin/repair.php?html=1&check=1
Referer: http://www.1stconnection.co.uk:2086/scripts/command
 -->
i checked the repair files source and thats what it said

Slynderdale 04-15-2002 07: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 09: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 09:27 PM
Glad you got it working. Just out of curiousity, how did you fix it?

Slynderdale 04-15-2002 09: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 01: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-17-2002 11:14 PM
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 05: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 01:33 AM
Quote:
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 02:08 AM
Quote:
04-17-02 at 04:51 AM eoc_Jason said this in Post #23
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 :/


All times are GMT. The time now is 04:59 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.01866 seconds
  • Memory Usage 1,841KB
  • 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
  • (9)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (27)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete