mm_media: Gallery thumb_deriv error

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

mm_media: Gallery thumb_deriv error

Hilary Caws-Elwitt

In our instances, when creating a new Gallery node, using link mode (“Show a link that opens a popup window”) errors out and doesn’t write to the DB. The log shows:

PDOException: SQLSTATE[HY000]: General error: 1364 Field 'thumb_deriv' doesn't have a default value: INSERT INTO {mm_media_gallery} (nid, vid, mode, link_text, grid_cols, grid_rows, final_deriv, flow_per_page, single_start, show_title, show_comment, show_caption) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11); Array ( [:db_insert_placeholder_0] => 93582 [:db_insert_placeholder_1] => 282118 [:db_insert_placeholder_2] => link [:db_insert_placeholder_3] => View the Image Gallery [:db_insert_placeholder_4] => 5 [:db_insert_placeholder_5] => 5 [:db_insert_placeholder_6] => fci_thumbnail [:db_insert_placeholder_7] => 20 [:db_insert_placeholder_8] => first [:db_insert_placeholder_9] => 1 [:db_insert_placeholder_10] => 1 [:db_insert_placeholder_11] => 1 ) in drupal_write_record() (line 7207 of /var/www/html/beta-htmLawed-20140806/.drupal-core/includes/


Changing an existing gallery’s setting doesn’t cause a problem because thumb_deriv has already been set, but the form for link mode doesn’t explicitly set a value. Apparently MySQL strict_all_tables mode is the default for D7, thereby causing the error? Is anyone else experiencing this issue?


Hilary Caws-Elwitt

IT Analyst - Five Colleges, Inc. -

97 Spring St, Amherst MA 01002

[hidden email] - 413-542-4022



You are currently subscribed to monster_menus as: [hidden email].

To unsubscribe click here:

(It may be necessary to cut and paste the above URL if the line is broken)

or send a blank email to [hidden email]