Installed the fresh 4.7 img_assist module on 4.7cvs, but when uploading image i get:

• 	user warning: Unknown column 'list' in 'field list' query: INSERT INTO files (fid, nid, filename, filepath, filemime, filesize, list) VALUES (7, 19, '_original', 'images/engery-attitude-chart.jpg', 'image/jpeg', '78865', 0) in public_html/test-site/drupalcvs2/includes/database.mysql.inc on line 120.

reinstalled module and restored also sql table but problem persists...

thx

Comments

benshell’s picture

benshell commented

Are you able to create images with the image module (create content/image) without using img_assist? There have been some file structure changes that have affected the image module.

marcoBauli’s picture

marcoBauli commented
Title: Unknown column 'list' in 'field list' query » Altered table 'files'
Status: Active » Needs review

Tryed adding column 'list' to table 'files' with the following phpMyAdmin query: 

ALTER TABLE files ADD list tinyint(1) unsigned NOT NULL default '0';

seems to work, still not being a tech would appreciate any confirm please

marcoBauli’s picture

marcoBauli commented
Title: Altered table 'files' » Unknown column 'list' in 'field list' query » Altered table 'files'

ups, changed the title sorry

Yes, happened also creating image with image.module upload.

Now with altered table seems to work: no errors and images are displayed.

Still I get the alert The selected file /home/kiteatla/public_html/test-site/drupalcvs2/files could not be copied

Superfast answer bytheway :]

moscow-tyger’s picture

moscow-tyger commented

I'm seeing this in the base image module (cvs version) against Drupal 4.7 RC1

benshell’s picture

benshell commented
Category: bug » support
Status: Needs review » Active

Once again, these are problems with the image.module, NOT img_assist. I do not recommend changing your database structure to avoid this error. Please see the image module project page for details on this issues.

moscow-tyger’s picture

moscow-tyger commented

To be precise, see this patch for a workaround, currently, and a solution later.

deekayen’s picture

deekayen commented
Project: Image Assist » Image
Version: 6.x-3.x-dev » 6.x-1.x-dev
Component: Code » image.module
Status: Active » Closed (duplicate)

http://drupal.org/node/50889