业务经理

微信扫描以上二维码

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
    迅睿框架创始人:通过备份出来的数据库没问题,我直接复制出来的有问题。。。。

迅睿系统漏洞

外贸多语言建站
外贸多语言建站(2026-10-30)
修正对百度编辑器提取支持
AI文章生成器
AI文章生成器(2026-10-29)
任务插图设置数量
Bing站长数据
Bing站长数据(2026-10-29)
根据BING接口调整菜单 各个页面数据支持点击查看详情
按字段付费
按字段付费(2026-10-29)
按字段付费用于模块的字段设置一定的价格,当用户购买了此内容的字段时才...
泛解析站群系统
泛解析站群系统(2026-10-29)
AI队列增加清空按钮 表单提示语收敛 目录模式不接管主域名模板
自定义收款/捐款
自定义收款/捐款(2026-10-28)
自定义收款或捐款插件可以让用户快速创建付款或者捐款功能
CMS内容批量修改
CMS内容批量修改(2026-10-28)
后台批量修改文章内容的指定字段在插件后台可以任意指定字段
全站模块搜索
全站模块搜索(2026-10-28)
实现全模块一次性搜索内容,一键搜索全站内容精准搜索全部模块:
PHPCMSV9数据转换
PHPCMSV9数据转换(2026-10-28)
PHPCMS转入迅睿CMS操作步骤:https://www.xunr...
域名授权系统
域名授权系统(2026-10-28)
后台增加前台访问地址链接