Upgrading WordPress…

 Pin It
by on October 1, 2007

I’m about to upgrade to the latest WordPress version.

If you hear loud cursing coming from the general Phoenix area, you’ll know what happend…

Upgrading WP is always….. Interesting…..

Ugh. Anyone know what this means?

WordPress database error: [Table 'jaygt.wp_terms' doesn't exist]
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘category’, ‘post_tag’) AND tr.object_id IN (500, 499, 498, 495, 494, 493, 492, 491, 490, 489, 488, 487) ORDER BY t.name ASC


UPDATE: Whew…. that was 45 minutes of sheer panic. Who knows what caused the above error. I had to go into the SQL database and force it to upgrade again. Requires using phpMyAdmin, which just sends chills down my spine as it’s *really* easy to implode the blog.

Everything seems to be in order though. Let me know if you see something goofy…. Sidebars may be wonky for a little while…

Like, Tweet, share...

 Pin It

 

Other things you can do...

Search for Homes
Email Updates
RSS

Filed Under: Blogging / Social Networking, Random Musings Tagged With: ,

About the Author
Jay Thompson

I'm a real estate broker in Phoenix, Arizona and the publisher of the Phoenix Real Estate Guy blog. I tend to drive too fast and scream at the University of Texas and Denver Broncos football teams. My two kids are smarter than most adults I know and my wife is simply amazing.

Related posts

Bookmark and promote

The Phoenix Real Estate Guy runs on AgentPress

AgentPress is a specialized WordPress theme for real estate agents and brokers, powered by the industry standard Genesis Framework. With AgentPress on your team, you're empowered to get the most out of WordPress for online marketing.

Genesis provides the secure and search-engine-optimized foundation that powers any successful website. And AgentPress provides the specific listing and lead-generation functionality real estate pros need to succeed.

Find out more about AgentPress here.

Comments

We always appreciate your comments! Phoenix Real Estate Guy uses two commenting systems, Facebook and LiveFyre. LiveFyre is the most robust system (and easy to use!). It allows you to login with Twitter, Facebook, Google+ LinkedIn, OpenId, LiveFyre and as a "Guest". I recommend getting a LiveFyre account, it has some great features (just click the LiveFyre button when you write your comment).

 

BLOG COMMENT POLICY: We respectfully ask that you use your real name (first name only is fine) and not use keywords (Why no keywords?). The only real "comment rules" are be civil -- no personal attacks -- and no advertising. (See the full comment policy here). Opinion and debate are welcome, but attack the idea, not the person.

 

LiveFyre Comments

Comments have been disabled for this post.
Sort: Newest | Oldest
Foreclosure Network

Thank you for this great knowledge.

This will be certainly help me.

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Carl Minicucci

Everything looks fine to me, but I've only just spent most of yesterday setting up a Wordpress.org blog. I decided it was time to take the plunge, and much like you, I love a good technology grudge match.

I readily admit, I almost surrendered, but I stuck through it. I hate shameless plugs but, if you had a speck of a moment, I'd love any feedback (www.vaughanblog.com). Content is very rudimentary at this point as I've focussed on structure only.

Nice to talk to you and keep up the inspiring work.

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Jay - The Phoenix Re

Hi Dru!

It probably doesn't really matter. Most (but not all) templates should be compatible with v2.3. It's possible you could select one though that isn't, so it could possibly be simpler to upgrade first, then chose a template.

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Dru Bloomfield

OK, Now that I've decided I need a new template, my question is: Do you recommend upgrading WordPress first or getting a new template stabilized and going at it?

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Jay McGillicuddy

Hi Jay,

I am having trouble on my wife's blog upgrading to WP 2.3, mine went smothly but on her's I am receiving this error message.

WordPress database error: [Duplicate entry '1-category' for key 2]

INSERT INTO wpi4fmm_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ('1', 'category', '', '0', '1')

WordPress database error: [Duplicate entry 'blogroll' for key 2]

INSERT INTO wpi4fmm_terms (name, slug, term_group) VALUES ('Blogroll', 'blogroll', '0')

WordPress database error: [Duplicate entry '2-link_category' for key 2]

INSERT INTO wpi4fmm_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ('2', 'link_category', '', '0', '7')

I can access myphpadmin but I am clueles sfrom there. Mark Flanders is trying to help from the Soundbite Blog. He is trying to come up with a solution.

Any help woukd be appreciated. Thanks Jay McGillicuddy

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Jay - The Phoenix Re

Barry: "I’ll let you guys work out all the kinks before I start looking into a wordpress blog. Kind of like the first year model of a new car."

Don't wait Barry, or it'll never happen! Wordpress is a solid platform, constantly evolving. It can be a little tricky to get going initially, but after that it runs very well...

Steve - I'm usually 2 or 3 rev's behind. I don't see the point in doing every single upgrade. I'm a plugin hound and liked the new feature of WP telling you when a plugin is updated. That's about the only reason I upgraded...

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Steve Belt

Right now I'm with Jonathan. But with you and Dave paving the way, I may try to upgrade my personal blog and see how it goes.

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Barry Cox

I'll let you guys work out all the kinks before I start looking into a wordpress blog. Kind of like the first year model of a new car. :)

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Jonathan Dalton

I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing.

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Jay - The Phoenix Re

I got the error mentioned with NO plugins activated. Forcing the DB to upgrade again (thanks to a post on the WP.org forum for that tip!) fixed it.

I'm installing the plugins one-by-one right now. I do like the new 2.3 feature that shows when an upgraded plugin is available!

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Scoot

There was an issue when I left that last comment. I'll leave this one and copy/paste in the next one. Never mind it seemed to fix itself on this one.

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
TDavid

"Anyone know what this means?"

Yes, the error means what it says in parenthesis: "[Table ‘jaygt.wp_terms’ doesn’t exist]"

The table in the database that was queried didn't exist. In WP 2.3 the category structure was changed in favor of adding tags. If you use plugins that reference categories instead of terms in wp 2.3, there will be problems.

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Foreclosure Network

Thank you for this great knowledge.

This will be certainly help me.

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Carl Minicucci

Everything looks fine to me, but I've only just spent most of yesterday setting up a Wordpress.org blog. I decided it was time to take the plunge, and much like you, I love a good technology grudge match.

I readily admit, I almost surrendered, but I stuck through it. I hate shameless plugs but, if you had a speck of a moment, I'd love any feedback (www.vaughanblog.com). Content is very rudimentary at this point as I've focussed on structure only.

Nice to talk to you and keep up the inspiring work.

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Jay - The Phoenix Re

Hi Dru!

It probably doesn't really matter. Most (but not all) templates should be compatible with v2.3. It's possible you could select one though that isn't, so it could possibly be simpler to upgrade first, then chose a template.

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Dru Bloomfield

OK, Now that I've decided I need a new template, my question is: Do you recommend upgrading WordPress first or getting a new template stabilized and going at it?

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Jay McGillicuddy

Hi Jay,

I am having trouble on my wife's blog upgrading to WP 2.3, mine went smothly but on her's I am receiving this error message.

WordPress database error: [Duplicate entry '1-category' for key 2]

INSERT INTO wpi4fmm_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ('1', 'category', '', '0', '1')

WordPress database error: [Duplicate entry 'blogroll' for key 2]

INSERT INTO wpi4fmm_terms (name, slug, term_group) VALUES ('Blogroll', 'blogroll', '0')

WordPress database error: [Duplicate entry '2-link_category' for key 2]

INSERT INTO wpi4fmm_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ('2', 'link_category', '', '0', '7')

I can access myphpadmin but I am clueles sfrom there. Mark Flanders is trying to help from the Soundbite Blog. He is trying to come up with a solution.

Any help woukd be appreciated. Thanks Jay McGillicuddy

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Jay - The Phoenix Re

Barry: "Iu00e2u0080u0099ll let you guys work out all the kinks before I start looking into a wordpress blog. Kind of like the first year model of a new car."

Don't wait Barry, or it'll never happen! Wordpress is a solid platform, constantly evolving. It can be a little tricky to get going initially, but after that it runs very well...

Steve - I'm usually 2 or 3 rev's behind. I don't see the point in doing every single upgrade. I'm a plugin hound and liked the new feature of WP telling you when a plugin is updated. That's about the only reason I upgraded...

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Steve Belt

Right now I'm with Jonathan. But with you and Dave paving the way, I may try to upgrade my personal blog and see how it goes.

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Barry Cox

I'll let you guys work out all the kinks before I start looking into a wordpress blog. Kind of like the first year model of a new car. :)

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Jonathan Dalton

I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing. I'm not changing.

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Las Vegas Guy

YOu have to love that about WordPress, they keep coming up with new ideas that makes a good product even better. If only Microsoft could duplicate that....

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Jay - The Phoenix Re

I got the error mentioned with NO plugins activated. Forcing the DB to upgrade again (thanks to a post on the WP.org forum for that tip!) fixed it.

I'm installing the plugins one-by-one right now. I do like the new 2.3 feature that shows when an upgraded plugin is available!

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Scoot

There was an issue when I left that last comment. I'll leave this one and copy/paste in the next one. Never mind it seemed to fix itself on this one.

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Scoot

Jay when I upgraded I found 3 or 4 plugins that needed upgrading, if they were on I would have problems. I had to go through and turn them on one at a time and see which ones were compatible. It will probably take time for the geeks to catch up with us.

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
TDavid

"Anyone know what this means?"

Yes, the error means what it says in parenthesis: "[Table u00e2u0080u0098jaygt.wp_termsu00e2u0080u0099 doesnu00e2u0080u0099t exist]"

The table in the database that was queried didn't exist. In WP 2.3 the category structure was changed in favor of adding tags. If you use plugins that reference categories instead of terms in wp 2.3, there will be problems.

share
  • spam
  • offensive
  • disagree
  • off topic
 Like
Jay - The Phoenix Re

Just testing that comments work after the upgrade....

share
  • spam
  • offensive
  • disagree
  • off topic
 Like

Facebook Comments

 

The ARMLS logo indicates a property listed by a real estate brokerage other than Thompson's Realty.
All information should be verified by the recipient and none is guaranteed as accurate by ARMLS.

Copyright 2012 Arizona Regional Multiple Listing Service, Inc. All rights reserved.

Data last updated 2/7/12 2:33 AM PST.

This IDX solution is (c) Diverse Solutions 2012.