Discuz! Database Error(1062) Duplicate entry '500990' for key

站长苏飞

Discuz! Database Error(1062) Duplicate entry '500990' for key 1INSERT INTO plugin_cf_visitor_port_visit SET `visit_time`='1443198253' , `leave_time`='1443198253' , `ip`='115.60.195.89' , `port`='4810' , `uid`='1' , `http_user_agent`='Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36' , `http_accept`='text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8' , `client_hardware`='1'

PHP Debug

No.	File	Line	Code
1	forum.php	71	require(%s)
2	source/module/forum/forum_index.php	432	include(%s)
3	data/template/25_diy_forum_discuz.tpl.php	1	hookscriptoutput(%s)
4	source/function/function_core.php	1195	hookscript(%s, %s)
5	source/function/function_core.php	1158	plugin_chanfron_port->global_header(Array)
6	source/plugin/chanfron_port/hook.class.php	56	discuz_container->insert(Array)
7	source/plugin/chanfron_port/hook.class.php	56	discuz_container->__call(%s, Array)
8	source/class/discuz/discuz_container.php	59	table_plugin_cf_visitor_port_visit->insert(Array)
9	source/plugin/chanfron_port/table/table_plugin_cf_visitor_port_visit.php	140	discuz_database::insert(%s, Array)
10	source/class/discuz/discuz_database.php	60	discuz_database::query(%s, %s, %s, true)
11	source/class/discuz/discuz_database.php	136	db_driver_mysql->query(%s, %s, true)
12	source/class/db/db_driver_mysql.php	151	db_driver_mysql->halt(%s, %d, %s)
13	source/class/db/db_driver_mysql.php	218	break()

这个问题的解决方案很简单找到这个表plugin_cf_visitor_port_visit
这里的自增列值是[size=14.6666669845581px]500990 其实数据库中已经有了[size=14.6666669845581px]500991了，所以自增的时候应该加1，可以手动修改数据，最简单的方法是执行一下数据库修复，使用phpmyadmin工具就行了。
[size=14.6666669845581px]

Cheungnotes

网站打不开就是这个原因吗？

站长苏飞

Cheungnotes 发表于 2015-9-26 00:54
网站打不开就是这个原因吗？

肯定不是，呵呵，网站是正常维护，升级模块的