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

By 上帝派我来 at 2013-11-03 11:59 • 2648次点击

数据库出错:

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/

MYSQL, ERROR, install, 导入, 数据库

相关帖子：

共 9 条回复 | 2013-11-03 15:22

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

上帝派我来 at 2013-11-03 12:08

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

上帝派我来 at 2013-11-03 12:15

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

数据库出错:

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/

上帝派我来 at 2013-11-03 12:16

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

上帝派我来 at 2013-11-03 12:18

    {
        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&amp;page=$3 last;
 rewrite ^/t-([0-9]+)(-([0-9]*))?$ /topicpage.php?tid=$1&amp;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&amp;mid=$3 last;
 rewrite ^/admin-link-([a-z]+)(-([0-9]*))?$ /admin-link.php?act=$1&amp;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 配置

上帝派我来 at 2013-11-03 12:19

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

上帝派我来 at 2013-11-03 12:57

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

admin at 2013-11-03 13:56

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

上帝派我来 at 2013-11-03 15:21

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

上帝派我来 at 2013-11-03 15:22

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

相关帖子：

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