Exception: FLEA_Db_Exception_SqlQuery
Message: SQL Error Message: "Can't create/write to file '/tmp/#sql_3dd2_0.MYI' (Errcode: 23)"
SQL : "SHOW FULL COLUMNS FROM `igiki_ads_photo`"
SQL Error code: "7335941".
Filename: /var/www/vhosts/igikiapps.com/httpdocs/WebLibs/FLEA/FLEA/Db/Driver/Mysql.php [244]
#10 FLEA_Db_Driver_Mysql::execute('SHOW FULL COLUMNS FROM `igi ...')
ARGS:
Array
(
[0] => SHOW FULL COLUMNS FROM `igiki_ads_photo`
)
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: /var/www/vhosts/igikiapps.com/httpdocs/WebLibs/FLEA/FLEA/Db/TableDataGateway.php [1993]
#9 FLEA_Db_Driver_Mysql::metaColumns('`igiki_ads_photo`')
ARGS:
Array
(
[0] => `igiki_ads_photo`
)
SOURCE CODE:
| 1983 |
$meta = FLEA::getCache($cacheId, FLEA::getAppInf('dbMetaLifetime'));
|
| 1984 |
if (is_array($meta)) {
|
| 1985 |
$this->meta = $meta;
|
| 1986 |
return true;
|
| 1987 |
}
|
| 1988 |
}
|
| 1989 |
|
| 1990 |
/**
|
| 1991 |
* 从数据库获得 meta
|
| 1992 |
*/
|
| 1993 |
$this->meta = $this->dbo->metaColumns($this->qtableName);
|
| 1994 |
if (!is_array($this->meta) || empty($this->meta)) {
|
| 1995 |
FLEA::loadClass('FLEA_Db_Exception_MetaColumnsFailed');
|
| 1996 |
return __THROW(new FLEA_Db_Exception_MetaColumnsFailed($this->qtableName));
|
| 1997 |
}
|
| 1998 |
|
| 1999 |
if ($cached) {
|
| 2000 |
return FLEA::writeCache($cacheId, $this->meta);
|
| 2001 |
} else {
|
| 2002 |
return true;
|
| 2003 |
}
|
Filename: /var/www/vhosts/igikiapps.com/httpdocs/WebLibs/FLEA/FLEA/Db/TableDataGateway.php [333]
#8 FLEA_Db_TableDataGateway::_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: /var/www/vhosts/igikiapps.com/httpdocs/WebLibs/FLEA/FLEA/Db/TableDataGateway.php [306]
#7 FLEA_Db_TableDataGateway::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.27
[TRUE_VALUE] => 1
[FALSE_VALUE] => 0
[NULL_VALUE] => NULL
[HAS_TRANSACTION] =>
[HAS_SAVEPOINT] =>
[RESULT_FIELD_NAME_LOWER] =>
[dsn] => Array
(
[driver] => mysql
[host] => localhost
[login] => panxp520
[password] => 123456
[database] => appsiphone
[port] =>
[options] =>
[prefix] => igiki_
[schema] =>
[id] => mysql://panxp520:123456@localhost_igiki_/appsiphone//
)
[conn] => Resource id #27
[log] => Array
(
[0] => SELECT VERSION()
[1] => SET NAMES 'utf8'
[2] => SHOW FULL COLUMNS FROM `igiki_ads_photo`
)
[querycount] => 3
[lasterr] => Can't create/write to file '/tmp/#sql_3dd2_0.MYI' (Errcode: 23)
[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: /var/www/vhosts/igikiapps.com/httpdocs/WebLibs/App/Model/Ads.php [11]
#6 FLEA_Db_TableDataGateway::FLEA_Db_TableDataGateway()
ARGS:
Array
(
)
SOURCE CODE:
| 1 |
<?php
|
| 2 |
class Model_Ads {
|
| 3 |
/**
|
| 4 |
* 各页面下方四个图片广告
|
| 5 |
*
|
| 6 |
* @param char $catagory 页面分类
|
| 7 |
* @return array
|
| 8 |
*/
|
| 9 |
function selectAds($catagory){
|
| 10 |
FLEA::loadClass("Table_adsphoto");
|
| 11 |
$obj = new Table_adsphoto();
|
| 12 |
$data = $obj->findAll("categoryId='$catagory' and active=1","photoId asc"); //active =1 表示图片为活动状态 2 为关闭状态
|
| 13 |
//$data = self::getClass('Table_adsphoto')->findAll("categoryId='$catagory'");
|
| 14 |
$photo = $data[0]['photo']=="" ? "pro2_011.png":$data[0]['photo'];
|
| 15 |
$photo2 = $data[1]['photo']=="" ? "pro2_02.png":$data[1]['photo'];
|
| 16 |
$photo3 = $data[2]['photo']=="" ? "pro2_03.png":$data[2]['photo'];
|
| 17 |
$photo4 = $data[3]['photo']=="" ? "pro2_04.png":$data[3]['photo'];
|
| 18 |
$url = $data[0]['linkUrl']=="" ? "http://www.baidu.com":$data[0]['linkUrl'];
|
| 19 |
$url2 = $data[1]['linkUrl']=="" ? "http://www.baidu.com":$data[1]['linkUrl'];
|
| 20 |
$url3 = $data[2]['linkUrl']=="" ? "http://www.baidu.com":$data[2]['linkUrl'];
|
| 21 |
$url4 = $data[3]['linkUrl']=="" ? "http://www.baidu.com":$data[3]['linkUrl'];
|
Filename: /var/www/vhosts/igikiapps.com/httpdocs/WebLibs/App/Controller/Client.php [478]
#5 Model_Ads::selectAds('markettoolkit')
ARGS:
Array
(
[0] => markettoolkit
)
SOURCE CODE:
| 468 |
"url"=>$ads[1]['url'],
|
| 469 |
"url2"=>$ads[1]['url2'],
|
| 470 |
"url3"=>$ads[1]['url3'],
|
| 471 |
"url4"=>$ads[1]['url4'],
|
| 472 |
"ttype"=>1,
|
| 473 |
);
|
| 474 |
$this->_executeView("front/markettoolkit.html",$viewData);
|
| 475 |
}
|
| 476 |
function DevelopmentmarkettoolkitAction(){
|
| 477 |
$category = 'markettoolkit';
|
| 478 |
$ads = self::getClass("Model_Ads")->selectAds($category);
|
| 479 |
$viewData = array(
|
| 480 |
'data'=>$data3,
|
| 481 |
"ads"=>$ads[0]['photo'],
|
| 482 |
"ads2"=>$ads[0]['photo2'],
|
| 483 |
"ads3"=>$ads[0]['photo3'],
|
| 484 |
"ads4"=>$ads[0]['photo4'],
|
| 485 |
"url"=>$ads[1]['url'],
|
| 486 |
"url2"=>$ads[1]['url2'],
|
| 487 |
"url3"=>$ads[1]['url3'],
|
| 488 |
"url4"=>$ads[1]['url4'],
|
Filename: /var/www/vhosts/igikiapps.com/httpdocs/WebLibs/FLEA/FLEA/Dispatcher/Simple.php [120]
#4 Controller_Client::DevelopmentmarkettoolkitAction()
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: /var/www/vhosts/igikiapps.com/httpdocs/WebLibs/FLEA/FLEA/Dispatcher/Simple.php [77]
#3 FLEA_Dispatcher_Simple::_executeAction('Client', 'Developmentmarkettoolkit', 'Controller_Client')
ARGS:
Array
(
[0] => Client
[1] => Developmentmarkettoolkit
[2] => Controller_Client
)
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: /var/www/vhosts/igikiapps.com/httpdocs/WebLibs/FLEA/FLEA.php [816]
#2 FLEA_Dispatcher_Simple::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: /var/www/vhosts/igikiapps.com/httpdocs/index.php [43]
#1 FLEA::runMVC()
ARGS:
Array
(
)
SOURCE CODE:
| 33 |
|
| 34 |
|
| 35 |
//載入smarty配置
|
| 36 |
$smartyConfig = LIBS_DIR.'/Shared/Config/Smarty.Config.php';
|
| 37 |
FLEA::loadAppInf($smartyConfig);
|
| 38 |
|
| 39 |
//載入控制器基類
|
| 40 |
FLEA::loadClass("Includes_Controller");
|
| 41 |
|
| 42 |
//启动系统
|
| 43 |
FLEA::runMVC();
|
| 44 |
?> |