Thread

This question may be related to a resolved thread.

I’m trying to upgrade a site from 2.3.1 to 2.4 and I am getting the same issue:

A Database Error Occurred
Error Number: 1054

Unknown column ‘wm_x_offset’ in ‘exp_file_watermarks’

ALTER TABLE `exp_file_watermarks` CHANGE `wm_x_offset` `wm_hor_offset` int

Filename: updates/ud_240.php

Line Number: 83

« Back

I have tried deleting the database and then creating a new one and importing as per the other thread,

Have tried changing the table type from InnoDB to MySamm,

any other ways ideas so i can upgrade?

thanks for your help (in advance)

Jeff

HI,

I couldn’t work my around that issue at all, but due to a deadline I installed a fresh copy of 2.4 and rebuilt the site around that rather the update - luckily it was a small site.

No idea what happened, and it’s never happened before, and hopefully it won’t happen again.

Jeff

Hello Jeff,

I a happy to hear you are back in business. I am sorry you were unable to complete the update and had to run off a fresh installation.

The error above is a solid indication that the update did not complete successfully. It looks like you did do some troubleshooting on your own, but that it did not work out. You were on the right track with the DB, not sure what was going on there though.

Next time the, and hopefully there is no next time, this Troubleshooting Upgrade Errors document might help.

Thank you for using the ExpressionEngine forums!

Cheers,