在编辑帝国cms7.5部分信息时,弹出“您来自的链接不存在”,无法进行编辑。这个问题不知是在上一次升级时出现的,还是在网站搬家时出现的,反正时间很久了。最近在服务器迁移时,这个问题还是存在,遂求助deepseek,有点思路但未能成功解决。后搜索时发现一篇文章,思路和AI相符,试验之后,管用。转发一下供后来人参考,附上链接作为对先行者的感谢。
<?php
require ('e/class/connect.php');
//引入数据库配置文件和公共函数文件
require ('e/class/db_sql.php');
//引入数据库操作文件
$link = db_connect();
//连接MYSQL
$empire = new mysqlquery();
//声明数据库操作类
$sql = $empire -> query("select * from {$dbtbpre}ecms_news_check WHERE id not in (SELECT id FROM {$dbtbpre}ecms_news_index)");
//查询缺少index记录的记录
while ($r = $empire -> fetch($sql))//循环获取查询记录
{
//手动添加index记录
$empire -> query("insert into {$dbtbpre}ecms_news_index(id,classid,checked,newstime,truetime,lastdotime,havehtml) values(".$r['id'].",".$r['classid'].",1,1399450895,1399451228,1399451228,1)");
$lastid = $empire -> lastid();
echo"刚插入的信息ID为:".$lastid;
}
$sql = $empire -> query("select * from {$dbtbpre}ecms_news WHERE id not in (SELECT id FROM {$dbtbpre}ecms_news_index)");
//查询缺少index记录的记录
while ($r = $empire -> fetch($sql))//循环获取查询记录
{
//手动添加index记录
$empire -> query("insert into {$dbtbpre}ecms_news_index(id,classid,checked,newstime,truetime,lastdotime,havehtml) values(".$r['id'].",".$r['classid'].",1,4294967295,4294967295,4294967295,1)");
$lastid = $empire -> lastid();
echo"刚插入的信息ID为:".$lastid;
}
echo"执行完毕";
db_close();
//关闭MYSQL链接
$empire = null;
//注消操作类变量
?>
require ('e/class/connect.php');
//引入数据库配置文件和公共函数文件
require ('e/class/db_sql.php');
//引入数据库操作文件
$link = db_connect();
//连接MYSQL
$empire = new mysqlquery();
//声明数据库操作类
$sql = $empire -> query("select * from {$dbtbpre}ecms_news_check WHERE id not in (SELECT id FROM {$dbtbpre}ecms_news_index)");
//查询缺少index记录的记录
while ($r = $empire -> fetch($sql))//循环获取查询记录
{
//手动添加index记录
$empire -> query("insert into {$dbtbpre}ecms_news_index(id,classid,checked,newstime,truetime,lastdotime,havehtml) values(".$r['id'].",".$r['classid'].",1,1399450895,1399451228,1399451228,1)");
$lastid = $empire -> lastid();
echo"刚插入的信息ID为:".$lastid;
}
$sql = $empire -> query("select * from {$dbtbpre}ecms_news WHERE id not in (SELECT id FROM {$dbtbpre}ecms_news_index)");
//查询缺少index记录的记录
while ($r = $empire -> fetch($sql))//循环获取查询记录
{
//手动添加index记录
$empire -> query("insert into {$dbtbpre}ecms_news_index(id,classid,checked,newstime,truetime,lastdotime,havehtml) values(".$r['id'].",".$r['classid'].",1,4294967295,4294967295,4294967295,1)");
$lastid = $empire -> lastid();
echo"刚插入的信息ID为:".$lastid;
}
echo"执行完毕";
db_close();
//关闭MYSQL链接
$empire = null;
//注消操作类变量
?>
参考来源:
https://blog.csdn.net/weixin_33743703/article/details/86019668?spm=1001.2014.3001.5502
https://www.cnblogs.com/nangong/p/9779159.html