this is I get when I try to upload pictures

user warning: Field 'fid' doesn't have a default value query: INSERT INTO x_album (pid, data) VALUES (1, 'a:14:{s:9:\"viewpager\";s:2:\"10\";s:10:\"imageorder\";s:14:\"timestamp|desc\";s:14:\"list_imagesize\";s:7:\"240x180\";s:14:\"view_imagesize\";s:7:\"640x480\";s:5:\"slide\";s:7:\"640x480\";s:12:\"page_display\";s:1:\"1\";s:12:\"page_viewnum\";s:2:\"10\";s:14:\"page_imagesize\";s:5:\"thumb\";s:10:\"page_slide\";s:7:\"640x480\";s:3:\"pid\";N;s:14:\"teaser_display\";s:1:\"1\";s:14:\"teaser_viewnum\";s:1:\"5\";s:16:\"teaser_imagesize\";s:5:\"thumb\";s:12:\"teaser_slide\";s:7:\"640x480\";}') in D:\temp\drupal\modules\photos\photos.module on line 428.

Comments

eastcn’s picture

eastcn commented

Please upgrade the database.

radiofranky2009’s picture

radiofranky2009 commented

Hi,
I have update the database with "update.php" but everytime I create an album. it displays the following error message and no photos will show although it says uploaded ok.

user warning: Field 'fid' doesn't have a default value query: INSERT INTO x_album (pid, data) VALUES (5, 'N;') in D:\temp\drupal\modules\photos\photos.module on line 428.

By the way, is there a way to create a bottom once the upload has been completed? Because users might not know what to do after the upload finishes. Thanks

eastcn’s picture

eastcn commented

photos.module line 428 Change：


db_query("INSERT INTO {x_album} (pid, data, fid) VALUES (%d, '%s', 0)", $node->nid, serialize($node->album));
radiofranky2009’s picture

radiofranky2009 commented

thanks. I noticed that mysql 5.1.31 has issue with table. What about version 5.1.32?

radiofranky2009’s picture

radiofranky2009 commented

thanks. but after a fresh install I'm getting this error message

user warning: Field 'count' doesn't have a default value query: INSERT INTO x_album (pid, data, fid) VALUES (4, 'a:9:{s:9:\"viewpager\";s:2:\"10\";s:10:\"imageorder\";s:14:\"timestamp|desc\";s:14:\"list_imagesize\";s:7:\"100x100\";s:14:\"view_imagesize\";s:7:\"640x480\";s:5:\"slide\";s:7:\"640x480\";s:14:\"teaser_display\";s:1:\"1\";s:14:\"teaser_viewnum\";s:1:\"5\";s:16:\"teaser_imagesize\";s:7:\"100x100\";s:12:\"teaser_slide\";s:7:\"640x480\";}', 0) in D:\temp\drupal\modules\photos\photos.module on line 428.

radiofranky2009’s picture

radiofranky2009 commented

Hi,
I still can't upload with flash based uploader. It gives me error 500 and wont' upload.

one thing I noticed that on Vista your module works ok, but on xp is not.

eastcn’s picture

eastcn commented

Please check the flash version, ver > 9.

zyme’s picture

zyme commented
Title: after updating to 6.x-2.6-beta2, i can't upload pictures anymore » ALTER TABLE `x_album`...

ALTER TABLE `x_album` CHANGE `fid` `fid` INT( 10 ) NOT NULL DEFAULT '0',
CHANGE `count` `count` INT( 11 ) NOT NULL DEFAULT '0'

nathaniel’s picture

nathaniel commented

...

nathaniel’s picture

nathaniel commented
Status: Active » Closed (fixed)