probleme

03 Noi 2020, 13:17

*Problemă/Întrebare: am si eu 2 probleme
1 la pet am instalat quest uri da tot la fel face..

gen dau pe el apare 1 secunde si dispare..
si a doua nu ma lasa sa fac caracter si nu stiu de ce..

Tipologie server(PvM / PvP):-
*Resursă folosită: -
*ServerFiles utilizat:-
*Syserr:-
Poză:-
*Detalii suplimentare:-

[Reizo] · 03 Noi 2020, 13:18

Bun, stii ca daca nu specifici nu faci nmc e ca si cum la matematica iti zice:

Ionel are 20 de ani, cati ani are ma-sa.

03 Noi 2020, 13:21

am specificat, doar ca la "crearea de caractere" nu stiu ce sa dau syser din auth1 idk, oricum np pt +1 =)

03 Noi 2020, 17:05

Galatan922 scrie: ↑03 Noi 2020, 13:21 am specificat, doar ca la "crearea de caractere" nu stiu ce sa dau syser din auth1 idk, oricum np pt +1 =)

Omul are dreptate, nu face doar pentru +1 asa cum ti se pare tie. Daca nu ne spui si noua exact ce se intampla, decat "nu merge sa fac caracter si nu stiu de ce", cum vrei sa stim cu ce sa te ajutam? Detalii, man, detalii ...

03 Noi 2020, 18:16

gen cand dau sa creez caracter nou imi da " nu poti crea acest caracter" si la pet cred ca am explicat bine..

05 Noi 2020, 08:49

Galatan922 scrie: ↑03 Noi 2020, 18:16 gen cand dau sa creez caracter nou imi da " nu poti crea acest caracter" si la pet cred ca am explicat bine..

Nu stiu cat te ajuta, dar incearca una din astea 2 variante, pentru ca nu stiu sigur de la ce ar putea fi :

1. Reboot server

2. Reinstall MySQL

05 Noi 2020, 09:09

nu ma ajuta, am facut deja asta..

[Reizo] · 05 Noi 2020, 09:13

e din partea de sursa de db, esti prea bun pe bagat sisteme si d aia, ClientManagerPlayer cel mai probabil. Verifica si sysser, syslog din db.

05 Noi 2020, 14:13

sysser db
SYSERR: Nov 5 12:34:11 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column count doesn't match value count at row 1
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_sash, gold, battle_points, playtime, skill_level, fish_slots, quickslot) VALUES(0, 1, 'adawd', 1, 4, 3, 6, 3, 5, 0, 0, 459986, 954061, 0, 770, 260, 0, 0, 0, 800, 0, 0, 0, 0, 0, 0, 0, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\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: Nov 5 12:34:11 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index SET pid3=0 WHERE id=1
SYSERR: Nov 5 12:41:36 :: 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 'quickslot = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\' at line 1 (query: UPDATE player SET job = 2, voice = 0, dir = 0, x = 459554, y = 949568, z = 0, map_index = 1, exit_x = 459554, exit_y = 949568, exit_map_index = 1, hp = 3561, mp = 444, stamina = 1315, random_hp = 291, random_sp = 144, playtime = 6, level = 8, level_step = 1, st = 5, ht = 3, dx = 3, iq = 5, gold = 248970975, battle_points = 0, exp = 7269, stat_point = 22, skill_point = 7, sub_skill_point = 0, stat_reset_count = 0, ip = '81.196.70.223', part_main = 11609, part_hair = 0, part_sash = 0, last_play = NOW(), skill_group = 1, alignment = 5224, horse_level = 21, horse_riding = 0, horse_hp = 32, horse_hp_droptime = 1604686459, horse_stamina = 120, horse_skill_point = 0, fish_use_count = 0, t_choosed = 0, t_available = '0,0,0,

05 Noi 2020, 14:25

Galatan922 scrie: ↑05 Noi 2020, 14:13 sysser db
SYSERR: Nov 5 12:34:11 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column count doesn't match value count at row 1
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_sash, gold, battle_points, playtime, skill_level, fish_slots, quickslot) VALUES(0, 1, 'adawd', 1, 4, 3, 6, 3, 5, 0, 0, 459986, 954061, 0, 770, 260, 0, 0, 0, 800, 0, 0, 0, 0, 0, 0, 0, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\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: Nov 5 12:34:11 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index SET pid3=0 WHERE id=1
SYSERR: Nov 5 12:41:36 :: 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 'quickslot = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\' at line 1 (query: UPDATE player SET job = 2, voice = 0, dir = 0, x = 459554, y = 949568, z = 0, map_index = 1, exit_x = 459554, exit_y = 949568, exit_map_index = 1, hp = 3561, mp = 444, stamina = 1315, random_hp = 291, random_sp = 144, playtime = 6, level = 8, level_step = 1, st = 5, ht = 3, dx = 3, iq = 5, gold = 248970975, battle_points = 0, exp = 7269, stat_point = 22, skill_point = 7, sub_skill_point = 0, stat_reset_count = 0, ip = '81.196.70.223', part_main = 11609, part_hair = 0, part_sash = 0, last_play = NOW(), skill_group = 1, alignment = 5224, horse_level = 21, horse_riding = 0, horse_hp = 32, horse_hp_droptime = 1604686459, horse_stamina = 120, horse_skill_point = 0, fish_use_count = 0, t_choosed = 0, t_available = '0,0,0,

Query-ul bagat are mai multe / mai putine coloane decat ai tu in Navicat, in tabela respectiva si nu stie care, unde sa le dea INSERT

probleme

3 Probleme

Probleme pet

Probleme pet-uri.

Probleme

Cine este conectat