$a=M()->execute("DELETE FROM ding_finish WHERE jobid IN (SELECT id FROM ding_job WHERE talkid='".$_POST['id']."')");

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1
错误位置
FILE: D:\xampp\htdocs\Ding_server\ThinkPHP\Library\Think\Db\Driver.class.php LINE: 217

TRACE
#0 D:\xampp\htdocs\Ding_server\ThinkPHP\Library\Think\Db\Driver.class.php(217): PDOStatement->execute()
#1 D:\xampp\htdocs\Ding_server\ThinkPHP\Library\Think\Db\Driver.class.php(922): Think\Db\Driver->execute('DELETE FROM `di...', false)
#2 D:\xampp\htdocs\Ding_server\ThinkPHP\Library\Think\Model.class.php(518): Think\Db\Driver->delete(Array)
#3 D:\xampp\htdocs\Ding_server\Apps\Home\Controller\IndexController.class.php(260): Think\Model->delete()
#4 [internal function]: Home\Controller\IndexController->deletetalk()
#5 D:\xampp\htdocs\Ding_server\ThinkPHP\Library\Think\App.class.php(164): ReflectionMethod->invoke(object(Home\Controller\IndexController))
#6 D:\xampp\htdocs\Ding_server\ThinkPHP\Library\Think\App.class.php(202): Think\App::exec()
#7 D:\xampp\htdocs\Ding_server\ThinkPHP\Library\Think\Think.class.php(120): Think\App::run()
#8 D:\xampp\htdocs\Ding_server\ThinkPHP\ThinkPHP.php(97): Think\Think::start()
#9 D:\xampp\htdocs\Ding_server\index.php(29): require('D:\\xampp\\htdocs...')
#10 {main}




[ 2018年05月01日T18:57:56+08:00 ] ::1 /Ding_server/index.php?m=Home&c=Index&a=deletetalk
INFO: [ app_init ] --START--
INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000006s ]
INFO: [ app_init ] --END-- [ RunTime:0.000213s ]
INFO: [ app_begin ] --START--
INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000374s ]
INFO: [ app_begin ] --END-- [ RunTime:0.000399s ]
NOTIC: [8] Undefined index: id D:\xampp\htdocs\Ding_server\Apps\Home\Controller\IndexController.class.php 第 259 行.
ERR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1

最佳答案

评论() 相关

收藏

赞

山海皆可平

ThinkPHP 是一个免费开源的,快速、简单的面向对象的 轻量级PHP开发框架 ,创立于2006年初,遵循Apache2开源协议发布,是为了敏捷WEB应用开发和简化企业应用开发而诞生的。ThinkPHP从诞生以来一直秉承简洁实用的设计原则,在保持出色的性能和至简的代码的同时,也注重易用性。并且拥有众多的原创功能和特性,在社区团队的积极参与下,在易用性、扩展性和性能方面不断优化和改进,已经成长为国内最领先和最具影响力的WEB应用开发框架,众多的典型案例确保可以稳定用于商业以及门户级的开发。