batch upload - works for small files, deletes bigger files

[dragosionel]

I have a Coppermine Photo Gallery 1.4.18 that I installed using Fantastico

I purchased a hosting plan with 1and1.com and copied the whole archive, changed the configuration. Everything works fine, except batch upload which works for some jpg and for other doesn't. I couldn't find a logic. For example I have 2 files around 1.5M, for one works for one doesn't. If I change the size to 25% to the one that does not work, it works fine.

For the files that it does not work, the batch process deletes them and the error is PB

I created one file using MS Paint and batch upload works fine even for a 3M file.

Here is the photo that is not working: http://www.shrimataji.net/photos/albums/uploads/2009/temp/Florida2009.jpg

Thanks in advance

Here are the logs:

USER:
------------------
Array
(
    [ID] => 62951e7167e2562218c8eb62f351d32c
    [am] => 1
    [lang] => english
    [lap] => 1
    [liv] => Array
        (
        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => admin
    [groups] => Array
        (
           

• => 1
          )
  
      [disk_max] => 0
      [disk_min] => 0
      [can_rate_pictures] => 1
      [can_send_ecards] => 1
      [ufc_max] => 3
      [ufc_min] => 3
      [custom_user_upload] => 1
      [num_file_upload] => 5
      [num_URI_upload] => 3
      [can_post_comments] => 0
      [can_upload_pictures] => 1
      [can_create_albums] => 1
      [has_admin_access] => 1
      [pub_upl_need_approval] => 0
      [priv_upl_need_approval] => 0
      [group_name] => Administrators
      [upload_form_config] => 3
      [group_quota] => 0
      [can_see_all_albums] => 1
      [group_id] => 1
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content, player FROM cpg_filetypes; (0s)
      [1] => select * from cpg_plugins order by priority asc; (0s)
      [2] => delete from `db279995084`.cpg_sessions where time<1237516202 and remember=0; (0.001s)
      [3] => delete from `db279995084`.cpg_sessions where time<1236310202; (0s)
      [4] => select user_id from `db279995084`.cpg_sessions where session_id = 'a69fd7df3f1495179b997c1701e459f3' (0.001s)
      [5] => select user_id as id, user_password as password from `db279995084`.cpg_users where user_id=1 (0s)
      [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `db279995084`.cpg_users AS u INNER JOIN `db279995084`.cpg_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
      [7] => SELECT user_group_list FROM `db279995084`.cpg_users AS u WHERE user_id='1' and user_group_list <> ''; (0s)
      [8] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg_usergroups WHERE group_id in (1) (0s)
      [9] => SELECT group_name FROM  cpg_usergroups WHERE group_id= 1 (0s)
      [10] => update `db279995084`.cpg_sessions set time='1237519802' where session_id = 'a69fd7df3f1495179b997c1701e459f3' (0.001s)
      [11] => SELECT user_favpics FROM cpg_favpics WHERE user_id = 1 (0.003s)
      [12] => DELETE FROM cpg_banned WHERE expiry < '2009-03-20 03:30:02' (0.008s)
      [13] => SELECT * FROM cpg_banned WHERE (ip_addr='173.33.158.21' OR ip_addr='173.33.158.21' OR user_id=1) AND brute_force=0 (0.008s)
      [14] => SELECT aid, title FROM cpg_albums WHERE 1 (0.001s)
      [15] => SELECT COUNT(*) FROM cpg_pictures WHERE approved = 'NO' (0.008s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
      [insert] => 1
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
      [d0000] => 343
      [pics] => Array
          (
             
• => i0000
          )
  
      [album_lb_id_i0000] => d0000
      [picfile_i0000] => dXBsb2Fkcy8yMDA5L3RlbXAvRGFsbGFzMjAwOV8uanBn
      [insert] => Insert selected files
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 4.4.9 - OK
  ------------------
  mySQL version: 5.0.67-log
  ------------------
  Coppermine version: 1.4.18(stable)
  ==========================
  Module: GD
  ------------------
  GD Version: bundled (2.0.28 compatible)
  FreeType Support: 1
  FreeType Linkage: with freetype
  T1Lib Support:
  GIF Read Support: 1
  GIF Create Support: 1
  JPG Support: 1
  PNG Support: 1
  WBMP Support: 1
  XBM Support: 1
  JIS-mapped Japanese Font Support:
  
  ==========================
  Module: mysql
  ------------------
  MySQL Supportenabled
  Active Persistent Links 0
  Active Links 1
  Client API version 5.0.67
  MYSQL_MODULE_TYPE external
  MYSQL_SOCKET /var/run/mysqld/mysqld.sock
  MYSQL_INCLUDE -I/usr//include/mysql
  MYSQL_LIBS -L/usr//lib -lmysqlclient 
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Compiled Version 1.2.3
  Linked Version 1.2.3
  ==========================
  Server restrictions (safe mode)?
  ------------------
  Directive | Local Value | Master Value
  safe_mode | Off | Off
  safe_mode_exec_dir | /usr/local/php/bin | /usr/local/php/bin
  safe_mode_gid | Off | Off
  safe_mode_include_dir | no value | no value
  safe_mode_exec_dir | /usr/local/php/bin | /usr/local/php/bin
  sql.safe_mode | Off | Off
  disable_functions | no value | no value
  file_uploads | On | On
  include_path | .:/usr/lib/php | .:/usr/lib/php
  open_basedir | no value | no value
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value
  sendmail_from | no value | no value
  sendmail_path | /usr/sbin/sendmail -t -i  | /usr/sbin/sendmail -t -i
  SMTP | localhost | localhost
  smtp_port | 25 | 25
  ==========================
  Size and Time
  ------------------
  Directive | Local Value | Master Value
  max_execution_time | 50000 | 50000
  max_input_time | -1 | -1
  upload_max_filesize | 20M | 20M
  post_max_size | 8M | 8M
  ==========================
  Page generated in 0.305 seconds - 16 queries in 0.031 seconds - Album set : ; Meta set: ;
  

[Hein Traag]

" I have a Coppermine Photo Gallery 1.4.18 that I installed using Fantastico" <-- two mistakes right there. One is using Fantastico, which is just plain crap. Which leads to number two which is the version number. As usual Fantastico is running behind.. the current stable and secure version is 1.4.21.

Upgrade first. And upgrade now, if you want your cpg to be secure.

A quote from the documentation:

PB : means that the file could not be added, check your configuration and the permission of directories where the files are located

. Check that and check with your hoster what the maximum allowed size is for uploading files.

[dragosionel]

I upgraded, no change.

The file size is not a problem as for some files of 1.5M, it works and for others of 1.5M fails.

I did notice that for those that work, the conversion take a long time. Is there a time out limit for ImageMagick? Is it possible that for some files it take longer and that is why it fails.

Appreciate your help!

[Hein Traag]

Switch to GD2 (which is the prefered method).

[dragosionel]

I did that and it works only for the small files but crashes for bigger files with the following

Fatal error: Out of memory (allocated 34865152) (tried to allocate 2549 bytes) in /homepages/23/d240298474/htdocs/shrimatajinet/photos/include/picmgmt.inc.php on line 262

The memory for PHP is 80M and there would be no reason to crash when it is processing a 3M file.

I open a ticket with the provider 1and1 and wait for the feedback.

If you have any other suggestions, please let me know.

Thanks a lot

[dragosionel]

I got a reply from 1and1:

Due to resource limits on our Shared Hosting machines, it is not
possible to allocate more than 20M of memory to PHP, although phpinfo()
may report a higher number. You will be unable to increase the memory
usage limit with a php.ini file.

More information..
http://faq.1and1.com/scripting_languages_supported/php/16.html

which translated means, 1and1.com cannot host Coppermine Galleries 

[Fabricio Ferrero]

which translated means, 1and1.com cannot host Coppermine Galleries 

Change of hosting company as I did when they told me almost the same as they said to you.

[Joachim Müller]

which translated means, 1and1.com cannot host Coppermine Galleries 

That's nonsense. Coppermine runs fine on 1and1-driven servers. You just mustn't upload files that are so incredibly huge. That's a waste of resources, trying to make the server resize the pics is a job that your client can do much better.

The memory for PHP is 80M and there would be no reason to crash when it is processing a 3M file.

I doubt that you'll get that much memory on shared hosting. You'd have to rent a dedicated server for that, which seems a bit off. Why don't you resize on the client instead of trying to make the server do a job that is was never designed for.

[dragosionel]

great suggestions, thanks