[Important]someting like database gone , please help ! :(

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
McLR
Registered User
Posts: 95
Joined: Thu Aug 21, 2003 12:51 pm

[Important]someting like database gone , please help ! :(

Post by McLR »

Hi
it verry important and if you will not help me , my forum is gone :(
i wanted to enter some topic and i get this error :

Code: Select all

phpBB : fatal error

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1016 Can't open file: 'phpbb_users.MYI'. (errno: 145)

SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = 'f388b79db2825ce1a8a8adc67ea7050c' AND u.user_id = s.session_user_id

Line : 235
File : /var/www/virtual/talkt.com/www/talkt/includes/sessions.php 
so i just entered to the forum in new page and i found that noting is work
all pages give me this error
...
so igone to the database and entered "phpbb_users" table
and i get this :

Code: Select all

Can't open file: 'phpbb_users.MYI'. (errno: 145) 

Error

SQL-query :  

SHOW KEYS FROM `phpbb_users` 

MySQL said: 


Can't open file: 'phpbb_users.MYI'. (errno: 145)
Back 
what i have to do ?
Please help me :cry:
tnx :cry:
User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34457
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run
Contact:

Post by A_Jelly_Doughnut »

Open phpMyAdmin (or similar; provided by many hosts, check your control panel). Choose your database name in the left frame. Then SQL in the right frame. In the large text box, type

Code: Select all

REPAIR TABLE phpbb_users;
and click Go.
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish
McLR
Registered User
Posts: 95
Joined: Thu Aug 21, 2003 12:51 pm

Post by McLR »

A_Jelly_Doughnut wrote: Open phpMyAdmin (or similar; provided by many hosts, check your control panel). Choose your database name in the left frame. Then SQL in the right frame. In the large text box, type

Code: Select all

REPAIR TABLE phpbb_users;
and click Go.

8O 8O 8O
verrryyy tnx
i not so good in english and i dont know how to say it (big tnx)
i think the site is dead , but you just saved it
tnx
one more thing...
why it happened ?
Locked

Return to “2.0.x Support Forum”