Çözüldü Battle Pass Sistemi Mysql Hatası

lmaohw demiş ki:

Selamlar, battle pass sistemi ekledim fakat mysqle eklemem gereken sütunları ekleyince hata alıyorum

db.sysser:

SYSERR: May 31 10:53:57 :: ChildLoop: AsyncSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNIX_TIMESTAMP(battle_pass_end) statistics_jinno_kills, statistics_shinsoo_kills' at line 1 (query: SELECT id,name,job,voice,dir,x,y,z,map_index,exit_x,exit_y,exit_map_index,hp,mp,stamina,random_hp,random_sp,playtime,gold,level,level_step,st,ht,dx,iq,exp,stat_point,skill_point,sub_skill_point,stat_reset_count,part_base,part_hair,part_acce, skill_level,quickslot,skill_group,alignment,mobile,horse_level,horse_riding,horse_hp,horse_hp_droptime,horse_stamina,UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(last_play),UNIX_TIMESTAMP(last_play),horse_skill_point,,UNIX_TIMESTAMP(battle_pass_end) statistics_jinno_kills, statistics_shinsoo_kills, statistics_chunjo_kills, statistics_total_kills,statistics_total_deaths,statistics_duels_won, statistics_duels_lost, statistics_bosses_kills, statistics_stones_kills, statistics_mobs_kills , t
SYSERR: May 31 10:53:57 :: RESULT_COMPOSITE_PLAYER: null MYSQL_RES QID 0

fazladan 1 virgül var bunu nasıl düzeltirim player tablomu .sql olarak dışarı çıkarıyorum orada bir sorun yok

SQL:

ALTER TABLE `player`
ADD COLUMN `battle_pass_end` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP AFTER `horse_skill_point`;

ALTER TABLE `player_deleted`
ADD COLUMN `battle_pass_end` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP AFTER `horse_skill_point`;

bunu kullandım fakat yine 2 virgül hatası var

Hepsini görmek için tıklayın...

hasanmacit demiş ki:

sql ile indirip manuel olarak düzelt virgülü

Hepsini görmek için tıklayın...