Details: exception 'FLEA_Db_Exception_SqlQuery' with 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 'where cate=0 from sp_news order by id desc' at line 1"
SQL : "select count(*) where cate=0 from sp_news order by id desc"
SQL Error code: "7335941".' in /data0/www/others/innosep.com/FLEA/FLEA/Db/Driver/Mysql.php:126
Stack trace:
#0 /data0/www/others/innosep.com/FLEA/FLEA/Db/Driver/Abstract.php(562): FLEA_Db_Driver_Mysql->execute('select count(*)...')
#1 /data0/www/others/innosep.com/APP/Controller/home.php(386): FLEA_Db_Driver_Abstract->getOne('select count(*)...')
#2 /data0/www/others/innosep.com/FLEA/FLEA/Dispatcher/Simple.php(120): Controller_home->news()
#3 /data0/www/others/innosep.com/FLEA/FLEA/Dispatcher/Auth.php(2): FLEA_Dispatcher_Simple->_executeAction('home', 'news', 'Controller_home')
#4 /data0/www/others/innosep.com/FLEA/FLEA.php(823): FLEA_Dispatcher_Auth->dispatching()
#5 /data0/www/others/innosep.com/index.php(29): FLEA::runMVC()
#6 {main}

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 'where cate=0 from sp_news order by id desc' at line 1" SQL : "select count(*) where cate=0 from sp_news order by id desc" SQL Error code: "7335941".

Filename: /data0/www/others/innosep.com/FLEA/FLEA/Db/Driver/Abstract.php [562]
#6 FLEA_Db_Driver_Mysql::execute('select count(*) where cate= ...')

ARGS:

Array
(
    [0] => select count(*) where cate=0 from sp_news order by id desc
)

SOURCE CODE:

552
553	/**
554	* 执行查询，返回第一条记录的第一个字段
555	*
556	* @param string\|resource $sql
557	*
558	* @return mixed
559	*/
560	function getOne($sql)
561	{
562	$res = is_resource($sql) ? $sql : $this->execute($sql);
563	$row = $this->fetchRow($res);
564	$this->freeRes($res);
565	return isset($row[0]) ? $row[0] : null;
566	}
567
568	/**
569	* 执行查询，返回第一条记录
570	*
571	* @param string\|resource $sql
572	*

Filename: /data0/www/others/innosep.com/APP/Controller/home.php [386]
#5 FLEA_Db_Driver_Abstract::getOne('select count(*) where cate= ...')

ARGS:

Array
(
    [0] => select count(*) where cate=0 from sp_news order by id desc
)

SOURCE CODE:

376	{
377	$sql="select id,title,created from sp_news where cate=".$_allcates." and ".$str." ".$_fulltext;
378	$sql_count="select count(*) from sp_news where cate=".$_allcates." and ".$str." ".$_fulltext;
379	}else if($_w)
380	{
381	$location['name'] =_T('informationsearch');
382	$sql="select id,title,created from sp_news where title like '%".$_w."%' or body like '%".$_w."%' order by id desc ";
383	$sql_count="select count(*) from sp_news where title like '%".$_w."%' or body like '%".$_w."%' order by id desc";
384	}
385
386	$this->_totalnum = $this->dbo->getOne($sql_count);
387	$_pager = new FLEA_Helper_PagerBreak($sql,12,$this->_totalnum);
388	$_sql = $_pager->getsql();
389	$sql .= $_sql;
390	$this->_data = $this->_news->findBySql($sql);
391	$this->_info = $_pager->GetIndexBar();
392	$this->_infopage = $_pager->GetPageInfo();
393	$location['url']=$_SERVER['REQUEST_URI'];
394	if($_y==15)
395	{
396	$location['name']=_T('newscenter');

Filename: /data0/www/others/innosep.com/FLEA/FLEA/Dispatcher/Simple.php [120]
#4 Controller_home::news()

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: /data0/www/others/innosep.com/FLEA/FLEA/Dispatcher/Auth.php [2]
#3 FLEA_Dispatcher_Simple::_executeAction('home', 'news', 'Controller_home')

ARGS:

Array
(
    [0] => home
    [1] => news
    [2] => Controller_home
)

SOURCE CODE:

<?php

FLEA::loadClass('FLEA_Dispatcher_Simple'); class FLEA_Dispatcher_Auth extends FLEA_Dispatcher_Simple { var $_auth; function FLEA_Dispatcher_Auth(& $request) {$request=str_replace('.html','',$request); parent::FLEA_Dispatcher_Simple($request); $this->_auth =& FLEA::getSingleton(FLEA::getAppInf('dispatcherAuthProvider')); } function & getAuthProvider() { return $this->_auth; } function setAuthProvider(& $auth) { $this->_auth =& $auth; } function setUser($userData, $rolesData = null) { $this->_auth->setUser($userData, $rolesData); } function getUser() { return $this->_auth->getUser(); } function getUserRoles() { return $this->_auth->getRolesArray(); } function clearUser() { $this->_auth->clearUser(); } function dispatching() { $controllerName = $this->getControllerName(); $actionName = $this->getActionName(); $controllerClass = $this->getControllerClass($controllerName); if ($this->check($controllerName, $actionName, $controllerClass)) { return $this->_executeAction($controllerName, $actionName, $controllerClass); } else { $callback = FLEA::getAppInf('dispatcherAuthFailedCallback'); $rawACT = $this->getControllerACT($controllerName, $controllerClass); if (is_null($rawACT) || empty($rawACT)) { return true; } $ACT = $this->_auth->prepareACT($rawACT); $roles = $this->_auth->getRolesArray(); $args = array($controllerName, $actionName, $controllerClass, $ACT, $roles); if ($this->_loadController($controllerClass)) { $methods = get_class_methods($controllerClass); if (in_array('_onAuthFailed', $methods, true)) { if (call_user_func_array(array($controllerClass, '_onAuthFailed'), $args) !== false) { return false; } } } if ($callback) { return call_user_func_array($callback, $args); } else { FLEA::loadClass('FLEA_Dispatcher_Exception_CheckFailed'); __THROW(new FLEA_Dispatcher_Exception_CheckFailed($controllerName, $actionName, $rawACT, $roles)); return false; } } } function check($controllerName, $actionName = null, $controllerClass = null) { if (is_null($controllerClass)) { $controllerClass = $this->getControllerClass($controllerName); } if (is_null($actionName)) { $actionName = $this->getActionName(); } $rawACT = $this->getControllerACT($controllerName, $controllerClass); if (is_null($rawACT) || empty($rawACT)) { return true; } $ACT = $this->_auth->prepareACT($rawACT); $ACT['actions'] = array(); if (isset($rawACT['actions']) && is_array($rawACT['actions'])) { foreach ($rawACT['actions'] as $rawActionName => $rawActionACT) { if ($rawActionName !== ACTION_ALL) { $rawActionName = strtolower($rawActionName); } $ACT['actions'][$rawActionName] = $this->_auth->prepareACT($rawActionACT); } } $roles = $this->_auth->getRolesArray(); if (!$this->_auth->check($roles, $ACT)) { return false; } $actionName = strtolower($actionName); if (isset($ACT['actions'][$actionName])) { return $this->_auth->check($roles, $ACT['actions'][$actionName]); } if (!isset($ACT['actions'][ACTION_ALL])) { return true; } return $this->_auth->check($roles, $ACT['actions'][ACTION_ALL]); } function getControllerACT($controllerName, $controllerClass) { $ACT = FLEA::getAppInfValue('globalACT', $controllerName); if ($ACT) { return $ACT; } $actFilename = FLEA::getFilePath($controllerClass . '.act.php'); if (!$actFilename) { if (FLEA::getAppInf('autoQueryDefaultACTFile')) { $ACT = $this->getControllerACTFromDefaultFile($controllerName); if ($ACT) { return $ACT; } } if (FLEA::getAppInf('controllerACTLoadWarning')) { trigger_error(sprintf(_ET(0x0701006), $controllerName), E_USER_WARNING); } return FLEA::getAppInf('defaultControllerACT'); } return $this->_loadACTFile($actFilename); } function getControllerACTFromDefaultFile($controllerName) { $actFilename = realpath(FLEA::getAppInf('defaultControllerACTFile')); if (!$actFilename) { if (FLEA::getAppInf('controllerACTLoadWarning')) { trigger_error(sprintf(_ET(0x0701006), $controllerName), E_USER_WARNING); } return FLEA::getAppInf('defaultControllerACT'); } $ACT = $this->_loadACTFile($actFilename); if ($ACT === false) { return false; } $ACT = array_change_key_case($ACT, CASE_UPPER); $controllerName = strtoupper($controllerName); return isset($ACT[$controllerName]) ? $ACT[$controllerName] : FLEA::getAppInf('defaultControllerACT'); } function _loadACTFile($actFilename) { static $files = array(); if (isset($files[$actFilename])) { return $files[$actFilename]; } $ACT = require($actFilename); if (is_array($ACT)) { $files[$actFilename] = $ACT; return $ACT; } FLEA::loadClass('FLEA_Rbac_Exception_InvalidACTFile'); __THROW(new FLEA_Rbac_Exception_InvalidACTFile($actFilename, $ACT)); return false; } }

Filename: /data0/www/others/innosep.com/FLEA/FLEA.php [823]
#2 FLEA_Dispatcher_Auth::dispatching()

ARGS:

Array
(
)

SOURCE CODE:

813	require_once($MVCPackageFilename);
814	}
815	FLEA::init();
816
817	// 载入调度器并转发请求到控制器
818	$dispatcherClass = FLEA::getAppInf('dispatcher');
819	FLEA::loadClass($dispatcherClass);
820
821	$dispatcher =& new $dispatcherClass($_GET);
822	FLEA::register($dispatcher, $dispatcherClass);
823	$dispatcher->dispatching();
824	}
825
826	/**
827	* 准备运行环境
828	*
829	* @param boolean $loadMVC
830	*/
831	function init($loadMVC = false)
832	{
833	static $firstTime = true;

Filename: /data0/www/others/innosep.com/index.php [29]
#1 FLEA::runMVC()

ARGS:

Array
(
)

SOURCE CODE:

19	define('forum',View.DS."forum");
20	define('web',View.DS."inno");
21	define('newproduct',View.DS."newproduct");
22	define('Swift',root.DS."lib");
23	require_once(conf.DS."callback.php");
24	require_once(flea_dir.DS."FLEA.php");
25	require_once(root.DS."fckeditor".DS."fckeditor.php");
26
27	FLEA::loadAppInf(conf.DS."dsn.php");
28	FLEA::import(APP);
29	FLEA::runMVC();
30
31	?>

Error reason: