Skip to content
This repository has been archived by the owner on May 2, 2024. It is now read-only.

sql 访问失败 #49

Open
Flowergloden opened this issue Apr 20, 2024 · 3 comments
Open

sql 访问失败 #49

Flowergloden opened this issue Apr 20, 2024 · 3 comments

Comments

@Flowergloden
Copy link

当启用缓存时会因无法访问数据库而解析失败

以下是由 nginx 托管的报错信息

2024/04/20 18:58:46 [error] 105474#105474: *2240 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Call to a member function query() on string in /opt/BiliRoaming-PHP-Server/utils/functio
ns_cache.php:67
Stack trace:
#0 /opt/BiliRoaming-PHP-Server/utils/auth.php(8): get_userinfo_fromsql()
#1 /opt/BiliRoaming-PHP-Server/intl/gateway/v2/ogv/playurl/index.php(21): include('/opt/BiliRoamin...')
#2 {main}
@M1saka10010
Copy link
Contributor

数据库配置有没有问题?

@Flowergloden
Copy link
Author

经过验证数据库的权限并没有问题,所有的表都正常创建,但是唯独 “keys” 表无法访问,疑似 shadow 了关键字,不知道是不是恰好撞上了 MariaDB 与 MySql 的微小差别之一

以下是错误信息
image

数据库配置有没有问题?

@M1saka10010
Copy link
Contributor

经过验证数据库的权限并没有问题,所有的表都正常创建,但是唯独 “keys” 表无法访问,疑似 shadow 了关键字,不知道是不是恰好撞上了 MariaDB 与 MySql 的微小差别之一

以下是错误信息 image

数据库配置有没有问题?

那应该就是这个问题了,尝试一下手动创建?我看sql基本都没用到很复杂的特性,理论上是兼容的诶

# for free to subscribe to this conversation on GitHub. Already have an account? #.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants