Bug (DB Errors] Upload new Photos

[KristerSwe]

Uploading images make this errors for me

Also in beta 3

Database error in vBulletin 4.2.0:

Invalid SQL:

					INSERT INTO 
						dbtech_gallery_images 
				 		(
				 			instanceid, 
				 			userid, 
				 			albumid, 
				 			filename, 
				 			filetype, 
				 			dateline, 
				 			is_animated, 
				 			custom_data, 
				 			exif_data, 
				 			approved
				 		)
				 	VALUES
				 		(
				 			1, 
				 			1, 
				 			0, 
				 			'IMG_0471.JPG', 
				 			'jpg', 
				 			1340313952, 
				 			0, 
				 			'a:5:{s:4:\"Make\";s:5:\"Apple\";s:5:\"Model\";s:8:\"iPhone 4\";s:8:\"aperture\";s:5:\"f/2.8\";s:8:\"DateTime\";s:19:\"2012:05:24 13:33:37\";s:3:\"ISO\";i:80;}', 
				 			'a:6:{s:4:\"FILE\";a:6:{s:8:\"FileName\";s:10:\"php10C.tmp\";s:12:\"FileDateTime\";i:1340313952;s:8:\"FileSize\";i:2064807;s:8:\"FileType\";i:2;s:8:\"MimeType\";s:10:\"image/jpeg\";s:13:\"SectionsFound\";s:35:\"ANY_TAG, IFD0, THUMBNAIL, EXIF, GPS\";}s:8:\"COMPUTED\";a:8:{s:4:\"html\";s:26:\"width=\"2592\" height=\"1936\"\";s:6:\"Height\";i:1936;s:5:\"Width\";i:2592;s:7:\"IsColor\";i:1;s:17:\"ByteOrderMotorola\";i:1;s:15:\"ApertureFNumber\";s:5:\"f/2.8\";s:18:\"Thumbnail.FileType\";i:2;s:18:\"Thumbnail.MimeType\";s:10:\"image/jpeg\";}s:4:\"IFD0\";a:11:{s:4:\"Make\";s:5:\"Apple\";s:5:\"Model\";s:8:\"iPhone 4\";s:11:\"Orientation\";i:1;s:11:\"XResolution\";s:4:\"72/1\";s:11:\"YResolution\";s:4:\"72/1\";s:14:\"ResolutionUnit\";i:2;s:8:\"Software\";s:5:\"5.1.1\";s:8:\"DateTime\";s:19:\"2012:05:24 13:33:37\";s:16:\"YCbCrPositioning\";i:1;s:16:\"Exif_IFD_Pointer\";i:204;s:15:\"GPS_IFD_Pointer\";i:594;}s:9:\"THUMBNAIL\";a:6:{s:11:\"Compression\";i:6;s:11:\"XResolution\";s:4:\"72/1\";s:11:\"YResolution\";s:4:\"72/1\";s:14:\"ResolutionUnit\";i:2;s:21:\"JPEGInterchangeFormat\";i:890;s:27:\"JPEGInterchangeFormatLength\";i:7491;}s:4:\"EXIF\";a:24:{s:12:\"ExposureTime\";s:6:\"1/1774\";s:7:\"FNumber\";s:4:\"14/5\";s:15:\"ExposureProgram\";i:2;s:15:\"ISOSpeedRatings\";i:80;s:11:\"ExifVersion\";s:4:\"0221\";s:16:\"DateTimeOriginal\";s:19:\"2012:05:24 13:33:37\";s:17:\"DateTimeDigitized\";s:19:\"2012:05:24 13:33:37\";s:23:\"ComponentsConfiguration\";s:4:\"
\0\";s:17:\"ShutterSpeedValue\";s:10:\"18521/1716\";s:13:\"ApertureValue\";s:9:\"4281/1441\";s:15:\"BrightnessValue\";s:8:\"8413/860\";s:12:\"MeteringMode\";i:5;s:5:\"Flash\";i:16;s:11:\"FocalLength\";s:5:\"77/20\";s:15:\"SubjectLocation\";a:4:{i:0;i:1295;i:1;i:967;i:2;i:699;i:3;i:696;}s:15:\"FlashPixVersion\";s:4:\"0100\";s:10:\"ColorSpace\";i:1;s:14:\"ExifImageWidth\";i:2592;s:15:\"ExifImageLength\";i:1936;s:13:\"SensingMethod\";i:2;s:12:\"ExposureMode\";i:0;s:12:\"WhiteBalance\";i:0;s:16:\"SceneCaptureType\";i:0;s:9:\"Sharpness\";i:2;}s:3:\"GPS\";a:9:{s:14:\"GPSLatitudeRef\";s:1:\"N\";s:11:\"GPSLatitude\";a:3:{i:0;s:4:\"59/1\";i:1;s:8:\"1243/100\";i:2;s:3:\"0/1\";}s:15:\"GPSLongitudeRef\";s:1:\"E\";s:12:\"GPSLongitude\";a:3:{i:0;s:4:\"15/1\";i:1;s:8:\"3004/100\";i:2;s:3:\"0/1\";}s:14:\"GPSAltitudeRef\";s:1:\"\0\";s:11:\"GPSAltitude\";s:9:\"12323/683\";s:12:\"GPSTimeStamp\";a:3:{i:0;s:4:\"11/1\";i:1;s:4:\"33/1\";i:2;s:8:\"3773/100\";}s:18:\"GPSImgDirectionRef\";s:1:\"T\";s:15:\"GPSImgDirection\";s:8:\"13451/72\";}}', 
				 			0
				 		);

MySQL Error   : Unknown column 'exif_data' in 'field list'
Error Number  : 1054
Request Date  : Thursday, June 21st 2012 @ 11:25:52 PM
Error Date    : Thursday, June 21st 2012 @ 11:25:53 PM
Script        : http://www.xxx.com/dbtgallery.php?do=doaddimage
Referrer      : http://www.xx.com/dbtgallery.php?gal=gallery&do=add_image
IP Address    : 90.xx.xx.xx
Username      : Krister
Classname     : vB_Database
MySQL Version : 5.5.16

 

[Dylan]

ACP->Plugins & Products-> Product Manager

Edit the gallery product and set the version to 1.0.0b1

Then do the upgrade again. The field gets added with the 1.0.0b2 file, not sure why yours didn't get added.

 

[KristerSwe]

Yep, did what you suggested and all back on track again Thanks