Extension talk:ArticleFeedbackv5

• Extension talk:ArticleFeedbackv5/Flow

Compatiblity to postgresql

Hello,

Is ther any chance to have postgresql database update compatibilty?

Regards! Willyedoo (talk) 14:33, 22 January 2025 (UTC)

@Willyedoo: I did some work on that back in originally way back in 2020. The current iteration of the patch is from September 2023 but it should still apply fairly cleanly: https://gerrit.wikimedia.org/r/565391

As for why I didn't merge it back in the day...some tests were failing, due to what seemed like an off-by-one (or was it off-by-two?) error. It was very weird and in my rather limited testing, I didn't notice any adverse effects, but I also didn't want to risk actually introducing potential showstopper bugs for PostgreSQL users, hence why the patch got shelved basically.

You're free to test out the patch (at your own risk) and see how it goes. If you decide to do so, please report back with your findings! --Jack Phoenix _(Contact) 11:22, 7 July 2025 (UTC)

Hello @Jack Phoenix,

Using the patch worked to install an use the specials pages associated.

Mediawiki 1.43

Postgresql 15

Still have to test using forms on pages. This is on hold for now on my test.

Full feedback ASAP.

Thanks! Willyedoo (talk) 13:47, 24 September 2025 (UTC)

Hello, this is the error now!

Wikimedia\Rdbms\DBQueryError from line 1198 of /var/www/html/includes/libs/rdbms/database/Database.php: Error 22008: ERROR: date/time field value out of range: "20251023145450"

LINE 1: ... WHERE (aft_archive = 0) AND (aft_archive_date <= '202510231...

^

HINT: Perhaps you need a different "datestyle" setting.

Function: DataModelBackendLBFactory::getList

Query: SELECT *,aft_timestamp AS "offset_value" FROM "aft_feedback" WHERE (aft_archive = 0) AND (aft_archive_date <= '20251023145450') ORDER BY aft_timestamp ASC,aft_id ASC LIMIT 50

1. 0 /var/www/html/includes/libs/rdbms/database/Database.php(1182): Wikimedia\Rdbms\Database->getQueryException()
2. 1 /var/www/html/includes/libs/rdbms/database/Database.php(1156): Wikimedia\Rdbms\Database->getQueryExceptionAndLog()
3. 2 /var/www/html/includes/libs/rdbms/database/Database.php(647): Wikimedia\Rdbms\Database->reportQueryError()
4. 3 /var/www/html/includes/libs/rdbms/database/Database.php(1345): Wikimedia\Rdbms\Database->query()
5. 4 /var/www/html/includes/libs/rdbms/database/DBConnRef.php(127): Wikimedia\Rdbms\Database->select()
6. 5 /var/www/html/includes/libs/rdbms/database/DBConnRef.php(351): Wikimedia\Rdbms\DBConnRef->__call()
7. 6 /var/www/html/extensions/ArticleFeedbackv5/data/DataModelBackend.LBFactory.php(227): Wikimedia\Rdbms\DBConnRef->select()
8. 7 /var/www/html/extensions/ArticleFeedbackv5/maintenance/setArchiveDate.php(73): DataModelBackendLBFactory->getList()
9. 8 /var/www/html/maintenance/includes/LoggedUpdateMaintenance.php(51): ArticleFeedbackv5_SetArchiveDate->doDBUpdates()
10. 9 /var/www/html/maintenance/update.php(207): MediaWiki\Maintenance\LoggedUpdateMaintenance->execute()
11. 10 /var/www/html/maintenance/includes/MaintenanceRunner.php(703): UpdateMediaWiki->execute()
12. 11 /var/www/html/maintenance/doMaintenance.php(100): MediaWiki\Maintenance\MaintenanceRunner->run()
13. 12 /var/www/html/maintenance/update.php(308): require_once('...')
14. 13 {main} Willyedoo (talk) 15:05, 23 October 2025 (UTC)