Please do something with update process, as on every attempt to update to alpha1 an exception occurs:

Update #7000

Failed: DatabaseSchemaObjectExistsException: Was not able to add a field beautytips_custom_tips.enabled: the field already exists. in DatabaseSchema_mysql->addField() (line 323 from [path]/includes/database/mysql/schema.inc).

It is clean installation on Drupal 7.

CommentFileSizeAuthor
#2 1211334_db_field_exists_patch_overlay_for_update_7000.patch482 bytesalphasupremicus

Comments

kleinmp’s picture

kleinmp commented
Version: 7.x-2.0-alpha1 » 7.x-2.x-dev
Status: Active » Fixed

This update is for people who have already been using the beayttips manager. I modified the update in the dev version so it takes this into account.

alphasupremicus’s picture

alphasupremicus commented
StatusFileSize
new 1211334_db_field_exists_patch_overlay_for_update_7000.patch482 bytes

I had the same error when applying update 7000. I run a PostgreSQL back-end and the update 7000 has some MySQL-specific syntax in the update. Attached is a patch that uses the Drupal DB Abstraction layer API that should accomplish this regardless of what database flavor you are using. Cheers!

kleinmp’s picture

kleinmp commented

Thanks for the patch! I added this to the dev version, and will probably release a new alpha version today for this and some other bug fixes.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

philsward’s picture

philsward commented
Status: Closed (fixed) » Needs work

I hate to re-open a "fixed" issue, but I just tried an upgrade from the latest D6 dev to beta2 and I received the same error even with the included patch installed... I have no idea how to fix it either :-/

philsward’s picture

philsward commented

Also getting similar for #7002 but it might be related to me manually adding a "beautytips_custom_tips" table in the DB without actually knowing what I'm doing...

Failed: DatabaseSchemaObjectDoesNotExistException: Cannot change the definition of field beautytips_custom_tips.element: field doesn't exist. in DatabaseSchema_mysql->changeField() (line 454 of /home/user/public_html/t/upgrade/includes/database/mysql/schema.inc).

Update: Managed to get past the errors by manually creating the db columns... No idea if I have them setup right though. I'm using MySQL 5.5 and I'm wondering if the update process is designed for earlier versions?

pifagor’s picture

pifagor commented
Issue summary: View changes
Status: Needs work » Closed (cannot reproduce)