Jump to content


Photo

Driver error on publishing images


Upon clicking the "Finish / Publish" button a driver error is thrown, more strict mode ( sorry! :) ) stuff though:

Date: Wed, 08 Aug 2012 13:26:47 +0000
 Error: 1364 - Field 'image_id' doesn't have a default value
 IP Address: 127.0.0.1 - /_QA/333up/index.php?app=gallery&module=images&section=review&do=process

Status: Duplicate
Version: 5.0.0 Beta 1
Fixed In: 5.0.0 Beta 1


3 Comments

mySQL query error: INSERT INTO ibf_gallery_images (`image_member_id`,`image_album_id`,`image_category_id`,`image_caption`,`image_description`,`image_directory`,`image_masked_file_name`,`image_medium_file_name`,`image_original_file_name`,`image_file_name`,`image_file_size`,`image_file_type`,`image_approved`,`image_thumbnail`,`image_date`,`image_metadata`,`image_copyright`,`image_feature_flag`,`image_gps_show`,`image_gps_raw`,`image_gps_lat`,`image_gps_lon`,`image_loc_short`,`image_data`,`image_media`,`image_media_thumb`,`image_media_data`,`image_caption_seo`,`image_notes`,`image_privacy`,`image_parent_permission`) VALUES(14,0,3,'DSC00047','','gallery/category_3','gallery_14_3_277188.jpg','med_gallery_14_3_277188.jpg','','DSC00047.JPG',326489,'image/jpeg',1,1,1344432401,'a:0:{}','',0,0,'N;',0,0,'','a:1:{s:5:\"sizes\";a:5:{s:5:\"thumb\";a:2:{i:0;s:3:\"100\";i:1;s:3:\"100\";}s:8:\"original\";a:2:{i:0;i:1280;i:1;i:960;}s:6:\"medium\";a:2:{i:0;i:800;i:1;d:600;}s:5:\"small\";a:2:{i:0;i:240;i:1;d:180;}s:3:\"max\";a:2:{i:0;i:1280;i:1;i:960;}}}',0,'','N;','dsc00047','',0,',4,2,3,7,')

 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.

 | File																	   | Function																	  | Line No.		  |

 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|

 | C:\_Wamp\www\_QA\332up\admin\applications_addon\ips\gallery\sources\classes\gallery\upload.php| [db_main_mysql].insert													    | 1438			  |

 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 | C:\_Wamp\www\_QA\332up\admin\applications_addon\ips\gallery\modules_public\images\review.php| [gallery_upload].finish													   | 556			   |

 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 | C:\_Wamp\www\_QA\332up\admin\applications_addon\ips\gallery\modules_public\images\review.php| [public_gallery_images_review]._process									   | 51			    |

 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 | C:\_Wamp\www\_QA\332up\admin\sources\base\ipsController.php			    | [public_gallery_images_review].doExecute									  | 306			   |

 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
As requested: :)

CREATE TABLE `ibf_gallery_images` (
 `image_id` bigint(20) NOT NULL,
 `image_member_id` int(11) NOT NULL DEFAULT '0',
 `image_category_id` int(11) NOT NULL DEFAULT '0',
 `image_album_id` bigint(20) NOT NULL DEFAULT '0',
 `image_caption` varchar(255) NOT NULL,
 `image_description` text,
 `image_directory` varchar(255) DEFAULT NULL,
 `image_masked_file_name` varchar(255) DEFAULT NULL,
 `image_medium_file_name` varchar(255) DEFAULT NULL,
 `image_file_name` varchar(255) DEFAULT NULL,
 `image_file_size` int(11) NOT NULL DEFAULT '0',
 `image_file_type` varchar(50) DEFAULT NULL,
 `image_approved` tinyint(4) NOT NULL DEFAULT '0',
 `image_thumbnail` tinyint(4) NOT NULL DEFAULT '0',
 `image_views` int(11) NOT NULL DEFAULT '0',
 `image_comments` int(11) NOT NULL DEFAULT '0',
 `image_comments_queued` int(11) NOT NULL DEFAULT '0',
 `image_date` int(11) NOT NULL DEFAULT '0',
 `image_ratings_total` int(11) NOT NULL DEFAULT '0',
 `image_ratings_count` int(11) NOT NULL DEFAULT '0',
 `image_rating` int(11) NOT NULL DEFAULT '0',
 `image_pinned` tinyint(4) NOT NULL DEFAULT '0',
 `image_last_comment` int(11) NOT NULL DEFAULT '0',
 `image_media` tinyint(4) NOT NULL DEFAULT '0',
 `image_credit_info` text,
 `image_copyright` varchar(255) DEFAULT NULL,
 `image_metadata` text,
 `image_media_thumb` varchar(255) DEFAULT NULL,
 `image_notes` text,
 `image_caption_seo` varchar(255) NOT NULL,
 `image_media_data` text,
 `image_data` text NOT NULL,
 `image_privacy` int(1) NOT NULL DEFAULT '0',
 `image_parent_permission` varchar(255) NOT NULL DEFAULT '',
 `image_feature_flag` tinyint(4) NOT NULL DEFAULT '0',
 `image_gps_raw` text,
 `image_gps_lat` varchar(255) DEFAULT NULL,
 `image_gps_lon` varchar(255) DEFAULT NULL,
 `image_gps_show` tinyint(4) NOT NULL DEFAULT '0',
 `image_loc_short` text,
 `image_gps_latlon` varchar(255) DEFAULT '',
 `image_original_file_name` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`image_id`),
 KEY `member_id` (`image_member_id`),
 KEY `im_select` (`image_approved`,`image_privacy`,`image_member_id`,`image_date`),
 KEY `idate` (`image_date`),
 KEY `cmt_lookup` (`image_privacy`,`image_member_id`,`image_parent_permission`,`image_album_id`,`image_approved`,`image_last_comment`),
 KEY `album_id` (`image_album_id`,`image_approved`,`image_date`),
 KEY `image_feature_flag` (`image_feature_flag`,`image_date`),
 KEY `gb_select` (`image_approved`,`image_parent_permission`,`image_date`),
 KEY `lastcomment` (`image_last_comment`,`image_date`)
) ENGINE=MyISAM AUTO_INCREMENT=1351 DEFAULT CHARSET=latin1
Updating Fixed In to: 5.0.0 Beta 1
Updating Status to: Duplicate

-