Pixelated a phpBB Template by SkaidonDesigns
 
Cheapest Web Software Support Area Forum Index www.cheapestwebsoftware.com
Play with the Best, be the Best!
Cheapest Web Software
FAQ
Search
Memberlist
Usergroups
Profile
Log in to check your private messages
Log in

The Mightiest Webmaster Solutions Ever
Plug Rush
Plug Rush
Blogs Automater
Blogs Automater
Rocket Pinger
Rocket Pinger
Special Offers
Special Offers

Haven't registered yet? Do it here now!
Can't open file: 'loinstats.MYD'. (errno: 144)

 
Post new topic   Reply to topic    Cheapest Web Software Support Area Forum Index -> Links Organizer
View previous topic :: View next topic  
Author Message
hjnet



Joined: 12 Apr 2007
Posts: 3

PostPosted: Thu Apr 12, 2007 8:50 am    Post subject: Can't open file: 'loinstats.MYD'. (errno: 144) Reply with quote
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 Smile
Back to top
View user's profile Send private message

Author Message
Atanasis
Owner


Joined: 22 May 2004
Posts: 4284
Location: The Net

PostPosted: Thu Apr 12, 2007 11:42 am    Post subject: Reply with quote
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

Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger ICQ Number

Author Message
hjnet



Joined: 12 Apr 2007
Posts: 3

PostPosted: Thu Apr 12, 2007 4:20 pm    Post subject: Reply with quote
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. Smile
Back to top
View user's profile Send private message

Author Message
Atanasis
Owner


Joined: 22 May 2004
Posts: 4284
Location: The Net

PostPosted: Thu Apr 12, 2007 4:29 pm    Post subject: Reply with quote
okay, here you go:

CREATE TABLE `loinstats` (
`site_id` mediumint(Cool unsigned NOT NULL default '0',
`trade_id` mediumint(Cool unsigned NOT NULL default '0',
`datata` bigint(20) unsigned NOT NULL default '0',
`hits_unique` mediumint(Cool unsigned NOT NULL default '0',
`hits_raw` mediumint(Cool 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

Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger ICQ Number

Author Message
hjnet



Joined: 12 Apr 2007
Posts: 3

PostPosted: Thu Apr 12, 2007 6:15 pm    Post subject: Reply with quote
Thanks, looks like it works again Smile
Back to top
View user's profile Send private message

Display posts from previous:   
Post new topic   Reply to topic    Cheapest Web Software Support Area Forum Index -> Links Organizer All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
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