CmsWing无法编辑?【已解决】

Error: ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same stat
ement as updates to transactional tables.
    at Query.Sequence._packetToError (E:work202105CmsWing
ode_modulesmysqllibprotocolsequencesSequence.js:47:14)
    at Query.ErrorPacket (E:work202105CmsWing
ode_modulesmysqllibprotocolsequencesQuery.js:79:18)
    at Protocol._parsePacket (E:work202105CmsWing
ode_modulesmysqllibprotocolProtocol.js:291:23)
    at Parser._parsePacket (E:work202105CmsWing
ode_modulesmysqllibprotocolParser.js:433:10)
    at Parser.write (E:work202105CmsWing
ode_modulesmysqllibprotocolParser.js:43:10)
    at Protocol.write (E:work202105CmsWing
ode_modulesmysqllibprotocolProtocol.js:38:16)
    at Socket.<anonymous> (E:work202105CmsWing
ode_modulesmysqllibConnection.js:88:28)
    at Socket.<anonymous> (E:work202105CmsWing
ode_modulesmysqllibConnection.js:526:10)
    at Socket.emit (events.js:315:20)
    at addChunk (internal/streams/readable.js:309:12)
    at readableAddChunk (internal/streams/readable.js:284:9)
    at Socket.Readable.push (internal/streams/readable.js:223:10)
    at TCP.onStreamRead (internal/stream_base_commons.js:188:23)
    --------------------
    at Protocol._enqueue (E:work202105CmsWing
ode_modulesmysqllibprotocolProtocol.js:144:48)
    at PoolConnection.query (E:work202105CmsWing
ode_modulesmysqllibConnection.js:198:25)
    at E:work202105CmsWing
ode_modules	hink-helperindex.js:83:10
    at new Promise (<anonymous>)
    at E:work202105CmsWing
ode_modules	hink-helperindex.js:82:12
    at ThinkMysql.[think-mysql-query] (E:work202105CmsWing
ode_modules	hink-mysqlindex.js:169:12)
    at E:work202105CmsWing
ode_modules	hink-mysqlindex.js:247:25
    at processTicksAndRejections (internal/process/task_queues.js:93:5) {
  code: 'ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE',
  errno: 1785,
  sqlMessage: 'Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactiona
l tables.',
  sqlState: 'HY000',
  index: 0,
  sql: "UPDATE `cmswing_search` SET `m_id`=3,`d_id`=106,`data`='迅雷看看播放器2  迅雷 看看 播放 器 2' WHERE ( `d_id` = '106' ) AND ( `m_id` = '3' )"
} {
  request: {
    method: 'POST',
    url: '/admin/article/update',
    header: {
      host: '127.0.0.1:8360',
      connection: 'keep-alive',
      'content-length': '1424',
      accept: '*/*',
      origin: 'http://127.0.0.1:8360',
      'x-requested-with': 'XMLHttpRequest',
      'user-agent': 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36',
      'content-type': 'application/x-www-form-urlencoded; charset=UTF-8',
      'sec-fetch-site': 'same-origin',
      'sec-fetch-mode': 'cors',
      referer: 'http://127.0.0.1:8360/admin/article/edit/?id=106&model=1&cate_id=63',
      'accept-encoding': 'gzip, deflate, br',
      'accept-language': 'zh-CN,zh;q=0.9',
      cookie: '__guid=96992031.1139838043702490800.1606370030585.7847; thinkjs=fc4b81b4-5e53-4c1b-aa06-68998f107f4f; Hm_lvt_db1838bfd0b81ebff469f5ef62a0621a=1620610018,1620979992; Hm_lpvt_db1838bfd0b81ebff469f5ef62a0621a=1620979992;
 monitor_count=6'
    }
  },
  response: {
    status: 200,
    message: 'OK',
    header: [Object: null prototype] { 'x-powered-by': 'thinkjs-3.2.13' }
  },
  app: { subdomainOffset: 2, proxy: false, env: 'development' },
  originalUrl: '/admin/article/update',
  req: '<original node req>',
  res: '<original node res>',
  socket: '<original node socket>'
}

 修改cmswing_search表索引:MyISAM 改为 InnoDB

-------------

 
编程学习交流群 QQ群:168703370
原文地址:https://www.cnblogs.com/phpfangzhan/p/14768990.html