Thread

The following error is thrown up and install exits.

A Database Error Occurred

Error Number: 1050

Table ‘exp_snippets’ already exists

CREATE TABLE `exp_snippets` ( `snippet_id` int(10) unsigned NOT NULL auto_increment, `site_id` int(4) NOT NULL, `snippet_name` varchar(75) NOT NULL, `snippet_contents` text NULL, PRIMARY KEY (`snippet_id`), KEY `site_id` (`site_id`) )

Filename: updates/ud_200.php

Line Number: 1700

Hi Michael,

I’m sorry the upgrade process has resulted in these errors. I have some resources to help get you up and running.

It’s important that you are following the correct part of the User Guide, Upgrading from a Previous Version of ExpressionEngine.

What has happened is that the update process is attempting to run a part of the script that has already passed. The way to get through this is to try again. To do that, get the backups of your site files and database that you captured *before* any attempts to upgrade and restore those to the pre-upgrade state. The process is outlined in Troubleshooting Upgrade Errors.

Be sure to read through all the steps in the User Guide and the Wiki before your next attempt.

I look forward to your reply.

Cheers,

Dan. Finally got a chance to try upgrading the 1.6.9 install to 2.4. I started over as you suggested but after the process reached the 2.4 version change in the process, it threw up the below error.

Any suggestions!!

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

Dan. Finally got a chance to try upgrading the 1.6.9 install to 2.4. I started over as you suggested but after the process reached the 2.4 version change in the process, it threw up the below error.

Any suggestions!!

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

Hi Micheal,

I closed your other thread on this issue so that we could keep the discussion all in one location.

As per Dan’s instructions above I’d like you to once again retry the upgrade. Please read the instructions on retrying after a failed up grade and pay special attention to the part about restoring your database - it’s essential that you completely delete the database from the failed upgrade before restoring the backup database.

Sean

been there, done that!

Also, in viewing your install code I found that in the db schema table setup used to create the tables already includes the updates you are making in ud_240 which is where the error is being generated from.

Hi All,

I’m getting the same error upgrading 2.2.2 (Build: 20110801) to 2.4.0

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

I also get this error related to the Structure module:

A Database Error Occurred
Error Number: 1146

Table 'pursantdb.exp_structure_members' doesn't exist

ALTER TABLE exp_structure_members drop primary key

Filename: /home/content/73/8414173/html/admin/expressionengine/third_party/structure/upd.structure.php

Line Number: 278

The first error is because the updates/ud_240.php file wants to CHANGE `wm_x_offset` TO `wm_hor_offset` int. The problem is the ‘exp_file_watermarks’ file was created in the process with the ‘wm_hor_offset’ NOT `wm_x_offset`

I’ve been waiting for someone to give me a solution that works. If I get one I’ll pass it along

Quick update, taking Structure out of the equation did the trick.  My installation went smoothly afterward.

Finally got a chance to try upgrading the 1.6.9 to 2.4 again. I started over as you suggested but after the process reached the 2.4 version change in the process, it threw up the below error.

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

In searching through the ud_install files, ud_240 is causing the error. I checked the DB watermark file and saw that the changes indicated by this file had indeed been made. The also ran its coarse and created the remaining DB files called for in the ud_240.php

Also, when the upgrade process hit this file the browser screen went blank and the install halted.

Out of curiosity I proceeded as though the install completed and opened the CP where on the home screen the following Notice appeared—-

“Your ExpressionEngine installation’s version (2.3.1) is not consistent with the reported version (2.4.0). Please update your installation of ExpressionEngine again.”

I Noticed other are now having the same problem! WHAT’S UP WITH THIS!!!!

:coolgrin:

Finally got a chance to try upgrading the 1.6.9 to 2.4 again. I started over as suggested. Deleted database, imported several older db’s, re-upload 2.4, followed all Guide and Wiki instructions but in all cases after the process reaches the 2.4 version change in the install process, it throws up the below error.

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

In searching through the ud_install files, ud_240.php appears to be causing the error. I checked the DB watermark file and saw that the changes indicated by this file for updating had already been made when the table was created. The result is the same for the other additions and changes requested by this file.

It appears that these tables were previously created by the schema/mysql_schema.php

Can some tell me what I can do to upgrade the system!!!!!!!

:coolgrin:

Finally got a chance to try upgrading the 1.6.9 to 2.4 again. I started over as suggested. Deleted database, imported several older db’s, re-upload 2.4, followed all Guide and Wiki instructions but in all cases after the process reaches the 2.4 version change in the install process, it throws up the below error.

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

In searching through the ud_install files, ud_240.php appears to be causing the error. I checked the DB watermark file and saw that the changes indicated by this file for updating had already been made when the table was created. The result is the same for the other additions and changes requested by this file.

It appears that these tables were previously created by the schema/mysql_schema.php

Can some tell me what I can do to upgrade the system!!!!!!!

Still waiting for a reply to my last post from the EllisLab regarding the install upgrade issue/error I’m receiving

Hi MichaelSimone,

I’m sorry you have been through so much frustration getting through the upgrade. Have you verified that every update in ud_240.php has been applied to the database?

When you get to this point in the process, pause, and open /system/expressionengine/config/config.php

What is the value of:

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

If all the changes are present, then the ud_240.php file may have already been run and we can safely move past it.

Cheers,

If memory serves me right, I believe the version, when I checked, was 231. I checked this file when I assumed the process had completed and this was an anomaly and started the CP where a Notice appeared claiming that there was a version discrepancy of 231 with 2.4

I would have to run the instal again to confirm