How could a USB wireless adapter, interfere with your video display (causing colorful ‘static’ despite Windows still running)?

I can’t find a similar case anywhere.
I’ve actually solved it (I hope) but I want to understand what caused it.

My friend got a refurb PC, and installed this Wireless USB adapter using the provided CD.

Within about 5-10 seconds of plugging it into any USB port (usb2 or 3), his monitor would flicker, and then display only colorful rapidly-moving static. No other issues. Windows was still running OK because it would make the usual sound if I unplugged and replugged the USB dongle.

If I removed the dongle it would not immediately recover, but if I also unplugged the video connector (VGA) and plugged it back in, it would recover.

The ‘fix’ was to connect to his wireless network during the 10 second window before the screen went nuts, then just wait and do nothing for a while. I saw he had a network driver update pending, in windows update. So I figured if the dongle is working, we can let windows update and see if that solves the issue. It apparently did. It’s been fine for hours.

Still, this is strange and I’d like to know… just a driver problem? Why would a USB device mess with the display? (it’s using onboard intel graphics).

Also, this is probably unrelated but maybe you have a guess… the speed seems terrible for fios. About 3-4 megabits. He’s across the house from the wireless router but his laptop (a few feet from router) gets 11-12 megabit. That’s more like low-end cable than FIOS, right? Also weird: Massive 300+ ping on the laptop but only like 3-5 ping on the more distant PC (the one with the misbehaving wireless adapter).

Could these URL tracking parameters be causing data discrepency between Facebook Ads and Google Analytics?


  • We’re seeing a lot of traffic from (direct) / (none) in GA whenever a Facebook Ads campaign is launched — it’s always the top source/medium pair.

  • In second place, there’s some fb / Facebook_Mobile_Feed etc. showing up, so it’s definitely registering. The direct drops a lot as soon as campaigns are paused.

We’ve tried: fixing GTM/pixel bugs, checking the URLs for redirects, or if something weird is going on our WordPress-SPA subdomain combo etc.

Could the following UTM template that’s been set up in Facebook be affecting this?


I typically set the utm_source as facebook, and medium as cpc, but that shouldn’t cause a data discrepancy like this, no?

pandas – Python coding differences between MacOS and Ubuntu causing UnicodeEncodeError

I'm copying CSV files from a machine to a remote PostgreSQL 11 server, using a Python 3.6.4 script.

CSV files have headers (and values) that can have spaces as well as non-ASCII characters, such as ∂ and µ. To save the CSV files, I use the following code:

with open(filename, "w", encoding="utf-8") as output:
    result.to_csv(output, sep='t', header=False, index=False, na_rep='null', encoding="utf-8")

Here is the result is a pandas dataframe. Then I get the list of column names.

columns = (""{}"".format(f) for f in list(result.head(0)))

The CSV and column_list is then used to write to Postgres:

    tn = f"{schema}.{tablename} ({', '.join(columns)})"
    with open(filename) as f:
            '-c', f"COPY {tn} FROM STDIN WITH NULL as 'null'",
            '-d', url,
        ), stdin=f)

It works wonderfully on MacOS (Catalina 10.15.x). But when the above code is executed on an Ubuntu instance (18.04 or 16.04), I still get the following error:

UnicodeEncodeError: 'ascii' codec can't encode character 'xb5' in position 231: ordinal not in range(128)

The error itself is well documented and I have gone through all of the published responses, including here, here and here. However, none of them help. I sprinkled the code with encoding = utf-8 as you can see, I tried to set all the environment variables in Ubuntu instances, to no avail.

I am not able to delete the special characters, they must be kept in the database. What can I do, either in my python script or in subprocess.check_call, to resolve this problem? I also switched to the following:

import codecs

    with, encoding='utf-8') as f:
            '-c', f"COPY {tn} FROM STDIN WITH NULL as 'null'",
            '-d', url,
        ), stdin=f, encoding='utf-8')

But the problem remains the same. Any help is appreciated.

ubuntu – many strange services using a port causing an EADDRINUSE error

So i was trying to install and configure nginx to run php files and everything went fine and works but now my node application gives me EADDRINUSE port: 443 error saying that the port of my express server (a node.js modal) that I used before adding php to nginx and installing its required packages is now occupied.

anyway i tried to connect the services (i guess these are services) that use the port 443 with lsof -i tcp:443 Here's the result:
enter description of image here
I tried to kill them with kill -9 PID but then they come back, if I reload the site, they become more.

so my question is what is it and how can i stop this madness?

my nginx configuration:

server {
    listen 80;
    listen (::):80;
    listen 443 ssl http2;
    listen (::):443 ssl http2;

    server_name 45.76.***.10;
    root   /srv/main/site;
    index  index.html index.php;

    ssl_certificate /etc/ssl/certs/;
    ssl_certificate_key /etc/ssl/private/;
    ssl_client_certificate /etc/ssl/certs/origin-pull-ca.pem;
    ssl_verify_client on;

    client_max_body_size 100M;

    autoindex off;

    location / {
        index index.html index.php;

# pass the PHP scripts to FastCGI server listening on
location ~ .php$ {
        include snippets/fastcgi-php.conf;

        # With php7.0-cgi alone:
        # fastcgi_pass;
        # With php7.0-fpm:
        fastcgi_pass unix:/run/php/php7.2-fpm.sock;

mysql – Update of the column having an index causing a blocking

Update XyzTable set state = & # 39; second & # 39; where pgmNumber = & # 39; prog123 & # 39; and state = & # 39; first & # 39;

The state & pgmNumber columns have an individual index.

A deadlock occurs even if the above request is executed simultaneously with different pgmNumber.

What would be the best way to solve the problem

captcha – reCaptcha causing a form submission error

In the past few days, users have started complaining about the following error when trying to submit forms:

CAPTCHA validation error: unknown CAPTCHA session ID

I'm having trouble finding it. Deleting the caches seemed to fix it for a while, but I need a permanent fix. I have had to disable captcha on public forms for now, but this is not a great long-term solution as we are experiencing a lot of spam on these forms.

The site is running Drupal 8.8.5

movie – What could be causing this Leica M6 light leak?

I just bought a Leica M6 a week ago and I developed the first and second roll that I took.
The photos of the first roll showed no problem,
but in the second scroll, the first, second and third photo show the vertical light leak.
The subsequent photos of the third photo are completely correct.
I can not guess what the problem is …
Anyone know what is causing this problem?
p.s. this roll is tri-x400
1st photo
2nd photo
3rd photo

SQL server – Addition of an article to transactional replication causing a blocking – locking of the schema mod

We have transaction replication initialized from backup on a highly transactional OLTP database. When we add new articles (from SSMS or using T-SQL) this causes massive blocking as the addition of the article process tries to acquire the lock schema mod on all articles in the publication, not just the one being added Exactly the same problem listed here.

Does anyone know if this can be avoided?

T-SQL script used to add a new article

exec sp_addarticle 
   @publication = N'blocking', 
   @article = N'rep6', 
   @source_owner = N'dbo', 
   @source_object = N'repl6', 
   @type = N'logbased', 
   @identityrangemanagementoption = N'manual', 
   @destination_table = N'repl6', 
   @destination_owner = N'dbo'

EXEC sp_addsubscription
   @publication = 'blocking',
   @article = N'rep6',
   @subscriber = 'sql3s14',
   @destination_db = 'repl2',
   **strong text**@sync_type = N'replication support only'

The problem seems to be with sp_addsubscription. sp_addarticle just needs a schema mode lock on the item being added. But sp_addsubscription requires schema mod locking on all existing articles in the publication. This is also true when running sp_addarticle then sp_refreshsubscriptions.

Something causing my Windows 2019 TCP / IP server to hang after some time of running GSA SER

something causing my Windows 2019 TCP / IP server to hang after some time of running GSA SER.
If I stop GSA SER, the problem on my server goes away immediately.
Also, on GSA ser, I see an error: "No buffer space available" when this occurs.
I only use high quality proxies.

replication – is there error code 22 and what is causing it?

I have the following doubt. Today in the morning, I had the following replication event:

SQL: the error & # 39; Character set & # 39; # 1032 & # 39; is not a compiled character set and is not specified in the file & # 39; /usr/share/mysql/charsets/Index.xml & # 39; on the request. Default database: & # 39; Call_Center_Infinit & # 39 ;. Request: & # 39; Update Agentes_logeo set fecha_fin = NOW () Whare if = 76204842 & # 39; & # 39 ;, Error_code: 22
200305 9:24:19 (warning) Slave: the character set & # 39; # 1032 & # 39; is not a compiled character set and is not specified in the file & # 39; /usr/share/mysql/charsets/Index.xml' Error_code: 22
200305 9:24:19 (ERROR) Error executing the query, slave SQL thread abandoned. Solve the problem and restart the slave SQL thread with "SLAVE START". We stopped at the newspaper & # 39; TN-TX-DB03-bin.000934 & # 39; position 127144912

I thought this event was a sql injection attack because it is too strange and never happened to me