I can’t record clean clear audio on my PC with my microphone

I’m using a Shure SM58 on my PC via an XLR Female to 3.5mm Jack Cable. The issue is whenever I listen back to a recording I hear a buzzing static like sound. I’m new to recording audio and I haven’t been able to find a solution for this yet. Any ideas as to how I can solve this issue and pick up clean audio?

smtp – SPF record when outgoing mail server is on the same IP as the web server

We have been happily using Zoho as an email provider for years, but recently we noticed we we’re getting a lot of emails being bounced as “blocked” at our client’s ends.
After investigating it seem that a bank of Zoho’s outgoing mail servers have been blacklisted as they had been “associated with a spam campaign”.

We have contacted our clients and they are liaising with their mail providers to have this reversed, but we know this could take a while. We have been asked, therefore, by our department head, to see if we can setup our own SMTP server for outgoing mail to get back up and running quickly.

I’ve got this set up and working, save for the SPF record. Emails are getting through currently but flagged as emails are coming from our domain example.com rather than a Zoho address.

The SPF record for example.com is currently: v=spf1 include:zoho.eu ~all

I have tried adding example.com as a second include: v=spf1 include:example.com include:zoho.eu ~all, but this is creating a recursive loop (example.com goes to example.com goes to example.com etc, etc).

How do I correctly format the SPF record to allow emails sent from our own SMTP server to pass validation?

mysql – Query record when N values of a column are present

This is the 4th question I’ve ran across in a month about querying parents (facility_name) for containing, at least, a specific sub-set of tags ( Week ).

For reference, Here is one of the posts on DBA SE with my answer.

The solution:

  1. Find all the required matches
  2. ensure that you have the correct cardinality.

This question required COUNT(distinct) instead of COUNT(*) (as shown in the other post).

Your schema was simple enough to put into DB Fiddle to validate.

Schema (MySQL v8.0)

create table source_table ( Facility_name varchar(1), product_id varchar(2), `Week` int);

insert into source_table values
 ('A', 'A1', 1),
 ('A', 'A1', 1),
 ('A', 'A2', 2),
 ('A', 'A3', 3),
 ('B', 'B1', 1),
 ('B', 'B2', 2),
 ('C', 'B3', 3),
 ('C', 'C1', 1),
 ('D', 'D1', 2);

Query #1

with query_these_weeks as (
  select 1 as `Week` union all
  select 2 as `Week` union all
  select 3 as `Week`
)
select Facility_name
from source_table as a
  join query_these_weeks as b on a.`Week` = b.`Week`
group by Facility_name
having count(distinct a.`Week`) = (select count(*) from query_these_weeks);
| Facility_name |
| ------------- |
| A             |

View on DB Fiddle

camera settings – “Record location data” gets switched off sometimes, why?

I want to record GPS coordinates for all of the pictures I take with my Nikon D5300.

Unfortunately, from time to time, after coming back from a photographing expedition, I realize that none of the pictures of the last few days have location information. Looking at the camera’s settings, I see that “Record location data” is set to “Off”, even though I am 100% sure I never switched it off.

When that happens, I cry for a few minutes then switch it back on, and hope it will last a bit longer.

I could check the setting every morning, but that would take time and I would rather avoid loosing a day’s worth of location data.

Question: Why does “Record location data” gets switched off?
If it is when a particular event happens, or after a certain number of days, I can try to mitigate the problem.

Note:

  • I removed the battery for a night to charge it, and upon putting the battery back into the camera, “Record location data” was still on, so it is probably not the reason.

mysql – Ensure integrity of other columns from foreign record

I have 3 tables:

Race
 - id PK

Racer
 - id PK
 - rank

Winner
 - id PK
 - race_id FK(Race.id)
 - racer_id FK(Racer.id)
 - rank
 - prize
 UNIQUE CONSTRAINT (race_id, rank)

Racer.rank is a non-unique values, as some players can tie to a rank. I try to have records in Winner to have its rank match the Racer.rank that it references to. The unique constraint is to ensure that each race has only one 1st place.

The integrity between Winner.rank and Racer.rank is to enforcing if we later update Racer.rank, we will have to update the value in Winner as well, or remove that Winner row. How can I enforce that matching?

Other separate question:
– Is there a keyword that describe what I try to accomplish? I try to search with “referential integrity”, “foreign constraint non-unique”… but none gets me to satified result.

Canon EOS M100 won’t record videos

I was using my Canon EOS M100 in recording a video. It suddenly stopped recording without me pressing the red record button. When I tried to record again, it creates a continuous beeping sound and it won’t record anything anymore. I tried checking the memory card and deleted files. I also took out the battery and put it in again. Nothing seemed to work. Would you anyone know how to fix it?

unity – Making animations not smooth while using Record button

In my 2D sidescroller game, I want to separate the animations for the head and the body of my character.

While idling, my charcter’s body bounces slightly up and down (kind of a breathing motion). Thus, the head should keep up.
However, when I press Record and make adjustments for the head, the head moves up and down smoothly instead of following the body frame by frame.

How can I remove the smooth transitions from one position to the other?

Here is a screenshot from Unity demonstrating the hierarchy and the animation keyframes.
enter image description here

Delete record button in PHP table

I am having trouble getting the button to delete a record in my table and in the database. Here is my code:

// Remove

near ();
?>

//Table

    

Lista de Pagamentos

num_rows > 0) { while ($row = $result->fetch_assoc()) { ?>
ID Nome Data pagamento Valor
" " Deletar
Voltar

Linux script to record the usage of directory disk space every minute?

Hello,

I'm trying to determine when disk space for a certain directory is changing. Is there a Linux shell script that can burn … | Read the rest of https://www.webhostingtalk.com/showthread.php?t=1808260&goto=newpost

Google Query: filter one record per day / week per user

I am collecting repeated measures using Google Forms that only allow 1 or unlimited responses. I need a way to filter the responses that the same user entered too close to each other.

For example, if the raw form responses are shown below, I would like the query to exclude the final row since Jim had already answered that day (or alternatively keep his second answer and exclude the first on 12/12).

| TimeStamp            | UserID | SurveyData |
|----------------------|--------|------------|
| 12/03/2020 16:10:40  | Bob    | Dog        |
| 12/03/2020 16:10:20  | Sue    | Cat        |
| 12/03/2020 16:50:40  | Jim    | Dog        |
| 12/15/2020 16:10:40  | Bob    | Cat        |
| 12/14/2020 16:10:20  | Sue    | Dog        |
| 12/12/2020 16:50:40  | Jim    | Cat        |
| 12/12/2020 20:00:00  | Jim    | Bird       |

It should support 2000 unique users, each typically adding one record each month. Ideally this could be written as a single query or filter, but you could use the number of auxiliary count inputs for the user that day if that's easier. It would also be useful if the exclusion criteria could be easily adjusted (eg changed to allow one entry per calendar week).