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

使用SQLite作数据库,在更新后无法访问首页 #1154

Closed
xanadus0 opened this issue Sep 8, 2021 · 0 comments
Closed

使用SQLite作数据库,在更新后无法访问首页 #1154

xanadus0 opened this issue Sep 8, 2021 · 0 comments
Labels
bug Something isn't working
Milestone

Comments

@xanadus0
Copy link

xanadus0 commented Sep 8, 2021

1. 该问题的重现步骤是什么?

使用SQLite,更新到最新版,访问首页

2. 你期待的结果是什么?实际看到的又是什么?

直接访问首页,只显示Error establishing a database connection
开启Debug模式,页面有内容显示,页面最下方显示:

SQLSTATE[HY000]: General error: 1 near "SELECT": syntax error
Typecho\Db\Adapter\SQLException: SQLSTATE[HY000]: General error: 1 near "SELECT": syntax error in /var/www/blog/var/Typecho/Db/Adapter/Pdo.php:112
Stack trace:
#0 /var/www/blog/var/Typecho/Db.php(383): Typecho\Db\Adapter\Pdo->query()
#1 /var/www/blog/var/Typecho/Db.php(449): Typecho\Db->query()
#2 /var/www/blog/var/Widget/Base/Contents.php(445): Typecho\Db->fetchObject()
#3 /var/www/blog/var/Widget/Archive.php(548): Widget\Base\Contents->size()
#4 /var/www/blog/var/Widget/Archive.php(811): Widget\Archive->getTotal()
#5 /var/www/blog/usr/themes/default/index.php(41): Widget\Archive->pageNav()
#6 /var/www/blog/var/Widget/Archive.php(1395): require_once('/var/www/blo...')
#7 /var/www/blog/var/Typecho/Router.php(99): Widget\Archive->render()
#8 /var/www/blog/index.php(23): Typecho\Router::dispatch()
#9 {main}

3. 问题出现的环境

  • 操作系统版本:Debian 11
  • Apache/NGINX 版本:Nginx 1.18.0
  • 数据库版本:SQLite3 3.34.1
  • PHP 版本:7.4.21
  • Typecho 版本:master
  • 浏览器版本:Firefox 92.0
@joyqi joyqi closed this as completed in 96eb56f Sep 8, 2021
@joyqi joyqi added the bug Something isn't working label Sep 8, 2021
@joyqi joyqi added this to the v1.2.0-beta.2 milestone Sep 10, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants