Jump to content
  • 0

DB error table 'ragnarok.picklog' does not exist.


ScriptingPhailure

Question


  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  87
  • Reputation:   21
  • Joined:  01/13/12
  • Last Seen:  

everytime a monster is killed no exp is gained and it drops no item. The console displays this:

[SQL]: DB error - Table 'ragnarok.picklog' doesn't exist
[Debug]: at c:\users\azure\desktop\awesome 2.0\src\map\log.c:210 - INSERT DELAYE
D INTO `picklog` (`time`, `char_id`, `type`, `nameid`, `amount`, `refine`, `card
0`, `card1`, `card2`, `card3`, `map`, `unique_id`) VALUES (NOW(), '150000', 'N',
 '2352', '1', '0', '0', '0', '0', '0', 'new_1-2', '0')

Using rAthena revision 17435

 

Edit: Apparently logs and main have to be in the ragnarok schema, the guide I followed on youtube had them as separate schemas.

 

By putting both sql files under 1 schema the errors in the console was resolved and monsters now drop items and give exp however the exp gain is not shown unless the character logs out then back in.

Edited by ScriptingPhailure
Link to comment
Share on other sites

2 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  55
  • Topics Per Day:  0.01
  • Content Count:  1191
  • Reputation:   161
  • Joined:  06/12/12
  • Last Seen:  

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  87
  • Reputation:   21
  • Joined:  01/13/12
  • Last Seen:  

Turns out the problem was client side, I used a different client and the problem resolved itself.

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