| |
Haven't registered yet? Do it here now!
|
rhino
Joined: 07 Aug 2007
Posts: 57
|
|
|
 |
|
 |
|
 Posted: Fri Feb 29, 2008 12:39 am Post subject: Error when I try to access BO admin? |
 |
|
|
 |
|
 |
|
|
|
|
Query to MySQL Failed: Can't open file: 'boposts.MYI' (errno: 144)
Getting this error when I try to access the BO admin... Administration controls display, but then the error message displays below the controls?
I ran perror 144 from shell, but all it tells me is MySQL error code 144: Table is crashed and last repair failed
No clue how to fix/restore from there. PM sent with login info.
Rhino |
|
|
|
|
|
|
|
Atanasis
Owner
Joined: 22 May 2004
Posts: 4284
Location: The Net
|
|
|
|
|
|
|
| Posted: Fri Feb 29, 2008 1:29 am Post subject: |
|
|
|
|
|
|
|
|
|
|
go in phpmyadmin or on the mysql command line type:
REPAIR table boposts;
_________________
Thanks,
Kaktusan
 |
|
|
|
|
|
|
|
rhino
Joined: 07 Aug 2007
Posts: 57
|
|
|
|
|
|
|
| Posted: Fri Feb 29, 2008 3:33 am Post subject: |
|
|
|
|
|
|
|
|
|
|
Looks like that fixed the problem... thanks!
Had noticed that the server hosting the BO/BA/GS/LO scripts was starting to see some load issues when the MySQL tasks were running... pretty much figured it was due to the number of blogs currently supported.
Would it be possible to get the shell command line command(s) to repair and optimize the DB tables? (Even better - can you add these tasks to the BO Admin Panel under General Settings on a future script update? The thumbs script I use has this feature available... might save someone else from this problem.)
I understand it might not work with my setup due to the size of my DB, so asking about the command option. (Your suggestion to run the DB backup from cron works well, would be easy to add another cronjob to maintain the DB... and might speed it up too.)
Rhino |
|
|
|
|
|
|
|
Atanasis
Owner
Joined: 22 May 2004
Posts: 4284
Location: The Net
|
|
|
|
|
|
|
| Posted: Fri Feb 29, 2008 1:09 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
all my scripts automatically optimize the databases every once in a while..sor no worries about that.. No need to extra optimization script, since it will do same..
In BA i implemented autorepair mechanism in case of corrupted tables like yours, so in next BO update i will add it too.
_________________
Thanks,
Kaktusan
|
|
|
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2002 phpBB Group
|
 |
|
 |
| |
