desertwebdesigns

It depends if you want to create a whole new home page, or edit add to what is already there.

SQL is a pretty simple language to understand. The above statement basically means

UPDATE <table_name> SET <what_to_change> WHERE <change_criteria>

So we’re updating the wp_posts table. We’re setting the value of post_type in that table to ‘post’ (it is currently ‘page’). And we’re making that change for the post record identified with an ID of 170 (or whatever your post ID is).

Each record in that table is equivalent to a post of some type in your website, be it a post, page, revision, attachment, etc. We want to change from page to post. All records are identified by an incrementing ID number. That’s how we specify which record to update (you can update multiple records at a time). We found the ID from the URLs.

That’s how we come up with our UPDATE statement. Pretty simple once you know how.

FYI: If you left off the WHERE statement at the end, you are no longer filtering for certain records, and you would update EVERY record in that table. This is not good. It would mean that all the revisions in there (auto-saves) just became live posts 🙂 Type carefully. Little mistakes can cause big problems

It doesn’t work because when the database tells the script the files are in the root directory, that’s where it looks, but the files aren’t there. You should just be able to move all the files from the directory you installed your blog to up to the root.

Example:

If you installed your blog into the /blog directory,
Move all files and folders from /blog/ to / within your FTP software.

You may need to download and reupload as your FTP software may not allow you to move directly.

Needs to be done through the database. Go to the Edit Pages screen and hover over/click on the page you want to change. You should have a link that looks like this:

http://www.domain.com/wp-admin/page.php?action=edit&post=170

You need that number

Log into your phpMyAdmin or MySQL interface, and execute this command:

UPDATE wp_posts SET post_type='post' WHERE ID=<strong>170</strong>

This is assuming that your WordPress database prefix is wp. If it isn’t, change wp_posts in the above code to whatever your posts table is named: (eg. my_posts, db_posts, really_long_prefix_posts, etc)

Now go to your Edit Posts page and you will see your page there. Change other post settings as necessary, but that will switch it over.

I have the same issue. Made the proper folders writable and it still didn’t work. I havn’t looked into it too much because I got it to work still. Enter your FTP information and it should work.

Hostname: localhost
FTP Username
FTP Password

That works for me on a virtual dedicated server

That link works for me. Site is working fine. All the links on your home page look like they’re setup properly with the category year/month/date added. Don’t forget to check your permalink structure “Settings > Permalinks”

You will need to install wordpress into the /dev folder and then change your general settings to have the URL be siabmedia.com/dev instead of siabmedia.