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.

"Error Number: 1054" (when upgrading from 2.3.1 to 2.5.1)

May 30, 2012 5:51pm

Subscribe [8]
  • #1 / May 30, 2012 5:51pm

    Lindsey D

    10 posts

    While upgrading EE from 2.3.1 to 2.5.1, I encountered this error…

    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: [path hidden for security]/expressionengine/modules/referrer/upd.referrer.php

    Line Number: 162

    I’ve since rolled back the database and files to the previous version.

    Any clue what this means, or how to fix it?

  • #2 / May 30, 2012 6:18pm

    Youthworks

    47 posts

    im getting exactly the same error when im upgrading from EE 2.5 to 2.5.1

  • #3 / May 30, 2012 6:28pm

    Lindsey D

    10 posts

    Yes, thank you Robert, that reminds me…

    The EE upgrade process happens incrementally… it will actually step through each version of EE between the old version and the new one.

    My installation stalled out at 2.5.0 - It successfully upgraded to that point before the error.

  • #4 / May 30, 2012 8:23pm

    AngelLaw

    12 posts

    I am getting the same error and for the update from 2.5.0 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: /www/HIDDEN/HIDDEN/system/expressionengine/modules/referrer/upd.referrer.php

    Line Number: 162

  • #5 / May 30, 2012 8:38pm

    than

    10 posts

    Same error here. Upgrading from 2.5.0 to 2.5.1

  • #6 / May 30, 2012 8:44pm

    than

    10 posts

    There’s a bug in the Referrers module in upd.referrer.php.

    Line 154 should be:

    'referrers',

    instead of

    'comments',


    Update: I filed a bug here ยป https://support.ellislab.com/bugs/detail/17967

    Andy (below) notes the full path of the file is

    system/expressionengine/modules/referrer/upd.referrer.php
  • #7 / May 30, 2012 8:46pm

    AngelLaw

    12 posts

    Than,

    Problem solved. Thank you.

    -Evan

  • #8 / May 30, 2012 9:18pm

    Lindsey D

    10 posts

    Ah, thank you! :lol:

  • #9 / May 31, 2012 5:50am

    verve

    39 posts

    Hi
    Had the same error. Problem solved. Thanks ‘than’ for the help
    Res

  • #10 / May 31, 2012 9:16am

    alijrob

    2 posts

    Thanks for that - I tried the upgrade several times and failed until I found your answer, which worked immediately. 😊

  • #11 / May 31, 2012 12:51pm

    Andy Slipher

    79 posts

    Lifesaver. Thanks. By the way, for the record the file is located at:

    system/expressionengine/modules/referrer/upd.referrer.php

    Also, I literally changed the file remotely on the fly (I’m using Coda 2), edited line 154, clicked the browser “back” button on the error page and the update re-ran smoothly, fast and easy. My upgrade was from 2.3.1 to 2.5.1.

    Thanks again, than!

  • #12 / May 31, 2012 12:58pm

    Shane Eckert

    7174 posts

    Hey all,

    I am sorry about your experience here. This has been filed as a bug.

    Please comments on the bug to say updated on it’s progress.

    Cheers,

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

ExpressionEngine News!

#eecms, #events, #releases