Category Archives: PC

How to update phpMyAdmin (and WordPress)

This blog post is mostly a reminder to myself on how to update phpMyAdmin (and WordPress) the next time I need to do that. It turns out that updating is quite simple and mostly involves copying a few files:

  1. Download and unzip the new version of phpMyAdmin.
  2. Copy or move the unzipped folder with the new phpMyAdmin version next to the old phpMyAdmin folder (might be located under xampp).
  3. Copy config.inc.php from the old folder to the new one.
  4. Rename the old phpMyAdmin folder to e.g. phpMyAdmin<old version number> in case it is ever needed again.
  5. Rename the new directory to phpMyAdmin (from e.g. phpMyAdmin-4.5.3.1-all-languages).

I found (approximately) these instructions here: https://www.ostraining.com/blog/coding/update-phpmyadmin/

As a bonus, here is how to update WordPress:

  1. Temporarily set the variable max_execution_time in xampp\php\php.ini to a sufficiently large value, maybe 240 (seconds).
  2. Click on the update link on the WordPress dashboard
  3. Hopefully it does not time out. If it does, increase max_execution_time further.
  4. Set max_execution_time in php.ini back to the normal value (maybe 30).

Making VLC automatically reload the favorite playlist

I sometimes use VLC as an mp3 player and it would be nice if it did automatically load my default playlist when it starts. It is not apparent from the settings within VLC how to accomplish this, but some googling brought up an old blog post from 2007 that explained how to do it. Sort of. The information was outdated, but the remaining piece of the puzzle was provided in one of the comments.

This is how to make VLC automatically load a specific playlist:

  • Select the menu Tools->Settings.
  • Click to show all settings and not just the simple ones.
  • Click on playlist.
  • Fill out the path to the playlist in the field “Standard stream”: file:///C:/audio_files/playlist.m3u
  • Click Save.

Note that there shall be three slashes after file: and that the slashes shall be forward (/), not backward (\) as is usually the case in file paths on Windows.

 

Solution to why Windows 10 randomly wakes up from hibernation

Here is another issue I have been having since upgrading to Windows 10: I often find that the computer has woken up from hibernation, which is of course irritating since it unnecessarily consumes power. I did some googling and found a number of things that could be the cause, like the mouse, keyboard or network interface being able to wake the computer up. Turning all of these off did however not stop the computer from waking up.

Also, a recommendation was to issue the following command in a cmd window to figure out why the computer woke up:

C:\WINDOWS\system32>powercfg /lastwake
Wake History Count - 1
Wake History [0]
  Wake Source Count - 0

In my case the response unfortunately says nothing about why the computer woke up, which seems like a major shortcoming.

Then I tried the following:

C:\WINDOWS\system32>powercfg /waketimers
Timer set by [SERVICE] \Device\HarddiskVolume2\Windows\System32\svchost.exe (SystemEventsBroker) expires at 15:46:51 on 2015-09-27.
  Reason: Windows kör den schemalagda aktiviteten NT TASK\Microsoft\Windows\Media Center\mcupdate_scheduled som kräver att datorn aktiveras.

This did give a useful hint since it told me that mcupdate_scheduled was set to wake the computer up at 15:46:51 the next day, presumably to update Media Center. I do not want the computer to wake up to install updates, so I found out that scheduled tasks can be controlled by “Schedule tasks” (or “Schemalägg aktiviteter” as it is called in my Swedish W10 installation). In it I was able to dig down to Media Center and disable its daily checking for updates, see screenshot below (again, it is from my Swedish installation, but I guess it is it trivial to figure out how to do the same thing in an English W10).

Media Center update scheduling
Media Center update scheduling.

I clicked the circled Deactivate (“Inaktivera”) button to disable the scheduled updates and after this the powercfg /waketimers gave the following response:

C:\WINDOWS\system32>powercfg /waketimers
There are no active wake timers in the system.

Another way of checking for tasks that could wake up the computer is to run Power Shell and the following command:

PS C:\Users\Per> Get-ScheduledTask | where {$_.settings.waketorun}

TaskPath                                       TaskName                          State
--------                                       --------                          -----
\Microsoft\Windows\.NET Framework\             .NET Framework NGEN v4.0.30319... Disabled
\Microsoft\Windows\.NET Framework\             .NET Framework NGEN v4.0.30319... Disabled
\Microsoft\Windows\Media Center\               mcupdate_scheduled                Disabled

Apparently, no task is currently about to wake the computer up. Good.

I also found the following Power Shell command that can be used to disable scheduled wake ups:

Get-ScheduledTask | ? {$_.Settings.WakeToRun -eq $true -and $_.State -ne "Disabled"} | % {$_.Settings.WakeToRun = $false; Set-ScheduledTask $_}

I hope that this will be the end of the computer waking up all by itself. If it is not, I will continue to run the above commands again to see if any new wake timers have popped up.

Update 2016-01-04

Even though the frequency of unwanted wakeups seemed to be much reduced by the above measures, they sometimes occured anyway. Maybe I have just not found and disabled enough things that can cause a wakeup. I have given up on hunting these down, so instead I connected the computer and monitor to a power strip with a switch that I use to remove power from the computer once it has started to hibernate. As long as I remember to turn off the switch, this is guaranteed to prevent the computer from waking up while in hibernation.

Update 2016-10-01

A couple of times I have noticed that my mouse has reverted to being able to wake the computer up. Maybe this happens during some Windows updates. Some of the spurious wake-ups have probably been due to e.g. the scroll wheel on the mouse moving half a notch by itself which might happen if it accidentally was left between two notches. A straightforward way to verify if this can happen is to put the computer into hibernation and then start moving, clicking and scrolling on the mouse. Also try the keyboard while you are at it. To disable wakeup from mouse or keyboard, go to the device manager, right click on the device, select the Power Management tab and disable the wake-up option.

Another thing I have found that can wake the computer up is if I connect am mp3-player to a USB hub while the computer is hibernating, but I have found no setting to disable this.

Still, the trusted old power switch on the power strip without any software involved remains the most reliable method of preventing the computer from waking up when it should not.

Update 2018-03-24

It seems like Windows repeatedly starts allowing mice and keyboards to wake the computer up. One way to check which devices can currently wake the PC up is to issue the following command in a cmd window:

powercfg -devicequery wake_armed

Then one can go into device manager, right click on the offending devices, select Properties and in the Power management tab disable the wakeup capability.

It would be really nice if one could set a flag somewhere to never ever enable anything but the power button to wake the computer up to avoid the PC unnecessarily being on and consuming power for long periods when it is not used.