Jump to content
  • 0

Ivion's Ranker sql error


rqueen

Question


  • Group:  Members
  • Topic Count:  20
  • Topics Per Day:  0.00
  • Content Count:  82
  • Reputation:   1
  • Joined:  04/30/13
  • Last Seen:  

I'm planning to use Ivion's Ranker for our server.

 

If you're not familiar with it, it's this one:

http://www.eathena.ws/board/Ranker-v11-Ingame-Txt-and-Sql-ranking-t193726.html

 

Anyway, when I tried loading it, I'm getting these errors: (we're on eA btw)


: DB error - CREATE command denied to user 'testserver@localhost' for table 'ranker_char'
[Debug]: at script.c:12376 - CREATE TABLE IF NOT EXISTS `ranker_char` (`char_id` int(11) unsigned NOT NULL default '0', `offline` tinyint unsigned NOT NULL default '0')
[Debug]: Source (NPC): ranker (invisible/not on a map)
[sql]: DB error - CREATE command denied to user 'testserver'@'localhost' for table 'ranker_guild'
[Debug]: at script.c:12376 - CREATE TABLE IF NOT EXISTS `ranker_guild` (`guild_id` int(11) unsigned)

 

Also, while we're in this topic, I've been looking around rA for a more recent dynamic ranker release, but I haven't seen any?

Edited by Capuche
Change the title for a more informative one.
Link to comment
Share on other sites

4 answers to this question

Recommended Posts


  • Group:  Developer
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  2407
  • Reputation:   613
  • Joined:  07/05/12
  • Last Seen:  

: DB error - CREATE command denied to user 'testserver@localhost' for table 'ranker_char'

Change the privilege for the user testserver in mysql.

  • Upvote 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  38
  • Topics Per Day:  0.01
  • Content Count:  276
  • Reputation:   24
  • Joined:  07/06/13
  • Last Seen:  

Did you follow correctly the installation guide? in 

http://www.eathena.ws/board/Ranker-v11-Ingame-Txt-and-Sql-ranking-t193726.html

If yes? Do you use rAthena? Well idk if that ranker can be used in new rathena revisions. What ranker would you like? If I bump into one topic. I will pm you right away.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  20
  • Topics Per Day:  0.00
  • Content Count:  82
  • Reputation:   1
  • Joined:  04/30/13
  • Last Seen:  

Did you follow correctly the installation guide? in 

http://www.eathena.ws/board/Ranker-v11-Ingame-Txt-and-Sql-ranking-t193726.html

If yes? Do you use rAthena? Well idk if that ranker can be used in new rathena revisions. What ranker would you like? If I bump into one topic. I will pm you right away.

Yes, I followed the guide real carefully.

No, we're on eA, as I stated above. XD I'd like a PvP, Guild, and Emperium ranker. I'm really surprised there are no other ranker releases after Ivion's though.

 

 

: DB error - CREATE command denied to user 'testserver@localhost' for table 'ranker_char'

Change the privilege for the user testserver in mysql.

Thanks! I'd like to this but, I'm using phpmyadmin and I can't seem to find where to do that, any ideas?

Link to comment
Share on other sites


  • Group:  Developer
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  2407
  • Reputation:   613
  • Joined:  07/05/12
  • Last Seen:  

users -> change privilege -> create -> execute

  • Upvote 1
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...