ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Database error updating 1.72 to 2.5.1

June 04, 2012 11:54am

Subscribe [2]
  • #1 / Jun 04, 2012 11:54am

    David Roberts

    250 posts

    Hi

    There seem to be numerous topics on the database error problems but I don’t see any fixes so I have added mine below.

    This is a live site so would appreciate a response ASAP.

    Thanks

    David

    A Database Error Occurred
    Error Number: 1091

    Can’t DROP ‘user_blog’; check that column/key exists

    ALTER TABLE `exp_referrers` DROP COLUMN `user_blog`

    Filename: /www/sssss/public_html/ssssss/expressionengine/modules/referrer/upd.referrer.php

    Line Number: 146

  • #2 / Jun 04, 2012 11:58am

    MichaelSimone

    76 posts

    David- goto to this thread for a solution You’ll need to edit one of the files

    http://ellislab.com/forums/viewthread/218435/

  • #3 / Jun 04, 2012 12:00pm

    David Roberts

    250 posts

    That’s not it. I fixed that error , then I got this one.

    thanks

  • #4 / Jun 05, 2012 1:01pm

    Dan Decker

    7338 posts

    Hi David,

    I do apologize for your frustration and errors during the upgrade process.

    When you get this error in the updater, can you look into the database and see if the “user_blog” column is already been dropped?

    If so, you can add it back in, refresh the updater and let it continue the update process.

    I look forward to your reply.

    Cheers,

  • #5 / Jun 05, 2012 3:21pm

    David Roberts

    250 posts

    Hi Dan,

    Its fixed.

    Thanks

    David

  • #6 / Jun 11, 2012 12:15pm

    Kevin Smith

    4784 posts

    Glad to see Dan was able to get you all squared away, David. Let us know if you need anything else!

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases