Sitegrounds Pushing Trouble

Hey all,

Me and the company I'm working for has run into a bit of a predicament when it comes to pushing one particular website. We've given a client of ours access to the staging site so they can add events and content and push without me or my boss needing to intervene when they need a push. However, there's been an issue as of lately that prevents any kind of push from succeeding.

A month ago our client came to us to report an issue with the pushing functionality. What had appeared to…

Sitegrounds Pushing Trouble

Trouble with Cloudwatch Event Targeting SSM Automation

I want to be able to shut down any ec2 instances with a certain tag, triggered by a scheduled cloudwatch event. However, when i choose SSM Automation as a target and choose the StopEC2Instance Document, it requires me to give individual instance IDs. Because the instance ids are likely to change over time, I want to instead target all instances with a specific tag so it is more flexible.

What is more frustrating is that I can execute the StopEC2Instance Automation Document directly from the Systems Manager console, and when I do it from there I have the option to select “rate control” instead of the default execution. With the rate control option I can do exactly what I need, target instance Ids of either a specific resource group or tag and manually hit the execute buttom. Everything works perfectly but it has to be done manually.

I need Cloudwatch to trigger the SSM Automation but not require me to name specific intance IDs. Any suggestions on joining these 2 requirements?

For the sake of this question let’s assume I can’t involve Lambda in anyway (even though I know that would solve the issue).

Can a Fake business card save me of trouble in Morocco?

I Will be traveling to Morocco in May, and I have being reading a lot about being harassed, scamed by locals and maybe even police.

I know of a friend who runs a very successful business and when visiting morocco he got into trouble with the police and got out of it handing them his business cards and telling them he had connections that could get them in trouble.

My question is: How legit is this? I’m very tempted to do some business cards with a fake e-mail and phone number and telling them I work for an important company or maybe even pretend I’m a diplomat some made up international association from the EU(I’m a EU citizen), because I’m very frightened by this sort of encouters and scams.

Can I get in trouble for this? If I happen to come up with some international organization and claim I work for them to scare them?

I hope you understand my question, Thank you

Trouble understanding proof regarding elements of an integral domain which are not product of irreductible elements.

I’m having trouble understanding the proof of a proposition regarding elements which are not product of irreductible elements in integral domains. The proposition is the following:

Let $ A$ be an integral domain and $ a\in A$ different of 0 and not a unit. If $ a$ is not product of irreductible elements then there exists a sequence $ \{a_n\}_{n\in N}$ of elements of $ A$ such that $ a_{n+1}$ is a proper divisor of $ a_n$ for every natural $ n$ .

The proof that has been given to me is this:

Let’s build inductively a sequence with this property. Let $ a_0 = a$ and suppose $ a_0,\dots,a_n$ , $ n\geq0$ are already built. Since $ a_n$ is not product of irreductibles it must be composite, this $ a_n = bc$ with $ b,c$ proper divisors of $ a_n$ . Clearly at least one of the two factors must not be product of irreductibles. We define $ a_{n+1}$ as this factor.

The problem I have understanding this proof is that I don’t get why not being product of irreductibles implies it is composite. Wouldn’t such elements be irreductibles itself? I mean if it is composite, couldn’t we keep decomposing its factors until all of them are irreductible?

Thanks for your help.

I’m having trouble getting sharp pictures while shooting a concert from a press pass location

I am a bit of a noob when it comes to photography. But I recently got the opportunity to shoot John Mayer this past weekend in Wisconsin. Upon getting home, I noticed the pictures weren’t as sharp as they could have been, and saw that almost all of them had a slight blur to them.

Me being new to the photography world, it is quite overwhelming jumping into such a huge act like John Mayer. I took some advice from a Nat Cam employee on how to shoot.

He told me to shoot in Aperture Priority mode. Keep my lens wide open at 2.8, (lens I’m using is a Tamron 17-50mm (no stabilizing feature) on my Nikon D5100). I stuck to shooting from an ISO of 800-1600 most of the show. Exposure meter was at 0.0 the whole time.

I’ll attach some pictures.

But I do need some help badly, as I am shooting John Mayer again next week, and I really dont want to mess thing up this time. Because all of my pics so far aren’t really useable.

I stopped back into Nat Cam yesterday to see if they could explain the problem. The guy there thought it was the “focusing points” that were focusing on random things in the background, speakers, mic stand, etc and that I should change it from auto area AF to Dynamic area so that I can put one focus point on his face so the focus point doesn’t get distracted with anything else. He also told me to bump up my ISO to 3200 because the “D5100 can handle it”. Lastly he said I should keep it on center weighted metering as I have it.

Do you all think that could be the problem? Or is it something else?

I can use all the help I can get, I just don’t want to blow my shots again next week.

Thank you all who respond!

Having trouble with contrast ratios [migrated]

I’ve been doing some work on trying to figure out some color themes for light and dark modes for a UI (aren’t we all these days?). Basically, given a particular light theme how might we determine the “equivalent” dark theme? After a couple of experiments/prototypes I started to use contrast ratios between colors to calculate the dark version of the UI. For one version, the hypothesis was that if the contrast ratios were the same between two colors across light and dark themes, they would be just as easy to distinguish in either mode. I think I’m learning that is not the case…because of how math works. I was hoping someone here might have some insight on this. I’ve been scratching my head on it for a while.

In the image below I have two sets of colors (light set and a dark set). The contrast ratio for the two sets are both 1.48. I would think that if two sets of colors had the same contrast ratio they would also appear to have a similar difference between the background and foreground of each set.

Note: Given a contrast ratio of 1.48, I know that these particular colors shouldn’t be for text but this is just an example to illustrate a problem.

enter image description here

However, in the image above the light set of colors seem much easier to distinguish than the dark set. I know this is a bit subjective and can depend on a number of factors (my monitor, calibration, ambient lighting, how good my eyes are, etc..) but I was thinking that a similar contrast ratio would appear to have a more similar difference.

It starts to make sense as I consider how math works, though. Darker colors at a given contrast ratio are going to be closer together in terms of relative luminance as opposed to lighter colors.

In contrast (no pun intended), if I consider colors that have the same difference in relative luminance as opposed to ratio I end up with colors that look more similar (to me)…but still not right.


All in all, I’m struggling to figure out if there is a way to calculate a dark theme based on a given light theme.

  • Should I be basing it on something other than relative luminance and their difference/contrast ratio?
  • Am I misusing contrast ratio in this case as it is typically (but not exclusively) targeted at text on background scenarios?
  • Am I just crazy and the images above that use contrast ratios do, indeed, seem similar?
  • Have I overthought all of this and there is a much simpler solution to create an “equivalent” dark theme from a given light theme? Equivalent, in this case, means that all elements of the UI are just as distinguishable and legible across both themes.

Thanks for your time.

Oracle to Postgres Conversion trouble shooting

Converted a Standalone Procedure from Oracle to Postgres but not sure why there is an run error even the code is successfully compiled

Converted the below code from Oracle to Postgres

CREATE OR REPLACE FUNCTION ssp2_pcat.pop_hoa_contracts_for_prod( ) RETURNS void LANGUAGE 'plpgsql'  COST 100 VOLATILE  AS $  BODY$    DECLARE  C1 CURSOR for SELECT MARKET_CODE, CONTRACT_COMBO_ID, COUNT(*) FROM  ssp2_pcat.VPF_HOA_CONTRACTS_FOR_PROD A WHERE start_Date IN   (SELECT MAX(start_date)   FROM VPF_HOA_CONTRACTS_FOR_PROD b   WHERE A.MARKET_CODE     = b.MARKET_CODE   AND A.CONTRACT_COMBO_ID = b.CONTRACT_COMBO_ID   AND A.CONTRACT_ID       = B.CONTRACT_ID   AND b.start_date       <= current_date   AND b.end_date          > current_date )   GROUP BY MARKET_CODE, CONTRACT_COMBO_ID    ORDER BY MARKET_CODE, CONTRACT_COMBO_ID;   C2 CURSOR(iMktCode VARCHAR, iCombo integer) for SELECT MARKET_CODE, CONTRACT_COMBO_ID, CONTRACT_ID  FROM ssp2_pcat.VPF_HOA_CONTRACTS_FOR_PROD A WHERE start_Date IN   (SELECT MAX(start_date)   FROM ssp2_pcat.VPF_HOA_CONTRACTS_FOR_PROD b   WHERE A.MARKET_CODE     = b.MARKET_CODE   AND A.CONTRACT_COMBO_ID = b.CONTRACT_COMBO_ID   AND A.CONTRACT_ID       = B.CONTRACT_ID   AND b.start_date       <= current_date   AND b.end_date          > current_date  )   AND MARKET_CODE       = iMktCode   AND CONTRACT_COMBO_ID = iCombo   ORDER BY MARKET_CODE, CONTRACT_COMBO_ID, START_DATE; Contracts     VARCHAR(32000); Contract_Val1 VARCHAR(4000) := NULL; Contract_Val2 VARCHAR(4000) := NULL; Contract_Val3 VARCHAR(4000) := NULL; Contract_Val4 VARCHAR(4000) := NULL; Contract_Val5 VARCHAR(4000) := NULL; Contract_Val6 VARCHAR(4000) := NULL; Contract_Val7 VARCHAR(4000) := NULL; Contract_Val8 VARCHAR(4000) := NULL; Num           INTEGER; Cont_Num      INTEGER; l_start TIMESTAMP :=  clock_timestamp(); l_end TIMESTAMP :=  clock_timestamp(); Time_Taken    VARCHAR(20);                     i record;                     j record;  BEGIN l_start  :=  clock_timestamp(); DELETE FROM ssp2_pcat.HOA_CONTRACTS_KH;   FOR i IN C1 LOOP   BEGIN  Num       := 0;   Contracts := NULL;   Cont_Num  := 1;          FOR j IN C2 (i.MARKET_CODE, i.CONTRACT_COMBO_ID) LOOP      Num         := Num + 1;     IF Num       = 1 THEN       Contracts := '|' || j.CONTRACT_ID || '|';     ELSE       IF LENGTH(Contracts || j.CONTRACT_ID || '|') > 4000 THEN  PERFORM ssp2_pcat.Assign (Cont_Num, SUBSTRING(Contracts, 1,   LENGTH(Contracts)-1));         Num       := 1;         Contracts := '|' || j.CONTRACT_ID || '|';         Cont_Num  := Cont_Num + 1;       ELSE         Contracts := Contracts || j.CONTRACT_ID || '|';       END IF;     END IF;   END LOOP;                           PERFORM ssp2_pcat.Assign (Cont_Num, Contracts);   IF Cont_Num > 5 THEN     raise notice'%', ('MARKET_CODE: ' || i.MARKET_CODE || ', CONTRACT_COMBO_ID: ' || i.CONTRACT_COMBO_ID || ' has more than 32K in size. These Contracts are left out: ' || Contracts);   END IF;   INSERT INTO HOA_CONTRACTS_KH     (       MARKET_CODE,       CONTRACT_COMBO_ID,       CONTRACT_ID,       CONTRACT_ID2,       CONTRACT_ID3,       CONTRACT_ID4,       CONTRACT_ID5,       LAST_UPDATED     )     VALUES     (       i.MARKET_CODE,       i.CONTRACT_COMBO_ID,       Contract_Val1,       Contract_Val2,       Contract_Val3,       Contract_Val4,       Contract_Val5,       CURRENT_TIMESTAMP::TIMESTAMP(0)     );   Contract_Val1 := NULL;   Contract_Val2 := NULL;   Contract_Val3 := NULL;   Contract_Val4 := NULL;   Contract_Val5 := NULL;   Contract_Val6 := NULL;   Contract_Val7 := NULL;   Contract_Val8 := NULL;  EXCEPTION WHEN OTHERS THEN   ROLLBACK;   raise notice'%', ('1) POP_HOA_CONTRACTS_FOR_PROD: ' || SQLERRM);  END; END LOOP;            RAISE NOTICE 'Function excution time Took: %', l_start; RAISE NOTICE 'Function excution time Took: %',l_end-l_start; SELECT l_end-l_start INTO Time_Taken; raise notice'%',('POP_HOA_CONTRACTS_FOR_PROD Took: ' || Time_Taken ); EXCEPTION  WHEN OTHERS THEN  raise notice'%', ('2) POP_HOA_CONTRACTS_FOR_PROD: ' || SQLERRM);  END; $  BODY$  ; 

The code is compiled successfully, but giving a run time error as follows,

NOTICE: 2) POP_HOA_CONTRACTS_FOR_PROD: cannot begin/end transactions in PL/pgSQL

Debugged the whole code and looks like still I’m unable to identify the issue, can any one help me in making me understand more about Postgres as I’m new to this Database. Found out in unit testing that its not calling the assign function mentioned in the code,

Having trouble uninstalling software with msiexec quietly

I want to use msiexec to uninstall some programs without going through confimation boxes.

the problem is when I use this command

msiexec.exe /x "{product id}" /quiet 

then nothing happens and the program does not uninstall.

when I use

msiexec.exe /x "{product id}" /passive 

I see the progress bar appears and disappears quickly but the program does not actually uninstall.