Erorr Player Mysql

[DoIIar 5]

Hello guys
I have a problem when adding new things in Player mysql

Query Player :

https://metin2.download/picture/17L64eW2z7W77Vd5EenVBft850li9g4m/.png

 

ClientManagerPlayer.cpp

Quote

#ifdef ENABLE_CONQUEROR_LEVEL
snprintf(queryStr, sizeof(queryStr),
"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,"
#ifdef ENABLE_CHEQUE_SYSTEM
"cheque,"
#endif
#ifdef ENABLE_GEM_SYSTEM
"gem,"
#endif
"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,"
#ifdef ENABLE_CONQUEROR_LEVEL
"conquerorlevel,conqueror_level_step,sungma_str,sungma_hp,sungma_move,sungma_inmune,conqueror_exp,conqueror_point,"
#endif
"mobile,horse_level,horse_riding,horse_hp,horse_hp_droptime,horse_stamina,"
"UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(last_play),horse_skill_point," 
"fish_use_count, fish_slots"
#ifdef ENABLE_GEM_SYSTEM
",UNIX_TIMESTAMP(gem_next_refresh),gem_items "
#endif
" ,envanter "

" FROM player%s WHERE id=%d",
GetTablePostfix(), packet->player_id);
#else
snprintf(queryStr, sizeof(queryStr),
"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,"
#ifdef ENABLE_CONQUEROR_LEVEL
"conquerorlevel,conqueror_level_step,sungma_str,sungma_hp,sungma_move,sungma_inmune,conqueror_exp,conqueror_point,"
#endif
"mobile,horse_level,horse_riding,horse_hp,horse_hp_droptime,horse_stamina,"
"UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(last_play),horse_skill_point," 
"fish_use_count, fish_slots"
" ,envanter "

" FROM player%s WHERE id=%d",
GetTablePostfix(), packet->player_id);
#endif

Syseer db 

Quote

SYSERR: Aug 19 21:38:10 :: ChildLoop: AsyncSQL: query failed: Unknown column 'conqueror_point' in 'field list' (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,cheque,gem,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,conquerorlevel,conqueror_level_step,sungma_str,sungma_hp,sungma_move,sungma_inmune,conqueror_exp,conqueror_point,mobile,horse_level,horse_riding,horse_hp,horse_hp_droptime,horse_stamina,UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(last_play),horse_skill_point,fish_use_count, fish_slots,UNIX_TIMESTAMP(gem_next_refresh),gem_items ,envanter FROM player WHERE id=265 errno: 1054)
SYSERR: Aug 19 21:38:10 :: RESULT_COMPOSITE_PLAYER: null MYSQL_RES QID 0

 

Edited September 4, 2022 by Metin2 Dev
Core X - External 2 Internal

[DoIIar 5]

Up

[Intel 732]

The server is literally telling you the problem:

Quote

Unknown column 'conqueror_point' [...] FROM player

 

[[007]DawisHU 262]

16 hours ago, DoIIar said:

Hello guys
I have a problem when adding new things in Player mysql

Query Player :

https://metin2.download/picture/d4qJh8yy4A2j0SpGCL5g2H6kgHRXuLLx/.png

 

ClientManagerPlayer.cpp

Syseer db 

 

Spoiler

1.

 change to ->

snprintf(queryStr, sizeof(queryStr),
"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,"
#ifdef ENABLE_CHEQUE_SYSTEM
    "cheque,"
#endif
#ifdef ENABLE_GEM_SYSTEM
    "gem,"
#endif
    "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,"
#ifdef ENABLE_CONQUEROR_LEVEL
    "conquerorlevel,conqueror_level_step,sungma_str,sungma_hp,sungma_move,sungma_inmune,conqueror_exp,conqueror_point,"
#endif
    "mobile,horse_level,horse_riding,horse_hp,horse_hp_droptime,horse_stamina,"
    "UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(last_play),horse_skill_point," 
    "fish_use_count, fish_slots"
#ifdef ENABLE_GEM_SYSTEM
    ",UNIX_TIMESTAMP(gem_next_refresh),gem_items "
#endif
    " ,envanter "
    " FROM player%s WHERE id=%d",
    GetTablePostfix(), packet->player_id);

2.
Check your sql syntax.... 
'sungma_inmune' ;

Change from ";" to "," 
 

 

 

Edited September 4, 2022 by Metin2 Dev
Core X - External 2 Internal