DoIIar 5 Posted August 19, 2022 Share Posted August 19, 2022 (edited) 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 Link to comment Share on other sites More sharing options...
DoIIar 5 Posted August 20, 2022 Author Share Posted August 20, 2022 Up Link to comment Share on other sites More sharing options...
Premium Intel 756 Posted August 20, 2022 Premium Share Posted August 20, 2022 The server is literally telling you the problem: Quote Unknown column 'conqueror_point' [...] FROM player Link to comment Share on other sites More sharing options...
Solution [007]DawisHU 277 Posted August 20, 2022 Solution Share Posted August 20, 2022 (edited) 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now