| |
Haven't registered yet? Do it here now!
|
hjnet
Joined: 12 Apr 2007
Posts: 3
|
|
|
 |
|
 |
|
 Posted: Thu Apr 12, 2007 8:50 am Post subject: Can't open file: 'loinstats.MYD'. (errno: 144) |
 |
|
|
 |
|
 |
|
|
|
|
I'm getting a MySQl error since a few days when I'm trying to take a look at my trade stats. The script always comes up with an error message like "Can't open file: 'loinstats.MYD'. (errno: 144)".
I've already tried to access the stats table (loinstats) via PHPMyAdmin, but the same error comes up.
So I'd like to creat the loinstats table manually again, but I'd need a SQL query with all required info for fields and keys therefore  |
|
|
|
|
|
|
|
Atanasis
Owner
Joined: 22 May 2004
Posts: 4284
Location: The Net
|
|
|
|
|
|
|
| Posted: Thu Apr 12, 2007 11:42 am Post subject: |
|
|
|
|
|
|
|
|
|
|
hey there, well thats because the table got corrupted. Do a repair on the table with your phpmyadmin or try with mysql query:
REPAIR table loinstats;
if that doesn't help, i will paste you the query to recreate the table manually.
_________________
Thanks,
Kaktusan
 |
|
|
|
|
|
|
|
hjnet
Joined: 12 Apr 2007
Posts: 3
|
|
|
|
|
|
|
| Posted: Thu Apr 12, 2007 4:20 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
| Unfortunately there aren't any fields left in loinstats to get repaired, so it would be great if you could give me the query to re-create it manually. |
|
|
|
|
|
|
|
Atanasis
Owner
Joined: 22 May 2004
Posts: 4284
Location: The Net
|
|
|
|
|
|
|
| Posted: Thu Apr 12, 2007 4:29 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
okay, here you go:
CREATE TABLE `loinstats` (
`site_id` mediumint( unsigned NOT NULL default '0',
`trade_id` mediumint( unsigned NOT NULL default '0',
`datata` bigint(20) unsigned NOT NULL default '0',
`hits_unique` mediumint( unsigned NOT NULL default '0',
`hits_raw` mediumint( unsigned NOT NULL default '0',
PRIMARY KEY (`site_id`,`trade_id`,`datata`),
KEY `hit_unique` (`hits_unique`),
KEY `hit_raw` (`hits_raw`),
KEY `trade_id` (`trade_id`,`datata`));
_________________
Thanks,
Kaktusan
|
|
|
|
|
|
|
|
hjnet
Joined: 12 Apr 2007
Posts: 3
|
|
|
|
|
|
|
| Posted: Thu Apr 12, 2007 6:15 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
| Thanks, looks like it works again |
|
|
|
|
|
|
|
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
|
 |
|
 |
| |
