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 '' at line 1"
SQL 语句: "SELECT `userimage`.* FROM `userimage` WHERE id=141 and aid= "
SQL 错误代码: "7335941".
Filename: /home5/connexi2/public_html/gznightlife/lib/flea/FLEA/Db/TableDataGateway.php [448]
#6 FLEA_Db_Driver_Mysql::execute('SELECT `userimage`.* FROM ...')
ARGS:
Array
(
[0] => SELECT `userimage`.* FROM `userimage` WHERE id=141 and aid=
)
SOURCE CODE:
| 438 |
// 当有关联需要处理时，必须获得主表的主键字段值
|
| 439 |
$sql = "SELECT {$distinct} {$this->qpka}, {$fields} FROM {$this->qtableName} {$whereby} {$sortby}";
|
| 440 |
} else {
|
| 441 |
$sql = "SELECT {$distinct} {$fields} FROM {$this->qtableName} {$whereby} {$sortby}";
|
| 442 |
}
|
| 443 |
|
| 444 |
// 根据 $length 和 $offset 参数决定是否使用限定结果集的查询
|
| 445 |
if (null !== $length || null !== $offset) {
|
| 446 |
$result = $this->dbo->selectLimit($sql, $length, $offset);
|
| 447 |
} else {
|
| 448 |
$result = $this->dbo->execute($sql);
|
| 449 |
}
|
| 450 |
|
| 451 |
if ($enableLinks) {
|
| 452 |
/**
|
| 453 |
* 查询时同时将主键值单独提取出来，
|
| 454 |
* 并且准备一个以主键值为键名的二维数组用于关联数据的装配
|
| 455 |
*/
|
| 456 |
$pkvs = array();
|
| 457 |
$assocRowset = null;
|
| 458 |
$rowset = $this->dbo->getAllWithFieldRefs($result, $this->pka, $pkvs, $assocRowset);
|
Filename: /home5/connexi2/public_html/gznightlife/app/front/Controller/pictures.php [246]
#5 FLEA_Db_TableDataGateway::findAll('id=141 and aid=', '')
ARGS:
Array
(
[0] => id=141 and aid=
[1] =>
)
SOURCE CODE:
| 236 |
$limit='';
|
| 237 |
}else{
|
| 238 |
$conditions='id>'.$p[1];
|
| 239 |
$limit=' id asc LIMIT 1';
|
| 240 |
}
|
| 241 |
}
|
| 242 |
|
| 243 |
if($p[0]=="a"){
|
| 244 |
$albumid = $_userimage->find($p[1]);
|
| 245 |
$aid=$albumid['aid'];
|
| 246 |
$image = $_userimage->findall($conditions." and aid=".$aid,$limit);
|
| 247 |
$album = $_album->find($image[0]['aid']);
|
| 248 |
$kid = 'a_'.$image[0]['aid']; //获取相册的ID，前辍为a--eyuan
|
| 249 |
$title = $album['title'];
|
| 250 |
$pid="a_".$image[0]['id'];
|
| 251 |
}else{
|
| 252 |
$eventid = $_eventimage->find($p[1]);
|
| 253 |
$eid=$eventid['eid'];
|
| 254 |
$image = $_eventimage->findall($conditions." and eid=".$eid,$limit);
|
| 255 |
$event = $_event->find($image[0]['eid']);
|
| 256 |
$kid = 'v_'.$image[0]['eid']; //获取相册的ID前辍为v--eyuan
|
Filename: /home5/connexi2/public_html/gznightlife/lib/flea/FLEA/Dispatcher/Simple.php [120]
#4 controller_pictures::actionpicturesbig()
ARGS:
Array
(
)
SOURCE CODE:
| 110 |
}
|
| 111 |
if (method_exists($controller, '__setDispatcher')) {
|
| 112 |
$controller->__setDispatcher($this);
|
| 113 |
}
|
| 114 |
|
| 115 |
// 调用 _beforeExecute() 方法
|
| 116 |
if (method_exists($controller, '_beforeExecute')) {
|
| 117 |
$controller->_beforeExecute($actionMethod);
|
| 118 |
}
|
| 119 |
// 执行 action 方法
|
| 120 |
$ret = $controller->{$actionMethod}();
|
| 121 |
// 调用 _afterExecute() 方法
|
| 122 |
if (method_exists($controller, '_afterExecute')) {
|
| 123 |
$controller->_afterExecute($actionMethod);
|
| 124 |
}
|
| 125 |
return $ret;
|
| 126 |
} while (false);
|
| 127 |
|
| 128 |
if ($callback) {
|
| 129 |
// 检查是否调用应用程序设置的错误处理程序
|
| 130 |
$args = array($controllerName, $actionName, $controllerClass);
|
Filename: /home5/connexi2/public_html/gznightlife/lib/flea/FLEA/Dispatcher/Auth.php [127]
#3 FLEA_Dispatcher_Simple::_executeAction('pictures', 'picturesbig', 'Controller_pictures')
ARGS:
Array
(
[0] => pictures
[1] => picturesbig
[2] => Controller_pictures
)
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 (is_null($rawACT) || 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: /home5/connexi2/public_html/gznightlife/lib/flea/FLEA.php [816]
#2 FLEA_Dispatcher_Auth::dispatching()
ARGS:
Array
(
)
SOURCE CODE:
| 806 |
require_once($MVCPackageFilename);
|
| 807 |
}
|
| 808 |
FLEA::init();
|
| 809 |
|
| 810 |
// 载入调度器并转发请求到控制器
|
| 811 |
$dispatcherClass = FLEA::getAppInf('dispatcher');
|
| 812 |
FLEA::loadClass($dispatcherClass);
|
| 813 |
|
| 814 |
$dispatcher =& new $dispatcherClass($_GET);
|
| 815 |
FLEA::register($dispatcher, $dispatcherClass);
|
| 816 |
$dispatcher->dispatching();
|
| 817 |
}
|
| 818 |
|
| 819 |
/**
|
| 820 |
* 准备运行环境
|
| 821 |
*
|
| 822 |
* @param boolean $loadMVC
|
| 823 |
*/
|
| 824 |
function init($loadMVC = false)
|
| 825 |
{
|
| 826 |
static $firstTime = true;
|
Filename: /home5/connexi2/public_html/gznightlife/index.php [69]
#1 FLEA::runMVC()
ARGS:
Array
(
)
SOURCE CODE:
| 59 |
*@param string $className
|
| 60 |
*@return object
|
| 61 |
**/
|
| 62 |
$_base=&FLEA::getSingleton('model_base');
|
| 63 |
$base=$_base->base();//所有页面都要用到的信息
|
| 64 |
|
| 65 |
/**
|
| 66 |
*如果要使用 FleaPHP 的 MVC 模式。那么在载入 FLEA.php 后，调用 FLEA::runMVC() 即可启动 MVC 模式。
|
| 67 |
*在 MVC 模式启动后，FleaPHP 会根据 URL 地址中包含的控制器名称和控制器动作名称，执行开发者编写的控制器代码。
|
| 68 |
**/
|
| 69 |
FLEA::runMVC();
|
| 70 |
?> |