[08:43:54] <Fabien81>	 Hello, I need help for some API functionality. Who can help me?
[18:40:08] <Fabien27>	 I need help to find the API that would match my need. Someone can help me?
[18:42:16] <Fabien27>	 I would like to do that : https://i.stack.imgur.com/IQIzk.png
[18:43:27] <Vulpix>	 Fabien27: https://www.mediawiki.org/wiki/API:Search ?
[18:44:04] <Vulpix>	 For simple autocompletion, this may be better: https://www.mediawiki.org/wiki/API:Prefixsearch
[18:46:01] <Fabien27>	 Vulpix With the "Search API" only it's possible to get a user's search from wikipedia.org to my website ? (the user is in the wikipedia.org url in his browser)
[18:47:38] <Fabien27>	 I know it exists because a magic app (available from Apple Store) does it.
[18:56:52] <Fabien27>	 I want to do that : https://stackoverflow.com/questions/64107962/retrieve-wikipedia-search-for-a-remote-user
[20:24:29] <CanuteTh->	 hey all. I am trying to upgrade from 1.34.4 to 1.35.0 and when running update.php I encounter this error: 'Error 23505: ERROR:  could not create unique index "redirect_pkey"'. db backend is postgresql. any ideas?
[20:30:18] <Reedy>	 https://github.com/wikimedia/mediawiki/commit/9d67de01cb374aa3df80c0154c19268c62b34925
[20:30:50] <CanuteTh->	 thank you!
[20:30:59] <Reedy>	 That's the offending ocmmit
[20:31:07] <Reedy>	 Why can't it create it/
[20:31:12] <Reedy>	 It already exists? Wrong permissions?
[20:36:12] <CanuteTh->	 already exists: "DETAIL:  Key (rd_from)=(26) is duplicated."
[20:37:56] <Reedy>	 Is there a chance you've added it manually before?
[20:38:42] <Reedy>	 Cause that line hasn't changed in many years...
[20:38:42] <Reedy>	 https://github.com/wikimedia/mediawiki/commit/7e84b58dab26987bcb1d4b1bb85207a8d1ce3f71
[20:38:48] <Reedy>	 https://github.com/wikimedia/mediawiki/commit/4539958087dcd428b720c9d1583d2943dcefb8e2#diff-b725dd0e8f9c83b4077b14ea230ef9c8R156
[20:41:53] <CanuteTh->	 no. I have not messed with anything todo with the wiki db at all
[20:42:22] <CanuteTh->	 I didn't encounter any problems going from the 1.34.0 point releases up to 1.34.4
[20:42:46] <Reedy>	 We don't tend to do schema changes in point releases
[20:43:41] <CanuteTh->	 ah. nvm
[20:43:45] <Reedy>	 Are you able to do whatever is the PG equivalent of `SHOW CREATE TABLE redirect;`?
[20:43:47] <Reedy>	 Go on?
[20:44:20] <CanuteTh->	 nvm on the point releases. didn't know what changes those included.
[20:44:34] <CanuteTh->	 I can try
[20:45:05] <Reedy>	 I'm wondering if PG has created an implicit PK.. And the name isn't what MW is trying to create, so the index exists call doesn't work quite as expected
[21:19:58] <CanuteTh->	 I think figured out the pg closest equivalent of 'show create table' is. where do you want me to send the output (it is several lines)?
[21:21:56] <Reedy>	 a pastebin type site would be perfect
[21:25:51] <CanuteTh->	 https://pastebin.com/2HUPx2YU
[21:43:41] <Reedy>	 My PG isn't good enough to necessarily work out if any of that results in a proper PK
[21:58:44] <Reedy>	 CanuteTheGreat: Do you have an account on phabricator
[21:59:32] <Reedy>	 I'd suggest you're probably best reporting it there... And in the meantime, edit includes/installer/PostgresUpdater.php to comment out [ 'addIndex', 'redirect', 'redirect_pkey', 'patch-redirect-pk.sql' ],
[21:59:36] <Reedy>	 And then hope for the best..
[22:08:44] <CanuteTheGreat>	 I don't believe I have an account. will look into it. I'll comment out that line and cross my fingers!
[22:15:59] <CanuteTheGreat>	 rest of the update process finished with that line commented out
[22:17:18] <Reedy>	 Well, that's good :)
[22:30:03] <CanuteTheGreat>	 alrighty, I reported it: https://phabricator.wikimedia.org/T264141
[22:32:16] <Reedy>	 thanks
[22:32:44] <CanuteTheGreat>	 thanks for fixing the report :)