Exception: flea_db_exception_sqlquery
Message: SQL 错误消息: "Can't create/write to file 'C:\Parallels\Plesk\Databases\MySQL\Data\#sql_176a8_0.MYI' (Errcode: 28)"
SQL 语句: "SHOW FULL COLUMNS FROM `wui_news`"
SQL 错误代码: "7335941".
Filename: C:\Inetpub\vhosts\getright.com.hk\httpdocs\FLEA\FLEA\Db\Driver\Mysql.php [126]
#13 flea_db_exception_sqlquery::flea_db_exception_sqlquery('SHOW FULL COLUMNS FROM `wui ...', 'Can't create/write to file ...', 1)
ARGS:
Array
(
[0] => SHOW FULL COLUMNS FROM `wui_news`
[1] => Can't create/write to file 'C:\Parallels\Plesk\Databases\MySQL\Data\#sql_176a8_0.MYI' (Errcode: 28)
[2] => 1
)
SOURCE CODE:
| 116 |
if ($result !== false) {
|
| 117 |
$this->lasterr = null;
|
| 118 |
$this->lasterrcode = null;
|
| 119 |
return $result;
|
| 120 |
}
|
| 121 |
$this->lasterr = mysql_error($this->conn);
|
| 122 |
$this->lasterrcode = mysql_errno($this->conn);
|
| 123 |
|
| 124 |
if ($throw) {
|
| 125 |
FLEA::loadClass('FLEA_Db_Exception_SqlQuery');
|
| 126 |
__THROW(new FLEA_Db_Exception_SqlQuery($sql, $this->lasterr, $this->lasterrcode));
|
| 127 |
}
|
| 128 |
return false;
|
| 129 |
}
|
| 130 |
|
| 131 |
function qstr($value)
|
| 132 |
{
|
| 133 |
if (is_int($value) || is_float($value)) { return $value; }
|
| 134 |
if (is_bool($value)) { return $value ? $this->TRUE_VALUE : $this->FALSE_VALUE; }
|
| 135 |
if (is_null($value)) { return $this->NULL_VALUE; }
|
| 136 |
return "'" . mysql_real_escape_string($value, $this->conn) . "'";
|
Filename: C:\Inetpub\vhosts\getright.com.hk\httpdocs\FLEA\FLEA\Db\Driver\Mysql.php [244]
#12 flea_db_driver_mysql::execute('SHOW FULL COLUMNS FROM `wui ...')
ARGS:
Array
(
[0] => SHOW FULL COLUMNS FROM `wui_news`
)
SOURCE CODE:
| 234 |
'BLOB' => 'X',
|
| 235 |
'TEXT' => 'X',
|
| 236 |
'MEDIUMBLOB' => 'X',
|
| 237 |
'MEDIUMTEXT' => 'X',
|
| 238 |
'LONGBLOB' => 'X',
|
| 239 |
'LONGTEXT' => 'X',
|
| 240 |
'ENUM' => 'C',
|
| 241 |
'SET' => 'C',
|
| 242 |
);
|
| 243 |
|
| 244 |
$rs = $this->execute(sprintf($this->META_COLUMNS_SQL, $table));
|
| 245 |
if (!$rs) { return false; }
|
| 246 |
$retarr = array();
|
| 247 |
while (($row = mysql_fetch_assoc($rs))) {
|
| 248 |
$field = array();
|
| 249 |
$field['name'] = $row['Field'];
|
| 250 |
$type = $row['Type'];
|
| 251 |
|
| 252 |
$field['scale'] = null;
|
| 253 |
$queryArray = false;
|
| 254 |
if (preg_match('/^(.+)\((\d+),(\d+)/', $type, $queryArray)) {
|
Filename: C:\Inetpub\vhosts\getright.com.hk\httpdocs\FLEA\FLEA\Db\TableDataGateway.php [1996]
#11 flea_db_driver_mysql::metacolumns('`wui_news`')
ARGS:
Array
(
[0] => `wui_news`
)
SOURCE CODE:
| 1986 |
$meta = FLEA::getCache($cacheId, FLEA::getAppInf('dbMetaLifetime'));
|
| 1987 |
if (is_array($meta)) {
|
| 1988 |
$this->meta = $meta;
|
| 1989 |
return true;
|
| 1990 |
}
|
| 1991 |
}
|
| 1992 |
|
| 1993 |
/**
|
| 1994 |
* 从数据库获得 meta
|
| 1995 |
*/
|
| 1996 |
$this->meta = $this->dbo->metaColumns($this->qtableName);
|
| 1997 |
if (!is_array($this->meta) || empty($this->meta)) {
|
| 1998 |
FLEA::loadClass('FLEA_Db_Exception_MetaColumnsFailed');
|
| 1999 |
return __THROW(new FLEA_Db_Exception_MetaColumnsFailed($this->qtableName));
|
| 2000 |
}
|
| 2001 |
|
| 2002 |
if ($cached) {
|
| 2003 |
return FLEA::writeCache($cacheId, $this->meta);
|
| 2004 |
} else {
|
| 2005 |
return true;
|
| 2006 |
}
|
Filename: C:\Inetpub\vhosts\getright.com.hk\httpdocs\FLEA\FLEA\Db\TableDataGateway.php [333]
#10 table_news::_preparemeta()
ARGS:
Array
(
)
SOURCE CODE:
| 323 |
$this->dbo =& $dbo;
|
| 324 |
|
| 325 |
if (empty($this->schema) && !empty($dbo->dsn['schema'])) {
|
| 326 |
$this->schema = $dbo->dsn['schema'];
|
| 327 |
}
|
| 328 |
if (empty($this->fullTableName)) {
|
| 329 |
$this->fullTableName = $dbo->dsn['prefix'] . $this->tableName;
|
| 330 |
}
|
| 331 |
$this->qtableName = $dbo->qtable($this->fullTableName, $this->schema);
|
| 332 |
|
| 333 |
if (!$this->_prepareMeta()) {
|
| 334 |
return false;
|
| 335 |
}
|
| 336 |
$this->fields = array_keys($this->meta);
|
| 337 |
|
| 338 |
if (is_array($this->validateRules)) {
|
| 339 |
foreach ($this->validateRules as $fieldName => $rules) {
|
| 340 |
$fieldName = strtoupper($fieldName);
|
| 341 |
if (!isset($this->meta[$fieldName])) { continue; }
|
| 342 |
foreach ((array)$rules as $ruleName => $rule) {
|
| 343 |
$this->meta[$fieldName][$ruleName] = $rule;
|
Filename: C:\Inetpub\vhosts\getright.com.hk\httpdocs\FLEA\FLEA\Db\TableDataGateway.php [306]
#9 table_news::setdbo(flea_db_driver_mysql)
ARGS:
Array
(
[0] => flea_db_driver_mysql Object
(
[NEXT_ID_SQL] => UPDATE %s SET id = LAST_INSERT_ID(id + 1)
[CREATE_SEQ_SQL] => CREATE TABLE %s (id INT NOT NULL)
[INIT_SEQ_SQL] => INSERT INTO %s VALUES (%s)
[DROP_SEQ_SQL] => DROP TABLE %s
[META_COLUMNS_SQL] => SHOW FULL COLUMNS FROM %s
[PARAM_STYLE] => ?
[HAS_INSERT_ID] => 1
[HAS_AFFECTED_ROWS] => 1
[_mysqlVersion] => 5.0.45-community-nt
[TRUE_VALUE] => 1
[FALSE_VALUE] => 0
[NULL_VALUE] => NULL
[HAS_TRANSACTION] =>
[HAS_SAVEPOINT] =>
[RESULT_FIELD_NAME_LOWER] =>
[dsn] => Array
(
[driver] => mysql
[host] => localhost
[login] => getright
[password] => abc123
[database] => webdb_getright
[port] =>
[options] =>
[prefix] => wui_
[schema] =>
[id] => mysql://getright:abc123@localhost_wui_/webdb_getright//
)
[conn] => Resource id #19
[log] => Array
(
[0] => SELECT VERSION()
[1] => SET NAMES 'utf8'
[2] => SHOW FULL COLUMNS FROM `wui_news`
)
[querycount] => 3
[lasterr] => Can't create/write to file 'C:\Parallels\Plesk\Databases\MySQL\Data\#sql_176a8_0.MYI' (Errcode: 28)
[lasterrcode] => 1
[_insertId] =>
[_transCount] => 0
[_hasFailedQuery] =>
[_savepointStack] => Array
(
)
[enableLog] => 1
)
)
SOURCE CODE:
| 296 |
// 初始化数据访问对象
|
| 297 |
if (!isset($params['dbo'])) {
|
| 298 |
if (isset($params['dbDSN'])) {
|
| 299 |
$dbo =& FLEA::getDBO($params['dbDSN']);
|
| 300 |
} else {
|
| 301 |
$dbo =& FLEA::getDBO();
|
| 302 |
}
|
| 303 |
} else {
|
| 304 |
$dbo =& $params['dbo'];
|
| 305 |
}
|
| 306 |
$this->setDBO($dbo);
|
| 307 |
|
| 308 |
// 当 skipCreateLinks 不为 true 时,建立关联
|
| 309 |
if (!isset($params['skipCreateLinks']) || $params['skipCreateLinks'] == false) {
|
| 310 |
$this->relink();
|
| 311 |
}
|
| 312 |
}
|
| 313 |
|
| 314 |
/**
|
| 315 |
* 设置数据库访问对象
|
| 316 |
*
|
Filename: C:\Inetpub\vhosts\getright.com.hk\httpdocs\FLEA\FLEA.php [422]
#8 table_news::flea_db_tabledatagateway()
ARGS:
Array
(
)
SOURCE CODE:
| 412 |
} else {
|
| 413 |
$classExists = class_exists($className);
|
| 414 |
}
|
| 415 |
if (!$classExists) {
|
| 416 |
if (!FLEA::loadClass($className)) {
|
| 417 |
$return = false;
|
| 418 |
return $return;
|
| 419 |
}
|
| 420 |
}
|
| 421 |
|
| 422 |
$instances[$className] =& new $className();
|
| 423 |
FLEA::register($instances[$className], $className);
|
| 424 |
return $instances[$className];
|
| 425 |
}
|
| 426 |
|
| 427 |
/**
|
| 428 |
* 将一个对象实例注册到对象实例容器,以便稍后取出
|
| 429 |
*
|
| 430 |
* example:
|
| 431 |
* <code>
|
| 432 |
* $obj =& new MyClass();
|
Filename: C:\Inetpub\vhosts\getright.com.hk\httpdocs\APP\Model\News.php [12]
#7 flea::getsingleton('Table_News')
ARGS:
Array
(
[0] => Table_News
)
SOURCE CODE:
| 2 |
class Model_News
|
| 3 |
{
|
| 4 |
/**
|
| 5 |
*
|
| 6 |
*
|
| 7 |
* @var Table_News
|
| 8 |
*/
|
| 9 |
var $tbNews;
|
| 10 |
|
| 11 |
function Model_News() {
|
| 12 |
$this->tbNews=& FLEA::getSingleton('Table_News');
|
| 13 |
}
|
| 14 |
function listWithPage($condition=null,$pagecount=8,$page='page'){
|
| 15 |
//数据
|
| 16 |
$tb=$this->tbNews;
|
| 17 |
$page = isset($_GET[$page]) ? (int)$_GET[$page] : 1;
|
| 18 |
FLEA::loadClass('FLEA_Helper_Pager');
|
| 19 |
$pager =& new FLEA_Helper_Pager($tb,$page-1,$pagecount,$condition,'created desc');
|
| 20 |
$data=$pager->findAll();
|
| 21 |
$info['data']=$data;
|
| 22 |
$info['pageinfo']=$pager->getPagerData();
|
Filename: C:\Inetpub\vhosts\getright.com.hk\httpdocs\FLEA\FLEA.php [422]
#6 model_news::model_news()
ARGS:
Array
(
)
SOURCE CODE:
| 412 |
} else {
|
| 413 |
$classExists = class_exists($className);
|
| 414 |
}
|
| 415 |
if (!$classExists) {
|
| 416 |
if (!FLEA::loadClass($className)) {
|
| 417 |
$return = false;
|
| 418 |
return $return;
|
| 419 |
}
|
| 420 |
}
|
| 421 |
|
| 422 |
$instances[$className] =& new $className();
|
| 423 |
FLEA::register($instances[$className], $className);
|
| 424 |
return $instances[$className];
|
| 425 |
}
|
| 426 |
|
| 427 |
/**
|
| 428 |
* 将一个对象实例注册到对象实例容器,以便稍后取出
|
| 429 |
*
|
| 430 |
* example:
|
| 431 |
* <code>
|
| 432 |
* $obj =& new MyClass();
|
Filename: C:\Inetpub\vhosts\getright.com.hk\httpdocs\APP\Controller\WuiFront.php [30]
#5 flea::getsingleton('Model_News')
ARGS:
Array
(
[0] => Model_News
)
SOURCE CODE:
| 20 |
* @var Model_Admins
|
| 21 |
*/
|
| 22 |
var $moAdmins;
|
| 23 |
/**
|
| 24 |
* Enter description here...
|
| 25 |
*
|
| 26 |
* @var Table_Info
|
| 27 |
*/
|
| 28 |
var $tbInfo;
|
| 29 |
function Controller_WuiFront(){
|
| 30 |
$this->moNews=&FLEA::getSingleton('Model_News');
|
| 31 |
$this->moMes=&FLEA::getSingleton('Model_Mes');
|
| 32 |
$this->moAdmins=&FLEA::getSingleton('Model_Admins');
|
| 33 |
$this->tbInfo=&FLEA::getSingleton('Table_Info');
|
| 34 |
}
|
| 35 |
function actionIndex(){
|
| 36 |
$con=array(
|
| 37 |
array('producted',1,'=','AND'),
|
| 38 |
);
|
| 39 |
$product=$this->moNews->tbNews->findAll($con,'created desc',3);
|
| 40 |
$con=array(
|
Filename: C:\Inetpub\vhosts\getright.com.hk\httpdocs\FLEA\FLEA\Dispatcher\Simple.php [106]
#4 controller_wuifront::controller_wuifront('WuiFront')
ARGS:
Array
(
[0] => WuiFront
)
SOURCE CODE:
| 96 |
|
| 97 |
$controller = null;
|
| 98 |
$controllerClassFilename = null;
|
| 99 |
do {
|
| 100 |
// 载入控制对应的类定义
|
| 101 |
if (!$this->_loadController($controllerClass)) { break; }
|
| 102 |
|
| 103 |
// 构造控制器对象
|
| 104 |
FLEA::setAppInf('FLEA.internal.currentControllerName', $controllerName);
|
| 105 |
FLEA::setAppInf('FLEA.internal.currentActionName', $actionName);
|
| 106 |
$controller =& new $controllerClass($controllerName);
|
| 107 |
if (!method_exists($controller, $actionMethod)) { break; }
|
| 108 |
if (method_exists($controller, '__setController')) {
|
| 109 |
$controller->__setController($controllerName, $actionName);
|
| 110 |
}
|
| 111 |
if (method_exists($controller, '__setDispatcher')) {
|
| 112 |
$controller->__setDispatcher($this);
|
| 113 |
}
|
| 114 |
|
| 115 |
// 调用 _beforeExecute() 方法
|
| 116 |
if (method_exists($controller, '_beforeExecute')) {
|
Filename: C:\Inetpub\vhosts\getright.com.hk\httpdocs\FLEA\FLEA\Dispatcher\Auth.php [127]
#3 flea_dispatcher_auth::_executeaction('WuiFront', 'index', 'Controller_WuiFront')
ARGS:
Array
(
[0] => WuiFront
[1] => index
[2] => Controller_WuiFront
)
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: C:\Inetpub\vhosts\getright.com.hk\httpdocs\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: C:\Inetpub\vhosts\getright.com.hk\httpdocs\Index.php [33]
#1 flea::runmvc()
ARGS:
Array
(
)
SOURCE CODE:
| 23 |
// APP_DIR 常量指示模版的保存目录
|
| 24 |
define('APP_DIR', dirname(__FILE__));
|
| 25 |
// UPLOAD_DIR 常量用于指示保存上传文件的根目录
|
| 26 |
define('UPLOAD_DIR','upload');
|
| 27 |
define('SHARE_DIR', APP_DIR. '/share');
|
| 28 |
define('NO_LEGACY_FLEAPHP', true);
|
| 29 |
require(APP_DIR.'/FLEA/FLEA.php');
|
| 30 |
FLEA::loadAppInf(APP_DIR . '/APP/Config/IHS_APP_INF.php');
|
| 31 |
FLEA::loadAppInf(SHARE_DIR.'/DSN.php');
|
| 32 |
FLEA::import(APP_DIR . '/APP');
|
| 33 |
FLEA::runMVC();
|
| 34 |
function wrongPermit(){
|
| 35 |
redirect(url('WuiLogin','PermitError'));
|
| 36 |
} |