forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 permissions => Topic started by: tmycann on September 08, 2007, 08:12:20 pm

Title: not allowed to delete missing images
Post by: tmycann on September 08, 2007, 08:12:20 pm

Hi,
I've been digging through FAQs, documentation, and forum posts trying to figure out how to deal with an error that it does seem people have had: Directory 'albums/userpics/10001/' is not writable, files can't be deleted  and have tried CHMODing the directory in question to both 775 and 777 with no effect on the error message I receive.

The album is installed and working at http://lindenhofbmds.com/coppermine/index.php but in the process of bulk uploading, it appears that some files were corrupted. I've re-uploaded those images and they display fine, but I have double-entries for which one doesn't have an image and the other does, so I've been trying to erase the ones without the image--and that's where I run into the error I outlined above.

I've also run debugging on this issue and come up with the following information:

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

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => berners
    [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] => 10
    [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 `lin0705907070406`.cpg_sessions where time<1189266580 and remember=0; (0s)
    [3] => delete from `lin0705907070406`.cpg_sessions where time<1188060580; (0s)
    [4] => select user_id from `lin0705907070406`.cpg_sessions where session_id=md5("c25968754a44e724cdf1e8a2557180744b1df921f02926f7dc386a4b691c08f0"); (0s)
    [5] => select user_id as id, user_password as password from `lin0705907070406`.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 `lin0705907070406`.cpg_users AS u INNER JOIN `lin0705907070406`.cpg_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
    [7] => SELECT user_group_list FROM `lin0705907070406`.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 `lin0705907070406`.cpg_sessions set time='1189270180' where session_id=md5('c25968754a44e724cdf1e8a2557180744b1df921f02926f7dc386a4b691c08f0'); (0s)
    [11] => SELECT user_favpics FROM cpg_favpics WHERE user_id = 1 (0s)
    [12] => DELETE FROM cpg_banned WHERE expiry < '2007-09-08 16:49:40' (0s)
    [13] => SELECT * FROM cpg_banned WHERE (ip_addr='65.30.220.236' OR ip_addr='65.30.220.236' OR user_id=1) AND brute_force=0 (0s)
    [14] => SELECT title, category FROM cpg_albums WHERE aid = '17' (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='10001'  OR category='10001' ORDER BY title (0s)
    [17] => SELECT category, filepath, filename, owner_id FROM cpg_pictures, cpg_albums WHERE cpg_pictures.aid = cpg_albums.aid AND pid='2' (0s)
    [18] => UPDATE cpg_pictures SET aid = '17', title = 'Brenna gives birth to the C litter', caption = '', keywords = '', user1 = '', user2 = '', user3 = '', user4 = '' WHERE pid='2' LIMIT 1 (0s)
    [19] => SELECT category, filepath, filename, owner_id FROM cpg_pictures, cpg_albums WHERE cpg_pictures.aid = cpg_albums.aid AND pid='4' (0s)
    [20] => UPDATE cpg_pictures SET aid = '17', title = 'Brenna with her pups', caption = '', keywords = '', user1 = '', user2 = '', user3 = '', user4 = '' WHERE pid='4' LIMIT 1 (0s)
    [21] => SELECT category, filepath, filename, owner_id FROM cpg_pictures, cpg_albums WHERE cpg_pictures.aid = cpg_albums.aid AND pid='3' (0s)
    [22] => UPDATE cpg_pictures SET aid = '17', title = 'Watchful Brenna', caption = '', keywords = '', user1 = '', user2 = '', user3 = '', user4 = '' WHERE pid='3' LIMIT 1 (0s)
    [23] => SELECT category, filepath, filename, owner_id FROM cpg_pictures, cpg_albums WHERE cpg_pictures.aid = cpg_albums.aid AND pid='155' (0s)
    [24] => UPDATE cpg_pictures SET aid = '17', title = '', caption = '', keywords = '', user1 = '', user2 = '', user3 = '', user4 = '' WHERE pid='155' LIMIT 1 (0s)
    [25] => SELECT category, filepath, filename, owner_id FROM cpg_pictures, cpg_albums WHERE cpg_pictures.aid = cpg_albums.aid AND pid='154' (0s)
    [26] => DELETE FROM cpg_comments WHERE pid='154' (0.001s)
    [27] => SELECT COUNT(*) FROM cpg_pictures WHERE approved = 'NO' (0s)
)

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

[album] => 17
    [start] => 0
    [count] => 25
)

==========================
POST :
------------------
Array
(
    [count] => 25
    [pid] => Array
        (
           

• => 2
[1] => 4
            [2] => 3
            [3] => 155
            [4] => 154
            [5] => 153
        )

   

[aid2] => 17
    [title2] => Brenna gives birth to the C litter
    [caption2] =>
    [keywords2] =>
    [user12] =>
    [user22] =>
    [user32] =>
    [user42] =>
    [aid4] => 17
    [title4] => Brenna with her pups
    [caption4] =>
    [keywords4] =>
    [user14] =>
    [user24] =>
    [user34] =>
    [user44] =>
    [aid3] => 17
    [title3] => Watchful Brenna
    [caption3] =>
    [keywords3] =>
    [user13] =>
    [user23] =>
    [user33] =>
    [user43] =>
    [aid155] => 17
    [title155] =>
    [caption155] =>
    [keywords155] =>
    [user1155] =>
    [user2155] =>
    [user3155] =>
    [user4155] =>
    [aid154] => 17
    [title154] =>
    [caption154] =>
    [keywords154] =>
    [user1154] =>
    [user2154] =>
    [user3154] =>
    [user4154] =>
    [delete154] => 1
    [aid153] => 17
    [title153] =>
    [caption153] =>
    [keywords153] =>
    [user1153] =>
    [user2153] =>
    [user3153] =>
    [user4153] =>
    [delete153] => 1
)

==========================
VERSION INFO :
------------------
PHP version: 4.3.11 - OK
------------------
mySQL version: 4.0.27-max-log
------------------
Coppermine version: 1.4.10(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.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
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 | /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/local/lib/php | .:/usr/local/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 | 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 | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 0.078 seconds - 28 queries in 0.003 seconds - Album set : ; Meta set: ;

Any help would be much appreciated.
Thanks!

Title: Re: not allowed to delete missing images
Post by: tmycann on September 08, 2007, 10:38:15 pm

OK... I have no idea why, but this issue has now resolved itself with no further action on my part...!?