上帝派我来 avatar

这是什么问题呀 install后 数据库也导入了 提示MYSQL ERROR

🕟 by 上帝派我来

http://you.luchuan.me

数据库出错:

MySQL Query Error Mysql error description: Duplicate entry 'site_create' for key 'PRIMARY' Mysql error number: 1062 Date: 2013-11-03 @ 11:56 Script: http://you.luchuan.me/

💘 相关文章

评论

共9条关于"这是什么问题呀 install后 数据库也导入了 提示MYSQL ERROR"的评论

上帝派我来 avatar
#1 上帝派我来 回复

重新上传安装，在没有把根目录的sql文件导入数据里会出现下面的错误

数据库出错:

MySQL Query Error Mysql error description: Duplicate entry 'site_create' for key 'PRIMARY' Mysql error number: 1062 Date: 2013-11-03 @ 11:56 Script: http://you.luchuan.me/

上帝派我来 avatar
#2 上帝派我来 回复

导入数据库 也不用执行/install 打开首页就会出现下面的错误，通过注释掉代码也是小问题了 Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/wwwroot/you.luchuan.me/include/mysql.class.php on line 97

上帝派我来 avatar
#3 上帝派我来 回复

点注册后也没有提示成功 但数据库已经写入了

数据库出错:

MySQL Query Error Mysql error description: Duplicate entry 'site_create' for key 'PRIMARY' Mysql error number: 1062 Date: 2013-11-03 @ 12:16 Script: http://you.luchuan.me/

上帝派我来 avatar
#5 上帝派我来 回复 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
 
{
		listen       80;
		server_name you.luchuan.me;
		index index.html index.htm index.php default.html default.htm default.php;
		root  /home/wwwroot/you.luchuan.me;

		include none.conf;
		location ~ .*\.(php|php5)?$
			{
				fastcgi_pass  unix:/tmp/php-cgi.sock;
				fastcgi_index index.php;
				include fcgi.conf;
			}

		 if (!-e $request_filename)  
		    {  
            rewrite ^/n-([0-9]+)(-([0-9]*))?$ /nodepage.php?cid=$1&page=$3 last;
 rewrite ^/t-([0-9]+)(-([0-9]*))?$ /topicpage.php?tid=$1&page=$3 last;
 rewrite ^/notifications$ /notifications.php last;
 rewrite ^/feed$ /feed.php last;
 rewrite ^/forgot$ /forgot.php last;
 rewrite ^/upload-(650|590)$ /upload.php?mw=$1 last;
 rewrite ^/viewat-(desktop|mobile)$ /viewat.php?via=$1 last;
 rewrite ^/goto-t-([0-9]+)$ /gototopic.php?tid=$1 last;
 rewrite ^/member/(.+)$ /member.php?mid=$1 last;
 rewrite ^/newpost/([0-9]+)$ /newpost.php?cid=$1 last;
 rewrite ^/admin-edit-post-([0-9]+)$ /admin-edit-post.php?tid=$1 last;
 rewrite ^/admin-edit-comment-([0-9]+)$ /admin-edit-comment.php?rid=$1 last;
 rewrite ^/admin-setuser-([0-9]+)$ /admin-setuser.php?mid=$1 last;
 rewrite ^/admin-node(-([0-9]*))?$ /admin-node.php?nid=$2 last;
 rewrite ^/admin-setting$ /admin-setting.php last;
 rewrite ^/admin-user-([a-z]+)(-([0-9]*))?$ /admin-user.php?act=$1&mid=$3 last;
 rewrite ^/admin-link-([a-z]+)(-([0-9]*))?$ /admin-link.php?act=$1&lid=$3 last;
 rewrite ^/(login|sigin|logout|forgot|setting|install)$ /$1.php last;
 rewrite ^/.*?templates /404.html last;
 rewrite ^/.*?avatar/$ /404.html last;
 rewrite ^/upload/([0-9]+/)?$ /404.html last;
 rewrite ^/.*?avatar/(large|normal|mini)/$ /404.html last;
 rewrite ^/favorites$ /favorites.php last;  
            }  

		location ~ .*\.(gif|jpg|jpeg|png|bmp|swf)$
			{
				expires      30d;
			}

		location ~ .*\.(js|css)?$
			{
				expires      12h;
			}

		access_log off;
	}

nginx 配置

admin avatar
#7 admin 回复

楼主的提示表示表 yunbbs_settings 有个键重复了，site_create 把它改为当前或某一天的 timestamp

写一条评论

登录发表评论
Based on Golang + fastHTTP + sdb | go1.17.1 Processed in 4ms