November 2022 - ozdotnet - codify.mailman3.com

Visual Studio 2022 cannot add existing project
by Greg Keogh Nov. 26, 2022

Nov. 26, 2022

Folks, I've had an intermittent problem in previous weeks where adding an existing csproj to a solution produces the message box: *The operation could not be completed.* It was occasional, but today I'm getting the error everywhere. I've made empty solutions, added A to B and B to A, deleted all the .vs .user and binary outputs (some searches suggest that), but absolutely nothing works. Web searches produce no modern useful results. I'm basically dead in the water. Has anyone else had this and solved it? I'm even running a repair now, which is pretty desperate (and slow). I know it won't work, but I do it anyway, which is a standard 21st century software development procedure. *Greg Keogh*

1 1

[OT] Finding duplicate rows in Sql Server
by Tom P Nov. 17, 2022

Nov. 17, 2022

Apologies if this is basic for probably most of you but I just can't get my head around it. I have a flat table in sql server which contains lots of duplicates, differing only by one column. Id,Name,Desc,Date,Etc 1,abc,abc abc,2022-11-17,a 2,abc,abc abc,2022-11-17,a 5,def,def def,2022-11-17,a 4,abc,abc abc,2022-11-17,a 3,def,def def,2022-11-17,a 6,xyz,def def,2022-11-17,a I'm trying to write a query that finds all duplicates *excluding the ones with the highest Id*. So for the above example it would return the following: Id,Name,Desc,Date,Etc 1,abc,abc abc,2022-11-17,a 2,abc,abc abc,2022-11-17,a 3,def,def def,2022-11-17,a There are many millions of rows to process so looking for something efficient. Any advice would be appreciated. Regards Tom

4 4

Visual Studio 17.4.0 side effects
by Greg Keogh Nov. 11, 2022

Nov. 11, 2022

Folks, I accepted the major update yesterday, and this morning some odd things are happening. I noticed that .NET SDK 6 was gone and 7 was installed. I had to manually reinstall SDK 6 to get going again (this didn't happen to a colleague). A WebApi project produced a huge slab of NU1106 compile errors. I removed every reference of every type and it made no difference. After 2 hours I discovered that if I removed one of my own rather innocuous project references then it all came good. That reference has been there for the last 6 months. Now all of my existing Blazor projects stall and produce something like this: Failed to launch debug adapter. Additional information may be available in the output window. Unable to launch browser: "Could not open ws://localhost:56709/_framework/debug/ws-proxy?browser=wsAFF127.0.0.1A59317FdevtoolsFbrowserF4fe90d5b-f3d4-4f84-950c-2cc9af15b95c" The program '' has exited with code 4294967295 (0xffffffff). I've now spent 2 hours on this, and it's not looking helpful. A brand new app runs okay. I've run out of ideas. I started work at 06:30 but I haven't done any real work yet. *Greg Keogh*

4 12

Fwd: Fw: [Announcements] Mailman3.com servers upgrade
by David Connors Nov. 8, 2022

Nov. 8, 2022

FYI. ------------------------------ *From:* New IT via Announcements <announcements(a)mailman3.com> *Sent:* Tuesday, 8 November 2022 6:25 PM *To:* announcements(a)mailman3.com <announcements(a)mailman3.com> *Subject:* [Announcements] Mailman3.com servers upgrade Dear Mailman3.com users! In the last few days, all the servers have been upgraded to the latest code. The upgrade is aligned with the latest releases of the Mailman 3 components, see https://docs.mailman3.org/projects/mailman/en/latest/src/mailman/docs/NEWS.… https://docs.mailman3.org/projects/postorius/en/latest/news.html https://docs.mailman3.org/projects/hyperkitty/en/latest/news.html If you experience glitches in the Postorius/Hyperkitty UI, please perform a hard refresh of the page in your browser. Danil Smirnov New IT

1 0