使用M函数访问postgresql出错。

浏览:1953 发布日期:2015/09/02
3.2.3 - 严重 - 已处理
方式一:
$Test1=M("test1");
$array = $Test1->select();
方式二:
$Model = new \Think\Model() ;
$array = $Model->query("select * from test1"");

'DB_TYPE' => 'pgsql', // 数据库类型
'DB_HOST' => '127.0.0.1', // 服务器地址
'DB_NAME' => 'david', // 数据库名
'DB_USER' => 'postgres', // 用户名
'DB_PWD' => 'postgres', // 密码
'DB_PORT' => '5432', // 端口

在使用方式一时会报错:
SQLSTATE[42703]: Undefined column: 7 ERROR: column "test1" does not exist LINE 1: ...s "default",fields_default as "extra" from table_msg(test1); ^
错误位置
FILE: D:\working\PHP-WEB\TestPGSQL\ThinkPHP\Library\Think\Db\Driver.class.php  LINE: 169
TRACE
#0 D:\working\PHP-WEB\TestPGSQL\ThinkPHP\Library\Think\Db\Driver.class.php(169): PDOStatement->execute()
#1 D:\working\PHP-WEB\TestPGSQL\ThinkPHP\Library\Think\Db\Driver\Pgsql.class.php(41): Think\Db\Driver->query('select fields_n...')
#2 D:\working\PHP-WEB\TestPGSQL\ThinkPHP\Library\Think\Model.class.php(134): Think\Db\Driver\Pgsql->getFields('test1')
#3 D:\working\PHP-WEB\TestPGSQL\ThinkPHP\Library\Think\Model.class.php(122): Think\Model->flush()
#4 D:\working\PHP-WEB\TestPGSQL\ThinkPHP\Library\Think\Model.class.php(1434): Think\Model->_checkTableInfo()
#5 D:\working\PHP-WEB\TestPGSQL\ThinkPHP\Library\Think\Model.class.php(97): Think\Model->db(0, '', true)
#6 D:\working\PHP-WEB\TestPGSQL\ThinkPHP\Common\functions.php(621): Think\Model->__construct('test1', '', '')
#7 D:\working\PHP-WEB\TestPGSQL\Application\Home\Controller\IndexController.class.php(6): M('test1')
#8 [internal function]: Home\Controller\IndexController->index()
#9 D:\working\PHP-WEB\TestPGSQL\ThinkPHP\Library\Think\App.class.php(164): ReflectionMethod->invoke(object(Home\Controller\IndexController))
#10 D:\working\PHP-WEB\TestPGSQL\ThinkPHP\Library\Think\App.class.php(202): Think\App::exec()
#11 D:\working\PHP-WEB\TestPGSQL\ThinkPHP\Library\Think\Think.class.php(120): Think\App::run()
#12 D:\working\PHP-WEB\TestPGSQL\ThinkPHP\ThinkPHP.php(97): Think\Think::start()
#13 D:\working\PHP-WEB\TestPGSQL\index.php(24): require('D:\\working\\PHP-...')
#14 {main}
评论(
后面还有条评论,点击查看>>