While trying to upload an image from /people/avatar_selection/upload I get the following error.

PDOException: SQLSTATE[HY000]: General error: 1364 Field 'fid' doesn't have a default value: INSERT INTO {avatar_selection} (avatar, name, weight) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( [:db_insert_placeholder_0] => user_2_avatar.png [:db_insert_placeholder_1] => user_2_avatar.png [:db_insert_placeholder_2] => 0 ) in _avatar_selection_save_avatar_info() (line 790 of C:\xampp\htdocs\drupal7\sites\all\modules\avatar_selection\avatar_selection.admin.inc).

This is on Windows XP with XAMPP 1.7.3 and Drupal 7.0, 2011-01-05

Comments

santam’s picture

santam commented

Subscribe .. gettting the same error here with a LAMP setup and latest drupal 7.8

dureaghin’s picture

dureaghin commented

Subscribe ...

cpasticcio82’s picture

cpasticcio82 commented

Subscribe.... same behaviour here with Drupal 7.8 on XAMPP

skizzo’s picture

skizzo commented
Title: Unab;e to upload avatar » PDOException when uploading/scanning avatars

I get the same error when uploading avatars manually and then requesting an avatar scan

sw3b’s picture

sw3b commented

Same here !

skizzo’s picture

skizzo commented

has anybody found a fix for this blocking error? Avatar_selection was working
nicely on D6, now I would like to move into D7 but I can't make AS work on D7,
and have found no substitute for it.

mcferren’s picture

mcferren commented

getting the same error

Imper1um’s picture

Imper1um commented

You can fix this by changing the column "fid" to "null" instead of "not null".

I haven't had any issues when I do that.

burgs’s picture

burgs commented

I'm not sure if #8 broke it, or if it never worked, but editing your profile and choosing an avatar doesn't work. ie. It doesn't stick.

stella’s picture

stella commented
Status: Active » Closed (duplicate)

Comment #8 solution isn't the right way about it. The patch from #1326854: D7 does not display anything (now committed) should fix this and other problems.