(!)SamaoPHP错误提示: | |
所在页面(行): | /usr/home/byu4720100001/htdocs/samao/libs/sys/pagelist.class.php (83) |
错误提示信息: |
执行语句错误 Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'industries' in 'where clause' ) 最终执行的SQL: select count(1) as MyCount from sl_project_equity where financing_mode REGEXP 2 and industries=17 and `keywords` like '%������������%' and `allow` =1 order by refresh_time desc, id desc |
执行函数: | DB::getone() |
函数参数: | Array ( [0] => select count(1) as MyCount from sl_project_equity where financing_mode REGEXP ? and industries=? and `keywords` like ? and `allow` =? order by refresh_time desc, id desc [1] => Array ( [0] => 2 [1] => 17 [2] => %������������% [3] => 1 ) ) |
GET 信息: | Array ( [typeof] => 1 [kw] => ������������ [sort] => time [financing_mode] => 2 [industries] => 17 [area_type] => [financing_amount] => [project_phase] => 3 ) |
错误代码附近: | 81. if (strripos($this->sql, ' from ') === stripos($this->sql, ' from ')) { 82. $sql = preg_replace('@^select\s+(distinct\s+[a-z][a-z0-9]+\s*,)?(.*)\s+from\s+@', 'select $1count(1) as MyCount from ', $this->sql); 83. $row = DB::getone($sql, $this->args); 84. } else { 85. $row = DB::getone('select count(1) as MyCount from (' . $this->sql . ') MyTempTable', $this->args); |
触发页面(行): | /usr/home/byu4720100001/htdocs/samao/libs/sys/db.class.php (352) |
所抛出信息页面(行): | (0) |
Call Stack | Function | Location | Line |
0 | DB::getone() | /usr/home/byu4720100001/htdocs/samao/libs/sys/pagelist.class.php | 83 |
1 | Pagelist->getinfo() | /usr/home/byu4720100001/htdocs/samao/libs/sys/pagelist.class.php | 127 |
2 | Pagelist->getlist() | /usr/home/byu4720100001/htdocs/Apps/Home/controls/lfp.ctl.php | 80 |
3 | LfpController->indexAction() | /usr/home/byu4720100001/htdocs/samao/samaophp.php | 95 |
4 | App::Run() | /usr/home/byu4720100001/htdocs/index.php | 63 |