:::
社大學員專用
Tad Gallery電子相簿 問題.請教.求救
TAD老師我裝了Tad Gallery電子相簿 但在上傳圖片要送出後卻出現以下亂碼
無法上傳.這是怎麼了呢?我是Powered by XOOPS 2.2.4 © 2001-2008 The XOOPS Project版本. 麻煩TAD老師幫我解答.感激不盡
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1insert into pF06v_tad_gallery (`csn`,`title`,`description`,`filename`,`size`,`type`,`width`,`height`,`dir`,`uid`,`post_date`,`counter`,`exif`) values('2','1','1','L1650548-1.jpg','167420','image/pjpeg','600','863','2007_06_29','1',now(),'0','[VerboseOutput]=0||[Errors]=0||[ValidJpeg]=1||[ValidIPTCData]=0||[ValidJFIFData]=1||[ValidEXIFData]=1||[ValidAPP2Data]=0||[ValidCOMData]=0||[JFIF][Size]=16||[JFIF][Data]=JFIFHH||[JFIF][Identifier]=JFIF||[JFIF][ExtensionCode]=02||[APP1Size]=3970||[Endien]=Intel||[IFD0NumTags]=11||[IFD0][Make]=LEICA||[IFD0][Model]=D-LUX 3||[IFD0][Orientation]=Normal (O deg)||[IFD0][xResolution]=72 dots per ResolutionUnit||[IFD0][yResolution]=72 dots per ResolutionUnit||[IFD0][ResolutionUnit]=Inch||[IFD0][Software]=Adobe Photoshop 7.0||[IFD0][DateTime]=2007:08:03 04:08:16||[IFD0][YCbCrPositioning]=Datum Point||[IFD0][unknown:c4a5]=PrintIM0250d ' '?'?' '^''?'?'||[IFD0][ExifOffset]=424||[IFD1Offset]=912||[SubIFDNumTags]=32||[SubIFD][ExposureTime]=1/30 sec||[SubIFD][FNumber]=f 3.2||[SubIFD][ExposureProgram]=Program||[SubIFD][ISOSpeedRatings]=100||[SubIFD][ExifVersion]=version 2.21||[SubIFD][DateTimeOriginal]=2007:06:29 22:32:27||[SubIFD][DateTimedigitized]=2007:06:29 22:32:27||[SubIFD][ComponentsConfiguration]=YCbCr||[SubIFD][CompressedBitsPerPixel]=4||[SubIFD][ExposureBiasValue]=0 EV||[SubIFD][MaxApertureValue]=f 2.8||[SubIFD][MeteringMode]=Spot||[SubIFD][LightSource]=Unknown: 4||[SubIFD][Flash]=Compulsory Flash||[SubIFD][FocalLength]=9.3 mm||[SubIFD][FlashPixVersion]=version 1||[SubIFD][ColorSpace]=sRGB||[SubIFD][ExifImageWidth]=600 pixels||[SubIFD][ExifImageHeight]=863 pixels||[SubIFD][SensingMethod]=Unknown: One Chip Color Area Sensor||[SubIFD][FileSource]=Digital Still Camera||[SubIFD][SceneType]=Directly Photographed||[SubIFD][CustomerRender]=0||[SubIFD][ExposureMode]=0||[SubIFD][WhiteBalance]=0||[SubIFD][DigitalZoomRatio]=0||[SubIFD][unknown:a405]=41||[SubIFD][SceneCaptureMode]=0||[SubIFD][GainControl]=0||[SubIFD][Contrast]=2||[SubIFD][Saturation]=2||[SubIFD][Sharpness]=2||[IFD1NumTags]=6||[IFD1][Compression]=Jpeg Compression||[IFD1][xResolution]=72 dots per ResolutionUnit||[IFD1][yResolution]=72 dots per ResolutionUnit||[IFD1][ResolutionUnit]=Inch||[IFD1][JpegIFOffset]=1006||[IFD1][JpegIFByteCount]=2956||')
若這個頁面沒有自動重新載入, 請點按 這裡
無法上傳.這是怎麼了呢?我是Powered by XOOPS 2.2.4 © 2001-2008 The XOOPS Project版本. 麻煩TAD老師幫我解答.感激不盡
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1insert into pF06v_tad_gallery (`csn`,`title`,`description`,`filename`,`size`,`type`,`width`,`height`,`dir`,`uid`,`post_date`,`counter`,`exif`) values('2','1','1','L1650548-1.jpg','167420','image/pjpeg','600','863','2007_06_29','1',now(),'0','[VerboseOutput]=0||[Errors]=0||[ValidJpeg]=1||[ValidIPTCData]=0||[ValidJFIFData]=1||[ValidEXIFData]=1||[ValidAPP2Data]=0||[ValidCOMData]=0||[JFIF][Size]=16||[JFIF][Data]=JFIFHH||[JFIF][Identifier]=JFIF||[JFIF][ExtensionCode]=02||[APP1Size]=3970||[Endien]=Intel||[IFD0NumTags]=11||[IFD0][Make]=LEICA||[IFD0][Model]=D-LUX 3||[IFD0][Orientation]=Normal (O deg)||[IFD0][xResolution]=72 dots per ResolutionUnit||[IFD0][yResolution]=72 dots per ResolutionUnit||[IFD0][ResolutionUnit]=Inch||[IFD0][Software]=Adobe Photoshop 7.0||[IFD0][DateTime]=2007:08:03 04:08:16||[IFD0][YCbCrPositioning]=Datum Point||[IFD0][unknown:c4a5]=PrintIM0250d ' '?'?' '^''?'?'||[IFD0][ExifOffset]=424||[IFD1Offset]=912||[SubIFDNumTags]=32||[SubIFD][ExposureTime]=1/30 sec||[SubIFD][FNumber]=f 3.2||[SubIFD][ExposureProgram]=Program||[SubIFD][ISOSpeedRatings]=100||[SubIFD][ExifVersion]=version 2.21||[SubIFD][DateTimeOriginal]=2007:06:29 22:32:27||[SubIFD][DateTimedigitized]=2007:06:29 22:32:27||[SubIFD][ComponentsConfiguration]=YCbCr||[SubIFD][CompressedBitsPerPixel]=4||[SubIFD][ExposureBiasValue]=0 EV||[SubIFD][MaxApertureValue]=f 2.8||[SubIFD][MeteringMode]=Spot||[SubIFD][LightSource]=Unknown: 4||[SubIFD][Flash]=Compulsory Flash||[SubIFD][FocalLength]=9.3 mm||[SubIFD][FlashPixVersion]=version 1||[SubIFD][ColorSpace]=sRGB||[SubIFD][ExifImageWidth]=600 pixels||[SubIFD][ExifImageHeight]=863 pixels||[SubIFD][SensingMethod]=Unknown: One Chip Color Area Sensor||[SubIFD][FileSource]=Digital Still Camera||[SubIFD][SceneType]=Directly Photographed||[SubIFD][CustomerRender]=0||[SubIFD][ExposureMode]=0||[SubIFD][WhiteBalance]=0||[SubIFD][DigitalZoomRatio]=0||[SubIFD][unknown:a405]=41||[SubIFD][SceneCaptureMode]=0||[SubIFD][GainControl]=0||[SubIFD][Contrast]=2||[SubIFD][Saturation]=2||[SubIFD][Sharpness]=2||[IFD1NumTags]=6||[IFD1][Compression]=Jpeg Compression||[IFD1][xResolution]=72 dots per ResolutionUnit||[IFD1][yResolution]=72 dots per ResolutionUnit||[IFD1][ResolutionUnit]=Inch||[IFD1][JpegIFOffset]=1006||[IFD1][JpegIFByteCount]=2956||')
若這個頁面沒有自動重新載入, 請點按 這裡
這是因為您相片中有中文或特殊字元，目前需要以批次上傳的方式處理，就OK了。下一版老師應該會修正的！
補充：是相片中的 EXIF 資訊有特殊字元的關係
