Closed (duplicate)
Project:
Image
Version:
6.x-1.x-dev
Component:
image_attach
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
30 Aug 2009 at 13:54 UTC
Updated:
30 Aug 2009 at 19:47 UTC
I got this error after updating.
user warning: Unknown column 'blocks.module' in 'where clause' query: DELETE FROM drup_blocks WHERE blocks.module = 'image_attach' AND blocks.delta = 0 in /home3/righteo7/public_html/sites/all/modules/image/contrib/image_attach/image_attach.install on line 123.
user warning: Duplicate column name 'weight' query: ALTER TABLE drup_image_attach ADD `weight` INT NOT NULL DEFAULT 0 in /home3/righteo7/public_html/includes/database.mysql-common.inc on line 298.
Comments
Comment #1
wibbla commentedand this error.
The following queries were executed
image_attach module
Update #6101
Failed: DELETE FROM {blocks} WHERE blocks.module = 'image_attach' AND blocks.delta = 0
Update #6102
ALTER TABLE {image_attach} DROP PRIMARY KEY
ALTER TABLE {image_attach} ADD PRIMARY KEY (nid, iid)
Failed: ALTER TABLE {image_attach} ADD `weight` INT NOT NULL DEFAULT 0
image module
Update #6103
UPDATE {permission} SET perm = 'access advanced_blog, administer advanced_blog, administer advanced forum, view forum statistics, send email advuser, add blip.fm account, create blog entries, delete any blog entry, delete own blog entries, edit any blog entry, edit own blog entries, access printer-friendly version, access administration pages, access brilliant_gallery, skip CAPTCHA, access comments, administer comments, post comments, post comments without approval, access site-wide contact form, view field_add_video, get any binary files, get own binary files, rate content, administer forums, create forum topics, delete any forum topic, delete own forum topics, edit own forum topics, have relationships with friendlist, access frontpage, create images, delete any images, delete own images, edit any images, edit own images, delete own images, view original images, access all images, access img_assist, access lastfm profile widgets, download original image, access lm_paypal_donate, view lm_paypal_all_donations, access content, load any node data, load own node data, access RDF data, search content, use advanced search, access service links, access services, view post access counter, subscribe to all content types, subscribe to blogs, subscribe to content, subscribe to content types, subscribe to taxonomy terms, administer files, select different theme, access udashboard, access udashboard add content page, access udashboard comments, access udashboard users, administer udashboard, upload files, view uploaded files, access user profiles, administer users, change own username, access user lists, administer user lists, delete any user, delete own user, get any user data, get own user data, update any user data, update own user data, administer userprotect, change own e-mail, change own password, access all views, view word count' WHERE rid = 4
UPDATE {permission} SET perm = 'access advanced_blog, add blip.fm account, create blog entries, delete own blog entries, edit own blog entries, access printer-friendly version, access brilliant_gallery, access comments, post comments, post comments without approval, access site-wide contact form, view field_add_video, get any binary files, get own binary files, rate content, create forum topics, delete any forum topic, delete own forum topics, edit any forum topic, edit own forum topics, have relationships with friendlist, access frontpage, create images, delete own images, edit own images, delete own images, view original images, access all images, access img_assist, access lastfm profile widgets, download original image, access lm_paypal_donate, access content, load any node data, load own node data, access RDF data, search content, use advanced search, access service links, access services, view post access counter, subscribe to all content types, subscribe to blogs, subscribe to content, subscribe to content types, subscribe to taxonomy terms, access udashboard, access udashboard add content page, access udashboard comments, access udashboard users, upload files, view uploaded files, access user profiles, access user lists, get own user data, update own user data, change own e-mail, change own password, access all views, view word count' WHERE rid = 5
Comment #2
joachim commentedThanks for taking the time to report this problem.
It's already been filed: #561686: alpha5 -> alpha6 database update 6101 error so marking this as a duplicate.