Random Tech (or IT Work!) Fail

[Ratatapa]

I am out of office. For all inquiries, please contact XXX at [email protected] or (XXX) XXX-XXXX.

I guess it<s just me who feel important to inform the customer

[Hellfury]

What Zetanio said pretty much, though I would add the duration of absence, why you are away is none of anyone except your boss' business.

And while vacation might be a harmless thing, what about the day you're away on something more serious?

[Zetanio]

What Zetanio said pretty much, though I would add the duration of absence, why you are away is none of anyone except your boss' business.

And while vacation might be a harmless thing, what about the day you're away on something more serious?

Couldn't agree more. I never put up the duration though. If they really need to get to me, they call the other person and they'll have the information for how long I'm out of office.

[Hellfury]

Guess it depends a little on the role, it would be very impractical in my case, since a lot of people would have reasonable interest in the duration of my absence so they'd know when to get back to me, and the "contact this person" in my case would be my direct boss, the the VP and I'm pretty sure she wouldn't be happy having to deal with that xD

[Zetanio]

Oh, I always go a level down. One of our newer data guys would get to cover my emails.

[Corrderio]

EDIT: Didn't see new page.

Anyway. Looking into this database more and oh how I wish I could set it on fire. 5 tables without a PK constraint....

[Ragns]

Anyway. Looking into this database more and oh how I wish I could set it on fire. 5 tables without a PK constraint....

I wish I worked with databases only that bad in the past 10 years but I guess that's what you get when you hire javascript devs to make your initial database design.

[Corrderio]

I'm still amazed a primary key constraint is an alien concept l. You'd think that would be like database 101

[Ragns]

I'm still amazed a primary key constraint is an alien concept l. You'd think that would be like database 101

I have to train people that only got formations from Hax0r Bullshit Bootcamps and all of them so far never touched SQL at all. FML.

[Corrderio]

Well I suppose I shouldn't be surprised. I had someone try to debug a stored proc once by running it instead of looking what it did.

[djzombie]

I have to train people that only got formations from Hax0r Bullshit Bootcamps and all of them so far never touched SQL at all. FML.

That sucks dude, SQL is easy, I learned it for fun when I was running an Arma 2 multiplayer server that I heavily modded myself.

The SQL server was used to track everything, players, vehicles, inventory of those entities, location of objects placed on the server (based building objects people placed to create their base).

The player ID was always the primary key for any table regarding players, location, inventories. It is the one constant unique identifier.

It's fairly simple. Hire me and let me work remote

[Hellfury]

I'm still amazed a primary key constraint is an alien concept l. You'd think that would be like database 101

I haven't even looked at anything more than an SQL database error message since high school, Primary Key Constraint = just a requirement of an unique primary key?

[Corrderio]

I haven't even looked at anything more than an SQL database error message since high school, Primary Key Constraint = just a requirement of an unique primary key?

It means the value must be unique and increments itself (First insert = 1, second = 2, snd so on.)

The way they have these tables set up is the ID column with a not null and unique constraint which boggles my mind. Not only that but the IDs are inconsistent between each environment.

[djzombie]

I haven't even looked at anything more than an SQL database error message since high school, Primary Key Constraint = just a requirement of an unique primary key?

Yea its basically a unique identifier that remains constant throughout different tables in the database.

For instance, in reference to Arma 2, the player ID was the primary key and used in every table that involved a player entity. So the player ID was the same in the table that held the players location, and the table that held their inventory, and anything else that needed to be attached to a player entity to exist.

It's just a way of having a consistent identifier for the same asset across multiple tables in the database.

[Melena]

Dumb question looking for opinion

When you guys place and Out of office, do you inform the reason of your absence and if you still have access to emails/cell during the time the person is away?

There's war going here that the boss just wnat an OOF to be

Hi i'm away returning this date pleae contact this person

While I want to use something like

Hi i'm currently on vacation and will return this date, please note that I will have no access to cell/emails during this time, for any Inquiries please contact this person

Mine is typically I'm out starting X date, returning Y date. During this time I will have limited e-mail access and no voicemail access. If you are in need of IT help, e-mail the helpdesk at Y. Otherwise I will respond to your e-mail upon my return.

[Corrderio]

So we've recently been converting our C# Libraries over to NuGet packages and one thing that keeps biting us is assembly binding redirects.

Does anyone know of any tools to scan for potential binding redirects or is full blown regression testing the only way to find these kind of exceptions?

[Mabubeezareel]

Yea its basically a unique identifier that remains constant throughout different tables in the database.

For instance, in reference to Arma 2, the player ID was the primary key and used in every table that involved a player entity. So the player ID was the same in the table that held the players location, and the table that held their inventory, and anything else that needed to be attached to a player entity to exist.

It's just a way of having a consistent identifier for the same asset across multiple tables in the database.

Doesn't using a PK constraint also come with other benefits too, like automatically creating an index on that column? That might depend on the database being used, but I think that's the case with Oracle, which is all I've ever used.

[Yuri-G]

project won't compile. html module causing issue even though it compiled previously and all I did was change the source code and I never use the html module.


ok, fine, remove html module. project won't compile because gradle is bitching that the html module is gone.


ok, fine. remove html module instructions from gradle build file. project won't compile because main class is now no longer recognized.


ok, fine. uninstall project, uninstall intellij, reinstall project and start from scratch on Eclipse.


I just love how 95% of the work in coding is getting the damned environment set up correctly, and every google search result has a different solution, none of which ever line up with what your particular setup looks like. at least I'm learning a shitton though; I never knew how to edit gradle builds directly or how to select different Android SDKs/build tools based on the gradle build, etc. so I'm trying to keep that in mind and have a positive outlook haha


gonna try and run the project again tonight; pray for me. if it works correctly I ain't touching shit until I'm ready to deploy (which will be a whole other layer of hell, but I'm ok with that. I just want to code/test/build for now).

[Corrderio]

Dumbfuck coworker (same one I've bitched about before) comes to me with an issue thinking the problem is we have no entries to process today which is why the application kept sleeping until it timed out/failed on us. They got the stored proc correct but according to them "when they ran it" nothing came up. For reference the stored proc was a simple "SELECT * FROM" for a table with the following critera:

-Date of transfer must be today
-Status of transfer must be unprocessed
-Transfer must be either set to not require approval or requires approval and has been marked as being approved.

Anyone with a sliver of common sense and IT knowledge can probably already see why nothing was being returned in that stored proc. But not this idiot. Guess it didn't click in their mind that maybe, just maybe, there's transfers out there which need to be approved first?

Also this was one of the very first things I taught them how to identify and fix...

[Ratatapa]

Random fail is for me again, because I feel this is so basic but I can't understand what is wrong

I have 1 user (JUST 1) with this problem.

So that user uses these devices for mails

1 Laptop windows 10 with Office 2016
1 Iphone with Mail for his Office account
1 Ipad with Mail for his Office account

It doesn't always happen but it happens often

When he has a Calender event he will exemple write it like this

Step 1) Go to work
Step 2) Go home

Then he click save

When he goes back in the event it's writtent like this

Step 1) Go to workStep 2) Go home

So we add a line break after the K from work and save the changes

But it goes back to no line break

Anyone knows why?