Topic on Project:Support desk

Justman10000 (talkcontribs)

With the extension DataDump this error appears at php maintenance/update.php:

Creating data_dump table...Wikimedia\Rdbms\DBQueryError from line 1606 of /home/web/mediawiki/includes/libs/rdbms/database/Database.php: Error 42601: ERROR:  syntax error at or near "`" LINE 2:  `dumps_completed` INT(1) NOT NULL,

Malyacko (talkcontribs)
Justman10000 (talkcontribs)

Hmm, it seems like DataDump is designed for MySQL/MariaDB only! Here the file that causes the error...

Justman10000 (talkcontribs)

I have now transferred everything from MySQL to PostgreSQL using SQLines! Except for this content:

ALTER TABLE /*$wgDBprefix*/data_dump MODIFY COLUMN dumps_size BIGINT unsigned NOT NULL DEFAULT 0;

SQLines doesn't do anything about it, and PostgreSQL doesn't accept it either

Justman10000 (talkcontribs)
Reply to "SQL Error"