Table ‘wordpress.wp_post2cat’ doesn’t exist – Error while upgrading to WordPress 2.3

Just today I performed an upgrade to the brand new WordPress 2.3.

Problem #1

The upgrade went without a hitch but the moment I refreshed my site I got this long error message that went like…


WordPress database error: [Table 'wordpress.wp_post2cat' doesn't exist]
SELECT p2c.category_id AS cat_id, COUNT(p2c.rel_id) AS numposts, UNIX_TIMESTAMP(max(p.post_date_gmt)) + '0' AS last_post_date, UNIX_TIMESTAMP(max(p.post_date_gmt)) AS last_post_date_gmt FROM wp_post2cat p2c INNER JOIN wp_posts p ON p2c.post_id=p.id WHERE (p.post_status='publish' OR p.post_status='static') AND p.post_date_gmt<='2007-09-27 11:44:24' GROUP BY p2c.category_id ORDER BY numposts DESC...

The same error kept appearing on the top of every single page. Now be aware that this new version of WordPress has a radically different table organisation. In all probability that was the cause of this error.

My first task was to disable every single plug-in I had installed. I was hoping that the error would go away immediately. It did not. After a bit of investigation I figured that even though the WP-Cache plug-in was disabled, it kept delivering the cached pages nevertheless. Deactivating it from the Plugins Panel didn’t help much. What I had to do was to go to Options > WP-Cache and disable it there. Only then did the caching stop.

The next step involved reactivating the plug-ins one-by-one and refreshing the site every time to see which plug-in was causing the error. I know it’s a painstaking task – but there’s no easy way out. Of course, you can make some well-aimed guesses, as the most likely culprit(s) are the plug-in(s) dealing with post categories, keywords, tags etc. Likewise, it didn’t take me long to catch the darned plug-in red-handed. Turned out to be Jerome’s Keywords (v2.0 beta 3). I use the Jerome’s Keywords Related Posts plug-in to display reading suggestions after each post. This plug-in in turn is dependent on Jerome’s Keywords.

As of now, I don’t think there’s any solution to this – except for deactivating the plug-in. I’ve posted a comment at the author’s site and waiting for some sort of a response.

Problem #2

As soon as I tackled the first one, a new one crept up silently and threw me off-balance again. This time the error message appeared when I tried to create a new post and save it. The screen went totally blank except for a lonely error message…

WordPress database error: [Table 'wordpress.wp_categories' doesn't exist]
SELECT c.cat_ID AS ID, MAX(p.post_modified) AS last_mod FROM `wp_categories` c, `wp_post2cat` pc, `wp_posts` p WHERE pc.category_id = c.cat_ID AND p.ID = pc.post_id AND p.post_status = 'publish' AND p.post_type='post' GROUP BY c.cat_id...

This one wasn’t hard to diagnose as half of my plug-ins were already deactivated. I simply started rolling back the activations one-by-one and had the trouble-maker in a minute or two. This time it was Google XML Sitemaps Generator (v3.0b8). Visiting the authors site took me to a post at the support forum at WordPress.org. Seems like this version of the plug-in has some sort of a conflict with Popularity Contest. The solution is quite simple here. Simply download the new v3.0b10 of this plug-in and update it. The error message disappears right-away.

So here are two very common problems you’re going to face while upgrading to WordPress v2.3. This post is intended to help those who’re facing the same problem and groping in the dark as I was a couple of hours back.

All the best.

Switching to the domain-based FeedBurner Pro service

RSS FeedI recently purchased Managed DNS service from my web-host (ComputingHost) as a result of which I no longer have to depend upon their tech support to cater to my DNS record modification needs. Consequently, I decided to switch to the FeedBurner Pro domain based feed service. Domain based feed service means you can customise the FeedBurner to handle your feeds straight under your domains URL (Example: http://feeds.your-domain.com) instead of the usual http://feeds.feedburner.com/YourFeed.

Earlier on this service was available under FeedBurner Pro as a paid option. Ever since Google acquired FeedBurner, this has been made free. As long as you own a domain and are able to modify your DNS records, you can set this up.

Henceforth, all feed subscribers are kindly requested to use the following URL:

http://feeds.chaos-laboratory.com/ChaosLaboratory

or

http://chaos-laboratory.com/feed

instead of the earlier:

http://feeds.feedburner.com/ChaosLaboratory

For existing subscribers – the old URL will still function, but to help facilitate my subscription tracking, kindly update the feed URL.

Any new subscribers automatically subscribe through the new domain based feed URL.

Spot the double images! A video compilation of some cool optical illusions

Here’s a video compilation of some of the coolest optical illusions. Can you spot the double images in each slide?


Best Optical Illusions – video powered by Metacafe

Hits4Pay: Get paid to read commercial emails on topics that You choose

An average internet user comes across plenty of Get Rich Quick schemes floating around on the net. Almost all of these lure members in with promises of delivering an insane amount of riches in just 3-4 days while you just sit at your computer building up your referral list. You’ll notice something strangely similar about their advertising methods – all of them put substantial emphasis on words & phrases like FREE, FASTEST MONEY MAKING MACHINE EVER, LIVE A DREAM LIFE EVER AFTER etc. and denounce all others in this business. Reading their income outline compels many of us to rush head on and sign-up immediately. Unfortunately it doesn’t take long to realise that this “dream opportunity” isn’t really all that free as it claims to be. to get any real advantages out of it you’ve to build a massive list of referrals / affiliates and pay a monthly membership fee in order to gain any real benefits out of your down-line. The monthly payment part is what most of these services very conveniently forget to mention in their advertisements. Ah well !

Multi Level MarketingI had played around with a lot of these online money makers before I launched this blog (and started earning advertisement revenue). These schemes operate on the principles of MLM (Multi Level Marketing) or Network Marketing – which means that in order to make some serious money you need to have a large networked down-line. Initially you can always lure others into signing up through similar advertisements. But when it comes to fishing out cash from their own pockets you’ll find a lot of your down-line vanishing into thin air overnight – coz it’s evident to everyone that there’s no guarantee that the scheme would work as advertised. Why waste hard-earned money of such a thing? While I am still interested in making those few extra bucks online – I’ve lost faith in all such schemes long since.

In comes Hits4Pay. I found this site through an AdBrite advertisement that popped up on my site. The catch-phrase sounded interesting but I was quite apprehensive about it. Anyway, there was no harm in spending a couple of second signing-up for it – so I went ahead with it. To my surprise this turned out to be the first ever scheme that doesn’t ask you to shell out anything from your pockets. You pay absolutely nothing for a membership with them – and never need to pay anything for upgrades either.

Hits4Pay operates on a much simpler principle. While signing-up you choose a bunch of topics that you’re interested in. They’ll keep sending you emails from advertisers about 2-3 times a week. To read the emails, you’ll need to log in to your Hits4Pay account and check your inbox. Once you’ve read the mails, your account gets credited with $0.02 – that is you receive 2 cents for every email you read. Admittedly this isn’t a big amount – but then again, this isn’t a get rich quick scheme either. There’s a scope to earn more by building a down-line. For every email read by your affiliates (1st and 2nd level), you receive $0.01. Having a large down-line can really boost your income – so that’s the only area you need to concentrate on.

What more – as of now they’re offering a $10 sign-up bonus. Your account gets padded with $10 the moment you sign-up and all emails you read after that goes towards topping up that amount. Payouts happen for as low as $25 and get sent directly to your PayPal account.

Here are the key features:

  • Free Sign-up
  • $10 bonus for just signing up
  • No membership / upgradation fees ever
  • Receive paid emails on topics that you choose
  • No spamming
  • A flat income of $0.02 per email you read
  • Earn $0.01 from every email read by your 1st and 2nd level down-lines
  • Minimum Payout $25
  • Payouts occur instantly through PayPal
  • Only limitation – 1 account per household

That more or less summarises the idea. If you’re interested in making some extra cash online, this could definitely be the scheme you’re looking for.

Instead of reading commercial emails for free receive emails on topics that interests you and Get Paid For It! Hits4Pay is one of very few highest paying advertising program in the industry.

Signup for free and receive $10 as a Free Reward.

Performance Data Resources – Your ultimate resource site for refurbished IBM hardware

Hardware (Motherboard)Offices who employ IBM AS/400, iSeries and i5 hardware may find solace in the fact that they don’t have suffer headaches anymore over the replacement of damaged but hard-to-find hardware.

Performance Data Resources or PDR Inc. is an authorised IBM Business Partner, who’ve been around since 1991 and is a leading solutions provider for IBM’s High-Availability (HA) series of hardware and software. PDR is a…

reliable source for diverse, hard to find, new and refurbished midrange hardware and to assist with issues ranging from simple device address & cabling problems to complex system tuning & troubleshooting assistance.

Apart from the server components PDR has an extensive product range that covers tape drives, modems, printer spares, routers/hubs, remote controllers, terminals, UPS-es etc. The software offerings include Web/Spam filter, POS & Barcode etc.

PDR maintains highly-trained technical staff certified to handle all issues pertaining to the e-Server series who provides you with a wide variety of solutions and services to meet your ever changing business requirements.

The listed prices for the spares are quite decent and they offer free shipping anywhere within the U.S. for packages under 50 lbs.

Next time your router goes for a toss you know where to head to.

Digg takes a giant leap into the Social Networking zone

Digg LogoThe immensely popular Social Media site Digg took a giant leap into the Social Networking zone. Digg announced a series of new features that takes it beyond just digging and burying articles with promises for more to come. In an email I received a couple of hours back, they introduced the all new Digg Profiles.

The basic user profiles that Digg offered so far have undergone major renovation and now hosts over fifty new features that include detailed personal information, bigger profile pictures and an extensive report of the activities of your friends / contacts. Social MediaApart from that you can setup content filters – so that the news headlines you get to see comes only from a select group of individuals.

Email notifications from Digg too have undergone big changes. From now on you’ll be able to receive automated notifications regarding certain activities – like when someone adds you as a buddy or a story you submitted suddenly becomes popular. Of course, you are able to specify the type of notifications you wish to receive from the email settings of your control panel.

Finding and adding friends is a lot easier now with the new email based profile search. And if you wish to protect your own privacy, you can always block yourself out from the email based search.

More new & hot stuff are on the way – like voting on images (and not just text-based articles), news recommendation system (similar to StumbleUpon) etc.

If you want a sneak-peek of the new features, Digg has compiled a video walk-through of all these new features.

Free SEO ranking techniques not working for you? Try Apogee

Apogee LogoLets say, you own a web-based business that isn’t working all that well. You don’t seem to get too many hits from the major search engines, despite trying out all the “proven” SEO techniques you dug up from the net. Your best bet under such circumstances is to turn to professional help – like Apogee Search – who can get your business into the limelight in no time.

The company has been around since 2001 and has evolved to become one of top 25 search engine marketing firms in the world. Apogee’s SEO can lead your site to be ranked at the top of today’s most popular natural search engines. Increased RevenuesThe increased visibility leads to more sales which in turn enables your business’s market share to grow by leaps and bounds.

Apogee handles the bulk of San Antonio SEO. San Antonio is a booming market for small, local businesses. Applying their domain of expertise (paid search, natural search, affiliate marketing, pay-per-call etc.), Apogee has put many of these small businesses online and helped them gain a stronghold in an ever expanding market.

They’ve an active blog that covers the latest and hottest search engine marketing news and events. Even if you aren’t availing their services, their articles can provide you with many helpful pointers & insights. If you wish to sample their services, you can always order a free Search Marketing Analysis of your site anytime.

To sum it all, Apogee is a trusted partner who can help squeeze the most out of your marketing dollar and quickly raise your revenues to the next level.

Xinu: Your one-stop SEO shop

Xinu LogoWell, almost ! Xinu is this great new “Jack-of-all-trades” tool that analyses and returns a horde of SEO (Search Engine Optimisation) related information regarding your site, neatly stacked in a single page. A real time-saver if you ask me.

All you go to do is enter your site’s URL and hit Go. The results are fetched using AJAX – so you don’t have to suffer long wait periods while all the factors are summed up and displayed. In fact, the interface comes up with pre-created tables and SEO factor titles, where the values are simply plugged-in later on.

Among the results provided are:

  • Screen-shot of your site
  • A mini site diagnosis involving your URL’s difficulty-to-remember score, site title score (based on the number of words), keywords & description, HTML file size, number of each types of tags etc. Surprisingly, this section reported that my site doesn’t have a favicon and I need to get one, whereas you can see mine (the blue flask) the moment you land-up at my site.
  • A small domain panel that shows the IP your domain resolves to, the country where your host is located, the site author’s name and if possible the age of the domain.
  • A site ranking panel that displays you Google PageRank, Technorati rank, Alexa Traffic rank as well as the number of DMOZ listings.
  • Couple of lines of information on the type of syndication (feeds) offered by your site and the number of subscribers.
  • Number of inbound links from various well-known Social Bookmarking sites like del.icio.us, Digg, Clipmarks as well as from lesser-known ones like Mister Wong, Meneame etc.
  • Site markup validity information broken up into HTML, CSS and Feeds.
  • Number of indexed pages on Google, Yahoo and Live.
  • Lastly, the number of backlinks from all major search engines like Google, Yahoo, AllTheWeb, AskJeeves etc.

Xinu Interface Screenshot

All in all a pretty good tool – although a bit buggy in places. Hopefully, they’ll fix these soon. What I like best about Xinu is that you can stop scampering around half of the internet just to check on all the important SEO aspects of your site.

PrepLogic: Your guardian angel for software / programming certification courses

ExaminationPrepLogic is an online certification training site that delivers a solid combination of quality and convenience at the most reasonable rates. Be it CompTIA, Microsoft, Oracle or Cisco certification training – PrepLogic offers a full range of products that can see you sail through the CBTs (Computer Based Tests) with utmost ease.

The training is disbursed through audio, video and text accompanied by plenty of mock practice exams. Every certification topic comes with a wide selection of “Printables” – which are compilations of question and answers with detailed explanations of each topic. Thrown in together are quick reference answer keys.

PrepLogic LogoPrepLogic also offers Exam Vouchers – which get you an exam ticket for any of the courses at substantially discounted prices (upto $25) than what you would pay for while registering directly through an exam center.

If you’re unsure whether you should sign-up with them, you can always take a look at the free audio and video lessons that are streamed from their site and assess the quality yourself.

Need an upper edge over all your colleagues for that much coveted promotion? Try PrepLogic.

Stripemania: A free online striped background generator for your site

Stripemania LogoEver felt like giving your site’s theme a cool, striped look but didn’t know how to go about it? Are the graphics tutorials on stripes too complex for you to follow? Here’s you quick and dirty way out. Stripemania is a free online tool that generates striped background images for use with your site’s theme in just a couple of quick, easy steps.

The interface is pretty simple. To get your desired stripe, you choose the width of the stripes, the distance between each stripe, orientation and a couple of colours and hit refresh. Thats it! Your custom stripe is ready to download. If you don’t like vanilla stripes (alternating coloured stripes) – you can choose multiple gradients for the stripes and get some pretty snazzy effects. There’s a quick full-screen preview option that lets you test your background out even before you download it.

Stripemania Screenshot

Stripemania falls within the recent Web 2.0 genre of online graphics design tools and is one of the better designed tools in this category and pretty much devoid of the ubiquitous AJAX timeout errors. It’s a must-add in any aspiring web-designer’s toolbox.