David's Technical Musings

Periodically I need to copy the contents of a log to another domain for testing purposes.  WordPress doesn’t make this particularly easy as it embeds the complete URL of the site in many places, including the options table, in the posts table for each post, and even in posts, such as when media is added.

There is no need to create the blog in the new database. If you’ve already done that, I would recommend deleting the tables before continuing.

Before you move on, you’ll want to back up your blog.  There are plenty of solutions for this, but a handy one that I’ve been using is WordPress Database Backup by Austin Matzko.

Now you can import the resulting backup file against the destination blog’s database.  I use phpMyAdmin for this, so here are the steps for doing that:

1. Log in to phpMyAdmin.
2. Select the destination blog’s database.
3. Click the Import tab.
4. Click the Browse button and find the .sql file that was the result of the backup operation.  If your backup produces a .zip or .gzip file, that will work fine also.
5. Click the Go button.

You now have your content over on the new site, but you still have work to do.  You still need to change all references to the old domain to be the new domain.  There are three SQL commands you need to execute to do this.  To execute a SQL command, select the database in phpMyAdmin and click the SQL tab.  Paste the following commands into the edit box and change old-domain and new-domain as appropriate.  If you changed your table prefix, don’t forget to change the names of the tables as well.

First let’s fix the wp_options table.

UPDATE wp_options SET option_value = replace(option_value, 'http://www.old-domain.com', 'http://www.new-domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';

Now let’s fix the guid column in the wp_posts table.

UPDATE wp_posts SET guid = replace(guid, 'http://www.old-domain.com','http://www.new-domain.com');

Finally let’s fix the content in the wp_posts table.

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.old-domain.com', 'http://www.new-domain.com');

The final step will be to copy any files that were uploaded, such as in the wp-content\files directory.

Resources

• How to Move WordPress Blog to New Domain or Location

I’ve been setting up WordPress on Windows Server 2008 R2 lately and as part of trying to understand the issues fully – by installing, uninstalling, installing, etc., the last time through I forgot to create the database and the SQL user for WordPress. Unfortunately, when I connected to my website, all I got was the following error page:

No matter how I modified my WordPress configuration file, I couldn’t get anything more to be displayed, and none of the log files (PHP or IIS) contained any additional information.  Turns out this is a security feature of IIS7 to prevent details of the web server (such as folder locations, etc.) from being displayed publicly.  The solution is simple, if somewhat obscure.

To get IIS to display more detailed information, you must run the Configuration and change a setting.  Here are the steps:

1. From Internet Information Services (IIS) Manager (hereafter called IIS Manager), click on the website you are having trouble with in the tree view to the left.  If you click on the server, your changes will apply to all websites.
2. In the Management section, double-click on Configuration Editor.
3. In the dropdown list next to the Section label, select system.webServer –> httpErrors.
4. Change the errorMode to Detailed.

It’s likely that the value of errorMode is set to DetailedLocalOnly, but this value doesn’t help for troubleshooting a WordPress site since IIS won’t consider your access local even if you access it from the machine running IIS.  Too bad really, since after you are done with your troubleshooting you will want to reset the value back to DetailedLocalOnly.

Resources

• PHP on Windows Server 2008 : 500 – Internal Server Error on IIS @ webdigi.co.uk

I made a mistake today when trying to move tool windows around in Visual Studio – I merged the two docking frames at the bottom while debugging.  I couldn’t figure out how to split them again, so I decided to search for a solution.  MSDN came to the rescue

When you drag a tab or a window, a guide diamond appears with four arrows and a center.  There are also four arrows at each side of the Visual Studio Window.  Each of these guides (a total of 9) allow you to create a new docking frame or add the dockable window to an existing frame.  For example, if you want to create a new frame on the right side, move the mouse to the arrow at the far right of the Visual Studio window while you are dragging the dockable window and you will see a blue are highlighted where it will place the window.

I’ve been seeing these guides for a long time but never tried hovering over one of them to see what they would do.  I have to say, they are a very nice interface.

Resources

• How to: Arrange and Dock Windows @ MSDN

I’ve been working on installing PHP 5.3.0 on a new server running Windows Server 2008 R2 and encountered a problem I hadn’t run into before.  After installing PHP following the instructions I published here (FastCGI is supported natively by W2K8 R2 so I didn’t need to do anything to use that), the following message was displayed when I navigated to http://localhost/phpinfo.php:

[06-Nov-2009 11:53:17] PHP Warning: phpinfo(): It is not safe to rely on the system’s timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected ‘America/Los_Angeles’ for ‘-8.0/no DST’ instead in C:\inetpub\wwwroot\phpinfo.php on line 1

The solution is to do exactly what the error message says – set the date.timezone setting in the php.ini file.  This must be a new requirement of version 5.3.0 as I didn’t have to add this setting in previous versions.  Too bad the folks who added this requirement didn’t talk to the folks who maintain the installation program to add an addition page (or something) to set the time zone.  Oh well.  It works now

Some notes.

• You may need to stop and restart either the application pool or IIS itself to get it to recognize the change in the php.ini file.
• If you misspell the time zone, you will get the same error.  I misspelled Los_Angeles as Los Angeles (space instead of underscore between the two words).
• I’ve changed my article on installing PHP to reflect this newly discovered information.

Resources

• Installing PHP on Windows and IIS
• PHP: Runtime Configuration – Manual – datetime configuration

I’m in the process of setting up WordPress on another server running Windows Server 2008 R2 following the same instructions I published for installing on Windows Server 2003 (see the series of articles here).  I ran into some trouble with the step to install phpMyAdmin so I tried to uninstall everything, including PHP and MySQL.  When I went to install MySQL again, it hung at the second step on the Ready to execute page, after the Write configuration file step was checked.

There is a question about this up at the MySQL forums, but the answers didn’t help me.

The one difference I found between the first install and subsequent installs was that the the reinstall asked for the current root password.  This told me that the uninstall program didn’t uninstall everything.  Here are the steps that worked for me on Windows Server 2008 R2.  These steps will probably work on Windows Server 2008, Windows Vista, and Windows 7 as well.  The steps will be slightly different on Windows Server 2003 or WIndows XP.

1. Stop the MySQL service.  Not sure why the uninstall program doesn’t offer to do this, but it doesn’t, so you have to do it manually.
2. Uninstall MySQL.
3. Delete the following folders:
   1. MySQL program files folder.  For me this was C:\Program Files\MySQL.
   2. MySQL database folder.  For me this was C:\MySQL Datafiles.
   3. MySQL application data folder.  For me this was C:\ProgramData\MySQL.  On a pre-Vista operating system, this will likely be C:\Documents and Settings\All Users\Application Data\MySQL or some such.
      (If someone tries this procedure on a pre-Vista operating system, let me know and I’ll update this info.)
4. Reinstall MySQL.

The key steps are deleting the above-mentioned folders.  After doing that, MySQL should install just fine.  Hope this helps you out.

I turned to the dark side at the end of February and purchased an iPhone.  I am so very impressed with it!  Since then I have moved to a new computer (a laptop) and reinstalled the operating system (Windows 7).  That means I have had to move what I sync my iPhone with twice ,and both times have been a little less than seamless; no data was lost but I expected it to be easier than it was.

Authorized Computers

Before abandoning the former computer, you need to deauthorize it.  You only get to authorize 5 computers on the same iTunes account, and there is no central way to manage authorizations.  To deauthorize a computer:

1. Click on the Store menu.
2. Select Deauthorize Computer.
3. Type your iTunes password and continue.

Authorizing the new computer is just as easy.

1. Click on the Store menu.
2. Select Authorize Computer.
3. Type your iTunes password and continue.

If you haven’t already authorized 5 computers, you can do this in any order.  Once you’ve reached 5 authorized computers, you can deauthorize all computers so you can start over.  You will want to be careful about managing your authorizations as it is possible to get orphaned authorizations.

Transferring Purchases

I didn’t realize that I had to perform a manual step to do this.  Fortunately, it’s a simple step.  There are two ways.

From the menu bar:

1. Click on the device under the Devices heading.
2. Click on the File menu.
3. Select Transfer Purchases from “yourdevicename”.

From the device:

1. Right-click on the device under the Devices heading.
2. Select Transfer Purchases.

Transferring purchases could take awhile depending on how many applications or songs you have purchased. Once they have been transferred, you can then set up iTunes to sync applications with your iPhone:

1. Click the device under the Devices heading.
2. Click the Applications tab.
3. Check the Sync Applications checkbox.
4. VERY IMPORTANT! Since the transfer didn’t preserve the layout of the applications, rearrange them as they appear on your phone.
5. Click the Apply button.

I failed to do step #4 above and as a result I’m left with deciding again how I want all my apps to be laid out – a real pain in the neck.

Resources

• Copying iTunes Store purchases from your iPod or iPhone to a computer
• About iTunes Store authorization and deauthorization

My son has downloaded a variety of instructional FLV (Flash video) files that he wants to have available in Windows Media Player.  Since we just installed Windows 7, he was having trouble figuring out how to make it work.  He’d already installed the correct codec (ffdshow) so he was able to play the videos, but when he attempted to create a playlist of several of the videos, WMP wasn’t being cooperative.  Gone is the Monitor Folder interface from previous versions an in its place is a dependence on Libraries in Windows 7.  Sounds like a cool idea, but how do you get files to show up in WMP that show up in those folders?

It turns out Windows Media Player relies on some voodoo in the registry to get it to recognize FLV and MP4 files as video files.  Copy the following text to a .reg file (e.g. ShowFlvInWmp.reg) and open it from Windows Explorer.

Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\.flv]
"PerceivedType"="video"
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Multimedia\WMPlayer\Extensions\.flv]
"PerceivedType"="video"
"Permissions"=dword:0000000f
"Runtime"=dword:00000007
"UserApprovedOwning"="yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MediaPlayer\MLS]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MediaPlayer\MLS\Extensions]
"flv"="video"

Note: If you are having trouble with MP4 files, you can modify the above registry file to replace flv with mp4.

Once you’ve done this, you need to kick Windows Media Player to rescan the folders.

1. Right-click on Videos and select Manage video library.
2. Select the folder to remove and click the Remove button.
3. Click the OK button.
4. Right-click on Videos and select Manage video library.
5. Click the Add button.
6. Select the folder you want to add and click the Include folder button.
7. Click the OK button.

Doing this will cause Windows Media Player to rescan folders.  Here’s another way to force a rescan:

1. Press the Alt key to bring up the menu.
2. Select Tools –> Apply Media Information Changes.
3. You can close the dialog box by clicking the X in the upper right corner (don’t click the Cancel button) and it will run in the background.

Reflections

Windows Media Player hides a LOT of functionality from people who don’t fit into their “core usage scenarios.”  It’s quite frustrating, in fact, as this kind of thing is a lot more common than Microsoft allows for.  It’s issues like this that cause people to flee from WMP to other players.  I tend to prefer WMP, but when I have to work so hard to get it to do what I need, I’m much more willing to try other solutions.  Something for the folks at Microsoft to consider.

Caveat

ZachD from Microsoft makes the following statement:

Please don’t ever set UserApprovedOwning. That’s extremely reserved for my usage only.

It’s unsupported and deprecated. Please please do not set it. It’s not going to do anything “bad”, but :: that’s a user only setting that nobody but the WMP interfaces should be setting. Please.

WMP plays nice. =)

The problem is that if you don’t set that registry value, none of this works.  If someone can show me a way to get Windows Media Player to show FLV files without setting that registry value, I’d sure appreciate it.

Resources

• WMP is not adding FLV, MP4 and other files to the library! @ Microsoft Discussion Groups
• How do I get WMP to rescan my media? @ Neowin Forums
• Play FLV Files in Windows Media Player @ SizzledCore.com
• PlayFLV

In previous versions of Windows (e.g. Windows Vista and Windows XP), you were required to enter a valid product key before getting too far into the installation.  With Windows 7, Microsoft has changed to a trial-friendly approach.  You can choose not to enter a product key until later and then you’ll be able to use Windows 7 for up to 30 days before activating it with a valid product key.

But what if you need more than 30 days to evaluate it?  There is tool that ships with the operating system that allows you to extend the trial period up to three times, for a total of 120 days.  Apparently this tool was also available in Windows Vista.  Here are the steps to extend you trial:

1. Start a command prompt as an administrator
   1. Click Start, All Programs, Accessories.
   2. Right-click Command Prompt and choose Run As Administrator.
   3. Enter your administrator password if prompted.
2. Type the following command and press Enter:

   slmgr -rearm

   Note the space after slmgr and the hyphen in front of rearm.

3. Restart Windows 7.

For more details, check out these articles:

• Use any version of Windows 7 free for 120 days @ WindowsSecrets.com
• Use Vista without activation for 120 days @ WindowsSecrets.com

I was looking for a Windows Explorer extension that would allow me to browse ISO files as if they were simply a folder, similar to how Windows exposes that support for ZIP files.  What I found is WAY better than what Windows providers.

Pismo Technic Inc. provides a tool called Pismo File Mount Audit Package.  This package allows you to easily mount and unmount files with extensions such as ZIP, ISO, CISO, ICZ, DAA, and CFS.  The reason I am raving over this tool are two-fold:

• It works from within Windows Explorer AND from the command line.  It works from everywhere in the entire operating system.  Most tools of this sort that extend Windows Explorer only provide support from within Windows Explorer.
• Unlike the built-in ZIP support in Windows, it provides the full features of Windows Explorer on all files in the resulting folder.  By that I mean all the options are present on context menus, not just the ones that Microsoft saw fit to expose.

Of course, it isn’t quite as seamless as the built-in ZIP support.  You must still mount and unmount the file.  However, the result is so much better, for me it is an acceptable trade-off.

Now if we can just get the browser features for file attachments in Outlook, I’ll be very happy.

This tool is supported on all 32- and 64-bit Windows NT-based operating systems since Windows 2000, including:

• Windows 2000
• Windows XP
• Windows Server 2003
• Windows Vista
• Windows Server 2008
• Windows 7 (that’s what I’m using it on)

Here’s a rundown of the features from the website:

• ZIP Reader – Supports read-only access to ZIP files.
• CD/DVD Image File Reader – Images of CDs and DVDs, typically in ISO or other formats, can be mounted in place as a read-only folder.  Includes the ability to execute contained applications.
• Compact File Set Reader – CFS files can be mounted in-place, including the ability to execute contained applications.
• Private Folders – You can create a container file to act as a folder of files, allowing you to password protect and/or encrypt the container file.
• Explorer Integration – As already mentioned, this tool integrates seamlessly into Windows Explorer, supporting the full range of standard context menus and drag-and-drop operations.
• Full File System Support – All built-in Windows file systems and 3rd party file systems are supported, including local, removable, and network devices.
• Command Line Interface – All functionality is available through the command line.  All mounted files appear as directories at the command line, just like they do from Windows Explorer.

I plan to install this utility on all machines in my household.  It just makes managing container files so much simpler.  Now, even though I’ve been gushing over it, the utility isn’t without its blemishes.  There are a few things that could be done to improve it.

• When mounting a container file using the Mount… option on the context menu, the Mount Options dialog box is displayed.  This dialog box allows you to specify a combination of options that may or may not be supported for the specified container file.  For example, I selected the Read and write option for an ISO file and when I clicked the Mount button it happily mounted the file.  However, it didn’t warn me that write access would not be available.  I’d like to see some validation of the options added.
• As already mentioned, there is no write support for ISO files.  This really isn’t surprising since this isn’t an ISO file maker, but it would be useful to be able to create an ISO like you can a Private Folder (e.g. New > ISO or New > Compact ISO).
  • A workaround for this is to create a Compact File Set (CFS) and then convert it to an ISO.  When you install PF-MAP, shortcuts are added to your Start Menu to create a CFS and to convert convert a CD or DVD image (aka an ISO).  This worked well, but was cumbersome.

I love finding tools like this – useful, feature-rich, well thought out.  Kudos to Joe Lowe and Pismo Technic Inc. for providing great value.

Resources

• Pismo File Mount Audit Package by Pismo Technic Inc.

I installed Windows 7 on my laptop a couple weeks ago and have been really enjoying it.  I had Vista installed before and had very few problems, but Windows 7 is a nice improvement.

One of the bright features of Windows 7 is the new taskbar, also known as the Superbar.  A nice add-on to the superbar is a Mac OS X stacks-like utility called 7stacks from Alastria Software.

The 7stacks utility allows you to create a shortcut on your desktop which can be pinned to your taskbar.  When you run the shortcut, it pops up a “stack” showing the contents of the folder.  It provides three different ways to view the contents:

• Stacks (shown)
• Grid
• Menu

This little utility is likely to become a permanent part of my stable of utilities.  There are a few improvements I’d like to see made, however.

1. Context menus – I’d like to be able to right-click on items in the stack and see the same context menu that appears in any other view.  With v1.2, right-clicking does nothing.
2. Support for Windows 7 libraries – You can create a stack for your desktop, but it doesn’t include the contents of the public desktop.  You can also create a stack for the “Common Desktop” (aka the public desktop) but it won’t show items that are only on your desktop, not on the public desktop.
3. It’s too easy to make changes and then click the Close button on the dialog box that is displayed when you create or edit a stack, thus losing your changes.  I would recommend having OK and Cancel buttons and make the user launch the dialog box again to create more stacks or to make more changes.
4. Creating a stack requires that you create it on the desktop.  Sure, you could move it to another location before pinning it to your taskbar, but it would be a lot more convenient to be able to specify where it goes.
5. The application allows you to specify whether you want to close the stack by clicking anywhere outside the stack or by clicking the stack’s icon again (like Mac OS X).  I’d like both behaviors.  I find myself clicking it again like a menu and then realizing that I have to click somewhere else.  I tried setting it to close when I click on the icon, but then found it stuck around too long when I clicked on it and decided to do something else.

Bugs I’ve Found in v1.2

• Shortcuts for documents launch the application but the document is not loaded.
• The icon for the stack cannot be changed using the Edit Stack dialog box.  Instead you must either recreate the stack or modify the icon for the shortcut on the desktop and then repin it to your taskbar.
• Renaming the folder to which a stack shortcut refers causes the stack to no longer work.  To rename the folder, you must unpin and then repin the stack shortcut.  Note that doing this will reset the stack type.

All in all, however, this is a terrific utility, and I recommend it whole-heartedly.

Resources

• 7stacks from Alastria Software
• Review: 7stacks Does OS X Stacks in Windows 7 Style @ Lifehacker.com
• Review: 7stacks lets you pin multiple folders to your Windows 7 taskbar @ DownloadSquad.com