[Sysser]db

[BackPlayer 60]

Spoiler

SYSERR: Jan  2 04:18:49.969796 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Lost connection to MySQL server during query
query: SELECT MAX(id) FROM item WHERE id >= 50000001 and id <= 60000000
SYSERR: Jan  2 04:18:49.971912 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT COUNT(*) FROM item WHERE id >= 50000001 AND id <= 60000000
SYSERR: Jan  2 04:18:49.974548 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT MAX(id) FROM item WHERE id >= 10000001 and id <= 20000000
SYSERR: Jan  2 04:18:49.974570 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT COUNT(*) FROM item WHERE id >= 10000001 AND id <= 20000000
SYSERR: Jan  2 04:18:49.999479 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Jan  2 04:18:49.999692 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Jan  2 04:18:51.714413 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Jan  2 04:18:51.714431 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jan  2 04:18:56.709623 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Jan  2 04:18:56.709646 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jan  2 04:18:56.709665 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Jan  2 04:18:56.709674 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jan  2 04:19:01.709605 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Jan  2 04:19:01.709620 :: ChildLoop: AsyncSQL: retrying

how can fix this? item_award is empty, tell me if you need some parts of source code

2) sysser

Spoiler

SYSERR: Jan  2 14:32:32.852700 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 3, 11290, -1200) errno: 1136)
SYSERR: Jan  2 14:32:32.853345 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 3, 11291, -2500) errno: 1136)
SYSERR: Jan  2 14:32:32.853447 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 3, 11292, -5000) errno: 1136)
SYSERR: Jan  2 14:32:32.853535 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 3, 11293, -10000) errno: 1136)
SYSERR: Jan  2 14:32:32.853639 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 50610, 12) errno: 1136)
SYSERR: Jan  2 14:32:32.853722 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 85004, 1) errno: 1136)
 

here the source code 

Spoiler

SYSERR: Jan  2 14:32:32.852700 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 3, 11290, -1200) errno: 1136)
SYSERR: Jan  2 14:32:32.853345 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 3, 11291, -2500) errno: 1136)
SYSERR: Jan  2 14:32:32.853447 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 3, 11292, -5000) errno: 1136)
SYSERR: Jan  2 14:32:32.853535 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 3, 11293, -10000) errno: 1136)
SYSERR: Jan  2 14:32:32.853639 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 50610, 12) errno: 1136)
SYSERR: Jan  2 14:32:32.853722 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 85004, 1) errno: 1136)
 

 

[ds_aim 263]

And if i will answer you, what ? 

[BackPlayer 60]

what do you mean?

[ds_aim 263]

If I now answer the question, and you solve your problem.
How should I know if I was helpful, since you do not respond to topics after you solve problems.

 

BTW, you should check mysql.sock  

tmp/mysql.sock and check if it's present .

[Ken 1035]

https://dev.mysql.com/doc/refman/5.5/en/error-messages-server.html#error_er_wrong_value_count_on_row (#Error Code: 1136)

Kind Regards ~ Ken

[bumxd 20]

Spoiler

-- ----------------------------
-- Table structure for `money_log`
-- ----------------------------
DROP TABLE IF EXISTS `money_log`;
CREATE TABLE `money_log` (
 `time` datetime default NULL,
 `1` varchar(20) default NULL,
 `2` varchar(20) default '0',
 `3` varchar(20) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

money_log create

[BackPlayer 60]

2 hours ago, ds_aim said:

If I now answer the question, and you solve your problem.
How should I know if I was helpful, since you do not respond to topics after you solve problems.

 

BTW, you should check mysql.sock  

tmp/mysql.sock and check if it's present .

it's here but looks empty and i can't open it https://metin2.download/picture/T9kMSPRldzxM0296g9KvnDL7wYN4YXrc/.png

*your solution in my problem with anti exp ring isn't correct(may i do it wrong) but when i would give exp from gm or just i exp my player server crash and down 

and when someone me helps i do like sometimes and comment

sorry for my enlighs.

Edited September 1, 2022 by Metin2 Dev
Core X - External 2 Internal