i have not ever Character deleted[PLEASE HELP]

mania58 · 01/24/2012, 21:32

Hi friends..

i dont have Character deleted

Character is not deleted after the maintenance,
Gives this error when trying to delete a character.
Code is not renewed, but still anyone have this problem.

Code:

SYSERR: Jan 24 22:22:04 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column count doesn't match value count at row 1
query: INSERT INTO player_deleted SELECT * FROM player WHERE id=67857

Please help urgent..

almobd3 · 01/24/2012, 22:52

Quote:

query: INSERT INTO player_deleted SELECT * FROM player WHERE id=67857

I think that you have changed something around here because these are 2 queries not one.

1- INSERT INTO player_deleted ....... something is missing here.

2- SELECT * FROM player WHERE id= 67857

you need to copy + paste the error from the syserr as it is without changing it.

Best Regards.

mania58 · 01/25/2012, 12:39

Thank you for your assistance..

But I do not understand anything :(

Code:

SYSERR: Jan 24 22:22:04 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column count doesn't match value count at row 1
query: INSERT INTO player_deleted SELECT * FROM player WHERE id=67857
SYSERR: Jan 24 22:39:53 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column count doesn't match value count at row 1
query: INSERT INTO player_deleted SELECT * FROM player WHERE id=67857
SYSERR: Jan 24 22:52:53 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '87981' for key 1 (query: INSERT INTO safebox (account_id, size) VALUES(87981, 1) errno: 1062)
SYSERR: Jan 24 23:37:56 :: Update: cannot update marriage : PID:132798 132799
SYSERR: Jan 25 00:27:56 :: Update: cannot update marriage : PID:101443 114684
SYSERR: Jan 25 00:36:01 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '89274' for key 1 (query: INSERT INTO safebox (account_id, size) VALUES(89274, 1) errno: 1062)
SYSERR: Jan 25 00:40:48 :: Update: cannot update marriage : PID:101443 114684
SYSERR: Jan 25 00:42:56 :: Update: cannot update marriage : PID:101443 114684
SYSERR: Jan 25 00:43:02 :: Update: cannot update marriage : PID:101443 114684
SYSERR: Jan 25 00:43:18 :: Update: cannot update marriage : PID:101443 114684
SYSERR: Jan 25 01:10:45 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column count doesn't match value count at row 1
query: INSERT INTO player_deleted SELECT * FROM player WHERE id=179439
SYSERR: Jan 25 01:14:02 :: Update: cannot update marriage : PID:101443 114684
SYSERR: Jan 25 03:04:32 :: Update: cannot update marriage : PID:132798 132799
SYSERR: Jan 25 03:05:23 :: Update: cannot update marriage : PID:132798 132799
SYSERR: Jan 25 03:26:34 :: Update: cannot update marriage : PID:132798 132799
SYSERR: Jan 25 03:31:31 :: Update: cannot update marriage : PID:132798 132799
SYSERR: Jan 25 03:31:52 :: Update: cannot update marriage : PID:132798 132799
SYSERR: Jan 25 03:38:33 :: Update: cannot update marriage : PID:132798 132799
SYSERR: Jan 25 03:39:51 :: Update: cannot update marriage : PID:132798 132799
SYSERR: Jan 25 03:42:51 :: Update: cannot update marriage : PID:132798 132799
SYSERR: Jan 25 03:44:18 :: Update: cannot update marriage : PID:132798 132799
SYSERR: Jan 25 07:35:05 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column count doesn't match value count at row 1
query: INSERT INTO player_deleted SELECT * FROM player WHERE id=177509
SYSERR: Jan 25 07:43:44 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column count doesn't match value count at row 1
query: INSERT INTO player_deleted SELECT * FROM player WHERE id=179678
SYSERR: Jan 25 08:46:06 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column count doesn't match value count at row 1
query: INSERT INTO player_deleted SELECT * FROM player WHERE id=179678
SYSERR: Jan 25 10:29:07 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column count doesn't match value count at row 1
query: INSERT INTO player_deleted SELECT * FROM player WHERE id=179606
SYSERR: Jan 25 10:40:36 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '13847' for key 1 (query: INSERT INTO safebox (account_id, size) VALUES(13847, 1) errno: 1062)
SYSERR: Jan 25 11:14:39 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column count doesn't match value count at row 1
query: INSERT INTO player_deleted SELECT * FROM player WHERE id=179486
SYSERR: Jan 25 11:19:37 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '59601' for key 1 (query: INSERT INTO safebox (account_id, size) VALUES(59601, 1) errno: 1062)
SYSERR: Jan 25 11:38:38 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column count doesn't match value count at row 1
query: INSERT INTO player_deleted SELECT * FROM player WHERE id=144285
SYSERR: Jan 25 11:50:45 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column count doesn't match value count at row 1
query: INSERT INTO player_deleted SELECT * FROM player WHERE id=179635
SYSERR: Jan 25 12:27:43 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column count doesn't match value count at row 1
query: INSERT INTO player_deleted SELECT * FROM player WHERE id=130874
SYSERR: Jan 25 12:29:01 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Duplicate entry '92363' for key 2
query: INSERT INTO guild_member VALUES(92363, 2265, 15, 0, 0)
SYSERR: Jan 25 12:29:01 :: GuildAddMember: Query failed when getting guild member data SELECT pid, grade, is_general, offer, level, job, name FROM guild_member, player WHERE guild_id = 2265 and pid = id and pid = 92363
SYSERR: Jan 25 12:29:29 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '88946' for key 1 (query: INSERT INTO safebox (account_id, size) VALUES(88946, 1) errno: 1062)
SYSERR: Jan 25 12:53:07 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '89384' for key 1 (query: INSERT INTO safebox (account_id, size) VALUES(89384, 1) errno: 1062)
SYSERR: Jan 25 12:53:12 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '83230' for key 1 (query: INSERT INTO safebox (account_id, size) VALUES(83230, 1) errno: 1062)
SYSERR: Jan 25 13:32:38 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column count doesn't match value count at row 1
query: INSERT INTO player_deleted SELECT * FROM player WHERE id=179713