Ok,
after trying to get cpg1.3 working, but receiving strange errors during the file upload (http://forum.coppermine-gallery.net/index.php?topic=6120.0, still sorry about that blunder ;D), I downgraded to cpg1.2.1. However, I still get the same errors. I realize that this means that it is probably not a problem with coppermine that I am facing, but I am hoping that someone here can point me in the right direction.
This is the error that I get using single file upload on about 80% of my jpg files:
ERROR
The requested URL could not be retrieved
--------------------------------------------------------------------------------
While trying to retrieve the URL: http://62.195.120.83/cpg121web/db_input.php
The following error was encountered:
Write Error
The system returned:
(32) Broken pipeAn error condition occurred while writing to the network. Please retry your request.
Any takers?
you can try to upload pictures yourself using at http://62.195.120.83/cpg121web/ using user test and password testing.
My Debug info:
USER:
Array
(
[ID] => d42b24144f751032db4cf4b2485baf75
[am] => 1
[liv] => Array
(
- => 54
[1] => 62
[2] => 60
[3] => 65
[4] => 1
)
[sort] => da
[theme] => default
[lang] => english
)
USER DATA:
Array
(
- => 1
[user_id] => 1
[1] => 1
[user_group] => 1
[2] => YES
[user_active] => YES
[3] => root
[user_name] => root
[4] => Klomp3
[5] => 2004-05-12 13:16:53
[user_lastvisit] => 2004-05-12 13:16:53
[6] => 2004-05-12 13:16:53
[user_regdate] => 2004-05-12 13:16:53
[7] =>
[user_lang] =>
[8] =>
[user_email] =>
[9] =>
[user_website] =>
[10] =>
[user_location] =>
[11] =>
[user_interests] =>
[12] =>
[user_occupation] =>
[13] =>
[user_actkey] =>
[14] => 1
[group_id] => 1
[15] => Administrators
[group_name] => Administrators
[16] => 0
[group_quota] => 0
[17] => 1
[has_admin_access] => 1
[18] => 1
[can_rate_pictures] => 1
[19] => 1
[can_send_ecards] => 1
[20] => 1
[can_post_comments] => 1
[21] => 1
[can_upload_pictures] => 1
[22] => 1
[can_create_albums] => 1
[23] => 0
[pub_upl_need_approval] => 0
[24] => 0
[priv_upl_need_approval] => 0
)
Queries:
Array
(
- => SELECT * FROM cpg11d_users, cpg11d_usergroups WHERE user_group = group_id AND user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '************'
[1] => DELETE FROM cpg11d_banned WHERE expiry < 1084368326
[2] => SELECT * FROM cpg11d_banned WHERE ip_addr='194.171.252.100' OR ip_addr='unknown' OR user_id=1
[3] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '' ORDER BY pos
[4] => SELECT aid FROM cpg11d_albums WHERE category >= 10000
[5] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category >= 10000
[6] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '1' ORDER BY pos
[7] => SELECT count(*) FROM cpg11d_albums WHERE 1
[8] => SELECT count(*) FROM cpg11d_pictures WHERE 1
[9] => SELECT count(*) FROM cpg11d_comments WHERE 1
[10] => SELECT count(*) FROM cpg11d_categories WHERE 1
[11] => SELECT sum(hits) FROM cpg11d_pictures WHERE 1
[12] => SELECT count(*) FROM cpg11d_albums WHERE category = ''
[13] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON thumb=pid WHERE category = '' ORDER BY pos LIMIT 0,1
[14] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg11d_pictures WHERE aid IN (1) AND approved = 'YES' GROUP BY aid
[15] => SELECT COUNT(*) from cpg11d_pictures WHERE approved = 'YES'
[16] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid FROM cpg11d_pictures WHERE approved = 'YES' ORDER BY RAND() LIMIT 8
[17] => SELECT COUNT(*) from cpg11d_pictures WHERE approved = 'YES'
[18] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, owner_id, owner_name, aid FROM cpg11d_pictures WHERE approved = 'YES' ORDER BY pid DESC LIMIT 0 ,8
)
GET :
Array
(
)
POST :
Array
(
)
What are the file sizes on those JPEGS?
Quote from: hyperion on May 12, 2004, 05:52:46 PM
What are the file sizes on those JPEGS?
These are typically pictures that I made myself with my 4 megapixel camera: between 1 and 2 MB per file.
These are the settings that I use related to the size of the uploads:
max_execution_time 30 30
max_input_time 60 60
upload_max_filesize 8M 8M
post_max_size 8M 8M
The problem is probably one of the pics being to big. This is not a coppermine problem, but a one of the image lib program (Imagemagick/GD), which requires huge memory resourses to deal with pics of large pixel size (this is regardless of jpeg quality settings).
Try making them smaller, say 1000 x 750, but with high quality.
Memory errors usually give a specific error message, but the memory limit could also break uploads in this case if it was unusually low. I'm betting that this is either a truncation issue caused by the setting for PHPLimitRequestBody (usually found in /etc/http/conf.d), or it is a case of an input timeout. 60 seconds may not be enough time for your files to load over your connection, and the script will not parse if you exceed this time limit.
Quote from: hyperion on May 13, 2004, 02:35:13 AM
Memory errors usually give a specific error message, but the memory limit could also break uploads in this case if it was unusually low. I'm betting that this is either a truncation issue caused by the setting for PHPLimitRequestBody (usually found in /etc/http/conf.d), or it is a case of an input timeout. 60 seconds may not be enough time for your files to load over your connection, and the script will not parse if you exceed this time limit.
As the error occurs immediatly, I ruled out the time-out option. Then I looked into the settings for LimitRequestBody and found it to be set at 0.5MB. I upped it to 4 and now everything is working just fine!
Thanks!