Exception: FLEA_Db_Exception_SqlQuery
Message: SQL 错误消息: "Unknown column 'robots.txt' in 'where clause'"
SQL 语句: "SELECT `property`.*
FROM `property`
WHERE 21/robots.txt
LIMIT 1"
SQL 错误代码: "7335941".
Filename: /home/l/o/lomondandtrossac/public_html/libs/FLEA/FLEA/Db/Driver/Mysql.php
#10
FLEA_Db_Driver_Mysql::execute('SELECT `property`.*
FROM `p ...')
FILE: Mysql.php
LINE: 459
ARGS:
Array
(
[0] => SELECT `property`.*
FROM `property`
WHERE 21/robots.txt
LIMIT 1
)
SOURCE CODE:
| 449 |
if ($offset !== null) {
|
| 450 |
$sql .= "\nLIMIT " . (int)$offset;
|
| 451 |
if ($length !== null) {
|
| 452 |
$sql .= ', ' . (int)$length;
|
| 453 |
} else {
|
| 454 |
$sql .= ', 4294967294';
|
| 455 |
}
|
| 456 |
} elseif ($length !== null) {
|
| 457 |
$sql .= "\nLIMIT " . (int)$length;
|
| 458 |
}
|
| 459 |
return $this->execute($sql);
|
| 460 |
}
|
| 461 |
|
| 462 |
/**
|
| 463 |
* 执行一个查询，返回查询结果记录集
|
| 464 |
*
|
| 465 |
* @param string|resource $sql
|
| 466 |
*
|
| 467 |
* @return array
|
| 468 |
*/
|
| 469 |
function & getAll($sql)
|
Filename: /home/l/o/lomondandtrossac/public_html/libs/FLEA/FLEA/Db/TableDataGateway.php
#9
FLEA_Db_Driver_Mysql::selectLimit('SELECT `property`.*
FROM `p ...', 1, )
FILE: TableDataGateway.php
LINE: 395
ARGS:
Array
(
[0] => SELECT `property`.*
FROM `property`
WHERE 21/robots.txt
[1] => 1
[2] =>
)
SOURCE CODE:
| 385 |
$fields = $this->dbo->qfields($fields, $this->fullTableName);
|
| 386 |
if ($enableLinks) {
|
| 387 |
// 当有关联需要处理时，必须获得主表的主键字段值
|
| 388 |
$sql = "SELECT {$distinct}{$this->qpka}, {$fields}\nFROM {$this->qtableName}{$whereby}{$sortby}";
|
| 389 |
} else {
|
| 390 |
$sql = "SELECT {$distinct}{$fields}\nFROM {$this->qtableName}{$whereby}{$sortby}";
|
| 391 |
}
|
| 392 |
|
| 393 |
// 根据 $length 和 $offset 参数决定是否使用限定结果集的查询
|
| 394 |
if (null !== $length || null !== $offset) {
|
| 395 |
$result = $this->dbo->selectLimit($sql, $length, $offset);
|
| 396 |
} else {
|
| 397 |
$result = $this->dbo->execute($sql);
|
| 398 |
}
|
| 399 |
|
| 400 |
if ($enableLinks) {
|
| 401 |
/**
|
| 402 |
* 查询时同时将主键值单独提取出来，
|
| 403 |
* 并且准备一个以主键值为键名的二维数组用于关联数据的装配
|
| 404 |
*/
|
| 405 |
$pkvs = array();
|
Filename: /home/l/o/lomondandtrossac/public_html/libs/FLEA/FLEA/Db/TableDataGateway.php
#8
FLEA_Db_TableDataGateway::findAll('21/robots.txt', , 1, '*', 1)
FILE: TableDataGateway.php
LINE: 348
ARGS:
Array
(
[0] => 21/robots.txt
[1] =>
[2] => 1
[3] => *
[4] => 1
)
SOURCE CODE:
| 338 |
*
|
| 339 |
* @param mixed $conditions
|
| 340 |
* @param string $sort
|
| 341 |
* @param mixed $fields
|
| 342 |
* @param mixed $queryLinks
|
| 343 |
*
|
| 344 |
* @return array
|
| 345 |
*/
|
| 346 |
function & find($conditions, $sort = null, $fields = '*', $queryLinks = true)
|
| 347 |
{
|
| 348 |
$rowset =& $this->findAll($conditions, $sort, 1, $fields, $queryLinks);
|
| 349 |
if (is_array($rowset)) {
|
| 350 |
$row = reset($rowset);
|
| 351 |
} else {
|
| 352 |
$row = false;
|
| 353 |
}
|
| 354 |
unset($rowset);
|
| 355 |
return $row;
|
| 356 |
}
|
| 357 |
|
| 358 |
/**
|
Filename: /home/l/o/lomondandtrossac/public_html/libs/APP/Model/Default.php
#7
FLEA_Db_TableDataGateway::find('21/robots.txt')
FILE: Default.php
LINE: 196
ARGS:
Array
(
[0] => 21/robots.txt
)
SOURCE CODE:
| 186 |
//dump($result,'result');
|
| 187 |
//dump($array,'vail');
|
| 188 |
//dump($result,'new');
|
| 189 |
|
| 190 |
//print_r($pageData);
|
| 191 |
include(TPL_DIR.'/search_result.tpl.php');
|
| 192 |
|
| 193 |
}
|
| 194 |
function ViewProperty(){
|
| 195 |
$pid=$_GET['pid']!=''?$_GET['pid']:'';
|
| 196 |
$property=$this->_Property->find($pid);
|
| 197 |
|
| 198 |
$regions=$this->getRegions();
|
| 199 |
$preferences=get_app_inf('preferences');
|
| 200 |
$p=explode(',',$property['preferences']);
|
| 201 |
|
| 202 |
$_Image=&new Table_BoTable('images','id');
|
| 203 |
$conditions='property='.$pid;
|
| 204 |
$images=$_Image->findAll($conditions);
|
| 205 |
|
| 206 |
include(TPL_DIR.'/ViewProperty.tpl.php');
|
Filename: /home/l/o/lomondandtrossac/public_html/libs/APP/Controller/Default.php
#6
Model_Default::ViewProperty()
FILE: Default.php
LINE: 46
ARGS:
Array
(
)
SOURCE CODE:
| 36 |
$this->_modelClass->start();
|
| 37 |
}
|
| 38 |
function actionShowSearch(){
|
| 39 |
$this->_modelClass->ShowSearch();
|
| 40 |
}
|
| 41 |
function actionSearch(){
|
| 42 |
$this->_modelClass->Search();
|
| 43 |
|
| 44 |
}
|
| 45 |
function actionViewProperty (){
|
| 46 |
$this->_modelClass->ViewProperty();
|
| 47 |
}
|
| 48 |
function actionCheckAvail(){
|
| 49 |
$this->_modelClass->CheckAvail();
|
| 50 |
}
|
| 51 |
|
| 52 |
function actionBook(){
|
| 53 |
$this->_modelClass->Book();
|
| 54 |
}
|
| 55 |
|
| 56 |
function actionAddressDetails(){
|
Filename: /home/l/o/lomondandtrossac/public_html/libs/FLEA/FLEA/Dispatcher/Simple.php
#5
Controller_Default::actionViewProperty()
FILE: Simple.php
LINE: 127
ARGS:
Array
(
)
SOURCE CODE:
| 117 |
}
|
| 118 |
if (method_exists($controller, '__setDispatcher')) {
|
| 119 |
$controller->__setDispatcher($this);
|
| 120 |
}
|
| 121 |
|
| 122 |
// 调用 _beforeExecute() 方法
|
| 123 |
if (method_exists($controller, '_beforeExecute')) {
|
| 124 |
$controller->_beforeExecute($actionMethod);
|
| 125 |
}
|
| 126 |
// 执行 action 方法
|
| 127 |
$ret = $controller->{$actionMethod}();
|
| 128 |
// 调用 _afterExecute() 方法
|
| 129 |
if (method_exists($controller, '_afterExecute')) {
|
| 130 |
$controller->_afterExecute($actionMethod);
|
| 131 |
}
|
| 132 |
return $ret;
|
| 133 |
} while (false);
|
| 134 |
|
| 135 |
if ($callback) {
|
| 136 |
// 检查是否调用应用程序设置的错误处理程序
|
| 137 |
$args = array($controllerName, $actionName, $controllerClass);
|
Filename: /home/l/o/lomondandtrossac/public_html/libs/FLEA/FLEA/Dispatcher/Auth.php
#4
FLEA_Dispatcher_Simple::_executeAction('Default', 'ViewProperty', 'Controller_Default')
FILE: Auth.php
LINE: 127
ARGS:
Array
(
[0] => Default
[1] => ViewProperty
[2] => Controller_Default
)
SOURCE CODE:
| 117 |
* @return mixed
|
| 118 |
*/
|
| 119 |
function dispatching()
|
| 120 |
{
|
| 121 |
$controllerName = $this->getControllerName();
|
| 122 |
$actionName = $this->getActionName();
|
| 123 |
$controllerClass = $this->getControllerClass($controllerName);
|
| 124 |
|
| 125 |
if ($this->check($controllerName, $actionName, $controllerClass)) {
|
| 126 |
// 检查通过，执行控制器方法
|
| 127 |
return $this->_executeAction($controllerName, $actionName, $controllerClass);
|
| 128 |
} else {
|
| 129 |
// 检查失败
|
| 130 |
$callback = FLEA::getAppInf('dispatcherAuthFailedCallback');
|
| 131 |
|
| 132 |
$rawACT = $this->getControllerACT($controllerName, $controllerClass);
|
| 133 |
if ($rawACT == null || empty($rawACT)) { return true; }
|
| 134 |
$ACT = $this->_auth->prepareACT($rawACT);
|
| 135 |
$roles = $this->_auth->getRolesArray();
|
| 136 |
|
| 137 |
if ($callback) {
|
Filename: /home/l/o/lomondandtrossac/public_html/libs/FLEA/FLEA.php
#3
FLEA_Dispatcher_Auth::dispatching()
FILE: FLEA.php
LINE: 644
ARGS:
Array
(
)
SOURCE CODE:
| 634 |
require_once($MVCPackageFilename);
|
| 635 |
}
|
| 636 |
FLEA::init();
|
| 637 |
|
| 638 |
// 载入调度器并转发请求到控制器
|
| 639 |
$dispatcherClass = FLEA::getAppInf('dispatcher');
|
| 640 |
FLEA::loadClass($dispatcherClass);
|
| 641 |
|
| 642 |
$dispatcher =& new $dispatcherClass($_GET);
|
| 643 |
FLEA::register($dispatcher, $dispatcherClass);
|
| 644 |
$dispatcher->dispatching();
|
| 645 |
}
|
| 646 |
|
| 647 |
/**
|
| 648 |
* 准备运行环境
|
| 649 |
*
|
| 650 |
* @param boolean $loadMVC
|
| 651 |
*/
|
| 652 |
function init($loadMVC = false)
|
| 653 |
{
|
| 654 |
static $firstTime = true;
|
Filename: /home/l/o/lomondandtrossac/public_html/libs/FLEA/FLEA/Compatibility.php
#2
FLEA::runMVC()
FILE: Compatibility.php
LINE: 263
ARGS:
Array
(
)
SOURCE CODE:
| 253 |
FLEA::init();
|
| 254 |
}
|
| 255 |
|
| 256 |
/**
|
| 257 |
* FLEA 应用程序入口（已经过时，用 FLEA::runMVC() 代替）
|
| 258 |
*
|
| 259 |
* @deprecated
|
| 260 |
*/
|
| 261 |
function run()
|
| 262 |
{
|
| 263 |
FLEA::runMVC();
|
| 264 |
}
|
| 265 |
|
| 266 |
/**
|
| 267 |
* 初始化 Ajax，返回 FLEA_Ajax 对象实例（已经过时，用 FLEA::initAjax() 代替）
|
| 268 |
*
|
| 269 |
* @return FLEA_Ajax
|
| 270 |
* @deprecated
|
| 271 |
*/
|
| 272 |
function & init_ajax()
|
| 273 |
{
|
Filename: /home/l/o/lomondandtrossac/public_html/index.php
#1
run()
FILE: index.php
LINE: 45
ARGS:
SOURCE CODE:
| 35 |
/**/
|
| 36 |
// APP_DIR 常量指示模版的保存目录
|
| 37 |
define('APP_DIR', dirname(__FILE__));
|
| 38 |
define('TPL_DIR',APP_DIR.'/templates');
|
| 39 |
|
| 40 |
require('libs/FLEA/FLEA.php');
|
| 41 |
register_app_inf(APP_DIR . '/libs/APP/Config/DSN.php');
|
| 42 |
register_app_inf(APP_DIR . '/libs/APP/Config/BO_APP_INF.php');
|
| 43 |
import(APP_DIR . '/libs/APP');
|
| 44 |
|
| 45 |
run();
|
| 46 |
?> |