Exception: FLEA_Db_Exception_SqlQuery
Message: SQL 错误消息: "Table 'member_blog_replay' is marked as crashed and should be repaired"
SQL 语句: "SELECT `member_blog_replay`.`mbbid` AS flea_pkref_mbbid, `member_blog_replay`.* FROM `member_blog_replay` WHERE `member_blog_replay`.`mbbid` IN ('7660')"
SQL 错误代码: "7335941".
Filename: /www/web/ggblog/public_html/libs/FLEA/FLEA/Db/Driver/Abstract.php [513]
#9 FLEA_Db_Driver_Mysql::execute('SELECT `member_blog_replay` ...')
ARGS:
Array
(
[0] => SELECT `member_blog_replay`.`mbbid` AS flea_pkref_mbbid, `member_blog_replay`.* FROM `member_blog_replay` WHERE `member_blog_replay`.`mbbid` IN ('7660')
)
SOURCE CODE:
503 |
} else {
|
504 |
if (!is_null($limit)) {
|
505 |
if (is_array($limit)) {
|
506 |
list($length, $offset) = $limit;
|
507 |
} else {
|
508 |
$length = $limit;
|
509 |
$offset = 0;
|
510 |
}
|
511 |
$res = $this->selectLimit($sql, $length, $offset);
|
512 |
} else {
|
513 |
$res = $this->execute($sql);
|
514 |
}
|
515 |
}
|
516 |
|
517 |
if ($oneToOne) {
|
518 |
// 一对一组装数据
|
519 |
while ($row = $this->fetchAssoc($res)) {
|
520 |
$rkv = $row[$refKeyName];
|
521 |
unset($row[$refKeyName]);
|
522 |
$assocRowset[$rkv][$mappingName] = $row;
|
523 |
}
|
Filename: /www/web/ggblog/public_html/libs/FLEA/FLEA/Db/TableDataGateway.php [483]
#8 FLEA_Db_Driver_Abstract::assemble('SELECT `member_blog_replay` ...', array(1), 'replay', , 'flea_pkref_mbbid', )
ARGS:
Array
(
[0] => SELECT `member_blog_replay`.`mbbid` AS flea_pkref_mbbid, `member_blog_replay`.* FROM `member_blog_replay` WHERE `member_blog_replay`.`mbbid` IN ('7660')
[1] => Array
(
[7660] => Array
(
[mbbid] => 7660
[mbid] => 232
[mbcid] => 0
[title] => aa
[content] => bbb
[click] => 0
[tags] =>
[is_good] => 0
[created] => 2015-11-05 13:31:27
[updated] => 2015-11-05 13:31:27
[img1] =>
[img2] =>
[img3] =>
[img4] =>
[img5] =>
[img6] =>
[img7] =>
[img8] =>
[img9] =>
[img10] =>
[blog] => Array
(
[mbid] => 232
[tpid] => 244
[mtpid] => 19
[enname] => wangguan
[name] => wangguan
[poster] =>
[is_day] => 0
[is_month] => 0
[is_class] => 0
[is_record] => 0
[is_friend] => 0
[is_near] => 0
[info] =>
[qr] => qr-img-20110527140946.png
[flag] => 0
[click] => 90348
[created] => 2011-05-27 14:09:46
[mid] => 236
)
[category] =>
[replay] =>
)
)
[2] => replay
[3] =>
[4] => flea_pkref_mbbid
[5] =>
)
SOURCE CODE:
473 |
* 查询获得数据后,将关联表的数据和主表数据装配在一起
|
474 |
*/
|
475 |
$callback = create_function('& $r, $o, $m', '$r[$m] = null;');
|
476 |
foreach ($this->links as $link) {
|
477 |
/* @var $link FLEA_Db_TableLink */
|
478 |
$mn = $link->mappingName;
|
479 |
if (!$link->enabled || !$link->linkRead) { continue; }
|
480 |
if (!$link->countOnly) {
|
481 |
array_walk($assocRowset, $callback, $mn);
|
482 |
$sql = $link->getFindSQL($in);
|
483 |
$this->dbo->assemble($sql, $assocRowset, $mn, $link->oneToOne, $this->pka, $link->limit);
|
484 |
} else {
|
485 |
$link->calcCount($assocRowset, $mn, $in);
|
486 |
}
|
487 |
}
|
488 |
|
489 |
return $rowset;
|
490 |
}
|
491 |
|
492 |
/**
|
493 |
* 对单一记录进行递归查询,并将查询结果组装到记录中
|
Filename: /www/web/ggblog/public_html/app/Modle/Blog.php [520]
#7 FLEA_Db_TableDataGateway::findAll(' mbbid in (7660)', 'created DESC')
ARGS:
Array
(
[0] => mbbid in (7660)
[1] => created DESC
)
SOURCE CODE:
510 |
|
511 |
$Table_Member = & FLEA::getSingleton('Table_Member');
|
512 |
$Table_MemberBowen = & FLEA::getSingleton('Table_MemberBowen');
|
513 |
|
514 |
$Modle_Common = & FLEA::getSingleton('Modle_Common');
|
515 |
|
516 |
$nearPublish = array();
|
517 |
|
518 |
if(is_array($id) && count($id) != 0){
|
519 |
|
520 |
$allNearRlt = $Table_MemberBowen->findAll($Modle_Common->getIN('mbbid', $id), 'created DESC');
|
521 |
|
522 |
|
523 |
for($i = 0; $i < count($allNearRlt); $i++){
|
524 |
|
525 |
$member = $Table_Member->find($allNearRlt[$i]['blog']['mid']);
|
526 |
|
527 |
$nearPublish[] = array(
|
528 |
'bowenid' => $allNearRlt[$i]['mbbid'],
|
529 |
'title' => $allNearRlt[$i]['title'],
|
530 |
'content' => $allNearRlt[$i]['content'],
|
Filename: /www/web/ggblog/public_html/app/Controller/Rss.php [76]
#6 Modle_Blog::_getBlogInfo(array(1))
ARGS:
Array
(
[0] => Array
(
[0] => 7660
)
)
SOURCE CODE:
66 |
|
67 |
//重新给blog赋值
|
68 |
$blog = $Table_MemberBlog->find($contidions);
|
69 |
|
70 |
$blogid = array();
|
71 |
|
72 |
for($i = 0; $i < count($blog[bowen]); $i++){
|
73 |
$blogid[] = $blog[bowen][$i]['mbbid'];
|
74 |
}
|
75 |
|
76 |
$blogInfo = $Modle_Blog->_getBlogInfo($blogid);
|
77 |
|
78 |
for($i = 0; $i < count($blogInfo); $i++){
|
79 |
$blogInfo[$i]['url'] = htmlspecialchars('http://' . $_SERVER['HTTP_HOST'] . '/Front/Content/U/' . $blog[enname] . '/CID/' . $blogInfo[$i][bowenid]);
|
80 |
|
81 |
$blogInfo[$i]['content'] = htmlspecialchars($Modle_ImageTran->getTranOkString($blogInfo[$i]['content']));
|
82 |
|
83 |
$blogInfo[$i]['authorurl'] = htmlspecialchars('http://' . $_SERVER['HTTP_HOST'] . '/Front/Person/U/' . $blog[enname]);
|
84 |
}
|
85 |
return $blogInfo;
|
86 |
}
|
Filename: /www/web/ggblog/public_html/app/Controller/Rss.php [34]
#5 Controller_Rss::_getMemberBlogMiddle(array(23))
ARGS:
Array
(
[0] => Array
(
[mbid] => 232
[tpid] => 244
[mtpid] => 19
[enname] => wangguan
[name] => wangguan
[poster] =>
[is_day] => 0
[is_month] => 0
[is_class] => 0
[is_record] => 0
[is_friend] => 0
[is_near] => 0
[info] =>
[qr] => qr-img-20110527140946.png
[flag] => 0
[click] => 90348
[created] => 2011-05-27 14:09:46
[mid] => 236
[tempset] => Array
(
[tsid] => 55
[mbid] => 232
[bg_pic] => TMP-1326092849.jpg
[bg_s_pic] => TMP-TH-1326092849.jpg
[bg_flag] => 0
[banner_pic] => 20120217160934.swf
[banner_s_pic] => 20120217160934.swf
[banner_flag] => 0
)
[blogset] =>
[member] => Array
(
[mid] => 236
[username] => wg@acty-d.com
[userpass] => RL315i3oB5NjORPU4VsDhg
[question] => 一番好きな映画は?
[answer] => wangguan
[flag] => 0
[IP] => 123.185.35.111
[created] => 2011-05-27 14:09:46
[updated] => 2011-05-27 14:13:53
[special] => 1
[pass] => 0
)
[bowen] => Array
(
[0] => Array
(
[mbbid] => 7660
[mbid] => 232
[mbcid] => 0
[title] => aa
[content] => bbb
[click] => 0
[tags] =>
[is_good] => 0
[created] => 2015-11-05 13:31:27
[updated] => 2015-11-05 13:31:27
[img1] =>
[img2] =>
[img3] =>
[img4] =>
[img5] =>
[img6] =>
[img7] =>
[img8] =>
[img9] =>
[img10] =>
)
)
[ping] =>
)
)
SOURCE CODE:
24 |
|
25 |
$blog_e_conditions = array(
|
26 |
'enname' => $_GET[U],
|
27 |
);
|
28 |
|
29 |
$blog_e_rlt = $Table_MemberBlog->find($blog_e_conditions);
|
30 |
//dump($blog_e_rlt);
|
31 |
//dump($this->_getMemberBlogHead($blog_e_rlt));
|
32 |
// dump($this->_getMemberBlogMiddle($blog_e_rlt));
|
33 |
$this->smarty->assign('head', $this->_getMemberBlogHead($blog_e_rlt));
|
34 |
$this->smarty->assign('info', $this->_getMemberBlogMiddle($blog_e_rlt));
|
35 |
|
36 |
}
|
37 |
|
38 |
$this->smarty->display('rss/rss.xml');
|
39 |
}
|
40 |
|
41 |
function _getMemberBlogHead($blog){
|
42 |
|
43 |
$Table_Member = & FLEA::getSingleton('Table_Member');
|
44 |
$Table_MemberBowen = & FLEA::getSingleton('Table_MemberBowen');
|
Filename: /www/web/ggblog/public_html/libs/FLEA/FLEA/Dispatcher/Simple.php [120]
#4 Controller_Rss::actionIndex()
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: /www/web/ggblog/public_html/libs/FLEA/FLEA/Dispatcher/Simple.php [77]
#3 FLEA_Dispatcher_Simple::_executeAction('Rss', 'Index', 'Controller_Rss')
ARGS:
Array
(
[0] => Rss
[1] => Index
[2] => Controller_Rss
)
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: /www/web/ggblog/public_html/libs/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: /www/web/ggblog/public_html/index.php [15]
#1 FLEA::runMVC()
ARGS:
Array
(
)
SOURCE CODE:
5 |
}
|
6 |
|
7 |
define('NO_LEGACY_FLEAPHP', true);
|
8 |
require('libs/FLEA/FLEA.php');
|
9 |
|
10 |
define('I_URL', dirname(__FILE__));
|
11 |
|
12 |
FLEA::loadAppInf($configFilename);
|
13 |
FLEA::import(I_URL . '/app');
|
14 |
|
15 |
FLEA::runMVC();
|
16 |
?>
|