money_log

[Acer]

Quote

SYSERR: Mar 24 23:20:23 :: Entergame: !GetMovablePosition (name Eren 825000x2500 map 81 changed to 822300x22000)
SYSERR: Mar 25 00:05:25 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 2, 2190, 80000) errno: 1136)
SYSERR: Mar 25 00:05:25 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 2, 3140, 360000) errno: 1136)
SYSERR: Mar 25 00:05:25 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 2, 3199, 30000) errno: 1136)
SYSERR: Mar 25 00:05:25 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 2, 3200, 10000) errno: 1136)

 

 

Quote

SYSERR: Mar 25 22:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 1107, 2) errno: 1136)
SYSERR: Mar 25 23:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 149, 1) errno: 1136)
SYSERR: Mar 25 23:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 3159, 1) errno: 1136)
SYSERR: Mar 25 23:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 11299, 1) errno: 1136)
SYSERR: Mar 25 23:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 27102, 1) errno: 1136)
SYSERR: Mar 25 23:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 27105, 1) errno: 1136)
SYSERR: Mar 25 23:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 40002, 1) errno: 1136)
SYSERR: Mar 25 23:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 50053, 1) errno: 1136)
SYSERR: Mar 25 23:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 50821, 1) errno: 1136)
SYSERR: Mar 25 23:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 50822, 1) errno: 1136)
SYSERR: Mar 25 23:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 50823, 1) errno: 1136)
SYSERR: Mar 25 23:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 50824, 1) errno: 1136)
SYSERR: Mar 25 23:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 50825, 1) errno: 1136)
SYSERR: Mar 25 23:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 50826, 1) errno: 1136)
SYSERR: Mar 25 23:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 71027, 1) errno: 1136)
SYSERR: Mar 25 23:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 71028, 1) errno: 1136)
SYSERR: Mar 25 23:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 71029, 1) errno: 1136)
SYSERR: Mar 25 23:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 71030, 1) errno: 1136)
SYSERR: Mar 25 23:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 71044, 1) errno: 1136)
SYSERR: Mar 25 23:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 71045, 1) errno: 1136)
SYSERR: Mar 25 23:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 72726, 1) errno: 1136)
SYSERR: Mar 25 23:21:32 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 72730, 1) errno: 1136)

 

 

alguno me ayuda solucionar este error por favor

[MiGueLiT0]

click derecho en money_log, en la opcion de design table busca count y colocale default 0

[Acer]

hace 38 minutos, MiGueLiT0 dijo:

click derecho en money_log, en la opcion de design table busca count y colocale default 0

 

Hola conpañero donde esta count

 

default sale NuLL y Empty String

[caanmasu]

La estructura de la tabla la tienes mal. Pon esta query en log:

 

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS `money_log`;
CREATE TABLE `money_log`  (
  `time` datetime(0) NULL DEFAULT NULL,
  `type` int(11) NULL DEFAULT NULL,
  `vnum` int(11) NULL DEFAULT NULL,
  `gold` int(11) NULL DEFAULT NULL
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

SET FOREIGN_KEY_CHECKS = 1;