I want to use a MariaDB 10.5 database for dokuwiki as explained on the site: https://www.dokuwiki.org/plugin:authpdo#example_database
If I created my database and want to create the tables I got the following errors:
Static analysis:
7 errors were found during analysis.
This option conflicts with "TABLE". (near "user" at position 13)
The name of the entity was expected. (near "(" at position 18)
A symbol name was expected! (near ""id"" at position 25)
At least one column definition was expected. (near ""id"" at position 25)
Unexpected beginning of statement. (near "''" at position 147)
Unexpected beginning of statement. (near ""mail"" at position 157)
Unrecognized statement type. (near "NOT NULL" at position 164)
SQL query:
CREATE TABLE user ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "login" UNIQUE NOT NULL, "pass" NOT NULL, "name" NOT NULL DEFAULT (''), "mail" NOT NULL DEFAULT ('') )
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"login" UNIQUE NOT NULL,
"p...' at line 2
Any idea?
I also think there's an error in the section "Option 'check-pass'", because the code is for md5 instead of verify, but I'm not sure.