Exception: FLEA_Db_Exception_SqlQuery
Message: SQL Error Message: "Table './imagedj_library/ss_count' is marked as crashed and last (automatic?) repair failed"
SQL : "SHOW FULL COLUMNS FROM `ss_count`"
SQL Error code: "7335941".
Filename: /var/www/html/tw_library/WebLibs/FLEA/FLEA/Db/Driver/Mysql.php [244]
#9 FLEA_Db_Driver_Mysql::execute('SHOW FULL COLUMNS FROM `ss_ ...')
ARGS:
Array
(
[0] => SHOW FULL COLUMNS FROM `ss_count`
)
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/html/tw_library/WebLibs/FLEA/FLEA/Db/TableDataGateway.php [1993]
#8 FLEA_Db_Driver_Mysql::metaColumns('`ss_count`')
ARGS:
Array
(
[0] => `ss_count`
)
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/html/tw_library/WebLibs/FLEA/FLEA/Db/TableDataGateway.php [333]
#7 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/html/tw_library/WebLibs/FLEA/FLEA/Db/TableDataGateway.php [306]
#6 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] => 10.3.28-MariaDB-log
[TRUE_VALUE] => 1
[FALSE_VALUE] => 0
[NULL_VALUE] => NULL
[HAS_TRANSACTION] =>
[HAS_SAVEPOINT] =>
[RESULT_FIELD_NAME_LOWER] =>
[dsn] => Array
(
[driver] => mysql
[host] => localhost
[login] => root
[password] => idj===38081
[database] => imagedj_library
[charset] => UTF8
[port] =>
[options] =>
[prefix] => ss_
[schema] =>
[id] => mysql://root:idj===38081@localhost_ss_/imagedj_library//
)
[conn] => Resource id #2
[log] => Array
(
[0] => SELECT VERSION()
[1] => SHOW FULL COLUMNS FROM `ss_forbidIp`
[2] => SELECT `ss_forbidIp`.* FROM `ss_forbidIp`
[3] => SELECT COUNT(`ss_forbidIp`.`forbidIpId`) FROM `ss_forbidIp` WHERE (fromIp <='315493835' and endIp>='315493835')
[4] => SHOW FULL COLUMNS FROM `ss_visit`
[5] => SELECT COUNT(`ss_visit`.`visitId`) FROM `ss_visit` WHERE ip='315493835' and (makeTime>='1702101388' and makeTime <='1702101988' and url='http://192.168.1.249/index.php?controller=client&action=image&tuKuId=&pinMingId=&id=1112&from=')
[6] => SELECT COUNT(`ss_visit`.`visitId`) FROM `ss_visit` WHERE ip='315493835' and (makeTime>='1702015588' and makeTime <='1702101988')
[7] => INSERT INTO `ss_visit` (`ip`, `status`, `url`, `userName`, `makeTime`) VALUES (315493835,0,'http://192.168.1.249/index.php?controller=client&action=image&tuKuId=&pinMingId=&id=1112&from=','',1702101988)
[8] => SHOW FULL COLUMNS FROM `ss_image`
[9] => SELECT `ss_image`.* FROM `ss_image` WHERE `ss_image`.`imageId` = 1112
[10] => SHOW FULL COLUMNS FROM `ss_entry`
[11] => SELECT `ss_entry`.`entryId`, `ss_entry`.`name` FROM `ss_entry`
[12] => SHOW FULL COLUMNS FROM `ss_entry`
[13] => SELECT `ss_entry`.`entryId`, `ss_entry`.`name` FROM `ss_entry`
[14] => SHOW FULL COLUMNS FROM `ss_entry`
[15] => SELECT `ss_entry`.`entryId`, `ss_entry`.`name` FROM `ss_entry`
[16] => SELECT `name` FROM `ss_entry` WHERE `entryId` =2
[17] => UPDATE `ss_image` SET `hitCnt`=219 WHERE `ss_image`.`imageId` = 1112
[18] => SHOW FULL COLUMNS FROM `ss_count`
)
[querycount] => 19
[lasterr] => Table './imagedj_library/ss_count' is marked as crashed and last (automatic?) repair failed
[lasterrcode] => 144
[_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/html/tw_library/WebLibs/App/Controller/Client.php [1428]
#5 FLEA_Db_TableDataGateway::FLEA_Db_TableDataGateway()
ARGS:
Array
(
)
SOURCE CODE:
| 1418 |
$data["pinMing"] = getEntryName($data["pinMing"]);
|
| 1419 |
$data["pinHao"] = getEntryName($data["pinHao"]);
|
| 1420 |
$data["tuKuFenLei"] = ($data["tuKuFenLei"]);
|
| 1421 |
$tuKuFenLei = $obj->findBySql('SELECT `name` FROM `ss_entry` WHERE `entryId` =' . $data["tuKuFenLei"]);
|
| 1422 |
$data["tuKuFenLei"] = $tuKuFenLei[0]['name'];
|
| 1423 |
$row = array("imageId" => $id, "hitCnt" => intval($data["hitCnt"]) + 1);
|
| 1424 |
$obj->update($row);
|
| 1425 |
|
| 1426 |
//$rows = array("image_id" => $id, "type" => '1', "datetime" => date("Y-m-d H:i:s", mktime(date('H'), date('i'), date('s'), date('m'), date('d'), date('Y'))), );
|
| 1427 |
$rows = array("image_id" => $id, "type" => '1', "datetime" => date("Y-m-d H:i:s", mktime(date('H'), date('i'), date('s'), date('m'), date('d'), date('Y'))), "userName" => $_SESSION["frontData"]["userName"]);
|
| 1428 |
$obj = new Table_Count();
|
| 1429 |
$obj->create($rows);
|
| 1430 |
//type=2=>image view紀錄
|
| 1431 |
if (isset($_SESSION["frontData"]["userName"])) {
|
| 1432 |
$obj = new Table_ImageUser();
|
| 1433 |
$row = array("imageId" => $id, "userName" => $_SESSION["frontData"]["userName"], "department" => $_SESSION["frontData"]["department"], "identity" => $_SESSION["frontData"]["identity"], "makeTime" => getTimeNow(), "ip" => getClientIp(), "type" => 2,);
|
| 1434 |
$obj->create($row);
|
| 1435 |
}
|
| 1436 |
$navTitle = "<a href=\"" . WEB_SITE . "" . SYS_URL_ROOT . "/index.php?controller=client&action=index" . "\" class=\"style2\">首頁 </a> > <a href=\"" . WEB_SITE . "" . SYS_URL_ROOT . "/index.php?controller=client&action=entryList\" class=\"style2\">系列總覽 </a>";
|
| 1437 |
$navTitle .= " > <a href=\"" . WEB_SITE . "" . SYS_URL_ROOT . "/index.php?controller=client&action=subEntryList&tuKuId=" . $image[0]['tuKuFenLei'] . "&from=" . $_GET["from"] . "\" class=\"style2\">" . ($data['tuKuFenLei']) . "</a> > <a href=\"" . WEB_SITE . "" . SYS_URL_ROOT . "/index.php?controller=client&action=imageList&pinMingId=" . $image[0]['pinMing'] . "&tuKuId=" . $image[0]['tuKuFenLei'] . "&from=" . $_GET["from"] . "\" class=\"style2\">" . ($data['pinMing']) . "</a>";
|
| 1438 |
$navTitle .= " > " . $data['dangMing'];
|
Filename: /var/www/html/tw_library/WebLibs/FLEA/FLEA/Dispatcher/Simple.php [120]
#4 Controller_Client::imageAction()
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/html/tw_library/WebLibs/FLEA/FLEA/Dispatcher/Simple.php [77]
#3 FLEA_Dispatcher_Simple::_executeAction('Client', 'image', 'Controller_Client')
ARGS:
Array
(
[0] => Client
[1] => image
[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/html/tw_library/WebLibs/FLEA/FLEA.php [815]
#2 FLEA_Dispatcher_Simple::dispatching()
ARGS:
Array
(
)
SOURCE CODE:
| 805 |
require_once($MVCPackageFilename);
|
| 806 |
}
|
| 807 |
FLEA::init();
|
| 808 |
|
| 809 |
// 载入调度器并转发请求到控制器
|
| 810 |
$dispatcherClass = FLEA::getAppInf('dispatcher');
|
| 811 |
FLEA::loadClass($dispatcherClass);
|
| 812 |
|
| 813 |
$dispatcher =& new $dispatcherClass($_GET);
|
| 814 |
FLEA::register($dispatcher, $dispatcherClass);
|
| 815 |
$dispatcher->dispatching();
|
| 816 |
}
|
| 817 |
|
| 818 |
/**
|
| 819 |
* 准备运行环境
|
| 820 |
*
|
| 821 |
* @param boolean $loadMVC
|
| 822 |
*/
|
| 823 |
function init($loadMVC = false)
|
| 824 |
{
|
| 825 |
static $firstTime = true;
|
Filename: /var/www/html/tw_library/WebRoot/index.php [66]
#1 FLEA::runMVC()
ARGS:
Array
(
)
SOURCE CODE:
| 56 |
$smartyConfig = BASE_DIR.'/../WebLibs/Shared/Config/Smarty.Config.php';
|
| 57 |
FLEA::loadAppInf($smartyConfig);
|
| 58 |
|
| 59 |
//載入控制器基類
|
| 60 |
FLEA::loadClass("Includes_Controller");
|
| 61 |
|
| 62 |
//根据客户的环境做的调整
|
| 63 |
$_GET["controller"] = ucfirst($_GET["controller"]);
|
| 64 |
ini_set('allow_call_time_pass_reference',true);
|
| 65 |
|
| 66 |
FLEA::runMVC();
|
| 67 |
|
| 68 |
//dump($_SESSION);
|