batch upload - works for small files, deletes bigger files batch upload - works for small files, deletes bigger files
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

batch upload - works for small files, deletes bigger files

Started by dragosionel, March 20, 2009, 04:59:06 AM

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.

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:
QuoteUSER:
------------------
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:
QuotePB : 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


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

Quote from: dragosionel on March 21, 2009, 03:04:08 AM
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. :)
Read Docs and Search the Forum before posting. - Soporte en español
--*--
Fabricio Ferrero's Website

Catching up! :)

Joachim Müller

Quote from: dragosionel on March 21, 2009, 03:04:08 AM
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.

Quote from: dragosionel on March 20, 2009, 07:41:41 PMThe 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