• 日常搜索
  • 端口查询
  • IP查询
  • 在线工具
  • 搜本站

一招解决1146:Table 'newhm.web_agentmenu' doesn't exist [ SQL语句 ] : SHOW COLUMNS FROM `web_agentmenu`

1146:Table 'newhm.web_agentmenu' doesn't exist [ SQL语句 ] : SHOW COLUMNS FROM `web_agentmenu`

错误位置

FILE: D:\phpstudy_pro\WWW\dalianmeng\ThinkPHP\Library\Think\Db\Driver.class.php  LINE: 350

TRACE

#0 D:\phpstudy_pro\WWW\dalianmeng\ThinkPHP\Library\Think\Db\Driver.class.php(350): E('1146:Table 'new...')
#1 D:\phpstudy_pro\WWW\dalianmeng\ThinkPHP\Library\Think\Db\Driver.class.php(180): Think\Db\Driver->error()
#2 D:\phpstudy_pro\WWW\dalianmeng\ThinkPHP\Library\Think\Db\Driver\Mysql.class.php(56): Think\Db\Driver->query('SHOW COLUMNS FR...')
#3 D:\phpstudy_pro\WWW\dalianmeng\ThinkPHP\Library\Think\Model.class.php(134): Think\Db\Driver\Mysql->getFields('web_agentmenu')
#4 D:\phpstudy_pro\WWW\dalianmeng\ThinkPHP\Library\Think\Model.class.php(122): Think\Model->flush()
#5 D:\phpstudy_pro\WWW\dalianmeng\ThinkPHP\Library\Think\Model.class.php(1454): Think\Model->_checkTableInfo()
#6 D:\phpstudy_pro\WWW\dalianmeng\ThinkPHP\Library\Think\Model.class.php(97): Think\Model->db(0, '', true)
#7 D:\phpstudy_pro\WWW\dalianmeng\ThinkPHP\Common\functions.php(621): Think\Model->__construct('Agentmenu', '', '')
#8 D:\phpstudy_pro\WWW\dalianmeng\Application\Admin\Controller\AgentController.class.php(180): M('Agentmenu')
#9 [internal function]: Admin\Controller\AgentController->group_edit()
#10 D:\phpstudy_pro\WWW\dalianmeng\ThinkPHP\Library\Think\App.class.php(173): ReflectionMethod->invoke(Object(Admin\Controller\AgentController))
#11 D:\phpstudy_pro\WWW\dalianmeng\ThinkPHP\Library\Think\App.class.php(110): Think\App::invokeAction(Object(Admin\Controller\AgentController), 'group_edit')
#12 D:\phpstudy_pro\WWW\dalianmeng\ThinkPHP\Library\Think\App.class.php(204): Think\App::exec()
#13 D:\phpstudy_pro\WWW\dalianmeng\ThinkPHP\Library\Think\Think.class.php(120): Think\App::run()
#14 D:\phpstudy_pro\WWW\dalianmeng\ThinkPHP\ThinkPHP.php(102): Think\Think::start()
#15 D:\phpstudy_pro\WWW\dalianmeng\admin.php(22): require('D:\\phpstudy_pro...')
#16 {main}

ThinkPHP3.2.3 { Fast & Simple OOP PHP Framework } -- [ WE CAN DO IT JUST THINK ]

一招解决1146:Table 'newhm.web_agentmenu' doesn't exist [ SQL语句 ] : SHOW COLUMNS FROM `web_agentmenu`  第1张

解决办法:

上面说得很明白了,就是表名写错了,把web_agentmenu改成web_agent_menu就可以(数据库是web_agent_menu),找到下面二个文件

一招解决1146:Table 'newhm.web_agentmenu' doesn't exist [ SQL语句 ] : SHOW COLUMNS FROM `web_agentmenu`  第2张

文件地址看图片顶部,Agentmenu改成Agent_menu就可以。

测试效果:

重新打开刚才报错地方:

一招解决1146:Table 'newhm.web_agentmenu' doesn't exist [ SQL语句 ] : SHOW COLUMNS FROM `web_agentmenu`  第3张

这个是五游代理权限编辑的报错,可以看到成功解决了!

文章目录
  • 错误位置
  • TRACE
  • 解决办法:
  • 测试效果:
  • 发表评论