CMS下的栏目管理,删除栏目时出现internal server error错误

xiaoshen 13天前 117

CMS下的栏目管理,删除栏目时出现internal server error错误
服务器环境:Nginx+Mysql 5.5+php5.5/php7.0
先后在三台不同的服务器上面测试,安装cms插件后,在栏目管理中选择删除栏目,都会出现internal server error这个问题。
虽然提示了internal server error,但是刷新后,发现栏目已经删除。
QQ图片20180511212143.png
QQ图片20180511212159.png

最后于 10天前 被xiaoshen编辑
最新回复 (8)
  • Karson 打赏 13天前
    感谢TA
    0 引用 2

    @xiaoshen 能否提供下详细的错误日志。

  • xiaoshen 楼主 12天前
    感谢TA
    0 引用 3

    你好,现提供后台账号,请看下是什么问题,已经开启debug
    [ 2018-05-12T10:21:52+08:00 ] 110.229.24.38 POST /index.php/admin/cms/channel/del/ids/44
    [ info ] x.htsjw.com/index.php/admin/cms/channel/del/ids/44 运行时间:0.922465s [内存消耗:1,366.13kb] [文件加载:94]
    [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000046s ]
    [ info ] [ CACHE ] INIT File
    [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001019s ]
    [ info ] [ LANG ] /www/wwwroot/x.htsjw.com/thinkphp/lang/zh-cn.php
    [ info ] [ ROUTE ] array (
    'type' => 'module',
    'module' =>
    array (

    0 => 'admin',
    1 => 'cms.channel',
    2 => 'del',

    ),
    )
    [ info ] [ HEADER ] array (
    'host' => 'x.htsjw.com',
    'connection' => 'keep-alive',
    'content-length' => '25',
    'accept' => 'application/json, text/javascript, /; q=0.01',
    'origin' => 'http://x.htsjw.com',
    'x-requested-with' => 'XMLHttpRequest',
    'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.181 Safari/537.36',
    'content-type' => 'application/x-www-form-urlencoded; charset=UTF-8',
    'referer' => 'http://x.htsjw.com/index.php/admin/cms/channel?addtabs=1',
    'accept-encoding' => 'gzip, deflate',
    'accept-language' => 'zh-CN,zh;q=0.9',
    'cookie' => 'think_template=default; UM_distinctid=1634f2c6748816-00957b6cdfe15-3a614f0b-1fa400-1634f2c674981c; CNZZDATA3949924=cnzz_eid%3D1148254008-1526036877-http%253A%252F%252F115.47.126.235%253A65515%252F%26ntime%3D1526036877; __guid=193497444.925220228828359200.1526041700377.1523; monitor_count=1; Hm_lvt_f8d0a8c400404989e195270b0bbf060a=1526046732,1526091512; Hm_lpvt_f8d0a8c400404989e195270b0bbf060a=1526091783; PHPSESSID=sr1e4ftespomshbsr7r6t63o26',
    )
    [ info ] [ PARAM ] array (
    'action' => 'del',
    'ids' => '44',
    'params' => '',
    )
    [ info ] [ LANG ] /www/wwwroot/x.htsjw.com/public/../application/admin/lang/zh-cn.php
    [ info ] [ BEHAVIOR ] Run appcommonbehaviorCommon @module_init [ RunTime:0.000235s ]
    [ info ] [ SESSION ] INIT array (
    'id' => '',
    'var_session_id' => '',
    'prefix' => 'think',
    'type' => '',
    'auto_start' => true,
    )
    [ info ] [ DB ] INIT mysql
    [ info ] [ LANG ] /www/wwwroot/x.htsjw.com/public/../application/admin/lang/zh-cn/cms/channel.php
    [ info ] [ RUN ] appcommoncontrollerBackend->del[ /www/wwwroot/x.htsjw.com/application/admin/library/traits/Backend.php ]
    [ info ] [ LOG ] INIT File
    [ sql ] [ DB ] CONNECT:[ UseTime:0.000308s ] mysql:host=localhost;dbname=x_htsjw_com;charset=utf8
    [ sql ] [ SQL ] SHOW COLUMNS FROM fa_auth_group_access [ RunTime:0.001052s ]
    [ sql ] [ SQL ] SELECT aga.uid,aga.group_id,ag.id,ag.pid,ag.name,ag.rules FROM fa_auth_group_access aga LEFT JOIN fa_auth_group ag ON aga.group_id=ag.id WHERE ( aga.uid='1' and ag.status='normal' ) [ RunTime:0.000318s ]
    [ sql ] [ SQL ] SHOW COLUMNS FROM fa_auth_rule [ RunTime:0.001146s ]
    [ sql ] [ SQL ] SELECT id,pid,condition,icon,name,title,ismenu FROM fa_auth_rule WHERE status = 'normal' [ RunTime:0.000518s ]
    [ sql ] [ SQL ] SHOW COLUMNS FROM fa_cms_channel [ RunTime:0.001168s ]
    [ sql ] [ SQL ] SELECT * FROM fa_cms_channel ORDER BY weigh DESC,id DESC [ RunTime:0.000356s ]
    [ sql ] [ SQL ] SHOW COLUMNS FROM fa_cms_model [ RunTime:0.001044s ]
    [ sql ] [ SQL ] SELECT * FROM fa_cms_model ORDER BY id ASC [ RunTime:0.000270s ]
    [ sql ] [ SQL ] SELECT * FROM fa_cms_channel WHERE id IN (44) [ RunTime:0.000508s ]
    [ sql ] [ SQL ] DELETE FROM fa_cms_channel WHERE id = 44 [ RunTime:0.003680s ]
    [ sql ] [ SQL ] SELECT id,parent_id,name,type,diyname,status FROM fa_cms_channel ORDER BY weigh DESC,id DESC [ RunTime:0.000561s ]

    最后于 10天前 被xiaoshen编辑
  • xiaoshen 楼主 12天前
    感谢TA
    0 引用 4

    以上是log文件

  • F4NNIU 打赏 12天前
    感谢TA
    0 引用 5

    表不存在?

    image.png

  • xiaoshen 楼主 12天前
    感谢TA
    0 引用 6
    F4NNIU 表不存在? ![image.png](//cdn.forum.fastadmin.net/uploads/201805/12/955f10f2ea6e61ec2fac3bcd331b0e6e) ...

    你好,看了下数据库,有fa_cms_archives表。没有fa_archives表
    QQ截图20180512111328.png

  • xiaoshen 楼主 12天前
    感谢TA
    0 引用 7
    F4NNIU 表不存在? ![image.png](//cdn.forum.fastadmin.net/uploads/201805/12/955f10f2ea6e61ec2fac3bcd331b0e6e) ...

    刚刚看了安装涉及的数据库文件fastadmin.sql,没有发现sql文件中有fa_archives字样或结构信息

  • Karson 打赏 12天前
    感谢TA
    0 引用 8

    @xiaoshen 感谢反馈,已经确认是BUG,下次插件更新时会修复此BUG,目前你可以手动修复
    找到文件addons/cms/application/admin/model/Channel.php49

    db('archives')

    改成

    db('cms_archives')

    然后在后台禁用再启用下即可修复。

    最后于 12天前 被Karson编辑
  • xiaoshen 楼主 10天前
    感谢TA
    0 引用 9
    Karson @xiaoshen 感谢反馈,已经确认是BUG,下次插件更新时会修复此BUG,目前你可以手动修复 找到文件`addons/cms/application/admin/model/Channel.ph ...

    好的,谢谢

  • 未登录
    10
返回
发表回复