Author Topic: Treestats problem
Bellona_SC 
Posts: ????
Registered: ????
Extended Info (if available)
Real Post Cnt: 0
User ID: 0
Subject: Treestats problem
I get the following error when I try to search using the skills rank options.


MySQL Query Error:
Error: 1016: Can't open file: 'skills.MYI'. (errno: 145)
Query: SELECT Skill.CurrentVal, Chars.CharLevel, Chars.Name, Chars.Template, Chars.Server, Mon.Name, Chars.Rank, Chars.Followers, Chars.LastUpdate FROM Chars INNER JOIN Chars Mon ON Mon.GUID = Chars.Monarch AND Mon.Server = Chars.Server INNER JOIN Skills Skill ON Skill.GUID = Chars.GUID AND Skill.Server = Chars.Server AND Skill.SkillNum = 38 ORDER BY Skill.CurrentVal DESC LIMIT 50
--------------------------------------------------------------------------------

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Inetpub\www.treestats.com\dbwrap.php on line 56

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Inetpub\www.treestats.com\dbwrap.php on line 56
Previous Page - Next Page -
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Inetpub\www.treestats.com\dbwrap.php on line 56
Starting at result #1 and listing 0 results...
Alchemy Level Name Template Server Monarch Rank Followers Updated

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Inetpub\www.treestats.com\dbwrap.php on line 50
Time for Full Page Send: 0.025s - 1 Queries



When trying to ID a specific char I get:

MySQL Query Error:
Error: 1016: Can't open file: 'skills.MYI'. (errno: 145)
Query: SELECT * FROM Skills WHERE GUID = 1342652050 AND Server = 7
--------------------------------------------------------------------------------

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Inetpub\www.treestats.com\dbwrap.php on line 50

 

-----signature-----
Link to this post
-Zalliun- 
Posts: 13,296
Registered: Jan 30, '02
Extended Info (if available)
Real Post Cnt: 13,116
User ID: 638,564
Subject: Treestats problem
mysql> use treestats2
Database changed
mysql> repair table skills
-> \g
+-------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------------+--------+----------+----------+
| treestats2.skills | repair | status | OK |
+-------------------+--------+----------+----------+
1 row in set (11.47 sec)

mysql>

---

looks like treestats.com is gone again and that treestats.akilla.net isnt pointing the right place.

 

-----signature-----
Fake it till you make it
Link to this post
Bellona_SC 
Posts: ????
Registered: ????
Extended Info (if available)
Real Post Cnt: 0
User ID: 0
Subject: Treestats problem
All better now, thanks!

 

-----signature-----
Link to this post

Valid XHTML 1.0 Transitional Powered by PHP