Opublikowano 17 Grudnia 20231 r Spoiler Dec 17 00:48:55 :: PlayerCreate accountid 59 name Niewiem level 1 gold 500000, st 4 ht 3 job 5 Dec 17 00:48:55 :: PlayerCreate accountid 59 name Niewiem gaya 0 SYSERR: Dec 17 00:48:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Field 'conqueror_level_step' doesn't have a default value query: INSERT INTO player (id, account_id, name, level, st, ht, dx, iq, job, voice, dir, x, y, z, hp, mp, random_hp, random_sp, stat_point, stamina, part_base, part_main, part_hair,part_acce, gold, gaya, envanter, playtime, skill_level, quickslot) VALUES(0, 59, 'Niewiem', 1, 4, 3, 6, 3, 5, 0, 0, 957263, 255070, 0, 770, 260, 0, 0, 0, 800, 0, 0, 0,0, 500000, 0, 0, 0, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ SYSERR: Dec 17 00:48:55 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index SET pid3=0 WHERE id=59 Nie mogę zrobić konta ani usunąc pomocy 🙂
Opublikowano 17 Grudnia 20231 r Czy używasz bazy od tych plików? Brakuje wartości domyślnej dla kolumny 'conqueror_level_step' w tabelce player. Uruchom to zapytanie SQL: ALTER TABLE player MODIFY conqueror_level_step INT DEFAULT 0; Jeśli nie masz takiej kolumny to ją dodaj: ALTER TABLE player ADD COLUMN conqueror_level_step INT DEFAULT 0;
Opublikowano 17 Grudnia 20231 r Autor YSERR: Dec 17 16:06:48 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'common.priv_settings' doesn't exist query: DELETE FROM priv_settings WHERE value <= 0 OR duration <= NOW(); SYSERR: Dec 17 16:06:48 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'common.priv_settings' doesn't exist query: SELECT priv_type, id, type, value, UNIX_TIMESTAMP(duration) FROM priv_settings SYSERR: Dec 17 16:06:52 :: SendItemExtraProtoTable: peer boot ERROR, empty item extra proto table. SYSERR: Dec 17 16:06:52 :: SendItemExtraProtoTable: peer boot ERROR, empty item extra proto table. SYSERR: Dec 17 16:06:52 :: SendItemExtraProtoTable: peer boot ERROR, empty item extra proto table. SYSERR: Dec 17 16:15:19 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Field 'conqueror_level_step' doesn't have a default value query: INSERT INTO player (id, account_id, name, level, st, ht, dx, iq, job, voice, dir, x, y, z, hp, mp, random_hp, random_sp, stat_point, stamina, part_base, part_main, part_hair,part_acce, gold, gaya, envanter, playtime, skill_level, quickslot) VALUES(0, 59, 'Ziomal', 1, 6, 4, 3, 3, 0, 0, 0, 957093, 255349, 0, 760, 260, 0, 0, 0, 800, 0, 0, 0,0, 500000, 0, 0, 0, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 SYSERR: Dec 17 16:15:19 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index SET pid3=0 WHERE id=59 Proszę o pomoc jak to naprawić
Opublikowano 17 Grudnia 20231 r Rozwiązanie DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Field 'conqueror_level_step' doesn't have a default value query: INSERT INTO player (id, account_id, name, level, st, ht, dx, iq, job, voice, dir, x, y, z, hp, mp, random_hp, random_sp, stat_point, stamina, part_base, part_main, part_hair,part_acce, gold, gaya, envanter, playtime, skill_level, quickslot) VALUES(0, 59, 'Ziomal', 1, 6, 4, 3, 3, 0, 0, 0, 957093, 255349, 0, 760, 260, 0, 0, 0, 800, 0, 0, 0,0, 500000, 0, 0, 0, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 Przecież w powyższym poście dałem Ci rozwiązanie tego problemu wykonaj te zapytania i sprawdź. SendItemExtraProtoTable: peer boot ERROR, empty item extra proto table. Nie mam pojęcia co to, sprawdź w źródle i podaj kod który wywołuje ten błąd. irectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'common.priv_settings' doesn't exist query: DELETE FROM priv_settings WHERE value <= 0 OR duration <= NOW(); Sprawdź, czy nie brakuje Ci tabelki priv_settings w bazie common.
Dec 17 00:48:55 :: PlayerCreate accountid 59 name Niewiem level 1 gold 500000, st 4 ht 3 job 5 Dec 17 00:48:55 :: PlayerCreate accountid 59 name Niewiem gaya 0 SYSERR: Dec 17 00:48:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Field 'conqueror_level_step' doesn't have a default value query: INSERT INTO player (id, account_id, name, level, st, ht, dx, iq, job, voice, dir, x, y, z, hp, mp, random_hp, random_sp, stat_point, stamina, part_base, part_main, part_hair,part_acce, gold, gaya, envanter, playtime, skill_level, quickslot) VALUES(0, 59, 'Niewiem', 1, 4, 3, 6, 3, 5, 0, 0, 957263, 255070, 0, 770, 260, 0, 0, 0, 800, 0, 0, 0,0, 500000, 0, 0, 0, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ SYSERR: Dec 17 00:48:55 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index SET pid3=0 WHERE id=59