VaultNetwork.net Vault Network Boards
Author Topic: Treestats problem [Locked]
Bellona_SC
Posts: 41
Registered:
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
-Zalliun-  1 star
Posts: 89
Registered: 2002-1-30 14:07:47
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
Bellona_SC
Posts: 41
Registered:
All better now, thanks!

VaultNetwork.net is an independently operated community forum and is not affiliated with, endorsed by, or technically based on IGN, GameSpy, FilePlanet, GameStats, or the former IGN/GameSpy Vault Network.
References to VaultNetwork.net mean this site/domain. VNBoards-style presentation is a visual homage only. By using this site, you agree to the forum rules.