Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
In admin/config/brilliant_gallery/manage, when trying to access a gallery folder, I get this error :
PDOException : in drupal_write_record() (line 7013 in /includes/common.inc)
Comments
Comment #1
Vacilando CreditAttribution: Vacilando commentedCannot reproduce the error. Does it also appear if you install 7.x-1.x-dev? Please let me know.
Comment #2
leelooch CreditAttribution: leelooch commentedSorry for the delay. I installed 7.x-1.x-dev then tried to update database but the update failed. It returned me this error :
and I'm still unable to manage my galleries.
Comment #3
Vacilando CreditAttribution: Vacilando commentedUsing PostgreSQL or MySQL? Windows or Linux?
Comment #4
leelooch CreditAttribution: leelooch commentedI'm using a Mysql database and the site is hosted on Linux.
Comment #5
McReall CreditAttribution: McReall commentedI am using latest MySQL and Apache under Debian, and got a similair message to #1614994: PDOException : in drupal_write_record() (line 7013 in /includes/common.inc). running update.php. This happened after the BG change log reported changing datetime to integer. The PDO query seems to have a missing value for datetime, which is not and integer...
Comment #6
darthf1 CreditAttribution: darthf1 commentedSame story here, got the message running update.php:
Comment #7
2faroffroad CreditAttribution: 2faroffroad commentedSame as 5 &6.
I reverted 1.3 however now I have scroll bars on some of the images... weird!
Comment #8
Eric Bullet CreditAttribution: Eric Bullet commentedUpdate #7204
Failed: PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'datetime' at row 1: INSERT INTO {brilliant_gallery_image_arrays} (hash, array, datetime) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( [:db_insert_placeholder_0] => 070a90dc69297ff05848efb1c536f7bb [:db_insert_placeholder_1] => a:4:{s:4:"imgp";s:26:"/gallery/PIC_9495retro.jpg";s:4:"imgw";s:4:"1000";s:4:"imgh";d:665;s:7:"imgcrop";s:2:"no";} [:db_insert_placeholder_2] => ) in brilliant_gallery_update_7204() (line 139 of ~/sites/all/modules/brilliant_gallery/brilliant_gallery.install).
Comment #9
therealmax CreditAttribution: therealmax commentedUpdate #7204 (7.x-1.6)
Failed: PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'datetime' at row 1: INSERT INTO {brilliant_gallery_image_arrays} (hash, array, datetime) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( [:db_insert_placeholder_0] => 00438c0f1917081fa5269bee2abf758d [:db_insert_placeholder_1] => a:4:{s:4:"imgp";s:37:"/gallerier/fastelavn2013/P2104012.jpg";s:4:"imgw";d:150;s:4:"imgh";s:3:"200";s:7:"imgcrop";s:3:"yes";} [:db_insert_placeholder_2] => ) i brilliant_gallery_update_7204() (linje 139 af sites/all/modules/brilliant_gallery/brilliant_gallery.install).
Installed 7.x-1.5 without problems.
Comment #10
Boletus CreditAttribution: Boletus commentedPDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'datetime' at row 1: INSERT INTO {brilliant_gallery_image_arrays} (hash, array, datetime) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( [:db_insert_placeholder_0] => 00485ecdc4e4174addefaa10317b4732 [:db_insert_placeholder_1] => a:4:{s:4:"imgp";s:91:"/brilliant_gallery_temp/bg_picasa_orig_c8aa010d008d35cd0af49fe95d7de0e6/2011_05_05_1020.jpg";s:4:"imgw";s:3:"130";s:4:"imgh";s:3:"130";s:7:"imgcrop";s:3:"yes";} [:db_insert_placeholder_2] => ) in brilliant_gallery_update_7204() (line 139 of
Updated to 7.x-1.6
Comment #11
Boletus CreditAttribution: Boletus commentedI tried to downgrade to 7.x-1.5, exchanging the files in the brilliant gallery folder under modules. I run update.php. The database script for the failed 7.x-1.6 update still runs and the error message still shows. Can this be remedied?
Comment #12
Boletus CreditAttribution: Boletus commentedStill the same error message. Status report states that the database need to be upgraded. It's Brilliant Gallery, and the update fails every time.
Comment #13
Max2505 CreditAttribution: Max2505 commentedGot the same problem using 7.x-1.8+0-dev
I have 2 directories that are working fine, the third one gives me the PDO exception for line 7239.
PDOException: in drupal_write_record() (line 7239 of
/includes/common.inc).
Update: Found my problem, there were special html characters in my filenames, causing this issue.
Comment #14
apadernoI am removing the issue tags used from very few issues. I apologize for bumping this issue.