Batch Upload w/ Windows Server Batch Upload w/ Windows Server
 

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 Upload w/ Windows Server

Started by infrontweb, October 20, 2005, 11:23:11 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

infrontweb

I am having trouble with batch/upload.
- I select the directory (no thumb display on the right only red x)
- I select the Album
- I can click the file link to see the picture http://www.alchemynightclub.com/cpg135/albums/amnesia/DSC04183.JPG
- Click insert and I get "PB".

I have read & re-read the boards, FAQ & manual and have had no luck with a solution. I have it setup according to the Windows instructions.

Things I know for fact:
1. IUSR_username has full permissions on the /albums/ directory (& I have tried many variations).
2. The permissions are set to propogate to sub-folders & files.
3. All files have been put into a folder under /albums/ NOT /userpics/.
4. Files in these folders are web viewable (see link abaove).
5. GD2 is installed and active in the the PHP.INI file (confirmed in debug mode).
6. I am running Plesk 7.5.4 for Windows Server 2003
7. CPG 1.3.5

Joachim Müller


infrontweb

http://www.alchemynightclub.com/cpg135/
Login:  gaugau
Pass: cpg135

Thanks in advance, Eric.

USER:
------------------
Array
(
    [ID] => 02b06908b0c7370f4773504dfc2f1e52
    [am] => 1
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_group] => 1
    [user_active] => YES
    [user_name] => alchemy
    [user_password] => ********
    [user_lastvisit] => 2005-10-18 15:08:07
    [user_regdate] => 2005-10-17 12:47:13
    [user_group_list] =>
    [user_email] =>
    [user_website] =>
    [user_location] =>
    [user_interests] =>
    [user_occupation] =>
    [user_actkey] =>
    [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] => 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] => 0
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
    [groups] => Array
        (
            [1] => 1
        )

)

==========================
Queries:
------------------
Array
(
   
  • => SELECT extension, mime, content FROM cpg135_filetypes;
        [1] => SELECT * FROM cpg135_users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '1ad63315ba627096f5837c7ea72f7062'
        [2] => 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 cpg135_usergroups WHERE group_id in (1)
        [3] => SELECT group_name FROM  cpg135_usergroups WHERE group_id= 1
        [4] => DELETE FROM cpg135_banned WHERE expiry < '2005-10-21 11:48:26'
        [5] => SELECT * FROM cpg135_banned WHERE ip_addr='64.252.118.130' OR ip_addr='64.252.118.130' OR user_id=1
        [6] => UPDATE cpg135_usergroups SET group_name='Administrators',group_quota='0',can_rate_pictures='1',can_send_ecards='1',can_post_comments='1',can_upload_pictures='1',pub_upl_need_approval='0',can_create_albums='1',priv_upl_need_approval='0',upload_form_config='0',custom_user_upload='0',num_file_upload='5',num_URI_upload='3' WHERE group_id = '1' LIMIT 1
        [7] => UPDATE cpg135_usergroups SET group_name='Registered',group_quota='5000',can_rate_pictures='1',can_send_ecards='1',can_post_comments='1',can_upload_pictures='1',pub_upl_need_approval='1',can_create_albums='1',priv_upl_need_approval='0',upload_form_config='0',custom_user_upload='0',num_file_upload='5',num_URI_upload='3' WHERE group_id = '2' LIMIT 1
        [8] => UPDATE cpg135_usergroups SET group_name='Anonymous',group_quota='0',can_rate_pictures='1',can_send_ecards='0',can_post_comments='0',can_upload_pictures='0',pub_upl_need_approval='1',can_create_albums='0',priv_upl_need_approval='1',upload_form_config='0',custom_user_upload='0',num_file_upload='5',num_URI_upload='3' WHERE group_id = '3' LIMIT 1
        [9] => UPDATE cpg135_usergroups SET group_name='Banned',group_quota='0',can_rate_pictures='0',can_send_ecards='0',can_post_comments='0',can_upload_pictures='0',pub_upl_need_approval='1',can_create_albums='0',priv_upl_need_approval='1',upload_form_config='0',custom_user_upload='0',num_file_upload='5',num_URI_upload='3' WHERE group_id = '4' LIMIT 1
        [10] => SELECT * FROM cpg135_usergroups WHERE 1 ORDER BY group_id
    )

    ==========================
    GET :
    ------------------
    Array
    (
    )

    ==========================
    POST :
    ------------------
    Array
    (
        [group_id] => Array
            (
               
  • => 1
                [1] => 2
                [2] => 3
                [3] => 4
            )

        [group_name_1] => Administrators
        [group_quota_1] => 0
        [can_rate_pictures_1] => 1
        [can_send_ecards_1] => 1
        [can_post_comments_1] => 1
        [can_upload_pictures_1] => 1
        [pub_upl_need_approval_1] => 0
        [can_create_albums_1] => 1
        [priv_upl_need_approval_1] => 0
        [upload_form_config_1] => 0
        [custom_user_upload_1] => 0
        [num_file_upload_1] => 5
        [num_URI_upload_1] => 3
        [group_name_2] => Registered
        [group_quota_2] => 5000
        [can_rate_pictures_2] => 1
        [can_send_ecards_2] => 1
        [can_post_comments_2] => 1
        [can_upload_pictures_2] => 1
        [pub_upl_need_approval_2] => 1
        [can_create_albums_2] => 1
        [priv_upl_need_approval_2] => 0
        [upload_form_config_2] => 0
        [custom_user_upload_2] => 0
        [num_file_upload_2] => 5
        [num_URI_upload_2] => 3
        [group_name_3] => Anonymous
        [group_quota_3] => 0
        [can_rate_pictures_3] => 1
        [can_send_ecards_3] => 0
        [can_post_comments_3] => 0
        [can_upload_pictures_3] => 0
        [pub_upl_need_approval_3] => 1
        [can_create_albums_3] => 0
        [priv_upl_need_approval_3] => 1
        [upload_form_config_3] => 0
        [custom_user_upload_3] => 0
        [num_file_upload_3] => 5
        [num_URI_upload_3] => 3
        [group_name_4] => Banned
        [group_quota_4] => 0
        [can_rate_pictures_4] => 0
        [can_send_ecards_4] => 0
        [can_post_comments_4] => 0
        [can_upload_pictures_4] => 0
        [pub_upl_need_approval_4] => 1
        [can_create_albums_4] => 0
        [priv_upl_need_approval_4] => 1
        [upload_form_config_4] => 0
        [custom_user_upload_4] => 0
        [num_file_upload_4] => 5
        [num_URI_upload_4] => 3
        [apply_modifs] => Apply modifications
    )

    ==========================
    VERSION INFO :
    ------------------
    PHP version: 4.3.11 - OK
    ------------------
    mySQL version: 4.1.12-nt
    ------------------
    Coppermine version: 1.3.5
    ==========================
    Module: gd
    ------------------
    GD Support enabled
    GD Version bundled (2.0.28 compatible)
    FreeType Support enabled
    FreeType Linkage with freetype
    GIF Read Support enabled
    GIF Create Support enabled
    JPG Support enabled
    PNG Support enabled
    WBMP Support enabled
    XBM Support enabled
    ==========================
    Module: mysql
    ------------------
    Active Persistent Links 0
    Active Links 1
    Client API version 3.23.49
    ==========================
    Module: zlib
    ------------------
    ZLib Support enabled
    Compiled Version 1.1.4
    Linked Version 1.1.4
    ==========================
    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 | .;./includes;./pear | .;./includes;./pear
    open_basedir | no value | no value
    ==========================
    email
    ------------------
    Directive | Local Value | Master Value
    sendmail_from | support@infrontweb.com | support@infrontweb.com
    sendmail_path | no value | no value
    SMTP | localhost | localhost
    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 | 2M | 2M
    post_max_size | 8M | 8M
    ==========================
    Page generated in 0.089 seconds - 11 queries in 0.005 seconds - Album set :

Nibbler

QuoteOnly files with the following extensions are accepted :

.
Check your config settings, you have blocked all file extensions.

infrontweb

(https://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Fwww.alchemynightclub.com%2Fgallery%2Falchemy.gif&hash=9868895a7fec1ced57b2f79df5b5fc0df4b0cfa5)
I have all necessary extensions in the proper fields (see image). Is there another place I would be blocking file extensions?

Joachim Müller

don't send emails nor PMs to devs/supporters unless they ask you to!  >:(

infrontweb

Certainly not my intention to irritate you. Replying via email is only a natural reaction. I will keep my replys to the board.

Do you have any further suggestions for me?
I'm not sure what else to do to get the batch upload to work properly..

Joachim Müller

try "ALL" instead of the list of allowed files you supplied. If this fixes things for you, use a tool like phpMyAdmin to directly edit your database, browse coppermine's filetypes table and remove the filetypes you don't want there. Make sure to backup before doing so.

infrontweb

Awesome!
This worked. Actually my issue was with the deliminator used in the config file.

Allowed image type:
jpg,jpeg,gif,png,tif
(Does not work)

Changed , to /

Allowed image type:
jpg/jpeg/gif/png/tif
(Works perfectly)

Joachim Müller

thanks for your feedback, I changed the section in the docs accordingly (in the stable branch of the cvs)