wiki.js

https://github.com/Requarks/wiki?tab=readme-ov-file

install

https://docs.requarks.io/install/docker

MySQL root@localhost:wiki> SHOW VARIABLES like "auto_increment%";
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| auto_increment_increment | 2     |
| auto_increment_offset    | 2     |
+--------------------------+-------+

auto_increment_offset ： AUTO_INCREMENT列值的起点，也就是初始值。取值范围是1 .. 65535

auto_increment_increment ： 控制列中的值的增量值，也就是步长。其默认值是1，取值范围是1 .. 65535

https://github.com/requarks/wiki/issues/1485

Incorrect groups auto-increment configuration! Should start at 0 and increment by 1. Contact your database administrator.

MySQL wikijs@localhost:wiki> truncate groups
You’re about to run a destructive command.
Do you want to proceed? (y/n): y
Your call!
(1701, ‘Cannot truncate a table referenced in a foreign key constraint (wiki.usergroups, CONSTRAINT usergroups_groupid_foreign)’)

#SET FOREIGN_KEY_CHECKS=0;

/etc/my.cnf 设置