Batch Add does nothing Batch Add does nothing
 

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

Batch Add does nothing

Started by transmodiar, February 29, 2008, 09:29:04 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

transmodiar

http://scriptcover.com/gallery
id: test_account
pwd: testing

Note: HTTP upload works fine. I was able to add an image with no problem to one of the galleries.

I am attempting to Batch Add files into my gallery. When I attempt to do so,  I select the directory, then place the images into the proper album category. Clicking in Insert Selected Files does nothing; it just returns me to the Batch Add page. Here is the code generated by the debug window. Thanks for any assistance you can offer:

USER:
------------------
Array
(
    [ID] => 1acaf82c7c6622bd1ea00e3605b37dfa
    [am] => 1
    [lang] => english
    [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] => 0
        [ufc_min] => 0
        [custom_user_upload] => 0
        [num_file_upload] => 1
        [num_URI_upload] => 0
        [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] => 0
        [group_quota] => 0
        [can_see_all_albums] => 1
        [group_id] => 1
    )

    ==========================
    Queries:
    ------------------
    Array
    (
       
  • => SELECT extension, mime, content, player FROM gallery_filetypes; (0s)
        [1] => delete from `hutaff_earthprime`.gallery_sessions where time<1204313243 and remember=0; (0s)
        [2] => delete from `hutaff_earthprime`.gallery_sessions where time<1203107243; (0s)
        [3] => select user_id from `hutaff_earthprime`.gallery_sessions where session_id=md5("c1a1143b2a598db6543e086c4bec31b111e18610001d8ec24f2bd0f700cd9116"); (0s)
        [4] => select user_id as id, user_password as password from `hutaff_earthprime`.gallery_users where user_id=1 (0s)
        [5] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `hutaff_earthprime`.gallery_users AS u INNER JOIN `hutaff_earthprime`.gallery_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
        [6] => SELECT user_group_list FROM `hutaff_earthprime`.gallery_users AS u WHERE user_id='1' and user_group_list <> ''; (0s)
        [7] => 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 gallery_usergroups WHERE group_id in (1) (0s)
        [8] => SELECT group_name FROM  gallery_usergroups WHERE group_id= 1 (0s)
        [9] => update `hutaff_earthprime`.gallery_sessions set time='1204316843' where session_id=md5('c1a1143b2a598db6543e086c4bec31b111e18610001d8ec24f2bd0f700cd9116'); (0s)
        [10] => SELECT user_favpics FROM gallery_favpics WHERE user_id = 1 (0s)
        [11] => DELETE FROM gallery_banned WHERE expiry < '2008-02-29 12:27:23' (0s)
        [12] => SELECT * FROM gallery_banned WHERE (ip_addr='134.173.158.145' OR ip_addr='134.173.158.145' OR user_id=1) AND brute_force=0 (0s)
        [13] => SELECT aid, title FROM gallery_albums WHERE 1 (0s)
        [14] => SELECT COUNT(*) FROM gallery_pictures WHERE approved = 'NO' (0s)
    )

    ==========================
    GET :
    ------------------
    Array
    (
        [insert] => 1
    )

    ==========================
    POST :
    ------------------
    Array
    (
        [d0000] => 18
        [pics] => Array
            (
               
  • => i0000
                [1] => i0001
                [2] => i0002
                [3] => i0003
                [4] => i0004
                [5] => i0005
                [6] => i0006
                [7] => i0007
                [8] => i0008
                [9] => i0009
                [10] => i0010
                [11] => i0011
                [12] => i0012
                [13] => i0013
                [14] => i0014
                [15] => i0015
                [16] => i0016
                [17] => i0017
                [18] => i0018
                [19] => i0019
                [20] => i0020
                [21] => i0021
                [22] => i0022
                [23] => i0023
                [24] => i0024
                [25] => i0025
                [26] => i0026
                [27] => i0027
                [28] => i0028
                [29] => i0029
                [30] => i0030
                [31] => i0031
                [32] => i0032
                [33] => i0033
                [34] => i0034
                [35] => i0035
                [36] => i0036
                [37] => i0037
                [38] => i0038
                [39] => i0039
                [40] => i0040
                [41] => i0041
                [42] => i0042
                [43] => i0043
                [44] => i0044
                [45] => i0045
                [46] => i0046
                [47] => i0047
                [48] => i0048
                [49] => i0049
                [50] => i0050
                [51] => i0051
                [52] => i0052
                [53] => i0053
                [54] => i0054
                [55] => i0055
                [56] => i0056
                [57] => i0057
                [58] => i0058
                [59] => i0059
                [60] => i0060
                [61] => i0061
                [62] => i0062
                [63] => i0063
                [64] => i0064
                [65] => i0065
                [66] => i0066
            )

        [album_lb_id_i0000] => d0000
        [picfile_i0000] => MDMvMDMtMDAwMS5qcGc=
        [album_lb_id_i0001] => d0000
        [picfile_i0001] => MDMvMDMtMDAwMi5qcGc=
        [album_lb_id_i0002] => d0000
        [picfile_i0002] => MDMvMDMtMDAwMy5qcGc=
        [album_lb_id_i0003] => d0000
        [picfile_i0003] => MDMvMDMtMDAwNC5qcGc=
        [album_lb_id_i0004] => d0000
        [picfile_i0004] => MDMvMDMtMDAwNS5qcGc=
        [album_lb_id_i0005] => d0000
        [picfile_i0005] => MDMvMDMtMDAwNi5qcGc=
        [album_lb_id_i0006] => d0000
        [picfile_i0006] => MDMvMDMtMDAwNy5qcGc=
        [album_lb_id_i0007] => d0000
        [picfile_i0007] => MDMvMDMtMDAwOC5qcGc=
        [album_lb_id_i0008] => d0000
        [picfile_i0008] => MDMvMDMtMDAwOS5qcGc=
        [album_lb_id_i0009] => d0000
        [picfile_i0009] => MDMvMDMtMDAxMC5qcGc=
        [album_lb_id_i0010] => d0000
        [picfile_i0010] => MDMvMDMtMDAxMS5qcGc=
        [album_lb_id_i0011] => d0000
        [picfile_i0011] => MDMvMDMtMDAxMi5qcGc=
        [album_lb_id_i0012] => d0000
        [picfile_i0012] => MDMvMDMtMDAxMy5qcGc=
        [album_lb_id_i0013] => d0000
        [picfile_i0013] => MDMvMDMtMDAxNC5qcGc=
        [album_lb_id_i0014] => d0000
        [picfile_i0014] => MDMvMDMtMDAxNS5qcGc=
        [album_lb_id_i0015] => d0000
        [picfile_i0015] => MDMvMDMtMDAxNi5qcGc=
        [album_lb_id_i0016] => d0000
        [picfile_i0016] => MDMvMDMtMDAxNy5qcGc=
        [album_lb_id_i0017] => d0000
        [picfile_i0017] => MDMvMDMtMDAxOC5qcGc=
        [album_lb_id_i0018] => d0000
        [picfile_i0018] => MDMvMDMtMDAxOS5qcGc=
        [album_lb_id_i0019] => d0000
        [picfile_i0019] => MDMvMDMtMDAyMC5qcGc=
        [album_lb_id_i0020] => d0000
        [picfile_i0020] => MDMvMDMtMDAyMS5qcGc=
        [album_lb_id_i0021] => d0000
        [picfile_i0021] => MDMvMDMtMDAyMi5qcGc=
        [album_lb_id_i0022] => d0000
        [picfile_i0022] => MDMvMDMtMDAyMy5qcGc=
        [album_lb_id_i0023] => d0000
        [picfile_i0023] => MDMvMDMtMDAyNC5qcGc=
        [album_lb_id_i0024] => d0000
        [picfile_i0024] => MDMvMDMtMDAyNS5qcGc=
        [album_lb_id_i0025] => d0000
        [picfile_i0025] => MDMvMDMtMDAyNi5qcGc=
        [album_lb_id_i0026] => d0000
        [picfile_i0026] => MDMvMDMtMDAyNy5qcGc=
        [album_lb_id_i0027] => d0000
        [picfile_i0027] => MDMvMDMtMDAyOC5qcGc=
        [album_lb_id_i0028] => d0000
        [picfile_i0028] => MDMvMDMtMDAyOS5qcGc=
        [album_lb_id_i0029] => d0000
        [picfile_i0029] => MDMvMDMtMDAzMC5qcGc=
        [album_lb_id_i0030] => d0000
        [picfile_i0030] => MDMvMDMtMDAzMS5qcGc=
        [album_lb_id_i0031] => d0000
        [picfile_i0031] => MDMvMDMtMDAzMi5qcGc=
        [album_lb_id_i0032] => d0000
        [picfile_i0032] => MDMvMDMtMDAzMy5qcGc=
        [album_lb_id_i0033] => d0000
        [picfile_i0033] => MDMvMDMtMDAzNC5qcGc=
        [album_lb_id_i0034] => d0000
        [picfile_i0034] => MDMvMDMtMDAzNS5qcGc=
        [album_lb_id_i0035] => d0000
        [picfile_i0035] => MDMvMDMtMDAzNi5qcGc=
        [album_lb_id_i0036] => d0000
        [picfile_i0036] => MDMvMDMtMDAzNy5qcGc=
        [album_lb_id_i0037] => d0000
        [picfile_i0037] => MDMvMDMtMDAzOC5qcGc=
        [album_lb_id_i0038] => d0000
        [picfile_i0038] => MDMvMDMtMDAzOS5qcGc=
        [album_lb_id_i0039] => d0000
        [picfile_i0039] => MDMvMDMtMDA0MC5qcGc=
        [album_lb_id_i0040] => d0000
        [picfile_i0040] => MDMvMDMtMDA0MS5qcGc=
        [album_lb_id_i0041] => d0000
        [picfile_i0041] => MDMvMDMtMDA0Mi5qcGc=
        [album_lb_id_i0042] => d0000
        [picfile_i0042] => MDMvMDMtMDA0My5qcGc=
        [album_lb_id_i0043] => d0000
        [picfile_i0043] => MDMvMDMtMDA0NC5qcGc=
        [album_lb_id_i0044] => d0000
        [picfile_i0044] => MDMvMDMtMDA0NS5qcGc=
        [album_lb_id_i0045] => d0000
        [picfile_i0045] => MDMvMDMtMDA0Ni5qcGc=
        [album_lb_id_i0046] => d0000
        [picfile_i0046] => MDMvMDMtMDA0Ny5qcGc=
        [album_lb_id_i0047] => d0000
        [picfile_i0047] => MDMvMDMtMDA0OC5qcGc=
        [album_lb_id_i0048] => d0000
        [picfile_i0048] => MDMvMDMtMDA0OS5qcGc=
        [album_lb_id_i0049] => d0000
        [picfile_i0049] => MDMvMDMtMDA1MC5qcGc=
        [album_lb_id_i0050] => d0000
        [picfile_i0050] => MDMvMDMtMDA1MS5qcGc=
        [album_lb_id_i0051] => d0000
        [picfile_i0051] => MDMvMDMtMDA1Mi5qcGc=
        [album_lb_id_i0052] => d0000
        [picfile_i0052] => MDMvMDMtMDA1My5qcGc=
        [album_lb_id_i0053] => d0000
        [picfile_i0053] => MDMvMDMtMDA1NC5qcGc=
        [album_lb_id_i0054] => d0000
        [picfile_i0054] => MDMvMDMtMDA1NS5qcGc=
        [album_lb_id_i0055] => d0000
        [picfile_i0055] => MDMvMDMtMDA1Ni5qcGc=
        [album_lb_id_i0056] => d0000
        [picfile_i0056] => MDMvMDMtMDA1Ny5qcGc=
        [album_lb_id_i0057] => d0000
        [picfile_i0057] => MDMvMDMtMDA1OC5qcGc=
        [album_lb_id_i0058] => d0000
        [picfile_i0058] => MDMvMDMtMDA1OS5qcGc=
        [album_lb_id_i0059] => d0000
        [picfile_i0059] => MDMvMDMtMDA2MC5qcGc=
        [album_lb_id_i0060] => d0000
        [picfile_i0060] => MDMvMDMtMDA2MS5qcGc=
        [album_lb_id_i0061] => d0000
        [picfile_i0061] => MDMvMDMtMDA2Mi5qcGc=
        [album_lb_id_i0062] => d0000
        [picfile_i0062] => MDMvMDMtMDA2My5qcGc=
        [album_lb_id_i0063] => d0000
        [picfile_i0063] => MDMvMDMtMDA2NC5qcGc=
        [album_lb_id_i0064] => d0000
        [picfile_i0064] => MDMvMDMtMDA2NS5qcGc=
        [album_lb_id_i0065] => d0000
        [picfile_i0065] => MDMvMDMtMDA2Ni5qcGc=
    )

    ==========================
    VERSION INFO :
    ------------------
    PHP version: 5.2.5 - OK
    ------------------
    mySQL version: 5.0.45-community
    ------------------
    Coppermine version: 1.4.16(stable)
    ==========================
    Module: GD
    ------------------
    GD Version: bundled (2.0.34 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
    XPM Support: 1
    XBM Support: 1
    JIS-mapped Japanese Font Support:

    ==========================
    Module: mysql
    ------------------
    module doesn't exist
    ==========================
    Module: zlib
    ------------------
    module doesn't exist
    ==========================
    Server restrictions (safe mode)?
    ------------------
    Directive | Local Value | Master Value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
    ==========================
    email
    ------------------
    Directive | Local Value | Master Value |  |  |  |  |  |  |  |
    ==========================
    Size and Time
    ------------------
    Directive | Local Value | Master Value |  |  |  |  |  |  |  |
    ==========================
    Page generated in 0.075 seconds - 15 queries in 0 seconds - Album set : ; Meta set: ;

Joachim Müller

The test user account doesn't have upload privileges, so it has no use. Read the docs, particularly the section "upload troubleshooting" and "asking for support on upload issues" and do exactly as suggested there.

transmodiar

Quote from: Joachim Müller on March 01, 2008, 01:11:15 AM
The test user account doesn't have upload privileges, so it has no use. Read the docs, particularly the section "upload troubleshooting" and "asking for support on upload issues" and do exactly as suggested there.
Upload privileges have been added for album "1x03 Prince of Wails" - thanks!

Joachim Müller

http uploads work as expected (see http://scriptcover.com/gallery/displayimage.php?pos=-2). Post a deep link to one of the files you're having issues with when batch-adding.

transmodiar

http://scriptcover.com/gallery/albums/03/03-0001.jpg

You can replace 0001 with any number between 0001 and 2400. In this case, I am trying to add the entire folder, which has 100 pictures in it. No picture is greater than 100kb.

Joachim Müller

That's the exact reason for your issues: there mustn't be thousands of files within one folder - the process of reading the directory will take too long. Use a sensible number of files per folder - create sub folders as needed and move your files there. A sane number of files per folder would be something far less than 1000.

transmodiar

Quote from: Joachim Müller on March 04, 2008, 06:37:59 PM
That's the exact reason for your issues: there mustn't be thousands of files within one folder - the process of reading the directory will take too long. Use a sensible number of files per folder - create sub folders as needed and move your files there. A sane number of files per folder would be something far less than 1000.
Okay, but in this test folder, there are only 100 pictures. Surely 100 photos is sensible?

Bigdave_15_1985

This is a similar problem to what Im getting with my batch add. If you upload them via HTTP, which you said worked ok and then try to change the album they are in using the edit files feature, do you get an error message?

Joachim Müller

The issue the thread starter of this thread has may or may not be the same that you have - we can't tell, since you have failed to post the needed details on your thread. Stay out of this thread, stick to your own one and do as suggested there.

transmodiar

Quote from: Joachim Müller on March 05, 2008, 08:05:28 AM
The issue the thread starter of this thread has may or may not be the same that you have - we can't tell, since you have failed to post the needed details on your thread. Stay out of this thread, stick to your own one and do as suggested there.
Is 100 pictures sensible for a directory?

By the way, If I try to upload other folders that do have 2000 pictures, CG does render thumbnails with no problem.

Joachim Müller

100 pics should be OK, but there can be no general recommendation, as this depends on the overall performance of your webserver. Maybe one (or more) of the files is broken and causes to webserver to hang when trying to retrieve the directory of the folder. Try limiting the number of files step by step - always delete half of it, then try again, if it doesn't work, delete the half of what is left and so on.