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

Vacilando’s picture

Status:Active» Postponed (maintainer needs more info)

Cannot reproduce the error. Does it also appear if you install 7.x-1.x-dev? Please let me know.

leelooch’s picture

Sorry for the delay. I installed 7.x-1.x-dev then tried to update database but the update failed. It returned me this error :

brilliant_gallery module
Update #7201

    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] => 041bffc33e48e7e7154a153b4b198448 [:db_insert_placeholder_1] => a:3:{s:4:"imgp";s:27:"/galleries/2009/Atelier.jpg";s:4:"imgw";s:3:"150";s:4:"imgh";d:100;} [:db_insert_placeholder_2] => ) dans brilliant_gallery_update_7201() (ligne 130 dans example.com/home/test/sites/all/modules/brilliant_gallery/brilliant_gallery.install).

and I'm still unable to manage my galleries.

Vacilando’s picture

Using PostgreSQL or MySQL? Windows or Linux?

leelooch’s picture

I'm using a Mysql database and the site is hosted on Linux.

McReall’s picture

Version:7.x-1.2» 7.x-1.4
Status:Postponed (maintainer needs more info)» Active
Issue tags:+confirming bug

I 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...

The following updates returned messages
brilliant_gallery module
Update #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] => 006f966af6f6159508bece428a18765b [:db_insert_placeholder_1] => a:4:{s:4:"imgp";s:98:"/local_gallery/brilliant_gallery_temp/bg_picasa_orig_7908b4a37f22b04ba972c95fe8c9c732/P9240103.JPG";s:4:"imgw";d:288;s:4:"imgh";d:384;s:7:"imgcrop";s:2:"no";} [:db_insert_placeholder_2] => ) brilliant_gallery_update_7204() függvényben (/var/www/mysite.hu/sites/all/modules/brilliant_gallery/brilliant_gallery.install 139 sor).

fcjversc’s picture

Same story here, got the message running update.php:

The following updates returned messages
brilliant_gallery module
Update #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] => 000a79db7246d625f2241c9ef3e99050 [:db_insert_placeholder_1] => a:4:{s:4:"imgp";s:84:"/brilliant_gallery_temp/bg_picasa_orig_fc299204d228f218366d60c0fd6b9563/DSC08899.JPG";s:4:"imgw";s:3:"150";s:4:"imgh";d:113;s:7:"imgcrop";s:2:"no";} [:db_insert_placeholder_2] => ) in brilliant_gallery_update_7204() (line 139 of /home/wwworg/xxx/sites/all/modules/brilliant_gallery/brilliant_gallery.install).

2faroffroad’s picture

Same as 5 &6.
I reverted 1.3 however now I have scroll bars on some of the images... weird!

Eric Bullet’s picture

Update #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).

therealmax’s picture

Update #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.

Boletus’s picture

Version:7.x-1.4» 7.x-1.6

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] => 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

Boletus’s picture

I 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?

Boletus’s picture

Still the same error message. Status report states that the database need to be upgraded. It's Brilliant Gallery, and the update fails every time.

Max2505’s picture

Issue summary:View changes

Got 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.