Steps to replicate the issue (include links if applicable):
- Install Echo
- Attempt to run php maintenance/update.php
What happens?:
PostgreSQL does not support auto_increment and unsigned and the binary type.
update.php exits with an error. DBMS log:
[9-1] 2022-07-09 14:45:24.503 UTC [86338] azurlane_wiki: ERROR: syntax error at or near "unsigned" at character 147 [9-2] 2022-07-09 14:45:24.503 UTC [86338] azurlane_wiki: STATEMENT: CREATE /* Wikimedia\Rdbms\Database::sourceFile( -var-www-azurlane.koumakan.jp-w-extensions-Echo-echo.sql ) */ TABLE "echo_event" ( [9-3] event_id int unsigned not null primary key auto_increment, [9-4] event_type varchar(64) binary not null, [9-5] event_variant varchar(64) binary null, [9-6] event_agent_id int unsigned null, [9-7] event_agent_ip varchar(39) binary null, [9-8] event_extra BLOB NULL, [9-9] event_page_id int unsigned null, [9-10] event_deleted tinyint unsigned not null default 0 [9-11] ) /*$wgDBTableOptions*/
What should have happened instead?:
update.php should have finished successfully.
Software version (skip for WMF-hosted wikis like Wikipedia):
1.38.2, Extension:Echo from ExtensionDistributor (the upstream does not seem to have any changes related to this issue).
Other information (browser name/version, screenshots, etc.):
N/A