Failed: ALTER TABLE {acidfree} ADD COLUMN share TINYINT(1) NOT NULL DEFAULT '0'

fluxrider - April 8, 2009 - 15:19
Project:Acidfree Albums
Version:5.x-1.x-dev
Component:Code
Category:support request
Priority:normal
Assigned:Unassigned
Status:active
Description

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

fluxrider - April 8, 2009 - 15:47

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.

 
 

Drupal is a registered trademark of Dries Buytaert.