I forgot to mention this is in SQL Server, so SIN operates on radians. So I THINK this can only ever cast to a 0 when clientId
is also 0
It certainly doesn’t for any of the 100,000 existing rows
I forgot to mention this is in SQL Server, so SIN operates on radians. So I THINK this can only ever cast to a 0 when clientId
is also 0
It certainly doesn’t for any of the 100,000 existing rows
The client
table has around 100,000 rows each with a unique clientId
, none of which are returned from the CAST / ABS / SIN
I think you are right and this is a ‘fix’ for something lost to time. I am going to talk to the original dev tomorrow to see if they remember what it was for
Thank you so much, I’ll check it out!
Absolutely, it’s a great read. Could you link the video you watched?
0589 6066 6425
I would love to give gifts to anyone here
I am from Australia, and I travel between Queensland and South Australia regularly
I think it is a bug and here’s why
I have setup a lemmy instance to understand how it works and hopefully contribute something meaningful
My instance has 2 users, both are subscribed to the same cross-instance community, but only one is showing Subscribe Pending
even if I un-sub and re-sub
I am not aware of any approval system to subscribe to a community, so I believe the approval was received the community instance, but the “accept” response data was missed / dropped when returning to your host instance
Let me make sure I understand first
i added my private key, and tried to connect
This concerns me, as the server should have the user’s public key, not private. Private should be exactly that, private
Is the Powershell user / SSH key the same as the Putty user / SSH key that still works?
When you run the Powershell script, does it give any error messages?
I know with Linux -> Linux SSH you can log verbosely with -v
, is that something you can do under Powershell?
Is password auth enabled? Does that still work from Putty, and can you do the same from Powershell?
On the website, or on an app?
I have posted half a dozen things from the Jerboa app and not encountered this
Also working for me. Lot of 1 stars!
Not specific to AI, some of the people I work with make me prone to drinking as well
The trick I use is to double-search for it
On your instance, search for the full URL of the original community, then search again for just the community name
So for you:
https://lemmy.world/c/sql
sql
It is not ideal, but it has worked on my instance every time
So far really good! It has some quirks, and there are some bugs and some teething issue with the large influx of people (specifically on lemmy.ml)
It is a mind-set change working with a different system and the whole instance
idea is still very new for me
As an Australian, it was very quiet last night (10ish hours ago), but that will improve as more people join
And this leads to another question, how can I browses communities on other instances with my already existing account? What about platforms such as mastodon where I’m supposed to be able to browse and submit and such?
I would recommend this
I have also found some interesting communities on !newcommunities@lemmy.world
I would love to get suggestions for Japanese resources / apps
I have done a month of Duolingo and I am sick of hearing Ken ask for sushi every lesson!
What about if I want to link to a post that will work for the local instance?
For example, @huojtkeg@lemmy.world posted above that https://lemmy.world/post/58535 is his instance link, and https://lemmy.ml/post/1205894 is the link from lemmy.ml. Neither of which allow me to comment directly.
Is there linking method that says Give me the link for post #X on instance Y, but give me the link on the viewing instance
?
so if the operator of rambo goes “man fuck this” and shuts it down, the posts/comments are gone? there’s no way to replicate them or sync them or whatever?
My understanding is that if a user on a different instance is subscribed, then that second instance will keep copies of previous post / comments.
But there also appears to be a download limit, so over time the non-original instances will lose those copies.
It’s a strange new world over here!
Oh yes, you are right! Specifically All
doesn’t work.
I have found a bug report listed for it, and it should be fixed in the next release - 0.18.
Update: The original dev does not remember exactly. However they have said that
clientId
was originally a VARCHAR, so this may have been checking for both'0'
or''
So an over-engineered workaround to a bad datatype perhaps?