database problem

[Akiza Izinsky]

: DB error - Unknown column 'unique_id' in 'field list'
[Debug]: at log.c:211 - INSERT DELAYED INTO `picklog` (`time`, `char_id`, `type`, `nameid`, `amount`, `refine`, `card0`, `card1`, `card2`, `card3`, `map`, `unique_id`) VALUES (NOW(), '1639', 'M', '2404', '-1', '0', '0', '0', '0', '0', 'lhz_dun03', '0')
 

can someone help me, there`s nothing wrong with the RO. it`s just it`s pretty disturbing everytime i monitoring the putty.

[Patskie]

Execute this on your database :

ALTER TABLE `picklog` ADD COLUMN `unique_id` bigint(20) unsigned NOT NULL default '0';

[sandbox]

It means your SQL is not paired with your SVN.. picklog table has a new column `unique_id` which has not been recognized by logs.c.. try updating it

[Akiza Izinsky]

how ?