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 ('7662','7661')"
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 ('7662','7661')
)
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(2), '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 ('7662','7661')
[1] => Array
(
[7662] => Array
(
[mbbid] => 7662
[mbid] => 653
[mbcid] => 0
[title] => 時に気をつ
[content] => 「それ、ちゃんと片付けないと次出しちゃダメだよー」<br />
の一言にものすごいしぶしぶといった感じで片付け始めました…(笑)<br />
新聞紙は以前幼児教室でやってからというものちぎるもの!って認識らしく、見つけたら即楽しそうにちぎり始めます…^^;<br />
うちは新聞取ってないので、たまーに梱包材とかに使われてるやつをそっとこちゃるさんのおもちゃ箱に忍ばせておくんですが、実家とか帰ったけないと当日の分やられるかもしれない…;<br />
<br />
さて。<br />
今日は午前中こちゃるさんの幼児教室でしたが仲良しの男の子が今日は風邪でお休みだった為、すんなり帰って来てくれました^^;<br />
それにしても今風邪はやってますね…!<br />
急に寒くなり出したので、やっぱり体調崩す人が多いのかな?教室も今日は人数少なかったです。<br />
我が家も夜は既に床暖房入れたりしてます…;<br />
皆様もどうぞお身体にはお気をつけください><;<br />
<br />
こちゃるさんの教室の間、本屋さんをぶらーりしていた<a style="color:#333333;text-decoration:none;" href="http://info.meishi86.com/?p=54
">臉部拉提</a>らたまたま見かけたこちら
[click] => 0
[tags] =>
[is_good] => 0
[created] => 2015-11-05 23:53:44
[updated] => 2015-11-05 23:53:44
[img1] =>
[img2] =>
[img3] =>
[img4] =>
[img5] =>
[img6] =>
[img7] =>
[img8] =>
[img9] =>
[img10] =>
[blog] => Array
(
[mbid] => 653
[tpid] => 1
[mtpid] => 1
[enname] => fanglan
[name] => fanglan
[poster] =>
[is_day] => 0
[is_month] => 0
[is_class] => 0
[is_record] => 0
[is_friend] => 0
[is_near] => 0
[info] =>
[qr] => qr-img-20151105235230.png
[flag] => 0
[click] => 5943
[created] => 2015-11-05 23:52:30
[mid] => 668
)
[category] =>
[replay] =>
)
[7661] => Array
(
[mbbid] => 7661
[mbid] => 653
[mbcid] => 0
[title] => Welcome to GGblog
[content] => <p><img alt="" border="0" src="http://blog.acty-b.net/images/logo_g.jpg" /></p>
<p>Welcome to GGblog.</p>
<p><a href="http://blog.acty-b.net">more>></a></p>
[click] => 0
[tags] => Welcome to GGblog
[is_good] => 0
[created] => 2015-11-05 23:52:30
[updated] => 2015-11-05 23:52:30
[img1] =>
[img2] =>
[img3] =>
[img4] =>
[img5] =>
[img6] =>
[img7] =>
[img8] =>
[img9] =>
[img10] =>
[blog] => Array
(
[mbid] => 653
[tpid] => 1
[mtpid] => 1
[enname] => fanglan
[name] => fanglan
[poster] =>
[is_day] => 0
[is_month] => 0
[is_class] => 0
[is_record] => 0
[is_friend] => 0
[is_near] => 0
[info] =>
[qr] => qr-img-20151105235230.png
[flag] => 0
[click] => 5943
[created] => 2015-11-05 23:52:30
[mid] => 668
)
[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 (7661,7662)', 'created DESC')
ARGS:
Array
(
[0] => mbbid in (7661,7662)
[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(2))
ARGS:
Array
(
[0] => Array
(
[0] => 7661
[1] => 7662
)
)
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] => 653
[tpid] => 1
[mtpid] => 1
[enname] => fanglan
[name] => fanglan
[poster] =>
[is_day] => 0
[is_month] => 0
[is_class] => 0
[is_record] => 0
[is_friend] => 0
[is_near] => 0
[info] =>
[qr] => qr-img-20151105235230.png
[flag] => 0
[click] => 5943
[created] => 2015-11-05 23:52:30
[mid] => 668
[tempset] =>
[blogset] =>
[member] => Array
(
[mid] => 668
[username] => onlyonelan@yahoo.com.hk
[userpass] => FeGm5CzlVMJgMA/W40ILhk5IPg
[question] => 一番好きな映画は?
[answer] => 123
[flag] => 0
[IP] => 101.78.223.77
[created] => 2015-11-05 23:52:30
[updated] => 2015-11-05 23:52:30
[special] => 0
[pass] => 1
)
[bowen] => Array
(
[0] => Array
(
[mbbid] => 7661
[mbid] => 653
[mbcid] => 0
[title] => Welcome to GGblog
[content] => <p><img alt="" border="0" src="http://blog.acty-b.net/images/logo_g.jpg" /></p>
<p>Welcome to GGblog.</p>
<p><a href="http://blog.acty-b.net">more>></a></p>
[click] => 0
[tags] => Welcome to GGblog
[is_good] => 0
[created] => 2015-11-05 23:52:30
[updated] => 2015-11-05 23:52:30
[img1] =>
[img2] =>
[img3] =>
[img4] =>
[img5] =>
[img6] =>
[img7] =>
[img8] =>
[img9] =>
[img10] =>
)
[1] => Array
(
[mbbid] => 7662
[mbid] => 653
[mbcid] => 0
[title] => 時に気をつ
[content] => 「それ、ちゃんと片付けないと次出しちゃダメだよー」<br />
の一言にものすごいしぶしぶといった感じで片付け始めました…(笑)<br />
新聞紙は以前幼児教室でやってからというものちぎるもの!って認識らしく、見つけたら即楽しそうにちぎり始めます…^^;<br />
うちは新聞取ってないので、たまーに梱包材とかに使われてるやつをそっとこちゃるさんのおもちゃ箱に忍ばせておくんですが、実家とか帰ったけないと当日の分やられるかもしれない…;<br />
<br />
さて。<br />
今日は午前中こちゃるさんの幼児教室でしたが仲良しの男の子が今日は風邪でお休みだった為、すんなり帰って来てくれました^^;<br />
それにしても今風邪はやってますね…!<br />
急に寒くなり出したので、やっぱり体調崩す人が多いのかな?教室も今日は人数少なかったです。<br />
我が家も夜は既に床暖房入れたりしてます…;<br />
皆様もどうぞお身体にはお気をつけください><;<br />
<br />
こちゃるさんの教室の間、本屋さんをぶらーりしていた<a style="color:#333333;text-decoration:none;" href="http://info.meishi86.com/?p=54
">臉部拉提</a>らたまたま見かけたこちら
[click] => 0
[tags] =>
[is_good] => 0
[created] => 2015-11-05 23:53:44
[updated] => 2015-11-05 23:53:44
[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 |
?>
|