Download error - pic generated on the server

[PJ_56]

Hello,

Impossible to upload a picture,
I can choose a picture, add a category (i can see the picture file on my server) and after validation, i'v got thise message :

"Le fichier précédent n'a pas pu être placé"

"Vous avez placé tous les fichiers avec succès"

What can be the trouble

Thanks for your help

[Joachim Müller]

Do exactly as suggested in the upload troubleshooting section of the docs if you need help.

[PJ_56]

Ok, it would be a problem with ImageMagick.
Is imageMagick the only way to upload files ?

[Nibbler]

Imagemagick is not involved in uploading files. It is used to resize the images on the server. As explained in the documentation you must use either ImageMagick or GD. Try switching to GD2 if it is available.

[PJ_56]

(always with imagemagick) so now i've got this error when i upload a file :

While executing query "INSERT INTO cpg134_pictures (pid, aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, owner_name, title, caption, keywords, approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip) VALUES ('', '38', 'userpics/11042/', 'Etat_Espece_v3.pdf', '49523', '49523', '0', '0', '1169633602', '1042', 'Pierre-Jean SCHWALM','test', 'test', 'test', 'YES', 'tet', '', '', '', '142.187.10.119', '142.187.10.119')" on 0

mySQL error: Out of range value adjusted for column 'pid' at row 1

[Nibbler]

Update your gallery.

[PJ_56]

I can't....

Here is the select, problem is the 'pid'. If i delete it from the select it's ok !!!!

INSERT INTO cpg134_pictures (pid, aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, owner_name, title, caption, keywords, approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip) VALUES ('', '29', 'userpics/11042/', 'nidcolore~3.JPG', '60180', '80749', '640', '480', '1170076346', '1042', 'Pierre-Jean SCHWALM','nid coloré', '', '', 'YES', '', '', '', '', '142.187.10.119', '142.187.10.119')

pid is an autoincrement field, so why is it a problem in the select ?

please, send me an answer

[Nibbler]

I already gave you the answer - update your gallery. This is an old bug and was fixed long ago.

[PJ_56]

Upload.php file of cpg 1.4.10 is the same. so are you sure i have to update cpg ? I have modify some files to integer it in my intranet.... it won't be very easy to do that ;(

[Nibbler]

That's the drawback of modifying the script, you have to merge in your changes to the updates. The fix is in include/picmgmt.inc.php, not upload.php. Updating is mandatory, previous versions have bugs and security issues.