SQL 2012 patching failure – The language of SQL Server instance MSSQLSERVER does not match the language expected by the SQL Server update

I’ve picked up the support for a SQL 2012 instance on a server at our German site and need to apply SQLServer2012SP4-KB4018073-x64-ENU.

The patching is failing with the installer showing error "The language of SQL Server instance MSSQLSERVER does not match the language expected by the SQL Server update. The installed SQL Server product language is German (Germany) and the expected SQL Server language is English (United States)."

The server properties general tab (in SSMS) shows Language German (Germany), but the SERVERPOPERTY(‘LCID’) shows 1033 (US_English). The registry entry shows 1031 (German) as the install language (https://www.sqlserverscience.com/basics/localization/language-used-sql-server-binaries/#comment-191) enter image description here

Trying to use the German patch file SQLServer2012SP4-KB4018073-x64-DEU results in “This SQL Server setup media does not support the language of the OS, or does not have the SQL Server English-language version installation files. Use the matching language-specific SQL Server media; or install both the language specific MUI and change the format and system locales through the regional settings in the control panel”.

Any pointers as to a way forward so I can apply the patch?

ORA-00932: inconsistent datatypes: expected CHAR got NUMBER

I am trying to SUBSTR the first 3 character in use this query -> CASE WHEN (RMSTMP_PNG.ota_activity_lotinfo.KEY = ‘TestProgram’) THEN TO_CHAR(SUBSTR(RMSTMP_PNG.ota_activity_lotinfo.VALUE,1,3)) ELSE 0 END AS Test1 But it return me this ORA-00932: inconsistent datatypes: expected CHAR got NUMBER 00932. 00000 – "inconsistent datatypes: expected %s got %s". May i know what wrong in my query? I tried to use To_NUMBER or To CHAR, it also return me same error. Appreciate if someone could help on this issue. Below is my query:

SELECT RMSTMP_PNG.ota_activity.EQP_ID, SUM(CASE WHEN (RMSTMP_PNG.ota_activity.MESSAGE='Load lot success.' AND RMSTMP_PNG.ota_activity_lotinfo.KEY = 'Quantity') THEN 1 ELSE 0 END) AS LOT_ID, SUM(CASE WHEN (RMSTMP_PNG.ota_activity.MESSAGE='Load lot success.' AND RMSTMP_PNG.ota_activity_lotinfo.KEY = 'Quantity') THEN TO_NUMBER(RMSTMP_PNG.ota_activity_lotinfo.VALUE) ELSE 0 END) AS QUANTITY, CASE WHEN (RMSTMP_PNG.ota_activity_lotinfo.KEY = 'TestProgram') THEN TO_CHAR(SUBSTR(RMSTMP_PNG.ota_activity_lotinfo.VALUE,1,3)) ELSE 0 END AS Test1 FROM RMSTMP_PNG.ota_activity  FULL OUTER JOIN RMSTMP_PNG.ota_activity_lotinfo ON RMSTMP_PNG.ota_activity.ID = RMSTMP_PNG.ota_activity_lotinfo.ID  WHERE RMSTMP_PNG.ota_activity.MODIFIED_DATE >= to_date('27-Sep-2020') AND RMSTMP_PNG.ota_activity.MODIFIED_DATE < to_date('27-Sep-2020') + 1  group by RMSTMP_PNG.ota_activity.EQP_ID,RMSTMP_PNG.ota_activity_lotinfo.VALUE, RMSTMP_PNG.ota_activity_lotinfo.KEY order by RMSTMP_PNG.ota_activity.EQP_ID 

If has action not working as expected

I’m using ACF Blocks in a theme I’m building.

Here’s my block template file within /my-plugin/template-parts/blocks/page-intro/page-intro.php:

<?php /**  * Page Intro Block Template.  *  * @param   array $  block The block settings and attributes.  * @param   string $  content The block inner HTML (empty).  * @param   bool $  is_preview True during AJAX preview.  * @param   (int|string) $  post_id The post ID this block is saved to.  */ ?> <?php do_action('acf_add_class'); ?> <div class="page-intro-wrapper" style="background: url(<?php esc_url( the_field('background_image') ); ?> )">     <div class="page-intro">         <h2><?= esc_html( get_field('title') ); ?></h2>         <?= get_field('text'); ?>     </div> </div> 

You’ll see that I’ve added <?php do_action('acf_add_class'); ?> at the top.

I then have the following via my plugin:

/**  * Add custom classes to body  */ function body_classes( $  classes ) {          if ( has_action('acf_add_class') ) {         $  classes[] = 'page-intro';     }          return $  classes; } add_filter( 'body_class', 'body_classes' ); 

I was hoping that if ( has_action('acf_add_class') ) { would trigger the condition and add the class, but this hasn’t worked.

I’ve also tried this within the body_class filter:

if ( has_action('acf_add_class', get_queried_object_id() ) ) {     $  classes[] = 'page-intro'; } 

This question may be off-topic if the issue is ACF related.

Any ideas?

I am not getting output for the below batch file as expected [closed]

I wrote the below mentioned test batch file… But while executing it, when I give input as "How are you" then the file automatically gets terminated.

@echo off echo Hi! echo Happy to be at your service 🙂 :start set /a A = How are you set /p help="How may I help you? " if /i %help% EQU excel (start excel) else (if /i %help% EQU %A% (echo I am good! Thanks for asking)) goto start

But, if I write…

@echo off echo Hi Sir! echo Happy to be at your service 🙂 :start set /a A = How set /p help="How may I help you? " if /i %help% EQU excel (start excel) else (if /i %help% EQU How (echo I am good Sir! Thanks for asking)) goto start

and when I give input as "How"… I get the output as expected.

The output that I get at this case is…

Hi! Happy to be at your service 🙂 How may I help you? how I am good! Thanks for asking How may I help you?

Kindly help me in solving this issue.

Setuid on rcp not working as expected

While pentesting in a lab, came across an rcp binary with setuid bit which looked like a potential privilege escalation vector.

bash-3.1$   ls -l /usr/bin/rcp -rwsr-xr-x 1 root root 18544 May 18  2007 /usr/bin/rcp 

Following the explanation at https://securiteam.com/exploits/6b00l1p0bc/ , I tried the following:

bash-3.1$   /usr/bin/rcp 'bob bobalina;/usr/bin/id;' uid=48(apache) gid=48(apache) groups=48(apache) bash: command not found 

My understanding is that since rcp is setuid as root, any command executed by it must be run as root. Why am I then seeing the output of /usr/bin/id as apache, which is the user I am running as?

I’m not a great Linux guy so if I’m missing something obvious, please let me know.

I’ve also tried the command injection with backticks, got the same result:

bash-3.1$   /usr/bin/rcp ``bob bobalina;/usr/bin/id;`` uid=48(apache) gid=48(apache) groups=48(apache) bash: command not found 

Are the open ports 53,139,445 and 49152 expected on a Linux machine? [closed]

I ran an nmap stealth scan on my home network (using linux) and this is my result. I don’t know why netbios is open – I ran the samba command and it is not recognised, so I don’t think I have Samba on my machine. If someone could clarify that would be great. I am running Ubuntu Linux. I’ve also noticed a lot of TCP ESTABLISHED connections I don’t recognise. Is this something to investigate further?

Not shown: 993 closed ports PORT      STATE    SERVICE 22/tcp    filtered ssh 53/tcp    open     domain 80/tcp    open     http 139/tcp   open     netbios-ssn 443/tcp   open     https 445/tcp   open     microsoft-ds 49152/tcp open     unknown 

What to do if a player expected much more than DM gave?

I was not the DM in this session, it was my GF, but she does not speak English so I’m here to ask for all of us. We’ve faced an issue that seems we can’t solve.

It was our 2nd game, no one of us ever played before. We played Lost Mine of Phandelver and finally entered a room with a hostage in a cave. Goblins told that they don’t want to fight and proposed a negotiation. We had a jade statuette and one of the PCs told the goblins that we have it (The DM said before that because it cost a lot, the goblins greedily want it).

After that, the goblins asked 20 gold coins and the statuette in exchange for a hostage. Since they had an advantage (3 PCs vs 6 goblins) I told the other players that this is a good price, despite is having to give out almost all our gold, but my friend decided to intimidate them, roleplayed and rolled a natural 20. The DM said that the goblins seemed kinda worried, but since they had a huge advantage, they (only) reduced the price to just the statuette.

After that, my friend was visibly disappointed (and still is) almost to the point where he refuses to play anymore. We were tired at this point since it was our 6th hour or so, and I can understand his mood here.

When we discussed this situation after the game, he explained his point: he had rolled a 20 and this means (in his opinion) that goblins shod have released the hostage without demanding any price because it was a 20. I tried to explain to him that it is up to DM to decide the consequences of any actions players do, and in this situation, the DM decided not to give us more. But the player still thinks that the DM was not right in this situation and a 20 is a 20 and he is ready to even have arguments for this game situation. I tried to convince him that the goblins had a huge advantage here and it was not possible that they give us the hostage without any price, but it seems impossible to convince him. He is negative because of the fact that the DM is the final judge and it is the DM’s responsibility to decide what happens next.

We’ve tried to find some solution on what to do in situations like this and did not come to anything.

What can we do?

At what point is a Lifedrinker Warlock’s expected damage reduced by Sharpshooter/GWM?

At Level 12, a Pact of the Blade Warlock can take the Lifedrinker Eldritch Invocation, which states the following:

When you hit a creature with your pact weapon, the creature takes extra necrotic damage equal to your Charisma modifier (minimum 1).

Assuming a Hexblade Warlock with a 20 in Charisma, this translates to 10 bonus damage per attack. This enormous bonus means that every missed attack results in a significant reduction in damage.

The Sharpshooter and Great Weapon Master feats grant options of the following pattern:

Before you make [an attack] with [a weapon] with which you are proficient, you can choose to take a -5 penalty to the attack roll. If you do so and the attack hits, it deals +10 damage.

At what point is the Warlock’s expected damage per attack reduced by using the optional attack modifier of either the Sharpshooter or Great Weapon Master feat?

Assume a Hexblade, Pact of the Blade Warlock with the following characteristics:

  • At least 12th level
  • Lifedrinker Eldritch Invocation
  • 20 in Charisma
  • Using a pact weapon, either:
    • A longbow
    • A greatsword
  • … with the respective weapon feat:
    • Sharpshooter
    • Great Weapon Master

With the following variables:

  • Enemy AC
  • Attack roll and damage roll bonuses (due to spells, proficiency bonus, magic weapons, etc.)

Why does Avatar Mask not work as expected?

I have 2 layers: The base layer, and an upper body layer. On the upper body layer, I have an avatar mask because I only want to affect the upper body. However, this mask doesn’t work as expected.

Here is what it looks like:

enter image description here

This is what is looks like when the upper body layer has a weight of 0:

enter image description here

And this is with the upper body layer with a weight of 1 and with the Avatar Mask:

enter image description here

As one can see, the lower body is affected. The avatar mask doesn’t seem to have an effect. Is that a bug in Unity, or is there anything I could still check?

Thank you!