Sofie Estolloso Hofmann Designs International

WordPress 2.9 “Carmen” is another great WordPress release. WordPress 2.9 was released on December 19, 2009 but I never had the time to upgrade the blogs and sites before Christmas and even after the holidays. Then on January 4, 2009, WordPress 2.9.1 was released to address a handful of minor issues.

With the two releases, I just thought that it was time to upgrade. And so, yesterday, I upgraded the blogs and sites below from WordPress 2.8.6 to WordPress 2.9 “Carmen” to WordPress 2.9.1.

Sofie Hofmann dot com
Sofie Estolloso Hofmann Designs International
Pro Blog it | ProBlogging Venture Tips and Ideas, Reviews and Opinions
ISYU.INFO Around the World
Patria Diesel Power Plant Issue
Semirara Dumpsite Issue
Pandan Antique Philippines
Tugbong Festival
Weggis along Lake Lucerne Switzerland
PAGTATAP Foundation
Philippine Seafarers Assistance Programme
Leocadio Alonsagay Dioso Memorial Public Library

WordPress 2.9 introduced a lot of new great features like editing an image using the built-in image editor, updating the plugins in batches, embedding with oEmbed among others, but I have not really explored and tested them yet. I will not write about the new features. You can read all about them at WordPress.org or just watch the video below.

There is one thing though that I would like to share to you. If you have been following my blog every time I upgraded to a new released version of WordPress you probably knew about my problem with the Image Gallery feature of WordPress and how I found a solution to it.

I was sort of not in the mood before to find out what was the real problem so I looked for a simple solution. But yesterday, I really looked for the problem and what I can actually do about it so I do not have to comment on the four lines at the post.php file every time there is a need to upgrade.

With one site for example, the “File URL” at the Media Library was different from the “guid” at the wp_posts at the database. You probably knew already that the “File URL” if you need to “Edit Media” at the Media Library cannot be edited from there. So I especially looked for that particular problem and found out that I can actually edit it at the wp_postmeta at the database.

I could actually use some SQL syntax but opted to edit them one by one as I did not want to take any chances that I might make a mistake and delete some things that I do not want to delete. I just removed the unnecessary folders and subfolders before the file name of the photos at the wp_postmeta at the database.

With another site, it was more of adding the year and month before the file name of the photos at the wp_postmeta at the database. The year and month were not reflected when I first uploaded the photos because the miscellaneous settings were different then from the one at the present.

I changed the settings at the miscellaneous by checking “Organize my uploads into month- and year-based folders”. When I first uploaded the photos, I did not check “Organize my uploads into month- and year-based folders”.

With what I just told you, I did not comment anymore on the four lines at the post.php under the wp-includes folder. Other than the Image Gallery problem, upgrading from WordPress 2.8.6 to WordPress 2.9 to WordPress 2.9.1 went fine.

I shared with you the steps on how to locate databases or phpMyAdmin at the PLESK control panel and the steps on how to locate databases or phpMyAdmin at the H-SPHERE control panel.

Now, let me share with you the steps on how to locate MySQL Databases and/or phpMyAdmin at the DreamHost Control Panel.

Login to your Control Panel…

1. Enter your Control Panel username at the Email Address or Web ID field.

2. Enter your Control Panel password at the Web Panel Password field.

3. Click Log In button.

You will be redirected to the DreamHost Control Panel.

Welcome

Welcome to your DreamHost Control Panel!

This is the control center of your DreamHost account. From here you can configure literally any aspect of your account in no time at all!

4. Look for Databases.

If you see Databases…

5. Click the text Databases with the icon.

You will be redirected to another page.

MySQL Databases

MySQL Database Management

Be sure to review the MySQL documentation in our wiki!
To access a database from the command line, use:…

You will also see the text Add New Hostname with 3 columns under it, the Hostname column, Web Administration column, and Actions column.

6. Click the text phpMyAdmin under the Web Administration column of the corresponding Hostname that you would like to access.

And You will be redirected to the MySQL and phpMyAdmin page.

If you will be required to login…

7. Enter your database username at the Name field.

8. Enter your database password at the Password field.

9. Click Log in button.

And you will be redirected to the MySQL and phpMyAdmin page.

You are now at the MySQL and phpMyAdmin page.

Warning:

Do not do anything at the phpMyAdmin unless you know what you are doing.

Take note of all the icons especially the delete icon all the time.

One mistake and your database might be gone in just one click.

To see your database…

10. Click Databases, then Database name.

That’s it!

Now that you know the link to the phpMyAdmin, please bookmark it.

Sometimes, you do not have to login at the Control Panel to access the phpMyAdmin.

You can go directly to the phpMyAdmin.

Just enter your database username and database password to access your database.