Sunday, October 4, 2015

How to Disable Wordpress "Prove your Humanity" captcha code question

A while back, Wordpress introduced an annoying little feature, where you have to solve a simple math question in order to log in to your site:




I ignored this for a while, but decided it was too much of a hassle wile offering no real benefit. However, finding a way to disable it is not very intuitive, as it is not actually a core Wordpress feature, but rather one added with Jetpack. It's part of the Protect module:




Disabling Protect disables the captcha.

If you don't see it on the main Jetpack page, click on the "See all xx Jetpack features" button:




and search for it:


After disabling, you'll no longer get asked any nagging math questions on login:




PLEASE NOTE: Disabling this feature may decrease security for your site. Use your best judgement!

Saturday, August 1, 2015

How to get the previous month in OpenOffice

If you need to derive the previous month from a known date, use this formula:

=DATE(YEAR(A1);MONTH(A1)-1;1)




This works in OpenOffice (and LibreOffice), which do not seem to have a native function to do the job, and should work in MS Office Excel as well.

Wednesday, July 22, 2015

iOS iTunes Remote can't find iTunes Library

The iTunes Remote software on my iPad worked flawlessly with my Macbook Air, but not with my Windows PC. I finally decided to investigate why, and after much search and trial-and-error, I found a solution.

It turns out that it gets confused by IPv6 on Windows (interestingly the same is not a problem on my MacBook, so I blame Windows). Once I disabled TCP/IPv6, iTunes remote started working.

To do so, open your Network and Sharing Center from the control panel. It looks like this:




Next, click on "Change adapter settings", on the left-hand sidebar of that screen. You'll get a new window, like this:



Now, most likely yours will be in English (Netzwerk = Network; LAN Verbindung = LAN Connection - Don't ask me why my Windows insists on using some German terms) and the name of your network card will probably differ, but you want the LAN Connection that connects to the same network that your iPad or iPhone connects to. This might be a WLAN, and I suspect most people only have one network connected to their PC.

Anyway, right-click on the network card and select "Properties". You'll need Administrator rights. A new window pops up:




Simply uncheck the checkbox of the "Internet Protocol Version 6" item. Click OK.

One additional step is required.

Even though windows doesn't ask you to, I found that I had to restart my PC. After that, my iTunes remote found my iTunes library flawlessly.

I hope this helps. And, no, I don't know what we can do once TCP/IPv6 becomes indispensable - except for hoping for a fix from Apple and/or Microsoft.

Thursday, June 4, 2015

Synology Cloudstation Pauses and Does Not Sync

The Problem:

My Cloudstation app stopped working and would not synchronize files anymore. This happened both on Windows, and on Mac.

Symptoms:

It seemed like the app was either permanently in a "connecting" state, or pausing itself.

The solution:

It turns out that my Quick Connect became disabled at some point. I am not sure how or why; it had no account associated. I re-added that and enabled Quick Connect on my DiskStation, and Cloudstation started working again. This was especially odd because in the Cloudstation settings on my Diskstation, the status "Healthy" was displayed.

Friday, May 8, 2015

How To Change Primary Display in Windows

A colleague had her Windows task bar on the wrong screen, and wanted to move the task bar to the other monitor. Seems this is a little confusing in Windows. You find the option if you right click on the desktop, then click on screen resolution. You will get this dialog:




First, you must click on the screen you want your windows start bar to appear on (blue arrow). Only then can you select the option "Make this my main display" (red arrow). If you have the wrong screen selected, the line "This is currently your main display" will appear.

Obviously, this is only applicable if you extend your desktop over multiple screens.