Duplicates When Batch Upload

[metalguy639]

I've searched on the forums here and found several posts with others having the same problem but no answers on how to solve it as of yet.

The problem: When i upload files through the batch add system I sometimes get duplicate images the script duplicates the image but does not actually duplicate the file. If I delete one of the duplicates then the images is completely gone.

I Have: Coppermine 1.4.19 installed and working properly with vbulletin 3.8. I have integrated coppermine with vbulletin to share the login/database. I'm running php 5.25, mysql 4.1.

I have Already Tried: The Docs suggestion to set the uploads to a single upload, & set the debug info up on the site. Did not do didley for me. It did not stop the problem. I did copy my debug output though. This is what the output was when I had a file duplicate in the batch add area:

Code Select Expand

USER:
------------------
Array
(
    [ID] => 822ea1305d841067e663220cde321228
    [am] => 1
    [lang] => english
    [liv] => Array
        (
            [0] => 5432
        )

    [search] => Array
        (
            [search] => covered in ashes
            [album] => search
            [title] => on
            [newer_than] =>
            [caption] => on
            [older_than] =>
            [keywords] => on
            [type] => AND
            [params] => Array
                (
                    [title] => on
                    [caption] => on
                    [keywords] => on
                )

        )

    [lap] => 16
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => metalguy
    [groups] => Array
        (
            [0] => 106
        )

    [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] => 0
    [has_admin_access] => 1
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 1
    [group_name] => Administrators
    [upload_form_config] => 0
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 106
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg14x_filetypes; (0.001s)
    [1] => select * from cpg14x_plugins order by priority asc; (0.001s)
    [2] => SELECT * FROM cpg14x_bridge (0.001s)
    [3] => SELECT u.userid, u.password, u.usergroupid+100 AS usergroupid FROM `mg_metaljunkies`.user AS u, `mg_metaljunkies`.session AS s WHERE s.userid=u.userid AND s.sessionhash='5a781705d17798ff658a24d0ad548de1' (0.001s)
    [4] => SELECT u.userid AS id, u.username AS username, u.password AS password, u.usergroupid+100 AS group_id FROM `mg_metaljunkies`.user AS u INNER JOIN `mg_metaljunkies`.usergroup AS g ON u.usergroupid=g.usergroupid WHERE u.userid='1' (0.001s)
    [5] => SELECT g.usergroupid+100 AS group_id, u.* FROM `mg_metaljunkies`.user AS u, `mg_metaljunkies`.usergroup as g WHERE g.usergroupid = u.usergroupid AND u.userid = '1' (0.002s)
    [6] => 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 cpg14x_usergroups WHERE group_id in (106) (0.001s)
    [7] => SELECT group_name FROM  cpg14x_usergroups WHERE group_id= 106 (0s)
    [8] => SELECT user_favpics FROM cpg14x_favpics WHERE user_id = 1 (0.001s)
    [9] => DELETE FROM cpg14x_banned WHERE expiry < '2009-01-26 20:01:22' (0.001s)
    [10] => SELECT * FROM cpg14x_banned WHERE (ip_addr='70.118.66.198' OR ip_addr='70.118.66.198' OR user_id=1) AND brute_force=0 (0.001s)
    [11] => SELECT aid, title FROM cpg14x_albums WHERE 1 (0.002s)
    [12] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' (0s)
    [13] => SELECT filepath, filename FROM cpg14x_pictures WHERE filepath LIKE 'uploads/wallpaper2/angel corpse%' (0.019s)
    [14] => SELECT aid, title FROM cpg14x_albums WHERE category = 0 (0.001s)
    [15] => SELECT DISTINCT a.aid as aid, a.title as title, c.name as cname FROM cpg14x_albums as a, cpg14x_categories as c WHERE a.category = c.cid AND a.category < '10000' (0.045s)
    [16] => SELECT aid, CONCAT('(', username, ') ', a.title) AS title
                                                        FROM cpg14x_albums AS a
                                                        INNER JOIN `mg_metaljunkies`.user AS u
                                                        ON category = (10000 + 1) AND userid = 1 ORDER BY title (0.001s)
)

==========================
GET :
------------------
Array
(
    [startdir] => uploads/wallpaper2/angel corpse
)

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

==========================
VERSION INFO :
------------------
PHP version: 5.2.5 - OK
------------------
mySQL version: 4.1.22-max-log
------------------
Coppermine version: 1.4.19(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:
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 1
Client API version 5.0.18
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /usr/local/mysql-5.0/data/mysql.sock
MYSQL_INCLUDE -I/usr/local/mysql-5.0//include/mysql
MYSQL_LIBS -L/usr/local/mysql-5.0//lib/mysql -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.1.4
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 | ~ | ~
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 | .:/usr/local/php5/lib/php | .:/usr/local/php5/lib/php
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | me@localhost.com | me@localhost.com
sendmail_path | /usr/sbin/sendmail -t -i  | /usr/sbin/sendmail -t -i
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.184 seconds - 17 queries in 0.079 seconds - Album set : ; Meta set: ;

Not sure about how much of that you need or if it contains the error in it so it can be fixed. How can this be fixed? Seems like its a bug of the script to me in some way.

[SamBuca]

Just posted about that: http://forum.coppermine-gallery.net/index.php/topic,57717.0.html

You could try what I did.....worked for me.

[Joachim Müller]

I have Already Tried: The Docs suggestion to set the uploads to a single upload, & set the debug info up on the site. Did not do didley for me.

Well, then read on there untill you come to the section that is named "asking for support on upload issues", because that's what you're actually doing right now (asking for support on uploading). Read that section carefully. If you're convinced that you already have read it, read it again. Read the section about posting a link to your site and a test user account and that this is mandatory when asking for support, no matter what upload method you have troubles with? Read the note that you mustn't post debug_output unless requested? There are reasons why we have that section in the docs. We even have a section in the docs that explains why we have that section and why everybody, in each support request where the poster fails to do as suggested is being told what to do.
If you have actually done as you said earlier (that you have read the board), there are two options: you have come across the rare threads where the thread starter did everything right. If this was the case, you should have posted the same amount of data. Second option: the threads you read have been identical to yours, with the thread starters not posting the needed information. In that case, the thread starter has no doubt been told to read the upload troubleshooting section of the docs first and do exactly as suggested there, so you could have made life easier for all of us by providing the needed data in the first place.