Failed: ALTER TABLE {acidfree} ADD COLUMN share TINYINT(1) NOT NULL DEFAULT '0'
| Project: | Acidfree Albums |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
I am getting this fail on update #2 after upgrading from drupal 4.7 to 5.16. On another site I also took from 4.7 to 5.16 everything went well , but this site shows no user albums and the root album is showing empty.
Duplicate column name 'share' query: ALTER TABLE acidfree ADD COLUMN share TINYINT(1) NOT NULL DEFAULT '0'
All other steps seem fine -
Update #1
ALTER TABLE {acidfree} DEFAULT CHARACTER SET utf8
ALTER TABLE {acidfree} CHANGE `class` `class` varbinary(16) DEFAULT '' NOT NULL, CHANGE `large` `large` varbinary(255) DEFAULT '' NOT NULL, CHANGE `small` `small` varbinary(255) DEFAULT '' NOT NULL, CHANGE `thumb` `thumb` varbinary(255) DEFAULT '' NOT NULL
ALTER TABLE {acidfree} CHANGE `class` `class` varchar(16) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `large` `large` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `small` `small` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `thumb` `thumb` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL
ALTER TABLE {acidfree_hierarchy} DEFAULT CHARACTER SET utf8
Update #2
Failed: ALTER TABLE {acidfree} ADD COLUMN share TINYINT(1) NOT NULL DEFAULT '0'
Update #3
No queries
Update #4
UPDATE {system} SET weight=99 WHERE name='acidfree'
Update #5
UPDATE {vocabulary} SET module = 'acidfree' WHERE vid = 6
Update #6
No queries
Update #7
UPDATE {acidfree_album} SET view = 'grid' WHERE view = ''
I could really use some help please on knowing what to do. All the picture files are there being served to various pages but I have no user albums showing at all .
Thank you for any guidance you can give
kate

#1
also on this I get the following warning when going to acidfree albums -
Duplicate entry '14' for key 1 query: INSERT INTO taxonomy_context_term (tid, format) VALUES (14, 0
if this helps shed light on what has happened.
Also . When I go to content and then any album previously created I get page not found , but in the content when I edit a user album I get the following tabs up top - view; blank ; album contents;edit;outline .
The view points to node/3 as does the blank tab next to it. Both show page not found. Album contents says the album is empty.