Jump to content
  • 0

Question

Posted (edited)

I just updated my svn and I keep getting this following error.

[sql]: DB error - Unknown column 'unique_id' in 'field list' [Debug]: at log.c:198 - INSERT DELAYED INTO `picklog`
(`time`, `char_id`, `type`, `nameid`, `amount`, `refine`, `card0`, `card1`, `card2`, `card3`, `map`, `unique_id`) VALUES (NOW(), '150051', 'P', '569', '-6', '0', '0', '0', '0', '0', 'odin_tem02', '0')

I searched about it and tried fixing it the whole day, but I keep getting the error every time i drop an item, pick up an item or use an item.

Please help me fix this >_<

Edited by Kloshke

3 answers to this question

Recommended Posts

Posted (edited)

I added all of the above and still get the error.....

[sql]: DB error - Unknown column 'unique_id' in 'field list'
[Debug]: at log.c:198 - INSERT DELAYED INTO `picklog` (`time`, `char_id`, `type`, `nameid`, `amount`, `refine`, `card0`, `card1`, `card2`, `card3`, `map`, `unique_id`) VALUES (NOW(), '150047', 'P', '687', '-1', '0', '0', '0', '0', '0', 'prontera', '0')

Also.... I noticed this error

[Error]: make_connection: connect failed (socket #6, error 111: Connection refused)!
[status]: Memory manager initialised: log/map-server_sql.leaks

what does this mean?

Edited by Kloshke
Posted
I added all of the above and still get the error.....

Are you sure you applied the SQL Upgrades to the correct databases?

Upgrade files ending in "_log" should be applied to the log database.

Upgrade files with no suffix are applied to the ragnarok database.

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.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...