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 when attempting to upgrade from 2.5.0 to 2.5.1

June 02, 2012 12:43am

Subscribe [4]
  • #1 / Jun 02, 2012 12:43am

    bcrabtree

    60 posts

    I received the following error when attempting to update to 2.5.1

    ——————————————————-
    A Database Error Occurred
    Error Number: 1054

    Unknown column ‘ref_ip’ in ‘exp_comments’

    ALTER TABLE `exp_comments` CHANGE `ref_ip` `ref_ip` varchar(45)

    Filename: /server_path/system/expressionengine/modules/referrer/upd.referrer.php

    Line Number: 162
    ——————————————————-

    The error occurs imediately after clicking submit on the license agreement page of the installer.

    I’ve since reverted back to 2.5.0

  • #2 / Jun 02, 2012 8:33am

    Tea

    15 posts

    Look at this solution/fix: https://support.ellislab.com/bugs/detail/17968

    It’s a known bug, but there seems to be a way around it for the time being if you need it.

  • #3 / Jun 02, 2012 6:12pm

    MichaelSimone

    76 posts

    Not only did I get this same error but, after doing the above recommended work around and running installer I now get this error…..

    A Database Error Occurred

    Error Number: 1091

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

    ALTER TABLE `exp_ip2nation_countries` DROP KEY `code`

    Filename: /home/wincityh/public_html/arp/earp/expressionengine/modules/ip_to_nation/upd.ip_to_nation.php

    Line Number: 182

  • #4 / Jun 02, 2012 6:22pm

    bcrabtree

    60 posts

    Just tried to update again and everything went smoothly with the Bug Report solution posted above 😊 Thanks Tea, for posting that.

    Not sure about the second issue with the IP to Nation Module though :( I have that module installed in my setup, but didn’t get the error.

  • #5 / Jun 04, 2012 1:01pm

    Shane Eckert

    7174 posts

    Hey Bryan Crabtree,

    Glad to see that this is resolved. Nice work. Sorry you ran into this bug

    If you need anything else, please just let me know by opening a new thread.

    Cheers,

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

ExpressionEngine News!

#eecms, #events, #releases