mysql error

[AleCSu 0]

Hello ,i started a metin2 server with hamachi just for me ,and i get this mysql error..

[code]

SYSERR: Feb 25 20:50:42 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'shop_item.price_vnum' in 'field list'
query: SELECT shop.vnum, shop.npc_vnum, shop_item.item_vnum, shop_item.count ,shop_item.price_vnum ,shop_item.price FROM shop LEFT JOIN shop_item ON shop.vnum = shop_item.shop_vnum ORDER BY shop.vnum, shop_item.item_vnum
SYSERR: Feb 25 20:50:42 :: InitializeShopTable: InitializeShopTable : Table count is zero.
SYSERR: Feb 25 20:50:42 :: InitializeTables: InitializeShopTable FAILED
SYSERR: Feb 25 20:50:42 :: Initialize: Table Initialize FAILED
SYSERR: Feb 25 20:50:42 :: pid_deinit: 
End of pid

SYSERR: Feb 25 20:53:24 :: pid_init: 
Start of pid: 1267

SYSERR: Feb 25 20:53:26 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'shop_item.price_vnum' in 'field list'
query: SELECT shop.vnum, shop.npc_vnum, shop_item.item_vnum, shop_item.count ,shop_item.price_vnum ,shop_item.price FROM shop LEFT JOIN shop_item ON shop.vnum = shop_item.shop_vnum ORDER BY shop.vnum, shop_item.item_vnum
SYSERR: Feb 25 20:53:26 :: InitializeShopTable: InitializeShopTable : Table count is zero.
SYSERR: Feb 25 20:53:26 :: InitializeTables: InitializeShopTable FAILED
SYSERR: Feb 25 20:53:26 :: Initialize: Table Initialize FAILED
SYSERR: Feb 25 20:53:26 :: pid_deinit: 
End of pid

[/code]

[caanmasu 309]

Add a new column in shop_item called "price_vnum", int 11 default 0
I guess that you need "price_count" too.

[AleCSu 0]

for price_count i already "count" it's same or?

[caanmasu 309]

Ye

Both are integer

[AleCSu 0]

and i need to put that twice?

 

EDIT: i added that and i have the same error..

Edited February 25, 2023 by AleCSu