Geeks’s Corner

Where the Geek Meets Real Life {!!BUGGERED Version!!} - » Wordpress Update…. Don’t forget to do this!







Wordpress Update…. Don’t forget to do this!

If you upgraded from 2.1 to 2.3.2, please don’t forget this database update:

You will need to add a new table called POST2CAT into your database.

Depending on your setup, it maybe defaulted to WP_ prefix
so make sure you add this to your SQL

-- phpMyAdmin SQL Dump
-- version 2.8.0.1
-- http://www.phpmyadmin.net
--
-- Host: custsql-pow07
-- Generation Time: Jan 10, 2008 at 03:57 PM
-- Server version: 5.0.45
-- PHP Version: 4.4.4
--
-- Database: `azrin_net1`
--

-- --------------------------------------------------------

--
-- Table structure for table `wp_IMM-Glossary`
--

CREATE TABLE IF NOT EXISTS `wp_IMM-Glossary` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Title` varchar(255) NOT NULL default '',
`Definition` text NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- Table structure for table `wp_categories`
--

CREATE TABLE IF NOT EXISTS `wp_categories` (
`cat_ID` bigint(20) NOT NULL auto_increment,
`cat_name` varchar(55) NOT NULL default '',
`category_nicename` varchar(200) NOT NULL default '',
`category_description` longtext NOT NULL,
`category_parent` bigint(20) NOT NULL default '0',
`category_count` bigint(20) NOT NULL default '0',
`link_count` bigint(20) NOT NULL default '0',
`posts_private` tinyint(1) NOT NULL default '0',
`links_private` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`cat_ID`),
KEY `category_nicename` (`category_nicename`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;

-- --------------------------------------------------------

--
-- Table structure for table `wp_comments`
--

CREATE TABLE IF NOT EXISTS `wp_comments` (
`comment_ID` bigint(20) unsigned NOT NULL auto_increment,
`comment_post_ID` int(11) NOT NULL default '0',
`comment_author` tinytext NOT NULL,
`comment_author_email` varchar(100) NOT NULL default '',
`comment_author_url` varchar(200) NOT NULL default '',
`comment_author_IP` varchar(100) NOT NULL default '',
`comment_date` datetime NOT NULL default '0000-00-00 00:00:00',
`comment_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00',
`comment_content` text NOT NULL,
`comment_karma` int(11) NOT NULL default '0',
`comment_approved` enum('0','1','spam') NOT NULL default '1',
`comment_agent` varchar(255) NOT NULL default '',
`comment_type` varchar(20) NOT NULL default '',
`comment_parent` bigint(20) NOT NULL default '0',
`user_id` bigint(20) NOT NULL default '0',
PRIMARY KEY (`comment_ID`),
KEY `comment_approved` (`comment_approved`),
KEY `comment_post_ID` (`comment_post_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4187 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4187 ;

-- --------------------------------------------------------

--
-- Table structure for table `wp_link2cat`
--

CREATE TABLE IF NOT EXISTS `wp_link2cat` (
`rel_id` bigint(20) NOT NULL auto_increment,
`link_id` bigint(20) NOT NULL default '0',
`category_id` bigint(20) NOT NULL default '0',
PRIMARY KEY (`rel_id`),
KEY `link_id` (`link_id`,`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Table structure for table `wp_links`
--

CREATE TABLE IF NOT EXISTS `wp_links` (
`link_id` bigint(20) NOT NULL auto_increment,
`link_url` varchar(255) NOT NULL default '',
`link_name` varchar(255) NOT NULL default '',
`link_image` varchar(255) NOT NULL default '',
`link_target` varchar(25) NOT NULL default '',
`link_category` bigint(20) NOT NULL default '0',
`link_description` varchar(255) NOT NULL default '',
`link_visible` enum('Y','N') NOT NULL default 'Y',
`link_owner` int(11) NOT NULL default '1',
`link_rating` int(11) NOT NULL default '0',
`link_updated` datetime NOT NULL default '0000-00-00 00:00:00',
`link_rel` varchar(255) NOT NULL default '',
`link_notes` mediumtext NOT NULL,
`link_rss` varchar(255) NOT NULL default '',
PRIMARY KEY (`link_id`),
KEY `link_category` (`link_category`),
KEY `link_visible` (`link_visible`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

-- --------------------------------------------------------

--
-- Table structure for table `wp_options`
--

CREATE TABLE IF NOT EXISTS `wp_options` (
`option_id` bigint(20) NOT NULL auto_increment,
`blog_id` int(11) NOT NULL default '0',
`option_name` varchar(64) NOT NULL default '',
`option_value` longtext NOT NULL,
`autoload` enum('yes','no') NOT NULL default 'yes',
PRIMARY KEY (`option_id`,`blog_id`,`option_name`),
KEY `option_name` (`option_name`)
) ENGINE=MyISAM AUTO_INCREMENT=936 DEFAULT CHARSET=latin1 AUTO_INCREMENT=936 ;

-- --------------------------------------------------------

--
-- Table structure for table `wp_post2cat`
--

CREATE TABLE IF NOT EXISTS `wp_post2cat` (
`rel_id` bigint(20) NOT NULL auto_increment,
`post_id` bigint(20) NOT NULL default '0',
`category_id` bigint(20) NOT NULL default '0',
PRIMARY KEY (`rel_id`),
KEY `post_id` (`post_id`,`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=829 DEFAULT CHARSET=latin1 AUTO_INCREMENT=829 ;

-- --------------------------------------------------------

--
-- Table structure for table `wp_postmeta`
--

CREATE TABLE IF NOT EXISTS `wp_postmeta` (
`meta_id` bigint(20) NOT NULL auto_increment,
`post_id` bigint(20) NOT NULL default '0',
`meta_key` varchar(255) default NULL,
`meta_value` longtext,
PRIMARY KEY (`meta_id`),
KEY `post_id` (`post_id`),
KEY `meta_key` (`meta_key`)
) ENGINE=MyISAM AUTO_INCREMENT=5556 DEFAULT CHARSET=latin1 AUTO_INCREMENT=5556 ;

-- --------------------------------------------------------

--
-- Table structure for table `wp_posts`
--

CREATE TABLE IF NOT EXISTS `wp_posts` (
`ID` bigint(20) unsigned NOT NULL auto_increment,
`post_author` bigint(20) NOT NULL default '0',
`post_date` datetime NOT NULL default '0000-00-00 00:00:00',
`post_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00',
`post_content` longtext NOT NULL,
`post_title` text NOT NULL,
`post_category` int(4) NOT NULL default '0',
`post_excerpt` text NOT NULL,
`post_status` enum('publish','draft','private','static','object','attachment','inherit','future','pending') NOT NULL default 'publish',
`comment_status` enum('open','closed','registered_only') NOT NULL default 'open',
`ping_status` enum('open','closed') NOT NULL default 'open',
`post_password` varchar(20) NOT NULL default '',
`post_name` varchar(200) NOT NULL default '',
`to_ping` text NOT NULL,
`pinged` text NOT NULL,
`post_modified` datetime NOT NULL default '0000-00-00 00:00:00',
`post_modified_gmt` datetime NOT NULL default '0000-00-00 00:00:00',
`post_content_filtered` text NOT NULL,
`post_parent` bigint(20) NOT NULL default '0',
`guid` varchar(255) NOT NULL default '',
`menu_order` int(11) NOT NULL default '0',
`post_type` varchar(20) NOT NULL default 'post',
`post_mime_type` varchar(100) NOT NULL default '',
`comment_count` bigint(20) NOT NULL default '0',
PRIMARY KEY (`ID`),
KEY `post_name` (`post_name`),
KEY `post_status` (`post_status`),
KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
FULLTEXT KEY `autometa` (`post_content`,`post_title`)
) ENGINE=MyISAM AUTO_INCREMENT=670 DEFAULT CHARSET=latin1 AUTO_INCREMENT=670 ;

-- --------------------------------------------------------

--
-- Table structure for table `wp_term_relationships`
--

CREATE TABLE IF NOT EXISTS `wp_term_relationships` (
`object_id` bigint(20) NOT NULL default '0',
`term_taxonomy_id` bigint(20) NOT NULL default '0',
PRIMARY KEY (`object_id`,`term_taxonomy_id`),
KEY `term_taxonomy_id` (`term_taxonomy_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `wp_term_taxonomy`
--

CREATE TABLE IF NOT EXISTS `wp_term_taxonomy` (
`term_taxonomy_id` bigint(20) NOT NULL auto_increment,
`term_id` bigint(20) NOT NULL default '0',
`taxonomy` varchar(32) NOT NULL default '',
`description` longtext NOT NULL,
`parent` bigint(20) NOT NULL default '0',
`count` bigint(20) NOT NULL default '0',
PRIMARY KEY (`term_taxonomy_id`),
UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`)
) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=utf8 AUTO_INCREMENT=63 ;

-- --------------------------------------------------------

--
-- Table structure for table `wp_terms`
--

CREATE TABLE IF NOT EXISTS `wp_terms` (
`term_id` bigint(20) NOT NULL auto_increment,
`name` varchar(55) NOT NULL default '',
`slug` varchar(200) NOT NULL default '',
`term_group` bigint(10) NOT NULL default '0',
PRIMARY KEY (`term_id`),
UNIQUE KEY `slug` (`slug`)
) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=utf8 AUTO_INCREMENT=63 ;

-- --------------------------------------------------------

--
-- Table structure for table `wp_tla_data`
--

CREATE TABLE IF NOT EXISTS `wp_tla_data` (
`id` int(10) unsigned NOT NULL auto_increment,
`post_id` bigint(20) unsigned NOT NULL default '0',
`url` text NOT NULL,
`text` text NOT NULL,
`before_text` text NOT NULL,
`after_text` text NOT NULL,
`rss_text` text NOT NULL,
`rss_before_text` text NOT NULL,
`rss_after_text` text NOT NULL,
`rss_prefix` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `post_id` (`post_id`),
KEY `post_id_2` (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `wp_tla_rss_map`
--

CREATE TABLE IF NOT EXISTS `wp_tla_rss_map` (
`post_id` int(10) unsigned NOT NULL default '0',
`advertisement` text NOT NULL,
PRIMARY KEY (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `wp_usermeta`
--

CREATE TABLE IF NOT EXISTS `wp_usermeta` (
`umeta_id` bigint(20) NOT NULL auto_increment,
`user_id` bigint(20) NOT NULL default '0',
`meta_key` varchar(255) default NULL,
`meta_value` longtext,
PRIMARY KEY (`umeta_id`),
KEY `user_id` (`user_id`),
KEY `meta_key` (`meta_key`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

-- --------------------------------------------------------

--
-- Table structure for table `wp_users`
--

CREATE TABLE IF NOT EXISTS `wp_users` (
`ID` bigint(20) unsigned NOT NULL auto_increment,
`user_login` varchar(60) NOT NULL default '',
`user_pass` varchar(64) NOT NULL default '',
`user_nicename` varchar(50) NOT NULL default '',
`user_email` varchar(100) NOT NULL default '',
`user_url` varchar(100) NOT NULL default '',
`user_registered` datetime NOT NULL default '0000-00-00 00:00:00',
`user_activation_key` varchar(60) NOT NULL default '',
`user_status` int(11) NOT NULL default '0',
`display_name` varchar(250) NOT NULL default '',
PRIMARY KEY (`ID`),
KEY `user_login_key` (`user_login`),
KEY `user_nicename` (`user_nicename`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Table structure for table `wpau_active_plugins_info`
--

CREATE TABLE IF NOT EXISTS `wpau_active_plugins_info` (
`id` int(4) NOT NULL auto_increment,
`plugin_name` varchar(255) NOT NULL default '',
`plugin_status` varchar(255) NOT NULL default '',
`plugin_deactive_response` smallint(2) default '0',
`plugin_reactive_response` smallint(2) default '0',
`fatal_plugin` smallint(2) default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `wpau_upgrade_log`
--

CREATE TABLE IF NOT EXISTS `wpau_upgrade_log` (
`id` int(4) NOT NULL auto_increment,
`task_name` varchar(150) NOT NULL default '',
`task_status` varchar(150) NOT NULL default '',
`task_description` varchar(150) NOT NULL default '',
`task_log` text,
`start_date` datetime NOT NULL default '0000-00-00 00:00:00',
`end_date` datetime default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

You may need to access your MYSQL DB controls thru your control panel (CPANEL / WHM / PLESK / HELM ) and go thru phpmyadmin to access them.
Check your CONFIG.PHP for your database settings.

Then …easily update yr blog using the WP-AUTO-UPGRADE script. Yeah..the post ID is satanic abit.



   Posted in Announcements, Network Storage, Networks, News Flash, PHP, Scripts, Server Side, System Announcement, linux    

Subscribe RSS 2.0 feed. Leave a response, or Trackback from your own site.





One Response to 'Wordpress Update…. Don’t forget to do this!'

  1. MyAvatars 0.2 Azhar Ahmad - January 11th, 2008 at 6:07 am

    Owhh2, ok2 faham…


Leave a Reply



Buddy Link:
SEO Engineering 101 Hacks and Cracks
In the Kitchen With Kak Mar
Walk with me in Europe
Singaporean in Europe
Ramble with the V@mp
With Her Royalness A Tun King Tia