[Invalid]: Batch upload not working [Invalid]: Batch upload not working
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

[Invalid]: Batch upload not working

Started by gwertheim, December 28, 2009, 05:46:09 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

gwertheim

First off, I am unable to use the Browsable interface.

When I try to upload my 300+ pictures, the pictures all load and when I try to view them in the album i selected, and only one is uploaded

http://www.wertheimphotography.com/proofs

uname:tester
pass: tester





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

)

==========================
USER DATA:
------------------
Array
(
   [user_id] => 5
   [user_name] => tester
   [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] => 0
       [num_file_upload] => 5
       [num_URI_upload] => 3
       [can_post_comments] => 1
       [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; (0.001s)
       [1] => select * from cpg_plugins order by priority asc; (0s)
       [2] => delete from `wer0936008540021`.cpg_sessions where time<1261971856 and remember=0; (0s)
       [3] => delete from `wer0936008540021`.cpg_sessions where time<1260765856; (0s)
       [4] => select user_id from `wer0936008540021`.cpg_sessions where session_id = 'afbb3b04338a22c13534c8281a23b1c7' (0.001s)
       [5] => select user_id as id, user_password as password from `wer0936008540021`.cpg_users where user_id=5 (0.004s)
       [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 `wer0936008540021`.cpg_users AS u INNER JOIN `wer0936008540021`.cpg_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='5' (0s)
       [7] => SELECT user_group_list FROM `wer0936008540021`.cpg_users AS u WHERE user_id='5' 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 (0.001s)
       [10] => update `wer0936008540021`.cpg_sessions set time='1261975456' where session_id = 'afbb3b04338a22c13534c8281a23b1c7' (0.001s)
       [11] => SELECT user_favpics FROM cpg_favpics WHERE user_id = 5 (0s)
       [12] => DELETE FROM cpg_banned WHERE expiry < '2009-12-27 21:44:16' (0s)
       [13] => SELECT * FROM cpg_banned WHERE (ip_addr='173.33.194.104' OR ip_addr='173.33.194.104' OR user_id=5) AND brute_force=0 (0s)
       [14] => SELECT title, category FROM cpg_albums WHERE aid = '4' (0s)
       [15] => SELECT DISTINCT aid, title, IF(category = 0, CONCAT('> ', title), CONCAT(name,' < ',title)) AS cat_title FROM cpg_albums, cpg_categories WHERE category < '10000' AND (category = 0 OR category = cid) ORDER BY cat_title (0.001s)
       [16] => SELECT aid, title FROM cpg_albums WHERE category='10005'  OR category='10005' ORDER BY title (0.001s)
       [17] => SELECT count(*) FROM cpg_pictures WHERE aid = '4' (0s)
       [18] => SELECT p.*,a.category FROM cpg_pictures as p INNER JOIN cpg_albums as a ON a.aid=p.aid WHERE p.aid = '4' ORDER BY p.filename LIMIT 0, 25 (0.001s)
       [19] => SELECT COUNT(*) FROM cpg_pictures WHERE approved = 'NO' (0.001s)
       [20] => SELECT aid, title FROM cpg_albums WHERE category='10005'  ORDER BY title (0.001s)
    )

    ==========================
    GET :
    ------------------
    Array
    (
       [album] => 4
    )

    ==========================
    POST :
    ------------------
    Array
    (
    )

    ==========================
    VERSION INFO :
    ------------------
    PHP version: 5.2.5 - OK
    ------------------
    mySQL version: 5.0.67.d7-ourdelta-log
    ------------------
    Coppermine version: 1.4.25(stable)
    ==========================
    Module: GD
    ------------------
    GD Version: bundled (2.0.34 compatible)
    FreeType Support: 1
    FreeType Linkage: with freetype
    T1Lib Support: 1
    GIF Read Support: 1
    GIF Create Support: 1
    JPG Support: 1
    PNG Support: 1
    WBMP Support: 1
    XPM Support:
    XBM Support: 1
    JIS-mapped Japanese Font Support:

    ==========================
    Module: mysql
    ------------------
    MySQL Supportenabled
    Active Persistent Links 0
    Active Links 1
    Client API version 5.0.45
    ==========================
    Module: zlib
    ------------------
    ZLib Support enabled
    Stream Wrapper support compress.zlib://
    Stream Filter support zlib.inflate, zlib.deflate
    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 | no value | no value
    safe_mode_gid | Off | Off
    safe_mode_include_dir | no value | no value
    safe_mode_exec_dir | no value | no value
    sql.safe_mode | Off | Off
    disable_functions | no value | no value
    file_uploads | On | On
    include_path | .;C:\php5\pear | .;C:\php5\pear
    open_basedir | no value | no value
    ==========================
    email
    ------------------
    Directive | Local Value | Master Value
    sendmail_from | webmaster@secureserver.net | webmaster@secureserver.net
    sendmail_path | no value | no value
    SMTP | relay-hosting.secureserver.net | relay-hosting.secureserver.net
    smtp_port | 25 | 25
    ==========================
    Size and Time
    ------------------
    Directive | Local Value | Master Value
    max_execution_time | 30 | 30
    max_input_time | 60 | 60
    upload_max_filesize | 8M | 8M
    post_max_size | 8M | 8M
    ==========================
    Page generated in 0.173 seconds - 21 queries in 0.013 seconds - Album set : ; Meta set: ;

Joachim Müller

Quote from: gwertheim on December 28, 2009, 05:46:09 AM
First off, I am unable to use the Browsable interface.
That's a know issue - you're on an Windows-driven server, where the batch-add interface doesn't work, as suggested in http://www.wertheimphotography.com/proofs/docs/#known_issues and many threads on this forum. Fix is discussed there as well: don't use the browsable interface then - use the classic interface instead.

You have posted an admin account, which is a very silly thing to do on a public board and not what you're suppossed to do as per documentation (section "asking for support on upload issues"). I have changed that account's password. You better RTFM and think what you do in the future. And don't reply saying "it was a test gallery anyway" - I (or any malevolent user) could have left a backdoor behind on your server and return later at any time to take over your site. Posting an admin account is always silly.

Regular http uploads work as expected (see http://www.wertheimphotography.com/proofs/displayimage.php?pos=-6).
Batch-add works as expected as well (using the classic, non-browsable interface), see http://www.wertheimphotography.com/proofs/thumbnails.php?album=3

Marking thread as "invalid".

gwertheim

But when I try to upload all of my 300, I get only one or two uploaded at a time! Hell, it didn't even upload the first picture

My concerns are valid, Please do not dismiss them. I asked two different EXPERIENCED web developers to test this out and they got the same result as I did.

gwertheim

Here's what happened when I tried to upload only 10



Joachim Müller



Joachim Müller

#6
They have a notorious reputation for crippled webspace - see for yourself: search results for godaddy. Are you per chance using their pre-installed flavor of coppermine (I think they call it "value application")?
Your server is very slow, so it's not very surprising that it crashes with only a few files to batch-add. I was able to batch-add 10 files in one go into http://www.wertheimphotography.com/proofs/thumbnails.php?album=3, so I can not replicate your report, although I confess that this took ages. If this bothers you, resize your files on your client before uploading them as suggested in http://coppermine-gallery.net/tutorial/irfanview1.php
Better still: get decent webhosting. You better not use Windows-driven webhosting, it sucks imo.