OFFLINE SHOP BUG TIME

[Quick123456 0]

Hi all, I'm encountering this error when I try to open the offline shop I can't open it in any way. I can't see the time, i.e. time and day. Checking for errors and both client-side and server-side nothing is specified... Does anyone know how to fix it?

Edited January 5 by Metin2 Dev International
Core X - External 2 Internal

[Psycho 85]

4 hours ago, Quick123456 said:

Hi all, I'm encountering this error when I try to open the offline shop I can't open it in any way. I can't see the time, i.e. time and day. Checking for errors and both client-side and server-side nothing is specified... Does anyone know how to fix it?

syserr client?

[Quick123456 0]

1. SYSERR: Jan  6 00:47:27 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.player_shop_items' doesn't exist
2. query: SELECT ps.id,ps.player_id,REPLACE('#PLAYER_NAME# Shop','#PLAYER_NAME#',p.name),ps.vnum,ps.count,ps.price,ps.socket0,ps.socket1,ps.socket2,ps.attrtype0,attrvalue0,ps.attrtype1,attrvalue1,ps.attrtype2,attrvalue2,ps.attrtype3,attrvalue3,ps.attrtype4,attrvalue4,ps.attrtype5,attrvalue5,ps.attrtype6,attrvalue6 FROM `player_shop_items` ps LEFT JOIN player p ON p.id=ps.player_id where not EXISTS(select name from player_shop WHERE id=ps.shop_id) and not ISNULL(p.name)
3. SYSERR: Jan  6 01:47:26 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.player_shop_items' doesn't exist
4. query: SELECT ps.id,ps.player_id,REPLACE('#PLAYER_NAME# Shop','#PLAYER_NAME#',p.name),ps.vnum,ps.count,ps.price,ps.socket0,ps.socket1,ps.socket2,ps.attrtype0,attrvalue0,ps.attrtype1,attrvalue1,ps.attrtype2,attrvalue2,ps.attrtype3,attrvalue3,ps.attrtype4,attrvalue4,ps.attrtype5,attrvalue5,ps.attrtype6,attrvalue6 FROM `player_shop_items` ps LEFT JOIN player p ON p.id=ps.player_id where not EXISTS(select name from player_shop WHERE id=ps.shop_id) and not ISNULL(p.name)
5. SYSERR: Jan  6 02:47:24 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.player_shop_items' doesn't exist
6. query: SELECT ps.id,ps.player_id,REPLACE('#PLAYER_NAME# Shop','#PLAYER_NAME#',p.name),ps.vnum,ps.count,ps.price,ps.socket0,ps.socket1,ps.socket2,ps.attrtype0,attrvalue0,ps.attrtype1,attrvalue1,ps.attrtype2,attrvalue2,ps.attrtype3,attrvalue3,ps.attrtype4,attrvalue4,ps.attrtype5,attrvalue5,ps.attrtype6,attrvalue6 FROM `player_shop_items` ps LEFT JOIN player p ON p.id=ps.player_id where not EXISTS(select name from player_shop WHERE id=ps.shop_id) and not ISNULL(p.name)
7. SYSERR: Jan  6 03:47:22 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.player_shop_items' doesn't exist
8. query: SELECT ps.id,ps.player_id,REPLACE('#PLAYER_NAME# Shop','#PLAYER_NAME#',p.name),ps.vnum,ps.count,ps.price,ps.socket0,ps.socket1,ps.socket2,ps.attrtype0,attrvalue0,ps.attrtype1,attrvalue1,ps.attrtype2,attrvalue2,ps.attrtype3,attrvalue3,ps.attrtype4,attrvalue4,ps.attrtype5,attrvalue5,ps.attrtype6,attrvalue6 FROM `player_shop_items` ps LEFT JOIN player p ON p.id=ps.player_id where not EXISTS(select name from player_shop WHERE id=ps.shop_id) and not ISNULL(p.name)
    

I found this error today ,thanks can you help me?

[Filachilla 29]

Do you have added mysql tables for shop?

"Table 'account.player_shop_items' doesn't exist"

[Quick123456 0]

guys thanks to all for the info, but looking around a bit I found out where the reading error was. I leave a small example for the next ones who will have this kind of problem ! Thank you

You must change CONFIG in core

a

PLAYER_SQL: localhost  ID PASSWORD account

whit 

PLAYER_SQL: localhost  ID PASSWORD player

 

risoluto