Archive for the ‘Wordpress tips’ Category

Upgrading Wordpres 2.7 to Wordpress 2.8

Posted on Sunday, December 27, 2009 at 7:33 am


Problems with upgrading Wordpres 2.7 to Wordpress 2.8 ?

I have search throughout the Internet, Googling the Wiordpress.org site and other forums etc. No solutions and nothing found. I have a few blogs that are still at the older ends of 2.6/2.7.

So why upgrade ? Due to exploits and bugs and features, especially Fantastico in Cpanel, which automatically updates to the latest version. Now whenever I change webhosting sites, I will use Fantastico instead of manually uploading.

Ok so heres a simple guide (wrote for myself actually) how I figure out upgrading this 2.7 to 2.8 thing, to solve all the STUPID problems with Upgrading Wordpress 2.8.X.

1) Install new WP 2.8 with Fantastico on your web host’s Cpanel

2) Create a new Database with your myPHPadmin (this is just for simple editing of your DB) Import your old Database (export using replace function) into this “test” Database.

3) Using this guide, do all the necessary changes for the Database structure. Its just a few simple deletion of attributes that differs from 2.7 and 2.8: http://codex.wordpress.org/Database_Description

4) Delete the “active plugins” data in Table WP_Options, just to make sure no conflicts of plugins + deactivates all plugins.

5) Export out this “Test” DB as Insert instead of Replace, then Import this Database script into the newly create Wordpress 2.8x Database in Step 1. There shouldn’t be any Database structure errors like errors or missing stuff etc…

6) Now, copy WP-Content folder (except Plugins folder) and into your FTP webspace.

7) What you should see now on your www.your || blog.com is a site with your posts, theme, and probably not widgets.

8) Now here’s the hard part (saving your trouble of reinstalling, you got to do this.) The posts might not have tags or categories due to the change in Wordpress Version. You have to manually create Categories and tags etc. But with the new versions, you can do bulk updates, which is quite simple.

That’s it. Hope your upgrading is a success.

Editing Wordpress pages to homepage

Posted on Saturday, July 5, 2008 at 3:47 pm


Here is a Wordpress tip on how to change the Wordpress’s pages’s permalink so that it can be used as a navigation menu instead.

 
 

Problem

I had a problem because I am afraid you will be lost while navigating this site, and wanted YOU to return to my index page (root directory). You can only click my DennisQuek.com hyperlink on my header right at the top, and that is the only way so far.

In this Wordpress CMS, I created had a page called “Home” that appears on the menu, but after clicking this “page”, a page of static post was expected. I needed have a more obvious way to return visitors to my home page, where index page is, without the need to click that DennisQuek.com link.

Dennis Home Page Images
The picture shows my old “home” pages page.

 
 

Solution

The solution is to edit the permalink such that you remove the “/home/” in the hyperlink to null. I found out a way by changing this, and that is to go into your mysql database or other database that you are running, and by changing to blank, you will be able to link the “pages” home back to your home page.

Edit Wordpress SQL database examples

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Step 1
Go into your Wordpress database. Locate the wp_posts, and find the structure tab. You will need that to execute the SQL search query later on.

 
 

Edit Wordpress SQL database examples

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Step 2
Click on the SQL tab and you should see a query that allows you to display the data in that table.

 
 

Edit Wordpress SQL database examples

 
 
 
 
 
 

Step 3
Scroll to the row where your post is. Although its a post, but its type is a page. Look carefully. Locate it and edit the row values. Look out for the “Post_name” value because this is where you change the value to null, or blank.

 

The bad point is you can’t use this method to link to other sites, so you’ve got to use the Links instead. But the good point is now you have a way to “cheat” and navigate around.

After you are done with the change, you should be able to see… err… it in live. Mouse over to my “Home” pages and you should see the URL as my domain name only and nothing else. Hope that enhances your Wordpress blog.

Book feature widget

Posted on Thursday, July 3, 2008 at 4:35 pm


I have added a book feature widget, which allows me to showcase some of the books that I have read or are currently reading. This is a nice feature, except that in order to show the books images on my main site, I have to set it to “currently reading”.

I recommend some of the books posted here which are “good-to-know”. For those of you who run wordpress CMS, you can add this widget into your application. The widget is available here: http://robm.me.uk/projects/plugins/wordpress/now-reading. This is plugin is written by Rob Miller’s and its free. It pulls your book’s data using the international ISBN code, from http://www.amazon.com.

On and off I’ll get new books and probably write some review, so if you like self-improvement books you can find some recommended ones here.

You could also recommend a book review to me, so that I can add it here. Simply send me a book review with a few lines, ISBN number, and the book title to:
DennisQuek@DennisQuek.com,
Your email contact or website will be added together with the book’s review.

Books contain knowledge of wealth, so happy reading !

Recent Entries

Popular Posts

Recent Comments

  • Ahmad: Hi, Hi, Very Very Informative and Practical. :) :) :) :) Regards, Ahmad
  • Ahmad: Hi, Very Very Informative and Practical. :) :) :) :) Regards, Ahmad
  • Anis Laila: The piggy buns look yummy. I am reading up on the different Malaysia accommodations available for a...
  • DennisQuek: Of cos definitely it feels much lighter. It doesn’t really bulge out, and it is much easier to put...
  • siurui: hey there, u have very good reviews and i noticed u were a user of the e61 too (using it now). this might...