讓花成花 讓我成我

从Hugo换到了Typecho

Hugo更新与维护还是不太方便,最终还是换到了Typecho

使用PostgreSQL,
然后更换主题出现了问题:Database Query Error

ERROR:  syntax error at or near "`"
LINE 1: ALTER TABLE `typecho_contents` ADD `views` INT(10) DEFAULT 0...
                    ^
Typecho\Db\Adapter\SQLException: ERROR:  syntax error at or near "`"
LINE 1: ALTER TABLE `typecho_contents` ADD `views` INT(10) DEFAULT 0...
                    ^ in /opt/var/Typecho/Db/Adapter/Pgsql.php:88
Stack trace:
#0 /opt/var/Typecho/Db.php(391): Typecho\Db\Adapter\Pgsql->query()
#1 /opt/usr/themes/matcha/libs/Matcha.php(353): Typecho\Db->query()
#2 /opt/usr/themes/matcha/includes/posts.php(16): Matcha::views()
#3 /opt/var/Widget/Archive.php(1336): require('/opt/usr/...')
#4 /opt/usr/themes/matcha/includes/main.php(35): Widget\Archive->need()
#5 /opt/var/Widget/Archive.php(1336): require('/opt/usr/...')
#6 /opt/usr/themes/matcha/index.php(13): Widget\Archive->need()
#7 /opt/var/Widget/Archive.php(1418): require_once('/opt/usr/...')
#8 /opt/var/Typecho/Router.php(99): Widget\Archive->render()
#9 /opt/index.php(23): Typecho\Router::dispatch()
#10 {main}

大概是postgresql版本的问题?我的版本是12的。我最后是换成sqlite解决掉了。

从Hugo换到了Typecho

https://llb.im/posts/1.html

作者

Qin

发布时间

2023-07-22

许可协议

CC BY 4.0

添加新评论 取消回复