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.

db error from 2.2.0 to 2.2.1

July 01, 2011 5:18am

Subscribe [3]
  • #1 / Jul 01, 2011 5:18am

    Interfacer

    92 posts

    Hi I tried to upgrade from 2.2.0 to 2.2.1. The two installs i tried it on both were throwing this error:

    A Database Error Occurred
    
    Error Number: 1060
    
    Duplicate column name 'exclude_from_moderation'
    
    ALTER TABLE exp_member_groups ADD COLUMN exclude_from_moderation char(1) NOT NULL default 'n'
    
    Filename: updates/ud_100.php
    
    Line Number: 92
    
    « Back

    Cheers

  • #2 / Jul 01, 2011 3:28pm

    Sue Crocker

    26054 posts

    Hi, interfacer. Which version number did you have in your config.php file? I’ll bet that’s where the issue is. Make sure you have the right one in there.

  • #3 / Jul 01, 2011 9:11pm

    Interfacer

    92 posts

    Hi Sue

    That is what i am having in my config file:

    $config['app_version'] = "22";

    not correct?

    Thanks

  • #4 / Jul 02, 2011 12:02am

    Brandon Jones

    5500 posts

    Interfacer,

    No, that’s not a valid version. For 2.2.0, change that to

    $config['app_version'] = "220";

    and try the upgrade to 2.2.1 again. Does that help?

  • #5 / Jul 02, 2011 2:19am

    Interfacer

    92 posts

    thanks that did the trick.

    Had an error message coming up though. listed in this thread

    How can I tell whether install was completed (other than the footer saying now ee 2.2.1)

    Cheers

  • #6 / Jul 05, 2011 6:18pm

    Brandon Jones

    5500 posts

    Hi Interfacer,

    If you’re showing 2.2.1 you’re good to go. Is everything else working as expected?

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

ExpressionEngine News!

#eecms, #events, #releases