Kloshke Posted January 29, 2013 Group: Members Topic Count: 15 Topics Per Day: 0.00 Content Count: 52 Reputation: 0 Joined: 12/08/12 Last Seen: August 30, 2013 Share Posted January 29, 2013 (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 January 29, 2013 by Kloshke Quote Link to comment Share on other sites More sharing options...
Emistry Posted January 29, 2013 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10015 Reputation: 2348 Joined: 10/28/11 Last Seen: May 6 Share Posted January 29, 2013 trunk/sql-files/upgrades/upgrade_svn17080.sql trunk/sql-files/upgrades/upgrade_svn17080_log.sql trunk/sql-files/upgrades/upgrade_svn17086.sql trunk/sql-files/upgrades/upgrade_svn17086_log.sql Quote Link to comment Share on other sites More sharing options...
Kloshke Posted January 29, 2013 Group: Members Topic Count: 15 Topics Per Day: 0.00 Content Count: 52 Reputation: 0 Joined: 12/08/12 Last Seen: August 30, 2013 Author Share Posted January 29, 2013 (edited) trunk/sql-files/upgrades/upgrade_svn17080.sql trunk/sql-files/upgrades/upgrade_svn17080_log.sql trunk/sql-files/upgrades/upgrade_svn17086.sql trunk/sql-files/upgrades/upgrade_svn17086_log.sql 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 January 29, 2013 by Kloshke Quote Link to comment Share on other sites More sharing options...
Brian Posted January 29, 2013 Group: Members Topic Count: 75 Topics Per Day: 0.02 Content Count: 2223 Reputation: 593 Joined: 10/26/11 Last Seen: June 2, 2018 Share Posted January 29, 2013 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. Quote Link to comment Share on other sites More sharing options...
Question
Kloshke
I just updated my svn and I keep getting this following error.
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 KloshkeLink to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.