数据库加锁操作无故失败

浏览:1353 发布日期:2015/11/20
3.2.3 - 致命 - 未处理
$query = M();
$sql = 'lock tables user write';
$ab = $query->query($sql);
在控制器中运行上面三行代码
下面是出错信息:

: [ SQL语句 ] : lock tables user write
错误位置
FILE: /var/www/html/movie-shop/ThinkPHP/Library/Think/Db/Driver.class.php  LINE: 366
TRACE
#0 /var/www/html/movie-shop/ThinkPHP/Library/Think/Db/Driver.class.php(366): E(':\n [ SQL\xE8\xAF\xAD\xE5\x8F\xA5 ...')
#1 /var/www/html/movie-shop/ThinkPHP/Library/Think/Db/Driver.class.php(189): Think\Db\Driver->error()
#2 /var/www/html/movie-shop/ThinkPHP/Library/Think/Model.class.php(1383): Think\Db\Driver->query('lock tables use...')
#3 /var/www/html/movie-shop/Application/Home/Controller/AController.class.php(9): Think\Model->query('lock tables use...')
#4 [internal function]: Home\Controller\AController->index()
#5 /var/www/html/movie-shop/ThinkPHP/Library/Think/App.class.php(173): ReflectionMethod->invoke(object(Home\Controller\AController))
#6 /var/www/html/movie-shop/ThinkPHP/Library/Think/App.class.php(110): Think\App::invokeAction(object(Home\Controller\AController), 'index')
#7 /var/www/html/movie-shop/ThinkPHP/Library/Think/App.class.php(204): Think\App::exec()
#8 /var/www/html/movie-shop/ThinkPHP/Library/Think/Think.class.php(120): Think\App::run()
#9 /var/www/html/movie-shop/ThinkPHP/ThinkPHP.php(97): Think\Think::start()
#10 /var/www/html/movie-shop/index.php(24): require('/var/www/html/m...')
#11 {main}

我自己查看了一下,在ThinkPHP/Library/Think/Db/Driver.class.php中的这个方法
/**
* 获得所有的查询数据
* @access private
* @return array
*/
private function getResult() {
//返回数据集
$result = $this->PDOStatement->fetchAll(PDO::FETCH_ASSOC);
$this->numRows = count( $result );
return $result;
}
在$result = $this->PDOStatement->fetchAll(PDO::FETCH_ASSOC);这一行中抛出异常,求看看是不是bug,还是我的使用方法有错误,如果是我的代码有问题请务必告诉我,谢谢,赶着做毕业设计,谢谢!
评论()
后面还有条评论,点击查看>>