Page MenuHomePhabricator

Dgessel (david gessel)
User

Projects

User does not belong to any projects.

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Thursday

  • Clear sailing ahead.

User Details

User Since
Jul 1 2015, 7:58 AM (458 w, 6 d)
Availability
Available
LDAP User
Unknown
MediaWiki User
DGessel [ Global Accounts ]

Recent Activity

Feb 20 2019

Dgessel added a comment to T215169: Database::update() with IGNORE option fails on PostgreSQL (MW-1.32 migration error).

Oh true, but it was only with the 1.30->1.32 update that it got flagged. There have been quite a few updates since 2011. For me it is happily solved and the wiki back.

Feb 20 2019, 5:37 PM · MW-1.32-notes, MW-1.31-release-notes, Platform Team Workboards (Done with CPT), MW-1.33-notes (1.33.0-wmf.19; 2019-02-26), Patch-For-Review, MW-1.33-release, MW-1.32-release, MW-1.31-release, MediaWiki-libs-Rdbms, PostgreSQL
Dgessel added a comment to T215169: Database::update() with IGNORE option fails on PostgreSQL (MW-1.32 migration error).

Yes, thank you, editing the two awstats external links in the db to remove the forward slashes (and the previous UPDATE fix) permitted a successful update to 1.32. :)

Feb 20 2019, 5:06 PM · MW-1.32-notes, MW-1.31-release-notes, Platform Team Workboards (Done with CPT), MW-1.33-notes (1.33.0-wmf.19; 2019-02-26), Patch-For-Review, MW-1.33-release, MW-1.32-release, MW-1.31-release, MediaWiki-libs-Rdbms, PostgreSQL
Dgessel added a comment to T215169: Database::update() with IGNORE option fails on PostgreSQL (MW-1.32 migration error).

It appears awstats uses backslashes as delimiters? I'm not entirely sure.

Feb 20 2019, 4:44 PM · MW-1.32-notes, MW-1.31-release-notes, Platform Team Workboards (Done with CPT), MW-1.33-notes (1.33.0-wmf.19; 2019-02-26), Patch-For-Review, MW-1.33-release, MW-1.32-release, MW-1.31-release, MediaWiki-libs-Rdbms, PostgreSQL
Dgessel added a comment to T215169: Database::update() with IGNORE option fails on PostgreSQL (MW-1.32 migration error).

Thank you for the quick response. The trailing comma was at fault. I edited that out and ran into a different error and in my uncertainty, returned it and tried it again. My bad. The diff as provided by @9st is the correct syntax. However, after running php update I got the error that incorrectly convinced me the comma might be needed:

Feb 20 2019, 11:23 AM · MW-1.32-notes, MW-1.31-release-notes, Platform Team Workboards (Done with CPT), MW-1.33-notes (1.33.0-wmf.19; 2019-02-26), Patch-For-Review, MW-1.33-release, MW-1.32-release, MW-1.31-release, MediaWiki-libs-Rdbms, PostgreSQL
Dgessel added a comment to T215169: Database::update() with IGNORE option fails on PostgreSQL (MW-1.32 migration error).

@jcrespo thanks for this but when I made the change suggested to line 76 and ran, I got the following error:

Feb 20 2019, 10:48 AM · MW-1.32-notes, MW-1.31-release-notes, Platform Team Workboards (Done with CPT), MW-1.33-notes (1.33.0-wmf.19; 2019-02-26), Patch-For-Review, MW-1.33-release, MW-1.32-release, MW-1.31-release, MediaWiki-libs-Rdbms, PostgreSQL

Feb 16 2019

Dgessel added a comment to T215731: Postgres doesn't support UPDATE IGNORE.

My wiki is down pending this fix, I'm happy to test any patches or to provide any other assistance.

Feb 16 2019, 1:48 PM · MW-1.31-release, MW-1.33-release, MW-1.32-release, MediaWiki-libs-Rdbms, PostgreSQL

Jul 1 2015

Dgessel created T104426: Blank Screen for MW 1.23/1.25 on FreeBSD 10.1 due to timeout of MWCryptRand.php mcrypt_create_iv.
Jul 1 2015, 8:11 AM · MediaWiki-General