Jump to content
  • 0

Help me in Personal Scavenger


Legacy

Question


  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  21
  • Reputation:   0
  • Joined:  12/24/11
  • Last Seen:  

Im using this script jTynne Personal Scavenger Script 

 

http://jtynne.com/rAthena/scripts/examples/personalscavenger.txt

I encounter this problem How to solve this? :(

 

[SQL]: DB error - INSERT command denied to user 'ragnarok'@'ADRIAN-PC' for table 'scavenger'
[Debug]: at d:\rathenaclean\src\map\script.c:14605 - insert into `game_data`.`scavenger` (`char_id`,`score`,`completed`,`failed`,`alltimescore`,`alltimecompleted`,`alltimefailed`) VALUES ('150004', '0', '0', '0', '0', '0', '0')
[Debug]: Source (NPC): Personal Scavenger at quiz_02 (360,346)
[SQL]: DB error - SELECT command denied to user 'ragnarok'@'ADRIAN-PC' for table 'scavenger'
[Debug]: at d:\rathenaclean\src\map\script.c:14605 - select game_data.scavenger.score AS score , game_data.char.name AS charname FROM game_data.scavenger, game_data.char WHERE game_data.scavenger.char_id = game_data.char.char_id ORDER BY game_data.scavenger.score DESC LIMIT 10
[Debug]: Source (NPC): Scavenger Rankings at quiz_02 (366,346)
[SQL]: DB error - Table 'ragnarok.scavenger' doesn't exist
[Debug]: at d:\rathenaclean\src\map\script.c:14605 - UPDATE `scavenger` SET `score` = `score` + '1' WHERE `char_id` =  '150004'
[SQL]: DB error - Table 'ragnarok.scavenger' doesn't exist
[Debug]: Source (NPC): Personal Scavenger at quiz_02 (360,346)
[SQL]: DB error - Table 'ragnarok.scavenger' doesn't exist
[Debug]: at d:\rathenaclean\src\map\script.c:14605 - UPDATE `scavenger` SET `alltimescore` = `alltimescore` + '1' WHERE `char_id` =  '150004'
[SQL]: DB error - Table 'ragnarok.scavenger' doesn't exist
[Debug]: Source (NPC): Personal Scavenger at quiz_02 (360,346)
[Debug]: at d:\rathenaclean\src\map\script.c:14605 - UPDATE `scavenger` SET `completed` = `completed` + '1' WHERE `char_id` =  '150004'
[Debug]: Source (NPC): Personal Scavenger at quiz_02 (360,346)
[Debug]: at d:\rathenaclean\src\map\script.c:14605 - UPDATE `scavenger` SET `alltimecompleted` = `alltimecompleted` + '1' WHERE `char_id` =  '150004'
[Debug]: Source (NPC): Personal Scavenger at quiz_02 (360,346)
[SQL]: DB error - SELECT command denied to user 'ragnarok'@'BLOODLINE-PC' for table 'scavenger'
[Debug]: at d:\rathenaclean\src\map\script.c:14605 - select game_data.scavenger.score AS score , game_data.char.name AS charname FROM game_data.scavenger, game_data.char WHERE game_data.scavenger.char_id = game_data.char.char_id ORDER BY game_data.scavenger.score DESC LIMIT 10
[Debug]: Source (NPC): Scavenger Rankings at quiz_02 (366,346)

 

 

Link to comment
Share on other sites

3 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  182
  • Reputation:   36
  • Joined:  01/26/12
  • Last Seen:  

Go to your MySQL administration tool and give your 'ragnarok' user SELECT, INSERT, UPDATE and DELETE permissions for the `scavenger` table and you'll be good to go.

Edited by jaBote
Link to comment
Share on other sites


  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10013
  • Reputation:   2345
  • Joined:  10/28/11
  • Last Seen:  

[SQL]: DB error - Table 'ragnarok.scavenger' doesn't exist

 

you didnt have the scavenger sql table ....ask Jtynne for that SQL table since he didnt included the table in his script..

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  21
  • Reputation:   0
  • Joined:  12/24/11
  • Last Seen:  

[SQL]: DB error - Table 'ragnarok.scavenger' doesn't exist

 

you didnt have the scavenger sql table ....ask Jtynne for that SQL table since he didnt included the table in his script..

 

Is there a way how I can make a SQL for that?

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...