Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

补充(大部分常见问题及解决方法) #41

Open
HtnrxUNc opened this issue Aug 18, 2020 · 15 comments
Open

补充(大部分常见问题及解决方法) #41

HtnrxUNc opened this issue Aug 18, 2020 · 15 comments

Comments

@HtnrxUNc
Copy link

我目前在用宝塔的环境来配置的
Nginx:1.17.10 Mysql:5.6.48 PHP:7.3 Pure-Ftpd:1.0.49 PHPMyAdmin:4.7 PM2 Manager:4.2.3 Redis:6.0.5
(并非全部都能用上,只是列出我现在所用的配置)
以下是我所遇见过的问题及解决方法
git clone [email protected]:yeskn-studio/vmoex-framework.git && cd vmoex-framework指令出错
我所遇见的错误是密钥出错/没有权限拉取github仓库资源(可能差不多是这个意思,来自谷歌翻译)

解决方法:

执行ssh-keygen -t rsa -b 4096

着会让你输入存放密钥的位置,输入/root/githubmiyue`之后回车

两次回车(或者一次?这是让你输入密钥的密码,不懂得或者不想麻烦的建议不输)

接着在你的/root/(同~/)目录下看到名为githubmiyuegithubmiyue.pub文件

执行git config --global user.name 你的github用户名

执行git config --global user.email 你的github邮箱

执行ssh-add githubmiyue

githubmiyue.pub中的内容全部复制

打开https://github.com/ ,登陆你的github,然后点击New ssh key,将刚刚复制的内容全部粘贴入key的编辑框中标题随意

执行ssh [email protected]测试是否成功

@HtnrxUNc
Copy link
Author

吃完饭再更

@Jack-bin183
Copy link

吃完了吗

@HtnrxUNc
Copy link
Author

HtnrxUNc commented Mar 7, 2021

吃完了吗

当时吃完有点事就忘记更了,等想起来的时候基本已经忘得差不多了w

@Jack-bin183
Copy link

我已经哭晕在厕所 本来部署的差不多了,但是不能注册,然后想着重装一次,结果数据库又出问题了,执行修改admin密码的时候,报错表中没有admin,啊啊啊
[root@VM-0-13-centos bbs.doyicu.com]# php bin/console change-password -u admin -p Zb19581400

In AbstractMySQLDriver.php line 60:

An exception occurred while executing 'SELECT t0.id AS id_1, t0.username AS username_2, t0.nick
name AS nickname_3, t0.password AS password_4, t0.email AS email_5, t0.is_email_verified AS is_
email_verified_6, t0.avatar AS avatar_7, t0.remark AS remark_8, t0.gold AS gold_9, t0.sign_day
AS sign_day_10, t0.active_val AS active_val_11, t0.role AS role_12, t0.salt AS salt_13, t0.chan
ged_nickname_at AS changed_nickname_at_14, t0.register_at AS register_at_15, t0.login_at AS log
in_at_16 FROM user t0 WHERE t0.username = ? LIMIT 1' with params ["admin"]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.changed_nickname_at' in 'field list'

In PDOStatement.php line 119:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.changed_nickname_at' in 'field list'

In PDOStatement.php line 117:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.changed_nickname_at' in 'field list'

@HtnrxUNc
Copy link
Author

HtnrxUNc commented Mar 7, 2021

我已经哭晕在厕所 本来部署的差不多了,但是不能注册,然后想着重装一次,结果数据库又出问题了,执行修改admin密码的时候,报错表中没有admin,啊啊啊
[root@VM-0-13-centos bbs.doyicu.com]# php bin/console change-password -u admin -p Zb19581400

In AbstractMySQLDriver.php line 60:

An exception occurred while executing 'SELECT t0.id AS id_1, t0.username AS username_2, t0.nick
name AS nickname_3, t0.password AS password_4, t0.email AS email_5, t0.is_email_verified AS is_
email_verified_6, t0.avatar AS avatar_7, t0.remark AS remark_8, t0.gold AS gold_9, t0.sign_day
AS sign_day_10, t0.active_val AS active_val_11, t0.role AS role_12, t0.salt AS salt_13, t0.chan
ged_nickname_at AS changed_nickname_at_14, t0.register_at AS register_at_15, t0.login_at AS log
in_at_16 FROM user t0 WHERE t0.username = ? LIMIT 1' with params ["admin"]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.changed_nickname_at' in 'field list'

In PDOStatement.php line 119:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.changed_nickname_at' in 'field list'

In PDOStatement.php line 117:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.changed_nickname_at' in 'field list'

你可以尝试重新建立一个数据库并且删掉网站目录重装一次,稍后我会尝试再次安装这个项目w

@Jack-bin183
Copy link

重建数据库,重建网站,重启服务器,重新下来代码,都试过了,折腾一上午还是这个错,说来也奇怪,昨天下午还好好的,有点玄学了都

@HtnrxUNc
Copy link
Author

HtnrxUNc commented Mar 7, 2021

重建数据库,重建网站,重启服务器,重新下来代码,都试过了,折腾一上午还是这个错,说来也奇怪,昨天下午还好好的,有点玄学了都

我好像记得之前我遇见这个错误,但是时间太过久远已经遗忘掉了,我可以查看一下我当时写的笔记

@Jack-bin183
Copy link

你的笔记在哪儿,没看到呀

@HtnrxUNc
Copy link
Author

HtnrxUNc commented Mar 7, 2021

你的笔记在哪儿,没看到呀

目前还没有找到,可能永久性遗失了。你执行修改管理员密码指令时出现错误,根据错误日志显示没有找到对应的表,可能是你的导入数据指令没有执行成功。

@Jack-bin183
Copy link

导入成功了的啊,宝塔的数据库管理工具可以看到里面user那个表中是有admin的呀

@HtnrxUNc
Copy link
Author

HtnrxUNc commented Mar 7, 2021

导入成功了的啊,宝塔的数据库管理工具可以看到里面user那个表中是有admin的呀

我刚刚想通过chrome查看当时的检索记录,但是似乎已经遗失了。你可以尝试重新安装一下mysql

@Jack-bin183
Copy link

刚刚试过,重装mysql5.7(之前也是5.7)也不行,就差重装php了。。。哭晕

@HtnrxUNc
Copy link
Author

HtnrxUNc commented Mar 7, 2021

刚刚试过,重装mysql5.7(之前也是5.7)也不行,就差重装php了。。。哭晕

可以尝试重装一下php

@Jack-bin183
Copy link

问题依旧 就差换服务器了。。。

@Jack-bin183
Copy link

解决了,先执行一段代码php bin/console doctrine:schema:update --force
再执行php bin/console change-password -u admin -p 123456 即可解决。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants