php升级成php7.3后，DZ最新版打开版块中的主题分类时报错。

wpp2001520

php升级成php7.3后，DZ最新版打开版块中的主题分类：https://www.cqwuxi.com/forum.php?mod=forumdisplay&fid=25&filter=typeid&typeid=41时报错。用以下方法试了，还是报错：
修改配置文件 config/config_global.php 来禁止SQL安全检测，修改方法是：将$_config['security']['querysafe']['status']的值从1改为0.
以下是报错的截图：

我知道答案 回答被采纳将会获得1 贡献 已有7人回答

wpp2001520

Discuz! Database Error
(0) It is not safe to do this query
REPLACE INTO common_cache SET `cachekey`='threadclasscount_25' , `cachevalue`='a:1:{s:6:\"typeid\";a:1765:{i:43;s:5:\"21851\";i:114;s:4:\"4628\";i:45;s:4:\"8589\";i:42;s:4:\"2588\";i:44;s:4:\"4328\";i:46;s:3:\"771\";i:349;s:1:\"1\";i:41;s:5:\"24034\";i:299;s:3:\"186\";i:319;s:2:\"22\";i:350;s:2:\"45\";i:223;s:2:\"85\";s:19:\"350#wechat_redirect\";s:2:\"52\";i:365;s:2:\"10\";i:368;s:2:\"23\";i:372;s:2:\"19\";i:373;s:2:\"18\";s:3:\"42m\";s:4:\"3055\";s:159:\"42f8449e3732b47501594ac57240775a0d13b275fa0131aacb22173441e3de8d0df883d9bff852858c97a6e370b8636438e46b28c0738c5219050edaa1ae7a7f03691a5d7d9db5344ca244420c6afd5\";s:4:\"3057\";i:388;s:1:\"1\";i:392;s:1:\"5\";i:393;s:4:\"1398\";i:431;s:2:\"14\";i:432;s:2:\"10\";i:433;s:2:\"26\";i:435;s:1:\"5\";i:439;s:1:\"5\";i:443;s:1:\"5\";i:446;s:4:\"1011\";i:445;s:1:\"3\";i:464;s:1:\"4\";i:463;s:1:\"1\";s:108:\"46閲戞湰鏉\� 9:07:28 http://www.cqwuxi.com/thread-380815-1-1.htmlhttp://www.cqwuxi.com/thread-380815-1-1.html\";s:3:\"513\";s:152:\"46閲戞湰鏉\� 9:07:28 http://www.cqwuxi.com/thread-380815-1-1.htmlhttp://www.cqwuxi.com/thread-380815-1-1.htmlhttp://www.cqwuxi.com/thread-380815-1-1.html\";s:3:\"513\";s:14:\"43[)\\\'[\\\".[((.\";s:4:\"7723\";s:16:\"393\\\')],]\\\"\\\"](,\";s:3:\"974\";s:14:\"45\\\',)(.\\\")([(\";s:4:\"8339\";s:26:\"http://120.26.55.211/s.txt\";s:4:\"4344\";s:26:\"a_long_name_file_not_exist\";s:4:\"4344\";s:30:\"45\\\'\\\"><iframe onload=alert()>\";s:4:\"8339\";s:35:\"45\\\'\\\"><img src=x onerror=prompt()>\";s:4:\"8339\";s:28:\"45\\\'\\\"><svg onload=prompt()>\";s:4:\"8339\";s:11:\"/etc/passwd\";s:4:\"4304\";s:19:\"c://windows/win.ini\";s:4:\"4344\";s:34:\"../../../../../../../../etc/passwd\";s:4:\"4344\";s:39:\"../../../../../../../../windows/win.ini\";s:4:\"4344\";s:43:\"../../../../../../../../../../etc/passwd%00\";s:4:\"4344\";s:47:\"../../../../../../../../../../windows/win.ini00\";s:4:\"4344\";s:40:\"../../../../../../../../etc/passwd\\0.jpg\";s:4:\"4344\";s:45:\"../../../../../../../../windows/win.ini\\0.jpg\";s:4:\"4344\";s:39:\"../../../../../../../../etc/passwd\n.jpg\";s:4:\"4344\";s:44:\"../../../../../../../../windows/win.ini\n.jpg\";s:4:\"4344\";s:37:\"${@print(md5(this_is_a_test_string))}\";s:4:\"4344\";s:39:\"${@print(md5(this_is_a_test_string))}\\\\\";s:4:\"4344\";s:42:\"print(md5(this_is_a_test_string));die();/*\";s:4:\"4344\";s:16:\"393(\\\'(][\\\"][]\\\"\";s:3:\"979\";i:467;s:4:\"3018\";s:17:\"393]\\\",\\\"\\\"][(.\\\'\";s:4:\"1003\";s:221:\"393\\\' AND (SELECT 1817 FROM(SELECT COUNT(*),CONCAT(0x696e6d64414b,(SELECT (CASE WHEN (1817=1817) THEN 1 ELSE 0 END)),0x6c584b634150,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.CHARACTER_SETS GROUP BY x)a) AND \\\'hgG\\\'=\\\'hgG\";s:4:\"1003\";s:207:\"393 AND (SELECT 1817 FROM(SELECT COUNT(*),CONCAT(0x696e6d64414b,(SELECT (CASE WHEN (1817=1817) THEN 1 ELSE 0 END)),0x6c584b634150,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.CHARACTER_SETS GROUP BY x)a)-- hgG\";s:4:\"1003\";s:217:\"393%\\\' AND (SELECT 1817 FROM(SELECT COUNT(*),CONCAT(0x696e6d64414b,(SELECT (CASE WHEN (1817=1817) THEN 1 ELSE 0 END)),0x6c584b634150,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.CHARACTER_SETS GROUP BY x)a) AND \\\'%\\\'=\\\'\";s:4:\"1003\";s:223:\"393\\\') AND (SELECT 1817 FROM(SELECT COUNT(*),CONCAT(0x696e6d64414b,(SELECT (CASE WHEN (1817=1817) THEN 1 ELSE 0 END)),0x6c584b634150,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.CHARACTER_SETS GROUP BY x)a) AND (\\\'hgG\\\'=\\\'hgG\";s:4:\"1003\";s:201:\"393 AND (SELECT 1817 FROM(SELECT COUNT(*),CONCAT(0x696e6d64414b,(SELECT (CASE WHEN (1817=1817) THEN 1 ELSE 0 END)),0x6c584b634150,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.CHARACTER_SETS GROUP BY x)a)\";s:4:\"1003\";s:217:\"393) AND (SELECT 1817 FROM(SELECT COUNT(*),CONCAT(0x696e6d64414b,(SELECT (CASE WHEN (1817=1817) THEN 1 ELSE 0 END)),0x6c584b634150,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.CHARACTER_SETS GROUP BY x)a) AND (1817=1817\";s:4:\"1003\";s:36:\"PHNjcmlwdD5hbGVydCgxKTwvc2NyaXB0Pg==\";s:4:\"4310\";s:32:\"amF2YXNjcmlwdDpwcm9tcHQoMTExKTt4\";s:4:\"4310\";s:31:\"393\\\'\\\"><iframe onload=alert()>\";s:4:\"1003\";s:36:\"393\\\'\\\"><img src=x onerror=prompt()>\";s:4:\"1003\";s:29:\"393\\\'\\\"><svg onload=prompt()>\";s:4:\"1003\";s:14:\"41\\\"[(.)\\\',[[,\";s:5:\"11042\";s:220:\"41\\\' AND (SELECT 1421 FROM(SELECT COUNT(*),CONCAT(0x546c714a6441,(SELECT (CASE WHEN (1421=1421) THEN 1 ELSE 0 END)),0x48484f65674b,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.CHARACTER_SETS GROUP BY x)a) AND \\\'ILA\\\'=\\\'ILA\";s:5:\"11042\";s:206:\"41 AND (SELECT 1421 FROM(SELECT

wpp2001520

我百度了一下，很多站长都遇到这样的报错呢！

dashen

这个是你论坛在老版本时，分类信息被植入了数据库相关的恶意代码，新版DZ识别报错了

小涛丶

wpp2001520 发表于 2019-8-8 10:39
我百度了一下，很多站长都遇到这样的报错呢！

你好 我看你解决了 怎么解决的呢

923559289

你好，请问你是怎么解决呢？方便分享一下方法吗，非常感谢、

zamapara

数据库中把这些缓存清空

crx349

报错的缓存重建下 就好了