Please Help with Sql Base

[qabakrall]

Please help to correct the error:

: DB error - Unknown column 'vend_coin' in 'field list'

	[Debug]: at ..\src\map\vending.c:633 - SELECT `id`, `account_id`, `char_id`, `se

	x`, `title`, `body_direction`, `head_direction`, `sit`, `vend_coin` FROM `vendin

	gs` WHERE `autotrade` = 1 AND (SELECT COUNT(`vending_id`) FROM `vending_items` W

	HERE `vending_id` = `id`) > 0 ORDER BY `id`;


	CREATE TABLE IF NOT EXISTS `vendings` (

	  `id` int(10) unsigned NOT NULL,

	  `account_id` int(11) unsigned NOT NULL,

	  `char_id` int(10) unsigned NOT NULL,

	  `sex` enum('F','M') NOT NULL DEFAULT 'M',

	  `map` varchar(20) NOT NULL,

	  `x` smallint(5) unsigned NOT NULL,

	  `y` smallint(5) unsigned NOT NULL,

	  `title` varchar(80) NOT NULL,

	  `body_direction` CHAR( 1 ) NOT NULL DEFAULT '4',

	  `head_direction` CHAR( 1 ) NOT NULL DEFAULT '0',

	  `sit` CHAR( 1 ) NOT NULL DEFAULT '1',

	  `autotrade` tinyint(4) NOT NULL,

	  PRIMARY KEY (`id`)

	) ENGINE=MyISAM;

[Promise]

Try to add this on your SQL:

ALTER TABLE vendings ADD vend_coin VARCHAR(5) NOT NULL;

 

[qabakrall]

thank you so much!!

[qabakrall]

Sorry but i have one error more, Please help mee

: DB error - Unknown column 'option_id0' in 'field list'

	[Debug]: at ..\src\char\int_auction.c:223 - SELECT `auction_id`,`seller_id`,`sel

	ler_name`,`buyer_id`,`buyer_name`,`price`,`buynow`,`hours`,`timestamp`,`nameid`,

	`item_name`,`type`,`refine`,`attribute`,`unique_id`,`card0`,`card1`,`card2`,`car

	d3`, `option_id0`, `option_val0`, `option_parm0`, `option_id1`, `option_val1`, `

	option_parm1`, `option_id2`, `option_val2`, `option_parm2`, `option_id3`, `optio

	n_val3`, `option_parm3`, `option_id4`, `option_val4`, `option_parm4` FROM `aucti

	on` ORDER BY `auction_id` DESC

	[Status]: Finished Reading GeoIP Database.

	[Status]: Characters per Account: '0'.

	[Info]: Start checking DB integrity

	[SQL]: DB error - Unknown column 'hotkey_rowshift' in 'field list'

	[Debug]: at ..\src\char\char.c:2992 - SELECT `char_id`,`account_id`,`char_num`,`

	name`,`class`,`base_level`,`job_level`,`base_exp`,`job_exp`,`zeny`,`str`,`agi`,`

	vit`,`int`,`dex`,`luk`,`max_hp`,`hp`,`max_sp`,`sp`,`status_point`,`skill_point`,

	`option`,`karma`,`manner`,`party_id`,`guild_id`,`pet_id`,`homun_id`,`elemental_i

	d`,`hair`,`hair_color`,`clothes_color`,`weapon`,`shield`,`head_top`,`head_mid`,`

	head_bottom`,`robe`,`last_map`,`last_x`,`last_y`,`save_map`,`save_x`,`save_y`,`p

	artner_id`,`online`,`father`,`mother`,`child`,`fame`,`rename`,`delete_date`,`mov

	es`,`unban_time`,`font`,`sex`,`hotkey_rowshift` FROM `char` LIMIT 1;

	[Fatal Error]: char : A tables is missing in sql-server, please fix it, see (sql

	-files main.sql for structure)

[Cyro]

Please upgrade your sql database using upgrade sql files in sql-files/upgrades

 

This particular error will be solved by upgrading using this file 

https://github.com/rathena/rathena/blob/master/sql-files/upgrades/upgrade_20160814.sql

[qabakrall]

Another Problem: I can not found in Updates this:

: DB error - Unknown column 'unique_id' in 'field list'

	[Debug]: at ..\src\login\loginlog.c:94 - INSERT INTO `loginlog`(`time`,`ip`,`use

	r`,`rcode`, `unique_id`,`log`) VALUES (NOW(), '0.0.0.0', 'login server', '100',

	'0', 'login server started')

[Cyro]

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

 

 

please take a backup before you run it