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 ('7643','7641','7640','7639','7638','7637')"
SQL 错误代码: "7335941".
Filename: /www/web/ggblog/public_html/libs/FLEA/FLEA/Db/Driver/Abstract.php [513]
#8 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 ('7643','7641','7640','7639','7638','7637')
)
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]
#7 FLEA_Db_Driver_Abstract::assemble('SELECT `member_blog_replay` ...', array(6), '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 ('7643','7641','7640','7639','7638','7637')
[1] => Array
(
[7643] => Array
(
[mbbid] => 7643
[mbid] => 651
[mbcid] => 0
[title] => Fan Fun中文节目在日本涩谷中心街DAISO大创百元店拍摄
[content] => <div>
10月6日 Fan Fun中文节目在日本涩谷中心街DAISO大创百元店拍摄。在拍摄中我们又新结识了3位美女。
</div>
<p>
<br />
</p>
<p>
<br />
</p>
<p>
<img src="/scripts/image/20151008133614_10387.jpg" alt="" />
</p>
<p>
<br />
</p>
<p>
<img src="/scripts/image/20151008133634_18830.jpg" alt="" />
</p>
<p>
<br />
</p>
<p>
<br />
</p>
[click] => 0
[tags] =>
[is_good] => 0
[created] => 2015-10-08 12:36:41
[updated] => 2015-10-08 12:36:41
[img1] =>
[img2] =>
[img3] =>
[img4] =>
[img5] =>
[img6] =>
[img7] =>
[img8] =>
[img9] =>
[img10] =>
[blog] => Array
(
[mbid] => 651
[tpid] => 247
[mtpid] => 1
[enname] => fanfun
[name] => fanfun
[poster] =>
[is_day] => 0
[is_month] => 0
[is_class] => 0
[is_record] => 0
[is_friend] => 0
[is_near] => 0
[info] =>
[qr] => qr-img-20150921091851.png
[flag] => 0
[click] => 2425
[created] => 2015-09-21 09:18:51
[mid] => 666
)
[category] =>
[replay] =>
)
[7641] => Array
(
[mbbid] => 7641
[mbid] => 651
[mbcid] => 0
[title] => 齐藤农园咖啡厅-美食
[content] => <p>
这里的美食也丰富!蔬菜都是绿色的,又新鲜又健康!如果想找个既休闲又能品尝美食那就快来—齐藤农园咖啡厅!
</p>
<p>
<br />
</p>
<p>
<img src="/scripts/image/20150924174610_44470.jpg" alt="" />
</p>
<p>
<br />
</p>
<p>
<img src="/scripts/image/20150924174624_46080.jpg" alt="" />
</p>
[click] => 0
[tags] =>
[is_good] => 0
[created] => 2015-09-24 16:46:39
[updated] => 2015-09-24 16:46:39
[img1] =>
[img2] =>
[img3] =>
[img4] =>
[img5] =>
[img6] =>
[img7] =>
[img8] =>
[img9] =>
[img10] =>
[blog] => Array
(
[mbid] => 651
[tpid] => 247
[mtpid] => 1
[enname] => fanfun
[name] => fanfun
[poster] =>
[is_day] => 0
[is_month] => 0
[is_class] => 0
[is_record] => 0
[is_friend] => 0
[is_near] => 0
[info] =>
[qr] => qr-img-20150921091851.png
[flag] => 0
[click] => 2425
[created] => 2015-09-21 09:18:51
[mid] => 666
)
[category] =>
[replay] =>
)
[7640] => Array
(
[mbbid] => 7640
[mbid] => 651
[mbcid] => 0
[title] => 齐藤农园咖啡厅二
[content] => <p>
齐藤农园咖啡厅环境优雅、服务周到。如果累了、倦了,离开喧哗的城市去这里看看书发发呆!是件无比惬意的事!
</p>
<p>
<br />
</p>
<p>
<img src="/scripts/image/20150924174444_60371.jpg" alt="" />
</p>
<p>
<br />
</p>
<p>
<img src="/scripts/image/20150924175622_19152.jpg" alt="" />
</p>
[click] => 0
[tags] => 齐藤农园咖啡厅二
[is_good] => 0
[created] => 2015-09-24 16:45:29
[updated] => 2015-09-24 16:56:26
[img1] =>
[img2] =>
[img3] =>
[img4] =>
[img5] =>
[img6] =>
[img7] =>
[img8] =>
[img9] =>
[img10] =>
[blog] => Array
(
[mbid] => 651
[tpid] => 247
[mtpid] => 1
[enname] => fanfun
[name] => fanfun
[poster] =>
[is_day] => 0
[is_month] => 0
[is_class] => 0
[is_record] => 0
[is_friend] => 0
[is_near] => 0
[info] =>
[qr] => qr-img-20150921091851.png
[flag] => 0
[click] => 2425
[created] => 2015-09-21 09:18:51
[mid] => 666
)
[category] =>
[replay] =>
)
[7639] => Array
(
[mbbid] => 7639
[mbid] => 651
[mbcid] => 0
[title] => 齐藤农园咖啡厅
[content] => <p>
今天来到了千叶县袖ヶ浦市的简单朴素、充满田园气息的农园咖啡厅—齐藤。这里可以让人卸掉所有疲惫,特别的放松自在。
</p>
<p>
<img src="/scripts/image/20150924174254_41354.jpg" alt="" />
</p>
<p>
<br />
</p>
<p>
<img src="/scripts/image/20150924174307_64849.jpg" alt="" />
</p>
<p>
<br />
</p>
<p>
<img src="/scripts/image/20150924174328_27801.jpg" alt="" />
</p>
<p>
<br />
</p>
<p>
<br />
</p>
<p>
<br />
</p>
[click] => 0
[tags] =>
[is_good] => 0
[created] => 2015-09-24 16:43:34
[updated] => 2015-09-24 16:43:34
[img1] =>
[img2] =>
[img3] =>
[img4] =>
[img5] =>
[img6] =>
[img7] =>
[img8] =>
[img9] =>
[img10] =>
[blog] => Array
(
[mbid] => 651
[tpid] => 247
[mtpid] => 1
[enname] => fanfun
[name] => fanfun
[poster] =>
[is_day] => 0
[is_month] => 0
[is_class] => 0
[is_record] => 0
[is_friend] => 0
[is_near] => 0
[info] =>
[qr] => qr-img-20150921091851.png
[flag] => 0
[click] => 2425
[created] => 2015-09-21 09:18:51
[mid] => 666
)
[category] =>
[replay] =>
)
[7638] => Array
(
[mbbid] => 7638
[mbid] => 651
[mbcid] => 0
[title] => edo press japan【FanxFun】卡牌游戏 force of wil
[content] => <p>
<br />
</p>
<p>
昨天是卡牌游戏force of will 世界大赛顶尖选手汇集在秋叶原的日子,明天和后天将迎来正式比赛,我们的edo press japan 的【FanxFun】采访了很多游戏爱好者们,选手们的热情和信心高涨,夜色中的秋叶原,承载着他们的希望与梦想,预祝他们今天取得优异成绩。但最希望中国台湾的选手能够夺得冠军!加油<img src="/scripts/image/20150921103750_30467.png" alt="" />
</p>
<p>
<br />
</p>
<p>
<img src="/scripts/image/20150921103031_78908.jpg" alt="" />
</p>
<p>
<br />
</p>
<p>
<img src="/scripts/image/20150921103043_75778.jpg" alt="" />
</p>
<p>
<br />
</p>
<p>
<img src="/scripts/image/20150921103057_39137.jpg" alt="" />
</p>
<p>
<br />
</p>
<p>
<img src="/scripts/image/20150921103108_19755.jpg" alt="" />
</p>
<p>
<br />
</p>
<p>
<img src="/scripts/image/20150921103120_17782.jpg" alt="" />
</p>
<p>
<br />
</p>
<p>
<img src="/scripts/image/20150921103133_51558.jpg" alt="" />
</p>
<p>
<br />
</p>
<p>
<img src="/scripts/image/20150921103148_57586.jpg" alt="" />
</p>
<p>
<br />
</p>
<p>
<img src="/scripts/image/20150921103200_28996.jpg" alt="" />
</p>
<p>
<br />
</p>
<p>
<br />
</p>
<p>
<br />
</p>
[click] => 0
[tags] => edo press japan【FanxFun】卡牌游戏 force of wil
[is_good] => 0
[created] => 2015-09-21 09:32:04
[updated] => 2015-09-21 09:37:54
[img1] =>
[img2] =>
[img3] =>
[img4] =>
[img5] =>
[img6] =>
[img7] =>
[img8] =>
[img9] =>
[img10] =>
[blog] => Array
(
[mbid] => 651
[tpid] => 247
[mtpid] => 1
[enname] => fanfun
[name] => fanfun
[poster] =>
[is_day] => 0
[is_month] => 0
[is_class] => 0
[is_record] => 0
[is_friend] => 0
[is_near] => 0
[info] =>
[qr] => qr-img-20150921091851.png
[flag] => 0
[click] => 2425
[created] => 2015-09-21 09:18:51
[mid] => 666
)
[category] =>
[replay] =>
)
[7637] => Array
(
[mbbid] => 7637
[mbid] => 651
[mbcid] => 0
[title] => EDO PRESS JAPAN 【FanxFun】
[content] => <p>
大家好!我是巍巍,我将在羽田机场Rainbow Town79.2电台转播间为大家直播,EDO PRESS JAPAN的最新网络节目 【FanxFun】,【FanxFun】是专门为大家提供日本的一些好吃的、好喝的、好玩的、包括旅游、购物等信息。每一期我将连线在日本的中国朋友,或者是来过日本的中国朋友,为大家分享他们在日本的精彩生活!
</p>
<p>
<br />
</p>
<p>
<img src="/scripts/image/20150921102724_61038.jpg" alt="" />
</p>
<p>
<br />
</p>
<p>
<br />
</p>
<p>
<img src="/scripts/image/20150921102740_33100.jpg" alt="" />
</p>
<p>
<br />
</p>
<p>
<br />
</p>
<p>
<img src="/scripts/image/20150921102801_43900.jpg" alt="" />
</p>
<p>
<br />
</p>
<p>
<br />
</p>
[click] => 0
[tags] => EDO PRESS JAPAN 【FanxFun】
[is_good] => 0
[created] => 2015-09-21 09:28:08
[updated] => 2015-09-21 09:43:04
[img1] =>
[img2] =>
[img3] =>
[img4] =>
[img5] =>
[img6] =>
[img7] =>
[img8] =>
[img9] =>
[img10] =>
[blog] => Array
(
[mbid] => 651
[tpid] => 247
[mtpid] => 1
[enname] => fanfun
[name] => fanfun
[poster] =>
[is_day] => 0
[is_month] => 0
[is_class] => 0
[is_record] => 0
[is_friend] => 0
[is_near] => 0
[info] =>
[qr] => qr-img-20150921091851.png
[flag] => 0
[click] => 2425
[created] => 2015-09-21 09:18:51
[mid] => 666
)
[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 [258]
#6 FLEA_Db_TableDataGateway::findAll(array(1), 'created desc')
ARGS:
Array
(
[0] => Array
(
[mbid] => 651
)
[1] => created desc
)
SOURCE CODE:
248 |
|
249 |
if($member){
|
250 |
//针对哪些月份写过博客的月份
|
251 |
if($member[memberblog][mbid]){
|
252 |
$Table_MemberBowen = & FLEA::getSingleton('Table_MemberBowen');
|
253 |
$info = array(
|
254 |
'mbid' => $member[memberblog][mbid],
|
255 |
);
|
256 |
$sortby="created desc";
|
257 |
$times = array();
|
258 |
$bowen = $Table_MemberBowen->findAll($info,$sortby);
|
259 |
for($i = 0; $i < count($bowen); $i++){
|
260 |
$dateRlt = $this->_date($bowen[$i][created]);
|
261 |
if(!in_array(array('k'=>$dateRlt[0], 'v'=>$dateRlt[1]), $times)){
|
262 |
$times[] = array('k'=>$dateRlt[0], 'v'=>$dateRlt[1]);
|
263 |
}
|
264 |
}
|
265 |
return $times;
|
266 |
}
|
267 |
|
268 |
//针对创建博客之日起 到目前的所有月份
|
Filename: /www/web/ggblog/public_html/app/Controller/Front.php [137]
#5 Modle_Blog::getBlogMonth('666')
ARGS:
Array
(
[0] => 666
)
SOURCE CODE:
127 |
<script type="text/javascript" src="https://apis.google.com/js/plusone.js"></script>
|
128 |
<script>!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src="//platform.twitter.com/widgets.js";fjs.parentNode.insertBefore(js,fjs);}}(document,"script","twitter-wjs");</script>
|
129 |
|
130 |
|
131 |
';
|
132 |
$this->smarty->assign('headcontent', $headcontent);
|
133 |
|
134 |
//时间栏目
|
135 |
$this->smarty->assign('timebar', $Modle_Blog->getTimeBar($blog_e_rlt[member][mid], $_GET[U], $_GET[T]));
|
136 |
//月份栏目
|
137 |
$this->smarty->assign('month', $Modle_Blog->getBlogMonth($blog_e_rlt[member][mid]));
|
138 |
//最近访问栏目
|
139 |
$this->smarty->assign('near', $Modle_Near->getNearMember($blog_e_rlt[member][mid], 9));
|
140 |
//好友栏目
|
141 |
$this->smarty->assign('friend', $Modle_Friend->getFriends($blog_e_rlt[member][mid]), 9);
|
142 |
//最新记事
|
143 |
$this->smarty->assign('nearthing', $Modle_Blog->getNearThing($blog_e_rlt[member][mid]));
|
144 |
//分类显示
|
145 |
$this->smarty->assign('scate', $Modle_Blog->getBlogCategory($blog_e_rlt[member][mid]));
|
146 |
//到处qr图
|
147 |
$this->smarty->assign('qr_img', $blog_e_rlt[qr]);
|
Filename: /www/web/ggblog/public_html/libs/FLEA/FLEA/Dispatcher/Simple.php [106]
#4 Controller_Front::Controller_Front('Front')
ARGS:
Array
(
[0] => Front
)
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: /www/web/ggblog/public_html/libs/FLEA/FLEA/Dispatcher/Simple.php [77]
#3 FLEA_Dispatcher_Simple::_executeAction('Front', 'Index', 'Controller_Front')
ARGS:
Array
(
[0] => Front
[1] => Index
[2] => Controller_Front
)
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 |
?>
|