Exception: flea_db_exception_sqlquery
Message: SQL Error Message: "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 7"
SQL : "
SELECT
u2_meeting_sort.id,
u2_meeting_sort.title
FROM
u2_meeting_sort
where
u2_meeting_sort.id=
"
SQL Error code: "7335941".
Filename: /usr/home/vhosts/u2ipo/FLEA/FLEA/Db/Driver/Mysql.php
#10
flea_db_exception_sqlquery::flea_db_exception_sqlquery('
SELECT
u2_meeting ...', 'You have an error in your S ...', 1064)
FILE: Mysql.php
LINE: 230
ARGS:
Array
(
[0] =>
SELECT
u2_meeting_sort.id,
u2_meeting_sort.title
FROM
u2_meeting_sort
where
u2_meeting_sort.id=
[1] => 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 7
[2] => 1064
)
SOURCE CODE:
| 220 |
if ($result !== false) {
|
| 221 |
$this->lasterr = null;
|
| 222 |
$this->lasterrcode = null;
|
| 223 |
return $result;
|
| 224 |
}
|
| 225 |
$this->lasterr = mysql_error($this->conn);
|
| 226 |
$this->lasterrcode = mysql_errno($this->conn);
|
| 227 |
if (!$throw) { return false; }
|
| 228 |
|
| 229 |
FLEA::loadClass('FLEA_Db_Exception_SqlQuery');
|
| 230 |
__THROW(new FLEA_Db_Exception_SqlQuery($sql, $this->lasterr, $this->lasterrcode));
|
| 231 |
return false;
|
| 232 |
}
|
| 233 |
|
| 234 |
/**
|
| 235 |
* 转义字符串
|
| 236 |
*
|
| 237 |
* @param string $value
|
| 238 |
*
|
| 239 |
* @return mixed
|
| 240 |
*/
|
Filename: /usr/home/vhosts/u2ipo/FLEA/FLEA/Db/Driver/Mysql.php
#9
flea_db_driver_mysql::execute('
SELECT
u2_meeting ...')
FILE: Mysql.php
LINE: 633
ARGS:
Array
(
[0] =>
SELECT
u2_meeting_sort.id,
u2_meeting_sort.title
FROM
u2_meeting_sort
where
u2_meeting_sort.id=
)
SOURCE CODE:
| 623 |
*
|
| 624 |
* @param string|resource $sql
|
| 625 |
*
|
| 626 |
* @return mixed
|
| 627 |
*/
|
| 628 |
function & getRow($sql)
|
| 629 |
{
|
| 630 |
if (is_resource($sql)) {
|
| 631 |
$res = $sql;
|
| 632 |
} else {
|
| 633 |
$res = $this->execute($sql);
|
| 634 |
}
|
| 635 |
$row = mysql_fetch_assoc($res);
|
| 636 |
mysql_free_result($res);
|
| 637 |
return $row;
|
| 638 |
}
|
| 639 |
|
| 640 |
/**
|
| 641 |
* 执行查询，返回结果集的指定列
|
| 642 |
*
|
| 643 |
* @param string|resource $sql
|
Filename: /usr/home/vhosts/u2ipo/u2ipo/Model/Moved.php
#8
flea_db_driver_mysql::getrow('
SELECT
u2_meeting ...')
FILE: Moved.php
LINE: 188
ARGS:
Array
(
[0] =>
SELECT
u2_meeting_sort.id,
u2_meeting_sort.title
FROM
u2_meeting_sort
where
u2_meeting_sort.id=
)
SOURCE CODE:
| 178 |
//根据活动类型id缺的该该会议类型
|
| 179 |
function getMovedSortName($id){
|
| 180 |
$sortname=$this->_dbo->getRow("
|
| 181 |
SELECT
|
| 182 |
u2_meeting_sort.id,
|
| 183 |
u2_meeting_sort.title
|
| 184 |
FROM
|
| 185 |
u2_meeting_sort
|
| 186 |
where
|
| 187 |
u2_meeting_sort.id=$id
|
| 188 |
");
|
| 189 |
return $sortname;
|
| 190 |
}
|
| 191 |
|
| 192 |
|
| 193 |
|
| 194 |
//根据活动id查询参与人员和项目情况
|
| 195 |
function getMemberProjectName($meeting_id){
|
| 196 |
$MPN=$this->_dbo->getAll("
|
| 197 |
SELECT
|
| 198 |
u2_meeting_join.project_id,
|
Filename: /usr/home/vhosts/u2ipo/u2ipo/Model/Moved.php
#7
model_moved::getmovedsortname()
FILE: Moved.php
LINE: 114
ARGS:
Array
(
[0] =>
)
SOURCE CODE:
| 104 |
u2_meeting.othercontact,
|
| 105 |
u2_meeting.endtime,
|
| 106 |
u2_meeting.project_joined_count,
|
| 107 |
u2_meeting.project_joined_limit,
|
| 108 |
u2_meeting.topic_page
|
| 109 |
FROM
|
| 110 |
u2_meeting
|
| 111 |
WHERE
|
| 112 |
u2_meeting.id=$id
|
| 113 |
");
|
| 114 |
$OneMoved['sort_name']=$this->getMovedSortName($OneMoved['sort_id']);
|
| 115 |
$OneMoved['onlydays'] = $this->onlydays($OneMoved['begintime']);
|
| 116 |
$OneMoved['hold1'] = $this->getHoldsAll($OneMoved['hold1']);
|
| 117 |
$OneMoved['hold2'] = $this->getHoldsAll($OneMoved['hold2']);
|
| 118 |
$OneMoved['hold3'] = $this->getHoldsAll($OneMoved['hold3']);
|
| 119 |
$OneMoved['media_list'] = $this->getHoldsAll($OneMoved['media_list']);
|
| 120 |
$OneMoved['support'] = $this->getHoldsAll($OneMoved['support']);
|
| 121 |
$OneMoved['nowtime']=time();
|
| 122 |
|
| 123 |
//活动结束标志更新
|
| 124 |
if ($OneMoved['begintime']<=$OneMoved['nowtime']){
|
Filename: /usr/home/vhosts/u2ipo/u2ipo/Controller/Moved.php
#6
model_moved::getonemoved(41)
FILE: Moved.php
LINE: 44
ARGS:
Array
(
[0] => 41
)
SOURCE CODE:
| 34 |
}
|
| 35 |
|
| 36 |
$this->_smarty->display('moved_list.html');
|
| 37 |
}
|
| 38 |
|
| 39 |
////////////////////////////////////////////////////////////////////////活动显示
|
| 40 |
function actionShow() {
|
| 41 |
$id = (int)$_REQUEST['id'];
|
| 42 |
if($id){
|
| 43 |
//$url = url('Moved', 'Show');
|
| 44 |
$OneMoved=$this->_modelMoved->getOneMoved($id);
|
| 45 |
//$OneMoved['topic_page']="http://www.u2ipo.com/nc2007";
|
| 46 |
if($OneMoved['topic_page']!='' and $OneMoved['noend']=='0'){
|
| 47 |
$url=$OneMoved['topic_page'];
|
| 48 |
header("location:$url");
|
| 49 |
}
|
| 50 |
$this->_smarty->assign('OM',$OneMoved);
|
| 51 |
$MovedReviewO = $this->_modelMoved->getMovedReview(1);
|
| 52 |
$this->_smarty->assign('MRO', $MovedReviewO);
|
| 53 |
$MovedPhotos = $this->_modelMoved->getMovedPhotos($id);
|
| 54 |
$this->_smarty->assign('MRPs', $MovedPhotos);
|
Filename: /usr/home/vhosts/u2ipo/FLEA/FLEA/Dispatcher/Simple.php
#5
controller_moved::actionshow()
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: /usr/home/vhosts/u2ipo/FLEA/FLEA/Dispatcher/Simple.php
#4
flea_dispatcher_simple::_executeaction('Moved', 'Show', 'Controller_Moved')
FILE: Simple.php
LINE: 77
ARGS:
Array
(
[0] => Moved
[1] => Show
[2] => Controller_Moved
)
SOURCE CODE:
| 67 |
|
| 68 |
/**
|
| 69 |
* 从请求中分析 Controller、Action 和 Package 名字，然后执行指定的 Action 方法
|
| 70 |
*
|
| 71 |
* @return mixed
|
| 72 |
*/
|
| 73 |
function dispatching()
|
| 74 |
{
|
| 75 |
$controllerName = $this->getControllerName();
|
| 76 |
$actionName = $this->getActionName();
|
| 77 |
return $this->_executeAction($controllerName, $actionName, $this->getControllerClass($controllerName));
|
| 78 |
}
|
| 79 |
|
| 80 |
/**
|
| 81 |
* 执行指定的 Action 方法
|
| 82 |
*
|
| 83 |
* @param string $controllerName
|
| 84 |
* @param string $actionName
|
| 85 |
* @param string $controllerClass
|
| 86 |
*
|
| 87 |
* @return mixed
|
Filename: /usr/home/vhosts/u2ipo/FLEA/FLEA.php
#3
flea_dispatcher_simple::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: /usr/home/vhosts/u2ipo/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: /usr/home/vhosts/u2ipo/index.php
#1
run()
FILE: index.php
LINE: 7
ARGS:
Array
(
)
SOURCE CODE:
| 1 |
<?php
|
| 2 |
|
| 3 |
require('FLEA/FLEA.php');
|
| 4 |
FLEA::setAppInf('urlMode', URL_REWRITE);
|
| 5 |
import(dirname(__FILE__) . '/u2ipo');
|
| 6 |
register_app_inf('u2ipo/Config/u2ipo.php');
|
| 7 |
run();
|
| 8 |
?> |