Some reason led me to update to dev from 1.3 but sweaver can't get the database update right.
sweaver module
Update #7102

Failed: DatabaseSchemaObjectExistsException: Cannot add field sweaver_style.visibility: field already exists. in DatabaseSchema_mysql->addField() (line 328 of /Applications/MAMP/htdocs/staging/includes/database/mysql/schema.inc).

Comments

bharata’s picture

bharata commented

Same story here. Is this a problem? Does this hurt my site? Can it be fixed? What happens if I ignore this on a production site?

Update #7102

Failed: DatabaseSchemaObjectExistsException: Cannot add field sweaver_style.visibility: field already exists. in DatabaseSchema_mysql->addField() (line 328 of /var/www/Nourishing Wholeness 2.0/includes/database/mysql/schema.inc).

Could this be because I didn't run update.php for a little while after replacing the module files? I used Sweaver for a little while before remembering to update.

Thanks for any input!!

bharata’s picture

bharata commented

So, I decided to try and fix this by droping the field "visibility" from the "sweaver _style" table in my database.

Oddly (to my newbe mind) I get the same error claiming the field exists.

Hmm... what to do...

bharata’s picture

bharata commented

The following steps fixed this issue for me:

1) Disable Sweaver (un-check in modules list).
2) Go to "Uninstall" tab on Modules page.
3) Unistall Sweaver. This deletes ALL Sweaver stuff from the database properly.
4) Return to Modules page.
5) Enable Sweaver.

All is well! Update.php is not needed.

If you have been making changes to your site with Sweaver, you may want to make a backup of the content of the folder sites/default/files/sweaver just to be safe (I don't think it gets deleted, but I'm no expert.)

Hope this helps!

Yorgg’s picture

Yorgg commented
Status: Active » Closed (fixed)