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

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.

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.

Using PostgreSQL or MySQL? Windows or Linux?

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

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

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

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

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

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.

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

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?

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.