Open HtnrxUNc opened 4 years ago
吃完饭再更
吃完了吗
吃完了吗
当时吃完有点事就忘记更了,等想起来的时候基本已经忘得差不多了w
我已经哭晕在厕所 本来部署的差不多了,但是不能注册,然后想着重装一次,结果数据库又出问题了,执行修改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_emailverified 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'
我已经哭晕在厕所 本来部署的差不多了,但是不能注册,然后想着重装一次,结果数据库又出问题了,执行修改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_emailverified 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
重建数据库,重建网站,重启服务器,重新下来代码,都试过了,折腾一上午还是这个错,说来也奇怪,昨天下午还好好的,有点玄学了都
重建数据库,重建网站,重启服务器,重新下来代码,都试过了,折腾一上午还是这个错,说来也奇怪,昨天下午还好好的,有点玄学了都
我好像记得之前我遇见这个错误,但是时间太过久远已经遗忘掉了,我可以查看一下我当时写的笔记
你的笔记在哪儿,没看到呀
你的笔记在哪儿,没看到呀
目前还没有找到,可能永久性遗失了。你执行修改管理员密码指令时出现错误,根据错误日志显示没有找到对应的表,可能是你的导入数据指令没有执行成功。
导入成功了的啊,宝塔的数据库管理工具可以看到里面user那个表中是有admin的呀
导入成功了的啊,宝塔的数据库管理工具可以看到里面user那个表中是有admin的呀
我刚刚想通过chrome查看当时的检索记录,但是似乎已经遗失了。你可以尝试重新安装一下mysql
刚刚试过,重装mysql5.7(之前也是5.7)也不行,就差重装php了。。。哭晕
刚刚试过,重装mysql5.7(之前也是5.7)也不行,就差重装php了。。。哭晕
可以尝试重装一下php
问题依旧 就差换服务器了。。。
解决了,先执行一段代码php bin/console doctrine:schema:update --force 再执行php bin/console change-password -u admin -p 123456 即可解决。
我目前在用宝塔的环境来配置的
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 git@github.com:yeskn-studio/vmoex-framework.git && cd vmoex-framework
指令出错 我所遇见的错误是密钥出错/没有权限拉取github仓库资源(可能差不多是这个意思,来自谷歌翻译)解决方法: