Hi,
ich habe dieses System eingebaut:
Bitte melden Sie sich an, um diesen Link zu sehen.
Das System funktioniert voll und ganz, nur kann ich keinen Charakter mehr erstellen meine Sysser sagt:
Code
- SYSERR: Feb 11 14:03:28 :: 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, horse_appearance, stat_point, stamina, part_base, part_main, part_hair, gold, playtime, skill_level, quickslot) VALUES(0, 54764, 'TESTER', 1, 5, 3, 3, 5, 2, 0, 0, 459877, 953872, 0, 770, 300, 0, 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\0\0\0\0\0\0\0\0
- SYSERR: Feb 11 14:03:28 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index SET pid1=0 WHERE id=54764
der Fehler liegt in der db in diesem Bereich:
Code: ClientManagePlayer.cpp
- queryLen = snprintf(queryStr, sizeof(queryStr),
- "INSERT INTO player%s "
- "(id, account_id, name, level, st, ht, dx, iq, "
- "job, voice, dir, x, y, z, "
- "hp, mp, random_hp, random_sp, horse_appearance stat_point, stamina, part_base, part_main, part_hair, gold, playtime, "
- "skill_level, quickslot) "
- "VALUES(0, %u, '%s', %d, %d, %d, %d, %d, "
- "%d, %d, %d, %d, %d, %d, %d, "
- "%d, %d, %d, 0, %d, %d, %d, %d, 0, %d, 0, ",
- GetTablePostfix(),
- packet->account_id, packet->player_table.name, packet->player_table.level, packet->player_table.st, packet->player_table.ht, packet->player_table.dx, packet->player_table.iq,
- packet->player_table.job, packet->player_table.voice, packet->player_table.dir, packet->player_table.x, packet->player_table.y, packet->player_table.z,packet->player_table.hp,
- packet->player_table.sp, packet->player_table.sRandomHP, packet->player_table.sRandomSP, packet->player_table.sHorse_appearance, packet->player_table.stat_point, packet->player_table.stamina,
- packet->player_table.part_base);
kann mir da bitte jemand helfen?