The Official Status Thread
-
@hungrier said in The Official Status Thread:
@tsaukpaetra Right, but I still found the least hair-pulling-maddening way to do that was to use a code-first model (auto-generated from DB; IIRC Visual Studio has that tool)
Reminds me about an EF question I saw today on MSDN forum.
The asker need to use EF to support multiple type of database, and one of them is SQLite. As you may know already, SQLite don't have datetime type. Do you know that in the case of "code first", which of the three candidate datatypes will it choose to store datetime data?
-
Status: If I've got a shell script, and it is slow, how many problems do I have?
-
@pleegwat said in The Official Status Thread:
Status: If I've got a shell script, and it is slow, how many problems do I have?
One. Because you're going to rewrite it anyway. :P
P.S.: Finding out what causing the script be slow always cause me to think I'm playing Where's Willy?
P.P.S.: WTF the link to Wikipedia points to something else and there's no disambiguate link.
-
@tsaukpaetra said in The Official Status Thread:
Like, you can take the initial model from the database, but once you switch to code first a lot of crap goes and says "hey if you touch me things will break! Stay away!" especially if the model doesn't match 100 percent to the database.
I forget what exact sequence of trickery it took to do it with our project, but we ended up with a working code-first model where we could change stuff in a sensible way, without any of the tools complaining.
drop-and-recreate default mode of code-first migrations
If you mean the way it would try to nuke the db whenever it found something out-of-sync between it and the code, you can tell it not to do that. The "drawback" (add arbitrary numbers of airquotes as needed) is that it would never try to auto-create the database from the code.
views
work just fine
stored procedures
-
@cheong said in The Official Status Thread:
@pleegwat said in The Official Status Thread:
Status: If I've got a shell script, and it is slow, how many problems do I have?
One. Because you're going to rewrite it anyway. :P
Ideally, I'd rewrite it into non-existence, since I really don't want code in that glue layer to begin with. But that's probably going to happen around the time hell freezes over.
-
@cheong said in The Official Status Thread:
@hungrier said in The Official Status Thread:
@tsaukpaetra Right, but I still found the least hair-pulling-maddening way to do that was to use a code-first model (auto-generated from DB; IIRC Visual Studio has that tool)
Reminds me about an EF question I saw today on MSDN forum.
The asker need to use EF to support multiple type of database, and one of them is SQLite. As you may know already, SQLite don't have datetime type. Do you know that in the case of "code first", which of the three candidate datatypes will it choose to store datetime data?
NVarchar(max)?
-
Status: Reading iBatis documentation. Please kill me.
iBatis
-
@hungrier said in The Official Status Thread:
@tsaukpaetra said in The Official Status Thread:
stored procedures
Basically it's not really supported at all, and if you mean views are supported "just fine" in code first:
You're basically writing the view SQL by hand anyways, I just don't see the benefit really...
-
@tsaukpaetra said in The Official Status Thread:
You're basically writing the view SQL by hand anyways
Well yeah, you do that, add
create view v_whatever as
before it, and you have your view. After that you can map it to an entity just like any table.
-
@hungrier said in The Official Status Thread:
@tsaukpaetra said in The Official Status Thread:
You're basically writing the view SQL by hand anyways
Well yeah, you do that, add
create view v_whatever as
before it, and you have your view. After that you can map it to an entity just like any table.Yes, but you don't do that for tables is my point. You just write the class and magic happens.
-
Status: 500 OK
-
@tsaukpaetra said in The Official Status Thread:
@hungrier said in The Official Status Thread:
@tsaukpaetra said in The Official Status Thread:
You're basically writing the view SQL by hand anyways
Well yeah, you do that, add
create view v_whatever as
before it, and you have your view. After that you can map it to an entity just like any table.Yes, but you don't do that for tables is my point. You just write the class and magic happens.
I thought your whole point was that you wanted to manage the database schema yourself, and didn't want EF to fiddle with/ruin it?
-
@hungrier said in The Official Status Thread:
@ben_lubar said in The Official Status Thread:
@tsaukpaetra said in The Official Status Thread:
@ben_lubar said in The Official Status Thread:
Status: In XCOM 2, I finished the lead-up to the final mission. I carefully pick my squad, then watch the dramatic cutscene in which spoiler redacted, and then...
Yay Unreal!
Although, what they're calling and why... Got any logs from the crash handler?
XCOM 2 has a pretty obnoxious crash handler, but I was feeling generous and let them upload a zip file containing this stuff:
Do you think they'll still care about bug reports in 50000 years when that file finishes uploading on your internet connection?
Fun fact: XCOM 2 takes place 20 years after XCOM: Enemy Unknown, which started in spring 2015.
At some point between Spring 2015 and 2035, something crazy happened that allowed the aliens to completely win their war against the Earth. I wonder what that could have been.
-
Status: Yesterday, the new character they've been teasing came out for Vindictus. The UI and performance have improved a lot too. Good character so far, but not my favorite most likely. But Path of Exile is TOMORROW!
-
@ben_lubar said in The Official Status Thread:
At some point between Spring 2015 and 2035, something crazy happened that allowed the aliens to completely win their war against the Earth. I wonder what that could have been.
Millennials took power
-
@cheong said in The Official Status Thread:
There ought to be a file with extension .tt in your project in the same folder with the .edmx file, that EF designer use it as template to generate the entity classes. By adding "partial" keyword there, you enable them to be used as partial classes so you can extend them with custom properties and methods that you use to manipulate/interpret data on the entity class..
(You don't have to add the "partial" keyword to the autogenerated classes. Everything autogenerated in C# is already a partial class. You just need to create a new class file to hold your code. Then the problem becomes: what to name it!)
-
@hungrier You be crazy. Database-first is the only way to get a correct DB. The ones EF generates are shit.
-
@ben_lubar said in The Official Status Thread:
At some point between Spring 2015 and 2035, something crazy happened that allowed the aliens to completely win their war against the Earth. I wonder what that could have been.
Maybe the canonical ending of XCOM: Enemy Unknown is that the player loses. Or, more likely, that they throw the controller down pissed off at the shitty RNG and broken-ass camera (probably while trying to aim a grenade toss.)
-
@blakeyrat said in The Official Status Thread:
@ben_lubar said in The Official Status Thread:
At some point between Spring 2015 and 2035, something crazy happened that allowed the aliens to completely win their war against the Earth. I wonder what that could have been.
Maybe the canonical ending of XCOM: Enemy Unknown is that the player loses. Or, more likely, that they throw the controller down pissed off at the shitty RNG and broken-ass camera (probably while trying to aim a grenade toss.)
I see your problem. PC master race forever! <kidding, sort of, well, not really>
-
@benjamin-hall said in The Official Status Thread:
I see your problem. PC master race forever! <kidding, sort of, well, not really>
Yeah I tried the keyboard/mouse controls, the camera was still shit and aiming grenades anywhere remotely close to their max throw range would cause it to spaz all around like a weasel on speed.
-
@blakeyrat said in The Official Status Thread:
@ben_lubar said in The Official Status Thread:
At some point between Spring 2015 and 2035, something crazy happened that allowed the aliens to completely win their war against the Earth. I wonder what that could have been.
Maybe the canonical ending of XCOM: Enemy Unknown is that the player loses. Or, more likely, that they throw the controller down pissed off at the shitty RNG and broken-ass camera (probably while trying to aim a grenade toss.)
The canonical ending is that you lost XCOM: Enemy Unknown.
Tutorial spoilers
The tutorial consists of Bradford (green shirt guy from XCOM: Enemy Unknown) grabbing your body from an alien facility in some giant padded suit and narrowly escaping with you, then Tygan discovering that there was a chip in your head that had something to do with simulating wars for the aliens.
That means that either you were captured when you canonically lost XCOM: Enemy Unknown, or that you were captured immediately and the entire first game was a brain chip-induced dream where you were simulating fights for the aliens so that they could win the war.
-
@ben_lubar said in The Official Status Thread:
The canonical ending is that you lost XCOM: Enemy Unknown.
Then why did you post here so surprised about the 20-- you know what never mind. Fuck it.
-
@hungrier said in The Official Status Thread:
@tsaukpaetra said in The Official Status Thread:
@hungrier said in The Official Status Thread:
@tsaukpaetra said in The Official Status Thread:
You're basically writing the view SQL by hand anyways
Well yeah, you do that, add
create view v_whatever as
before it, and you have your view. After that you can map it to an entity just like any table.Yes, but you don't do that for tables is my point. You just write the class and magic happens.
I thought your whole point was that you wanted to manage the database schema yourself, and didn't want EF to fiddle with/ruin it?
Yes, that's why I do database first, but the supposition was that with code-first, I wouldn't be having the issue in the first place because my class could have unmapped properties or something if I made them partial.
-
@blakeyrat said in The Official Status Thread:
@hungrier You be crazy. Database-first is the only way to get a correct DB. The ones EF generates are shit.
Right, but for reasons I don't remember, we found that EF's idea of database-first didn't work for us, which is why we went with code-first generated from existing database.
-
@hungrier said in The Official Status Thread:
which is why we went with code-first generated from existing database.
Oh that's actually what I do, I'm just using the wrong words for it I guess.
-
Status: Oh damn, Ctrl-B doesn't work no more...
In other news,
Assertion failed: MaxShift && (uint64(PAK_CACHE_GRANULARITY) << (MaxShift + 1)) == 0 && (uint64(PAK_CACHE_GRANULARITY) << MaxShift) != 0 [File:C:\UE4\Engine\Source\Runtime\PakFile\Private\IPlatformFilePak.cpp] [Line: 936]
Of course, you can't tell me what part of that failed, just that one of them did. Now to read through 50+ lines of dense undocumented code to try and figure out what that means, since Google doesn't have a clue what PAK_CACHE_GRANULARITY is, and the only one (1!) other user that seemed to have this problem was Chinese and didn't share whatever they did to fix it...
-
-
@blakeyrat said in The Official Status Thread:
@ben_lubar said in The Official Status Thread:
At some point between Spring 2015 and 2035, something crazy happened that allowed the aliens to completely win their war against the Earth. I wonder what that could have been.
Maybe the canonical ending of XCOM: Enemy Unknown is that the player loses. Or, more likely, that they throw the controller down pissed off at the shitty RNG and broken-ass camera (probably while trying to aim a grenade toss.)
This is exactly it. XCOM 2's story is that the "canonical" ending of XCOM EU/EW was that of most players' attempts at an Impossible-difficulty Ironman run (i.e. you lose, hardcore, and the aliens swooped in and took over with very little resistance)
-
@blakeyrat said in The Official Status Thread:
I like this speech a lot!
Do you have stairs in your house?
Suddenly I have this strange impulsion to shove around blind people......
-
@e4tmyl33t Meanwhile, those of us who learned at the altar of Beaglerush are marginalized to mere fantasy.
(Learned so much from watching that dude play I went from getting my ass handed to be on nerf mode to eventually running out of steam playing Long War Ironman Impossible. Until that point, I didn't really get why people enjoyed watching other people play games)
-
-
@tsaukpaetra said in The Official Status Thread:
In other news,
Assertion failed: MaxShift && (uint64(PAK_CACHE_GRANULARITY) << (MaxShift + 1)) == 0 && (uint64(PAK_CACHE_GRANULARITY) << MaxShift) != 0 [File:C:\UE4\Engine\Source\Runtime\PakFile\Private\IPlatformFilePak.cpp] [Line: 936]
Of course, you can't tell me what part of that failed, just that one of them did. Now to read through 50+ lines of dense undocumented code to try and figure out what that means, since Google doesn't have a clue what PAK_CACHE_GRANULARITY is, and the only one (1!) other user that seemed to have this problem was Chinese and didn't share whatever they did to fix it...
Added in a few debugging lines:
The packchunk110 that's failing is 11Kb. Apparently the PAK_CACHE_GRANULARITY (which is set to 64Kb) is the minimum file size?
Because, once I eliminated this check, it loads just fine.
My question: If the file is small enough to fit entirely in cache, why not just assume it's fine to do so and move on?
Ugh.
-
Microsoft Quality 2017 Edition.
This now happens to me multiple times a day:
Severity Code Description Project File Line Suppression State Error Unable to copy file "C:\Users\xxx\Documents\Development\xxx\xxx\packages\Microsoft.Net.Compilers.2.1.0\tools\System.Collections.Immutable.dll" to "bin\roslyn\System.Collections.Immutable.dll". Access to the path 'bin\roslyn\System.Collections.Immutable.dll' is denied.
-
@blakeyrat Oh well obviously my problem is the file is open in
I hate when files are open in
-
Status: Fuck you too, Windows.
I didn't make any significant changes to this VM, could you tell me a bit more than "Buy me again!"
Also, the stupid automated system told me to save the confirmation number in case I needed to enter it again. Guess what?
You know, I'm going to leave this one unactivated and see just how many Wiruses and Hackers get on this machine.
Fun fact: Running the Activation Troubleshooter:
Apparently I have a digital license. Or something. But I need to install Windows 10 Pro to use it.
Edit: Oh, now that the troubleshooter ran, it now says this:
So, what, should I delete the product key then? Goddam....
-
@blakeyrat Open in ? Perhaps it accidentally the file?
-
@tsaukpaetra said in The Official Status Thread:
@cheong said in The Official Status Thread:
@hungrier said in The Official Status Thread:
@tsaukpaetra Right, but I still found the least hair-pulling-maddening way to do that was to use a code-first model (auto-generated from DB; IIRC Visual Studio has that tool)
Reminds me about an EF question I saw today on MSDN forum.
The asker need to use EF to support multiple type of database, and one of them is SQLite. As you may know already, SQLite don't have datetime type. Do you know that in the case of "code first", which of the three candidate datatypes will it choose to store datetime data?
NVarchar(max)?
SQLite has Text only, no nvarchar type. :P
Although it's text is more like NText as it stores string in (UTF-8, UTF-16BE or UTF-16LE) depending on the database's encoding selected.
-
Status: Time to finally learn what the fuck a JDBC is and how to use one.
-
@blakeyrat said in The Official Status Thread:
@cheong said in The Official Status Thread:
There ought to be a file with extension .tt in your project in the same folder with the .edmx file, that EF designer use it as template to generate the entity classes. By adding "partial" keyword there, you enable them to be used as partial classes so you can extend them with custom properties and methods that you use to manipulate/interpret data on the entity class..
(You don't have to add the "partial" keyword to the autogenerated classes. Everything autogenerated in C# is already a partial class. You just need to create a new class file to hold your code. Then the problem becomes: what to name it!)
I prefer to name the folder instead (if the original .edmx file is in model\database1 folder, I'll place my classes to add additional properties to model\database1.aux folder on the same level to make sure I get a good view of what custom classes I've added)
Also, make sure you add XML comments to any of the properties / methods you added so you can distinguish them from the automatically generated ones..
-
@ben_lubar said in The Official Status Thread:
@tsaukpaetra said in The Official Status Thread:
@ben_lubar said in The Official Status Thread:
@tsaukpaetra said in The Official Status Thread:
@ben_lubar said in The Official Status Thread:
Status: In XCOM 2, I finished the lead-up to the final mission. I carefully pick my squad, then watch the dramatic cutscene in which spoiler redacted, and then...
Yay Unreal!
Although, what they're calling and why... Got any logs from the crash handler?
XCOM 2 has a pretty obnoxious crash handler, but I was feeling generous and let them upload a zip file containing this stuff:
What's the tail 50 lines (or so) of that Logfile.log ? For the curious. Wanna make sure whatever they're doing we're not doing.
I'll try to remember to post it tomorrow, but I'll have to
<details>
it since it contains a bunch of internal names for a spoiler character.Entity name spoilers
Or maybe further up:
</deails>
-
@anotherusername said in The Official Status Thread:
@dreikin said in The Official Status Thread:
@dreikin said in The Official Status Thread:
Status:
Tomorrow we get —
@anonymous234 said in The Official Status Thread:
Status: new connection
Woo! Symmetry!Uh, that! Upgrading from 2.6 Mbps DSL to 50 Mbps (750GB cap) cable.
Status: Fuck. God fucking dammit. Installer showed up but my grandfather sent him away because he didn't want the guy to loose lay the cable across the driveway until it was buried later. Didn't even bother to call or let me know, nor even make any real attempt at finding an alternative (like going through the waterways? under the driveway). Got home expecting faster internet, instead had to renegotiate and reschedule everything.
Ten more fucking days, because now I have to be home to deal with it.
I've been trying to get this for over a year now, and he's lecturing me about patience because I don't really want to have to wait another month if I don't have to.
Be grateful that he isn't lecturing you on how long it took to download his emails via the Pony Express.
Dial-up was mentioned.
-
@heterodox said in The Official Status Thread:
@heterodox said in The Official Status Thread:
Haven't figured out how to get it to go the fuck away yet.
You fucking can't. There's no option to.
Fuck this bullshit. I'm going to have to fucking install a custom launcher now. What the fuck is Google's problem. I now agree with all of @blakeyrat's complaints about Android, retroactively and in perpetuity.
Sounds like my next device is definitely going to be a Note. Hopefully they don't all catch on fire this time.
-
@ben_lubar Unfortunately, looks like it didn't make it into the log. It should have said something to the effect of:
[2017.12.07-17.42.46:423][ 0]PacketHandlerLog: Loaded PacketHandler component: Engine.EngineHandlerComponentFactory (StatelessConnectHandlerComponent) [2017.12.07-17.42.46:425][ 0]LogNet: GameNetDriver IpNetDriver_0 IpNetDriver listening on port 7782 [2017.12.07-17.42.46:495][ 0]LogWindows: Windows GetLastError: The operation completed successfully. (0) [2017.12.07-17.42.59:034][ 0]LogWindows:Warning: CreateProc failed (2) ../../../Engine/Binaries/Win64/CrashReportClient.exe "D:/Shared/NightlyBuild/WindowsServer/Hypatia/Saved/Crashes/UE4CC-Windows-E1E62E534020CDEB6A24F98EF40EBE9C_0000" -Unattended -nullrhi -AppName=UE4-Hypatia -CrashGUID=UE4CC-Windows-E1E62E534020CDEB6A24F98EF40EBE9C_0000 -DebugSymbols=..\..\..\Engine\Intermediate\Symbols [2017.12.07-17.42.59:039][ 0]LogWindows:Error: === Critical error: === [2017.12.07-17.42.59:040][ 0]LogWindows:Error: [2017.12.07-17.42.59:040][ 0]LogWindows:Error: Assertion failed: MaxShift && (uint64(PAK_CACHE_GRANULARITY) << (MaxShift + 1)) == 0 && (uint64(PAK_CACHE_GRANULARITY) << MaxShift) != 0 [File:C:\UE4\Engine\Source\Runtime\PakFile\Private\IPlatformFilePak.cpp] [Line: 936] [2017.12.07-17.42.59:040][ 0]LogWindows:Error: [2017.12.07-17.42.59:044][ 0]LogWindows:Error: [2017.12.07-17.42.59:046][ 0]LogWindows:Error: [2017.12.07-17.42.59:048][ 0]LogWindows:Error: KERNELBASE.dll!0x000000003D213FB8 [2017.12.07-17.42.59:052][ 0]LogWindows:Error: HypatiaServer.exe!FOutputDeviceWindowsError::Serialize() [c:\ue4\engine\source\runtime\core\private\windows\windowsplatformoutputdevices.cpp:120] [2017.12.07-17.42.59:055][ 0]LogWindows:Error: HypatiaServer.exe!FOutputDevice::Logf__VA() [c:\ue4\engine\source\runtime\core\private\misc\outputdevice.cpp:70] [2017.12.07-17.42.59:056][ 0]LogWindows:Error: HypatiaServer.exe!FDebug::AssertFailed() [c:\ue4\engine\source\runtime\core\private\misc\assertionmacros.cpp:349] [2017.12.07-17.42.59:059][ 0]LogWindows:Error: HypatiaServer.exe!FPakPrecacher::FPakData::FPakData() [c:\ue4\engine\source\runtime\pakfile\private\iplatformfilepak.cpp:938] [2017.12.07-17.42.59:062][ 0]LogWindows:Error: HypatiaServer.exe!FPakPrecacher::RegisterPakFile() [c:\ue4\engine\source\runtime\pakfile\private\iplatformfilepak.cpp:1058]
Oh well.
-
@dreikin The Android 8.1.0 update also fucking trashed my Bluetooth quality to the point of it being unusable. This is just the gift that keeps on giving.
-
@dreikin said in The Official Status Thread:
@anotherusername said in The Official Status Thread:
@dreikin said in The Official Status Thread:
@dreikin said in The Official Status Thread:
Status:
Tomorrow we get —
@anonymous234 said in The Official Status Thread:
Status: new connection
Woo! Symmetry!Uh, that! Upgrading from 2.6 Mbps DSL to 50 Mbps (750GB cap) cable.
Status: Fuck. God fucking dammit. Installer showed up but my grandfather sent him away because he didn't want the guy to loose lay the cable across the driveway until it was buried later. Didn't even bother to call or let me know, nor even make any real attempt at finding an alternative (like going through the waterways? under the driveway). Got home expecting faster internet, instead had to renegotiate and reschedule everything.
Ten more fucking days, because now I have to be home to deal with it.
I've been trying to get this for over a year now, and he's lecturing me about patience because I don't really want to have to wait another month if I don't have to.
Be grateful that he isn't lecturing you on how long it took to download his emails via the Pony Express.
Dial-up was mentioned.
Pish posh. I am old enough to remember dial-up.
-
@atazhaia said in The Official Status Thread:
@hardwaregeek said in The Official Status Thread:
@atazhaia said in The Official Status Thread:
the connecting wires to the lamp was bare because the old tape they had used as insulator had crumbled away. May need to apply new tape there.
As an electrical engineer, may I suggest the proposed solution is ... less than ideal.
As someone with training in electrical installations and safety I agree. However, the wiring in the house overall is both old and with ugly monkey patches that wouldn't be allowed under current law and is one of the higher priority targets for total replacement to modern wiring and sockets, therefore calling in an electrician to just fix that one socket feels like a bit of overkill.
There is no overkill. There is underkill, however, and that would be a great example of it.
-
@cheong said in The Official Status Thread:
@hungrier said in The Official Status Thread:
@tsaukpaetra Right, but I still found the least hair-pulling-maddening way to do that was to use a code-first model (auto-generated from DB; IIRC Visual Studio has that tool)
Reminds me about an EF question I saw today on MSDN forum.
The asker need to use EF to support multiple type of database, and one of them is SQLite. As you may know already, SQLite don't have datetime type. Do you know that in the case of "code first", which of the three candidate datatypes will it choose to store datetime data?
Oh look, all three of my worst choice options.
-
@jazzyjosh said in The Official Status Thread:
Status: Reading iBatis documentation. Please kill me.
iBatis
Better or worse than MasterBatis?
-
@anotherusername said in The Official Status Thread:
@dreikin said in The Official Status Thread:
@anotherusername said in The Official Status Thread:
@dreikin said in The Official Status Thread:
@dreikin said in The Official Status Thread:
Status:
Tomorrow we get —
@anonymous234 said in The Official Status Thread:
Status: new connection
Woo! Symmetry!Uh, that! Upgrading from 2.6 Mbps DSL to 50 Mbps (750GB cap) cable.
Status: Fuck. God fucking dammit. Installer showed up but my grandfather sent him away because he didn't want the guy to loose lay the cable across the driveway until it was buried later. Didn't even bother to call or let me know, nor even make any real attempt at finding an alternative (like going through the waterways? under the driveway). Got home expecting faster internet, instead had to renegotiate and reschedule everything.
Ten more fucking days, because now I have to be home to deal with it.
I've been trying to get this for over a year now, and he's lecturing me about patience because I don't really want to have to wait another month if I don't have to.
Be grateful that he isn't lecturing you on how long it took to download his emails via the Pony Express.
Dial-up was mentioned.
Pish posh. I am old enough to remember dial-up.
So am I. Doesn't mean I want to be reminded of it.
-
@dreikin don't tell me you don't have fond nostalgia whenever you hear the dialup connection sound...