Thread

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?

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

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.

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

Same error here. Upgrading from 2.5.0 to 2.5.1

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

Than,

Problem solved. Thank you.

-Evan

Ah, thank you! :lol:

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

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

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!

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,