Cevaplandı Mysql DirectQuery Problem

  • Konuyu başlatan Konuyu başlatan essayx
  • Başlangıç tarihi Başlangıç tarihi
  • Cevaplar Cevaplar 1
  • Görüntüleme Görüntüleme 483

essayx

Level 1
Katılım
22 Eyl 2021
Konular
2
Mesajlar
48
Online süresi
9d 1h
Reaksiyon Skoru
14
Altın Konu
0
TM Yaşı
4 Yıl 8 Ay 17 Gün
Başarım Puanı
50
MmoLira
5,436
DevLira
3
Ticaret - 0%
0   0   0

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]
 
Columns in DB source code do not match in SQL. You should check and add the missing columns where necessary.
 
Çözüm

Şu an konuyu görüntüleyenler (Toplam : 0, Üye: 0, Misafir: 0)