上帝派我来
上帝派我来
4505 9 0

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

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/

0

See Also

Nearby


Discussion (9)

上帝派我来
上帝派我来 2013-11-03 04:08

重新上传安装,在没有把根目录的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/

0
上帝派我来
上帝派我来 2013-11-03 04:15

导入数据库 也不用执行/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

0
上帝派我来
上帝派我来 2013-11-03 04:16

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

数据库出错:

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/

0
上帝派我来
上帝派我来 2013-11-03 04:18

然后就一直卡这里了 安装的是github的版本

0
上帝派我来
上帝派我来 2013-11-03 04:19
	{
		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 配置

0
上帝派我来
上帝派我来 2013-11-03 04:57

查找数据库的相关字节 把0改为1 就可以了

0
admin
admin 2013-11-03 05:56

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

0
上帝派我来
上帝派我来 2013-11-03 07:21

在把固定链接t-转为t/ 的过程中出现错误了
http://you.luchuan.me/t/5#new-comment 回复的时候 跳转错误 要修改哪个地方呀,

0
上帝派我来
上帝派我来 2013-11-03 07:22

按提交是跳转到这个链接了 http://you.luchuan.me/t-5-1#new-comment

0
Login Topics