Page 1 of 1

Forum Critical Error!!!

Posted: Fri Sep 19, 2003 4:31 pm
by FinalAeon
Hey, I had got my forum working great and it worked for about a week and i didn't messaround with anything so i souldn't mess anything up. But one day when i woke up and wanted to check my forum on my site, i got this error:

-------------------------------------------------------------------------------------

phpBB : Critical Error

Could not obtain lastvisit data from user table

DEBUG MODE

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

SELECT * FROM phpbb_users WHERE user_id = -1

Line : 62
File : /home2/fearmysk/public_html/forum/includes/sessions.php

-------------------------------------------------------------------------------------

I am using phpBB v2.06 from http://www.phpbb.com

Thank you,

FinalAeon :oops:

Mysql can't open file

Posted: Fri Sep 19, 2003 4:52 pm
by evilMind
Sounds to me like it could be a corrupt table. try "repairing" the table. IE,

Code: Select all

REPAIR TABLE `phpbb_users` EXTENDED;
or

mysqlcheck --auto-repair -m DATABASENAME tables
where DBNAME = the name of the database
tables = comma seperated list of tables you want to check (optional, don't include tables for mysqlcheck to check all tables w/in the specified db)
*Note* if -m doesn't work then try -e (this will take longer though)

Should do the trick if the table is in fact corrupt. What os + filesystem are you using?

Posted: Fri Sep 19, 2003 5:33 pm
by FinalAeon
Umm, can you tell me what to do with that code you sent me? I don't know what to do with it or where to put it... :oops:

Thank you,

FinalAeon

code

Posted: Fri Sep 19, 2003 6:14 pm
by evilMind
The REPAIR TABLE.... code should be run from a msyql> prompt.
ie, log in to mysql as a user who has permissions to modify those tables, and then run the REPAIR TABLE... code.

the mysqlcheck can be run from the command line like this (I believe in both *nix and Windows):

Code: Select all

mysqlcheck -m --auto-repair -u SomeUserName -p DATABASENAME tables
once again, where:
SomeUserName = user who has priviliges to modify the database/tables in question.
DATABASENAME = the name of the database you are trying to repair
tables = comma seperated list of tables to check

Another example, (I tend to be confusing at times esp. when I try to be clear with what I"m saying)

Code: Select all

mysqlcheck -m --auto-repair -u myUser -p mydb table1,table2,table3

Posted: Fri Sep 19, 2003 6:44 pm
by FinalAeon
Well i have webhosting from ionhosting.com and they give my mysql admin or something like that i know for sure, but i can't seem to find where the command prompt is. The only place i would think of looking is in the control panel right? but i dont see it there... if you could guide me and tell me exactly what to look for it would be very much appreciated.

Thank you,

FinalAeon :oops:

Posted: Fri Sep 19, 2003 7:01 pm
by evilMind
if it's phpMyAdmin that you are using (and that would be my guess since ion uses cpanel which is the same thing as the site I help maintain)

*You should see a list of tables on the left.

*Click on the table name (in this case phpbb_users).

*You should now see a row of tabs at the top .. possibly -> Structure, Browse, SQL, Select, Insert, Export, Operations, Empty, Drop.

*Click on Operations

*Scroll down to where you will see table maintence and click on "Repair Table"

Posted: Fri Sep 19, 2003 7:17 pm
by FinalAeon
ok i got to where u were talking about but when i hit operations it said the following below the tabs:

-------------------------------------------------------------------------------

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

Error

SQL-query :

SHOW COLUMNS FROM `phpbb_users` FROM `fearmysk_forum`

MySQL said:


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

-------------------------------------------------------------------------------

Please keep helping me I really appreciate it!

Thank you,

FinalAeon :oops:

Posted: Fri Sep 19, 2003 7:30 pm
by evilMind
ok lets try this.

when you first "log in" to mysql (or on the very first page you see when you click the phpMyAdmin link)

*click "Databases"

*Under the Database Column Select the name of the database that has the phpbb_users table in it.
*Note* You should then see a list of tables which are in that database

*At the top click on the tab that says "SQL"

*In the text box " Run SQL query/queries on database " enter this:
REPAIR TABLE `phpbb_users` EXTENDED


*At the bottom (under or Location of text file) Click Go.

Posted: Fri Sep 19, 2003 7:31 pm
by php_wiz_kid
*Click on SQL

*Type REPAIR TABLE `phpbb_users` EXTENDED;

This might fix the problem through phpMyAdmin. I had the exact same problem not to long ago.

Another way you could do this, without having to use query's would be:

*Select database in left panel.

*Place a checkmark in the table that's not working.

*In the dropdown menu which says "With selected:" select "Repair Table".

Hopefuly my instructions will be correct depending on the version on phpMyAdmin you are using. I really hope this helps.

Posted: Fri Sep 19, 2003 7:52 pm
by FinalAeon
Well no i still get the same error when i click SQL tab. And I don't know where u are talking about "database"

I'm going to just reinstall it it's no big deal. Thanks for all of ur help though!

Thank you,

FinalAeon :oops:

Posted: Sat Sep 20, 2003 10:13 pm
by Cruzado_Mainfrm
that meanst he is not going to 'learn' anything, because he decided to go the novice 'easy' way

Posted: Sun Sep 21, 2003 6:39 am
by FinalAeon
well "sorry" there buddy, but i wasn't getting too many answers and i was going on 5 days without knowing what to do. And by the way, i've had about 4 people tell me that i "couldn't" fix it unless i reinstalled phpbb. since what the person put above didn't work. that's what everyone told me to do. so if u know how to fix it, i'd like you to post it here anywayz if you wouldn't mind just so i know u arent some sh** head <span style='color:blue' title='I&#39;m naughty, are you naughty?'>smurf</span> that thinks he's all cool...

Posted: Sun Sep 21, 2003 6:40 am
by FinalAeon
but of course if you do know then i have respect for you of course. just so u know that i'm not a <span style='color:blue' title='I&#39;m naughty, are you naughty?'>smurf</span> head. :lol: