Kloshke Posted January 29, 2013 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
Emistry Posted January 29, 2013 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
Kloshke Posted January 29, 2013 Author 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
Brian Posted January 29, 2013 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
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 Kloshke3 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.