Cevaplandı Mysql DirectQuery Problem

[essayx]

ROHAN2 WORLD 1-120 TR TİPİ OFFICIAL YOHARA, BALATHOR VE AMON! 80. GÜNÜNDE! +10.000 ONLİNE! HİLE VE BOT %100 ENGELLİ HEMEN TIKLA!

I have this problem with this serverfile, and i don't know how to solve mysql problem.
[CODE title="Chanels"]SYSERR: Aug 21 15:38:07 :: pid_init:
Start of pid: 1129

SYSERR: Aug 21 15:38:11 :: CreateShops: Downloading shops list..
SYSERR: Aug 21 15:38:11 :: CreateShops: Passed disable off_shop check
SYSERR: Aug 21 15:38:11 :: DirectQuery: AsyncSQL:irectQuery : mysql_query error: Unknown column 'ps.look' in 'field list'
query: SELECT ps.id,ps.player_id,REPLACE('#PLAYER_NAME# Shop','#PLAYER_NAME#',p.name),ps.vnum,ps.count,ps.look,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)[/CODE]
[CODE title="Client"]0821 13:20:07437 :: RaceManager::CreateRace : Race 0 already created
0821 13:20:07441 :: RaceManager::CreateRace : Race 4 already created
0821 13:20:07444 :: RaceManager::CreateRace : Race 1 already created
0821 13:20:07447 :: RaceManager::CreateRace : Race 5 already created
0821 13:20:07450 :: RaceManager::CreateRace : Race 2 already created
0821 13:20:07452 :: RaceManager::CreateRace : Race 6 already created
0821 13:20:07455 :: RaceManager::CreateRace : Race 3 already created
0821 13:20:07458 :: RaceManager::CreateRace : Race 7 already created[/CODE]

 

[Dr.Legendy]

Columns in DB source code do not match in SQL. You should check and add the missing columns where necessary.