Jump to content
  • 0
Acer

money_log

Question

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)

 

nzTj84v.png

L781nfZ.png

 

alguno me ayuda solucionar este error por favor

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 0
hace 38 minutos, MiGueLiT0 dijo:

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

k8flDIy.png

8taH6Ee.png

 

Hola conpañero donde esta count

 

default sale NuLL y Empty String

Share this post


Link to post
Share on other sites
  • 0

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;

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...