Exception: FLEA_Db_Exception_SqlQuery
Message: SQL 错误消息: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND right_value >
ORDER BY left_value ASC' at line 3"
SQL 语句: "SELECT `commclass`.*
FROM `commclass`
WHERE left_value < AND right_value >
ORDER BY left_value ASC"
SQL 错误代码: "7335941".
Filename: /home/markmx/domains/diggames.net/public_html/Classes/FLEA/Db/TableDataGateway.php
#8
FLEA_Db_Driver_Mysql::execute('SELECT `commclass`.*
FROM ` ...')
FILE: TableDataGateway.php
LINE: 427
ARGS:
Array
(
[0] => SELECT `commclass`.*
FROM `commclass`
WHERE left_value < AND right_value >
ORDER BY left_value ASC
)
SOURCE CODE:
| 417 |
// 当有关联需要处理时，必须获得主表的主键字段值
|
| 418 |
$sql = "SELECT {$distinct}{$this->qpka}, {$fields}\nFROM {$this->qtableName}{$whereby}{$sortby}";
|
| 419 |
} else {
|
| 420 |
$sql = "SELECT {$distinct}{$fields}\nFROM {$this->qtableName}{$whereby}{$sortby}";
|
| 421 |
}
|
| 422 |
|
| 423 |
// 根据 $length 和 $offset 参数决定是否使用限定结果集的查询
|
| 424 |
if (null !== $length || null !== $offset) {
|
| 425 |
$result = $this->dbo->selectLimit($sql, $length, $offset);
|
| 426 |
} else {
|
| 427 |
$result = $this->dbo->execute($sql);
|
| 428 |
}
|
| 429 |
|
| 430 |
if ($enableLinks) {
|
| 431 |
/**
|
| 432 |
* 查询时同时将主键值单独提取出来，
|
| 433 |
* 并且准备一个以主键值为键名的二维数组用于关联数据的装配
|
| 434 |
*/
|
| 435 |
$pkvs = array();
|
| 436 |
$assocRowset = null;
|
| 437 |
$rowset = $this->dbo->getAllWithFieldRefs($result,
|
Filename: /home/markmx/domains/diggames.net/public_html/WebApp/Table/Node.php
#7
FLEA_Db_TableDataGateway::findAll('left_value < AND right_val ...', 'left_value ASC')
FILE: Node.php
LINE: 146
ARGS:
Array
(
[0] => left_value < AND right_value >
[1] => left_value ASC
)
SOURCE CODE:
| 136 |
* 结果集是一个二维数组，可以用 array_to_tree() 函数转换为层次结构（树型）。
|
| 137 |
*
|
| 138 |
* @param array $node
|
| 139 |
*
|
| 140 |
* @return array
|
| 141 |
*/
|
| 142 |
function getPath($node) {
|
| 143 |
$conditions = "left_value < {$node['left_value']} AND " .
|
| 144 |
"right_value > {$node['right_value']}";
|
| 145 |
$sort = 'left_value ASC';
|
| 146 |
$rowset = $this->findAll($conditions, $sort);
|
| 147 |
if (is_array($rowset)) {
|
| 148 |
array_shift($rowset);
|
| 149 |
}
|
| 150 |
return $rowset;
|
| 151 |
}
|
| 152 |
|
| 153 |
/**
|
| 154 |
* 返回指定节点的直接子节点
|
| 155 |
*
|
| 156 |
* @param array $node
|
Filename: /home/markmx/domains/diggames.net/public_html/WebApp/Model/ClassInfo.php
#6
Table_Node::getPath()
FILE: ClassInfo.php
LINE: 24
ARGS:
Array
(
[0] =>
)
SOURCE CODE:
| 14 |
$this->_CommClass->enableLinks();
|
| 15 |
$rtString ="<a href=\"/\">首页</a> »";
|
| 16 |
$rtString.= "<a href=\"".$Thisis->_url($Path)."\">";
|
| 17 |
$rtString.="{$ClassNode['name']}</a>»";
|
| 18 |
return $rtString;
|
| 19 |
}
|
| 20 |
|
| 21 |
function getClassIDPath($ClassId,$Thisis=null,$PathName="MainList"){
|
| 22 |
$this->_CommClass->disableLinks();
|
| 23 |
$ClassNode= $this->_CommClass->find(array("class_id"=>$ClassId));
|
| 24 |
$ClassPath=$this->_CommClass->getPath($ClassNode);
|
| 25 |
$this->_CommClass->enableLinks();
|
| 26 |
if (is_array($ClassPath)) {
|
| 27 |
array_shift($ClassPath);
|
| 28 |
}
|
| 29 |
array_push($ClassPath,$ClassNode);
|
| 30 |
|
| 31 |
$rtString ="<a href=\"/\">首页</a> »";
|
| 32 |
|
| 33 |
if(is_array($ClassPath)){
|
| 34 |
foreach ($ClassPath as $Path){
|
Filename: /home/markmx/domains/diggames.net/public_html/WebApp/Controller/China.php
#5
Model_ClassInfo::getClassIDPath(, Controller_China, 'RegulationsList')
FILE: China.php
LINE: 165
ARGS:
Array
(
[0] =>
[1] => Controller_China Object
(
[_Include_Son_Arrey] => Array
(
[0] => WSTZZL
[1] => GSFZL
[2] => LDRSFLZL
)
[_Include_Son_Arrey_Url] => Array
(
[0] => Invest
[1] => Bylaw
[2] => Economiclaw
)
[_Include_Default_Arrey] => Array
(
[0] => ZSCQZL
[1] => HTF
)
[DefaultController] => China
[CNController] => China
[ENController] => English
[JPController] => Japan
[WebMunBer] => 000000602714
[OpenWeb] => 0000-00-00
[_controllerName] => China
[_dispatcher] => FLEA_Dispatcher_Auth Object
(
[_auth] => FLEA_Rbac Object
(
[_sessionKey] => gview.com.Web
[_rolesKey] => RBAC_ROLES
)
[_request] => Array
(
[controller] => China
[action] => RegulationsView
)
[_requestBackup] => Array
(
[controller] => China
[action] => RegulationsView
)
)
[components] => Array
(
)
[_renderCallbacks] => Array
(
)
)
[2] => RegulationsList
)
SOURCE CODE:
| 155 |
$PgaeValue=$pager->getPagerData();
|
| 156 |
|
| 157 |
include(DefaultTemplate."/regulationslist.php");
|
| 158 |
}
|
| 159 |
|
| 160 |
function actionRegulationsView(){
|
| 161 |
$Home_A='Regulations';
|
| 162 |
$Table_CommInfo = &FLEA::getSingleton("Table_CommInfo");
|
| 163 |
$Model_ClassInfo =&FLEA::getSingleton("Model_ClassInfo");
|
| 164 |
$InfoViewNode=$Table_CommInfo->find(array("info_id"=>GetNumHttp("id")));
|
| 165 |
$PathString=$Model_ClassInfo->getClassIDPath($InfoViewNode['commclass']['class_id'],$this,"RegulationsList");
|
| 166 |
include(DefaultTemplate."/regulationsview.php");
|
| 167 |
}
|
| 168 |
|
| 169 |
function actionMainView(){
|
| 170 |
$Home_A='';
|
| 171 |
$Table_CommInfo = &FLEA::getSingleton("Table_CommInfo");
|
| 172 |
$Model_ClassInfo =&FLEA::getSingleton("Model_ClassInfo");
|
| 173 |
$InfoViewNode=$Table_CommInfo->find(array("info_id"=>GetNumHttp("infoid")));
|
| 174 |
$PathString=$Model_ClassInfo->getClassIDPath($InfoViewNode['commclass']['class_id'],$this,"MainList");
|
| 175 |
include(DefaultTemplate."/view.php");
|
Filename: /home/markmx/domains/diggames.net/public_html/Classes/FLEA/Dispatcher/Simple.php
#4
Controller_China::actionRegulationsView()
FILE: Simple.php
LINE: 121
ARGS:
Array
(
)
SOURCE CODE:
| 111 |
}
|
| 112 |
if (method_exists($controller, '__setDispatcher')) {
|
| 113 |
$controller->__setDispatcher($this);
|
| 114 |
}
|
| 115 |
|
| 116 |
// 调用 _beforeExecute() 方法
|
| 117 |
if (method_exists($controller, '_beforeExecute')) {
|
| 118 |
$controller->_beforeExecute($actionMethod);
|
| 119 |
}
|
| 120 |
// 执行 action 方法
|
| 121 |
$ret = $controller->{$actionMethod}();
|
| 122 |
// 调用 _afterExecute() 方法
|
| 123 |
if (method_exists($controller, '_afterExecute')) {
|
| 124 |
$controller->_afterExecute($actionMethod);
|
| 125 |
}
|
| 126 |
return $ret;
|
| 127 |
} while (false);
|
| 128 |
|
| 129 |
if ($callback && !$noCallback) {
|
| 130 |
// 检查是否调用应用程序设置的错误处理程序
|
| 131 |
$args = array($controllerName, $actionName, $controllerClass);
|
Filename: /home/markmx/domains/diggames.net/public_html/Classes/FLEA/Dispatcher/Auth.php
#3
FLEA_Dispatcher_Simple::_executeAction('China', 'RegulationsView', 'Controller_China')
FILE: Auth.php
LINE: 127
ARGS:
Array
(
[0] => China
[1] => RegulationsView
[2] => Controller_China
)
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 |
$args = array($controllerName, $actionName, $controllerClass, $ACT, $roles);
|
| 137 |
|
Filename: /home/markmx/domains/diggames.net/public_html/Classes/FLEA.php
#2
FLEA_Dispatcher_Auth::dispatching()
FILE: FLEA.php
LINE: 651
ARGS:
Array
(
)
SOURCE CODE:
| 641 |
require_once($MVCPackageFilename);
|
| 642 |
}
|
| 643 |
FLEA::init();
|
| 644 |
|
| 645 |
// 载入调度器并转发请求到控制器
|
| 646 |
$dispatcherClass = FLEA::getAppInf('dispatcher');
|
| 647 |
FLEA::loadClass($dispatcherClass);
|
| 648 |
|
| 649 |
$dispatcher =& new $dispatcherClass($_GET);
|
| 650 |
FLEA::register($dispatcher, $dispatcherClass);
|
| 651 |
$dispatcher->dispatching();
|
| 652 |
}
|
| 653 |
|
| 654 |
/**
|
| 655 |
* 准备运行环境
|
| 656 |
*
|
| 657 |
* @param boolean $loadMVC
|
| 658 |
*/
|
| 659 |
function init($loadMVC = false)
|
| 660 |
{
|
| 661 |
static $firstTime = true;
|
Filename: /home/markmx/domains/diggames.net/public_html/index.php
#1
FLEA::runMVC()
FILE: index.php
LINE: 49
ARGS:
Array
(
)
SOURCE CODE:
| 39 |
|
| 40 |
include(ErrorTemplate_DIR.'/error.php');
|
| 41 |
|
| 42 |
require(LIBS_DIR . '/FLEA.php');
|
| 43 |
require(Class_DIR . '/Class.php');
|
| 44 |
|
| 45 |
FLEA::loadAppInf(CONFIG_DIR."/dns.php");
|
| 46 |
FLEA::loadAppInf(CONFIG_DIR."/web_app_inf.php");
|
| 47 |
FLEA::import(WebAPP_DIR);
|
| 48 |
|
| 49 |
FLEA::runMVC();
|
| 50 |
?>
|