业务经理

微信扫描以上二维码

028-61286886

技术咨询

网站搬家后出现系统错误提示数据库不存在但是数据库又是确实存在

迅睿框架 更新 2020-04-03 19:20:36 草木人

网站搬家后出现系统错误,提示数据库不存在,但是数据库又是确实存在的。

怀疑这个是安装应用插件-模块内容开关 引起的?但是我把这个插件卸载了才迁移也会报错,

我是搬到本地测试,所以是127.0.0.1,xtdh、down、bbs都是独立模块,访问其他模块也会报对应的错

报错日志如下:

CRITICAL - 2020-04-03 17:16:58 --> Table 'testweb.hf_1_xtdh' doesn't exist

# http://127.0.0.1/

# SELECT * FROM `hf_1_xtdh` WHERE `hf_1_xtdh`.`catid` = 1 AND `hf_1_xtdh`.`status` = 9 ORDER BY `hf_1_xtdh`.`updatetime` ASC LIMIT 15

#0 D:\phpstudy_pro\WWW\dayrui\System\Database\MySQLi\Connection.php(330): mysqli->query('SELECT * FROM `...')

#1 D:\phpstudy_pro\WWW\dayrui\System\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('SELECT * FROM `...')

#2 D:\phpstudy_pro\WWW\dayrui\System\Database\BaseConnection.php(666): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT * FROM `...')

#3 D:\phpstudy_pro\WWW\dayrui\Fcms\Core\View.php(2150): CodeIgniter\Database\BaseConnection->query('SELECT * FROM `...')

#4 D:\phpstudy_pro\WWW\dayrui\Fcms\Core\View.php(2090): Phpcmf\View->_query('SELECT * FROM `...', '', 0)

#5 D:\phpstudy_pro\WWW\cache\template\template_pc_default_boot_home_index.html.cache.php(20): Phpcmf\View->list_tag('action=module m...')

#6 D:\phpstudy_pro\WWW\dayrui\Fcms\Core\View.php(229): include('D:\\phpstudy_pro...')

#7 D:\phpstudy_pro\WWW\dayrui\Core\Controllers\Home.php(18): Phpcmf\View->display('index.html')

#8 D:\phpstudy_pro\WWW\dayrui\Core\Controllers\Home.php(64): Phpcmf\Controllers\Home->_index()

#9 D:\phpstudy_pro\WWW\dayrui\System\CodeIgniter.php(910): Phpcmf\Controllers\Home->index()

#10 D:\phpstudy_pro\WWW\dayrui\System\CodeIgniter.php(398): CodeIgniter\CodeIgniter->runController(Object(Phpcmf\Controllers\Home))

#11 D:\phpstudy_pro\WWW\dayrui\System\CodeIgniter.php(306): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)

#12 D:\phpstudy_pro\WWW\dayrui\Fcms\Init.php(329): CodeIgniter\CodeIgniter->run()

#13 D:\phpstudy_pro\WWW\index.php(47): require('D:\\phpstudy_pro...')

#14 {main}

CRITICAL - 2020-04-03 17:16:59 --> Table 'testweb.hf_1_down' doesn't exist

# http://127.0.0.1/index.php?s=down

# SELECT count(*) as c FROM `hf_1_down` WHERE `hf_1_down`.`status` = 9 ORDER BY NULL

#0 D:\phpstudy_pro\WWW\dayrui\System\Database\MySQLi\Connection.php(330): mysqli->query('SELECT count(*)...')

#1 D:\phpstudy_pro\WWW\dayrui\System\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('SELECT count(*)...')

#2 D:\phpstudy_pro\WWW\dayrui\System\Database\BaseConnection.php(666): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT count(*)...')

#3 D:\phpstudy_pro\WWW\dayrui\Fcms\Core\View.php(2150): CodeIgniter\Database\BaseConnection->query('SELECT count(*)...')

#4 D:\phpstudy_pro\WWW\dayrui\Fcms\Core\View.php(2072): Phpcmf\View->_query('SELECT count(*)...', '', 0, false)

#5 D:\phpstudy_pro\WWW\cache\template\template_pc_default_boot_home_down_index.html.cache.php(41): Phpcmf\View->list_tag('action=module m...')

#6 D:\phpstudy_pro\WWW\dayrui\Fcms\Core\View.php(229): include('D:\\phpstudy_pro...')

#7 D:\phpstudy_pro\WWW\dayrui\Fcms\Control\Home\Module.php(92): Phpcmf\View->display('index.html')

#8 D:\phpstudy_pro\WWW\dayrui\App\Down\Controllers\Home.php(11): Phpcmf\Home\Module->_Index()

#9 D:\phpstudy_pro\WWW\dayrui\System\CodeIgniter.php(910): Phpcmf\Controllers\Home->index()

#10 D:\phpstudy_pro\WWW\dayrui\System\CodeIgniter.php(398): CodeIgniter\CodeIgniter->runController(Object(Phpcmf\Controllers\Home))

#11 D:\phpstudy_pro\WWW\dayrui\System\CodeIgniter.php(306): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)

#12 D:\phpstudy_pro\WWW\dayrui\Fcms\Init.php(329): CodeIgniter\CodeIgniter->run()

#13 D:\phpstudy_pro\WWW\index.php(47): require('D:\\phpstudy_pro...')

#14 {main}

CRITICAL - 2020-04-03 17:17:03 --> Table 'testweb.hf_1_bbs' doesn't exist

# http://127.0.0.1/index.php?s=bbs

# SELECT * FROM `hf_1_bbs` WHERE `hf_1_bbs`.`isflag` IN (2) AND `hf_1_bbs`.`status` = 9 ORDER BY `hf_1_bbs`.`updatetime` DESC 

#0 D:\phpstudy_pro\WWW\dayrui\System\Database\MySQLi\Connection.php(330): mysqli->query('SELECT * FROM `...')

#1 D:\phpstudy_pro\WWW\dayrui\System\Database\BaseConnection.php(738): CodeIgniter\Database\MySQLi\Connection->execute('SELECT * FROM `...')

#2 D:\phpstudy_pro\WWW\dayrui\System\Database\BaseConnection.php(666): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT * FROM `...')

#3 D:\phpstudy_pro\WWW\dayrui\Fcms\Core\View.php(2150): CodeIgniter\Database\BaseConnection->query('SELECT * FROM `...')

#4 D:\phpstudy_pro\WWW\dayrui\Fcms\Core\View.php(2090): Phpcmf\View->_query('SELECT * FROM `...', '', 0)

#5 D:\phpstudy_pro\WWW\cache\template\template_pc_default_boot_home_bbs_index.html.cache.php(20): Phpcmf\View->list_tag('action=module I...')

#6 D:\phpstudy_pro\WWW\dayrui\Fcms\Core\View.php(229): include('D:\\phpstudy_pro...')

#7 D:\phpstudy_pro\WWW\dayrui\Fcms\Control\Home\Module.php(92): Phpcmf\View->display('index.html')

#8 D:\phpstudy_pro\WWW\dayrui\App\Bbs\Controllers\Home.php(11): Phpcmf\Home\Module->_Index()

#9 D:\phpstudy_pro\WWW\dayrui\System\CodeIgniter.php(910): Phpcmf\Controllers\Home->index()

#10 D:\phpstudy_pro\WWW\dayrui\System\CodeIgniter.php(398): CodeIgniter\CodeIgniter->runController(Object(Phpcmf\Controllers\Home))

#11 D:\phpstudy_pro\WWW\dayrui\System\CodeIgniter.php(306): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)

#12 D:\phpstudy_pro\WWW\dayrui\Fcms\Init.php(329): CodeIgniter\CodeIgniter->run()

#13 D:\phpstudy_pro\WWW\index.php(47): require('D:\\phpstudy_pro...')

#14 {main}


方案

  • 迅睿框架创始人 #1 · 2020-04-03 17:22:49
    满意答案
    迁移跟插件没有关系,看着是SQL少表,再导出迁移下数据库试试
  • 草木人 #2 · 2020-04-03 19:20:36
    迅睿框架创始人:通过备份出来的数据库没问题,我直接复制出来的有问题。。。。

迅睿系统漏洞

GEO系统
GEO系统(2026-09-15)
运营客户端,防止误触阴影处关闭对话框
独立站群系统
独立站群系统(2026-09-14)
子站独立部署时修复同步附件失败问题
在线客服
在线客服(2026-09-13)
修复删除会话报错问题 删除会话时联动删除聊天图片
在线考试竞赛系统
在线考试竞赛系统(2026-09-12)
增加投票功能 考试功能拓展 注意:更新后需要执行系统更新,更新数...
网上信箱
网上信箱(2026-09-12)
修复新版本兼容问题
GeoSeo收录宝
GeoSeo收录宝(2026-09-12)
1 优化Update.php文件,解决版本在线升级不完整问题 2 ...
GeoSeo工具箱
GeoSeo工具箱(2026-09-11)
修正历史记录推送
微信系统
微信系统(2026-09-11)
增加数据统计总览界面 账号管理增加服务和公众号的区别 菜单管理支持更...
答题系统
答题系统(2026-09-11)
一站式在线答题系统,支持真题考试、题库练习和错题本,适合培训、考证、...
阿里云滑动验证码
阿里云滑动验证码(2026-09-10)
采用阿里云验证码替换迅睿系统自带的图片验证码和滑动验证码。后台设置方...