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

Vacilando CreditAttribution: Vacilando commented
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

leelooch CreditAttribution: leelooch commented

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

Vacilando CreditAttribution: Vacilando commented

Using PostgreSQL or MySQL? Windows or Linux?

leelooch’s picture

leelooch CreditAttribution: leelooch commented

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

McReall’s picture

McReall CreditAttribution: McReall commented
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).
darthf1’s picture

darthf1 CreditAttribution: darthf1 commented

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

2faroffroad CreditAttribution: 2faroffroad commented

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

Eric Bullet’s picture

Eric Bullet CreditAttribution: Eric Bullet commented

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

therealmax CreditAttribution: therealmax commented

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

Boletus CreditAttribution: Boletus commented
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

Boletus CreditAttribution: Boletus commented

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

Boletus CreditAttribution: Boletus commented

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

Max2505 CreditAttribution: Max2505 commented
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.

apaderno’s picture

apaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
CreditAttribution: apaderno as a volunteer commented
Issue tags: -confirming bug

I am removing the issue tags used from very few issues. I apologize for bumping this issue.