SELECT * FROM sy_goods WHERE rmd = '1' AND visible = '1' ORDER BY id LIMIT 6<br />执行错误: Incorrect key file for table './zgsjz/sy

SELECT * FROM sy_goods WHERE rmd = '1' AND visible = '1' ORDER BY id LIMIT 6
执行错误: Incorrect key file for table './zgsjz/sy_goods.MYI'; try to repair it

Deprecated: Function ereg() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /home/www/other/zgsjz/SpeedPHP/Misc/notice.php on line 54

/home/www/other/zgsjz/SpeedPHP/Drivers/mysqli.php on line 62

57.

58.


        $this->arrSql[] = $sql;

59.


        if( $result = mysqli_query($this->conn, $sql) ){

60.


            return $result;

61.


        }else{

62.


            spError("{$sql}<br />执行错误: " . mysqli_error($this->conn));

63.

64.

65.

66.

/**

67.


     * 返回影响行数

/home/www/other/zgsjz/SpeedPHP/Drivers/mysqli.php on line 26

21.

22.


     * @param sql  执行的SQL语句

23.

*/

24.


    public function getArray($sql)

25.

26.


        if( ! $result = $this->exec($sql) )return array();

27.


        if( ! mysqli_num_rows($result) )return array();

28.


        $rows = array();

29.


        while($rows[] = mysqli_fetch_array($result, MYSQLI_ASSOC)){}

30.


        mysqli_free_result($result);

31.


        array_pop($rows);

/home/www/other/zgsjz/SpeedPHP/Core/spModel.php on line 106

101.

102.


        $sql = "SELECT {$fields} FROM {$this->tbl_name} {$where} {$sort}";

103.

104.


        if(null != $limit)$sql = $this->_db->setlimit($sql, $limit);

105.

106.


        return $this->_db->getArray($sql);

107.

108.

109.

/**

110.


     * 过滤转义字符

111.

/home/www/other/zgsjz/include/functions.php on line 849

844.

845.

846.

847.


        }elseif($type=='2'){

848.


            //二种不按分类推荐读取

849.


            $list=$lib_table->findAll(array('rmd'=>'1','visible'=>'1'),null, null,''.$limit.'');

850.

851.


        //合并产品或者新闻的分类信息

852.


        foreach($list_rmd as $key=>$v){

853.


            $s[$key]=spClass("lib_goodscat")->find(array('id'=>$v['cid']));

854.


            $list[$key]['pname']=$s[$key]['name'];

/home/www/other/zgsjz/controller/index.php on line 226

221.


            /**首页推荐

222.


             * $table:表名

223.


             * $type:类型(1：按分类推荐，2：不按分类推荐)

224.


             * $limit:读取的条数

225.

*/

226.


            $this->goodsRmd = $goods_rmd = index_rmd('goods', '2', '6');

227.


            $this->newsRmd = $news_rmd = index_rmd('news', '2', '6');

228.


            //推荐产品

229.


            $lib_goods = spClass("lib_goods");

230.


            //一种按分类推荐读取,推荐10个

231.


            $g_cats = spClass("lib_goodscat")->findAll(array('visible' => '1'));

/home/www/other/zgsjz/SpeedPHP/spFunctions.php on line 21

16.


    if(!is_object($handle_controller) || !method_exists($handle_controller, $__action)){

17.


        eval($GLOBALS['G_SP']["dispatcher_error"]);

18.


        exit;

19.

20.


    // 路由并执行用户代码

21.


    $handle_controller->$__action();

22.


    // 控制器程序运行完毕，进行模板的自动输出

23.


    if(FALSE != $GLOBALS['G_SP']['view']['auto_display']){

24.


        $__tplname = $__controller.$GLOBALS['G_SP']['view']['auto_display_sep'].

25.


                $__action.$GLOBALS['G_SP']['view']['auto_display_suffix']; // 拼装模板路径

26.


        $handle_controller->auto_display($__tplname);

/home/www/other/zgsjz/index.php on line 70

65.

66.


// 这里是入口文件全局位置

67.


import(APP_PATH.'/include/functions.php');

68.


import(APP_PATH.'/include/diyFunctions.php');

69.


import(APP_PATH.'/include/smarty.int.php');

70.


spRun();

SELECT * FROM sy_goods WHERE rmd = '1' AND visible = '1' ORDER BY id LIMIT 6执行错误: Incorrect key file for table './zgsjz/sy_goods.MYI'; try to repair it

SELECT * FROM sy_goods WHERE rmd = '1' AND visible = '1' ORDER BY id LIMIT 6
执行错误: Incorrect key file for table './zgsjz/sy_goods.MYI'; try to repair it