Can't Batch upload and can't delete files

[hillyh]

When I try to batch upload files (single upload works great) :

1. upload files into ftp
2. go to batch add files
3. click the uploads link
4. i see all the pictures that i uploaded
5. i click okay
6. and then i get the message that says, "no new file was found"

all the permissions are set correctly (777) and i am in admin mode. help!

Can't delete files
I go to the file i want to delete and then cllick delete this file. i then get this message that says: Critical Error: There was an error while processing a database query 

i go back to the album and the picture i tried to delete shows up as a link with the file name on it (the one i deleted) and when i click on it...nothing shows up...no pictures...but there is still something there.
what should i do? all permissions are set and i am in admin mode.
the same thing happens when i try to delete an album...Critical Error: There was an error while processing a database query 

my gallery link is http://www.princesswatson.net

[hillyh]

i forgot...here is a user:

login: test
pass: test

[hillyh]

here is the debug info:

Code Select Expand

USER:
------------------
Array
(
    [ID] => 39e6b2a8d08858ca7d86eb0116e17f58
    [am] => 1
    [lang] => english
    [liv] => Array
        (
            [0] => 23
        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => Hillary
    [groups] => Array
        (
            [0] => 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
(
    [0] => SELECT extension, mime, content, player FROM cpg_filetypes; (0.001s)
    [1] => select * from cpg_plugins order by priority asc; (0s)
    [2] => delete from `princess_copp3`.cpg_sessions where time<1207002115 and remember=0; (0.001s)
    [3] => delete from `princess_copp3`.cpg_sessions where time<1205796115; (0.001s)
    [4] => select user_id from `princess_copp3`.cpg_sessions where session_id=md5("1aba0c25a1792bec181229c148c83e92d350d7fb6b06d839665ad682490b56f4"); (0s)
    [5] => select user_id as id, user_password as password from `princess_copp3`.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 `princess_copp3`.cpg_users AS u INNER JOIN `princess_copp3`.cpg_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
    [7] => SELECT user_group_list FROM `princess_copp3`.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 `princess_copp3`.cpg_sessions set time='1207005715' where session_id=md5('1aba0c25a1792bec181229c148c83e92d350d7fb6b06d839665ad682490b56f4'); (0s)
    [11] => SELECT user_favpics FROM cpg_favpics WHERE user_id = 1 (0.018s)
    [12] => DELETE FROM cpg_banned WHERE expiry < '2008-03-31 23:21:32' (0s)
    [13] => SELECT * FROM cpg_banned WHERE (ip_addr='71.141.110.34' OR ip_addr='71.141.110.34' OR user_id=1) AND brute_force=0 (0s)
    [14] => SELECT aid, title FROM cpg_albums WHERE 1 (0.001s)
    [15] => SELECT COUNT(*) FROM cpg_pictures WHERE approved = 'NO' (0s)
    [16] => SELECT filepath, filename FROM cpg_pictures WHERE filepath LIKE 'images/Harry Potter and the Order of the Phoenix LA%' (0.001s)
)

==========================
GET :
------------------
Array
(
    [startdir] => images/Harry Potter and the Order of the Phoenix LA
)

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

==========================
VERSION INFO :
------------------
PHP version: 4.4.6 - OK
------------------
mySQL version: 4.1.22-standard
------------------
Coppermine version: 1.4.16(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.28 compatible)
FreeType Support:
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 4.1.22
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.2.1.2
Linked Version 1.2.1.2
==========================
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 | .:/usr/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
open_basedir | /home/princess:/usr/lib/php:/usr/local/lib/php:/tmp | 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 | 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.292 seconds - 17 queries in 0.023 seconds - Album set : ; Meta set: ;

[hillyh]

this is the debug with the trouble shooting done as directed by in the documentation:

Code Select Expand

USER:
------------------
Array
(
    [ID] => 39e6b2a8d08858ca7d86eb0116e17f58
    [am] => 1
    [lang] => english
    [liv] => Array
        (
            [0] => 23
        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => Hillary
    [groups] => Array
        (
            [0] => 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
(
    [0] => SELECT extension, mime, content, player FROM cpg_filetypes; (0.01s)
    [1] => select * from cpg_plugins order by priority asc; (0.003s)
    [2] => delete from `princess_copp3`.cpg_sessions where time<1207002508 and remember=0; (0.043s)
    [3] => delete from `princess_copp3`.cpg_sessions where time<1205796508; (0.001s)
    [4] => select user_id from `princess_copp3`.cpg_sessions where session_id=md5("1aba0c25a1792bec181229c148c83e92d350d7fb6b06d839665ad682490b56f4"); (0s)
    [5] => select user_id as id, user_password as password from `princess_copp3`.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 `princess_copp3`.cpg_users AS u INNER JOIN `princess_copp3`.cpg_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
    [7] => SELECT user_group_list FROM `princess_copp3`.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 `princess_copp3`.cpg_sessions set time='1207006108' where session_id=md5('1aba0c25a1792bec181229c148c83e92d350d7fb6b06d839665ad682490b56f4'); (0s)
    [11] => SELECT user_favpics FROM cpg_favpics WHERE user_id = 1 (0s)
    [12] => DELETE FROM cpg_banned WHERE expiry < '2008-03-31 23:28:05' (0s)
    [13] => SELECT * FROM cpg_banned WHERE (ip_addr='71.141.110.34' OR ip_addr='71.141.110.34' OR user_id=1) AND brute_force=0 (0s)
    [14] => SELECT aid, title FROM cpg_albums WHERE 1 (0.001s)
    [15] => SELECT COUNT(*) FROM cpg_pictures WHERE approved = 'NO' (0.001s)
    [16] => SELECT filepath, filename FROM cpg_pictures WHERE filepath LIKE 'uploads%' (0.008s)
)

==========================
GET :
------------------
Array
(
    [startdir] => uploads
)

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

==========================
VERSION INFO :
------------------
PHP version: 4.4.6 - OK
------------------
mySQL version: 4.1.22-standard
------------------
Coppermine version: 1.4.16(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.28 compatible)
FreeType Support:
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 4.1.22
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.2.1.2
Linked Version 1.2.1.2
==========================
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 | .:/usr/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
open_basedir | /home/princess:/usr/lib/php:/usr/local/lib/php:/tmp | 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 | 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.397 seconds - 17 queries in 0.067 seconds - Album set : ; Meta set: ;

[Joachim Müller]

here is the debug info

Nobody has asked for it!

Actual link to your gallery is http://www.princesswatson.net/visuals/

You haven't done as suggested in the upload troubleshooting section of the docs: the number of file upload fields is set to 5 although it should be set to 1. The number of URI upload fields is set to 3 although it should be set to 0.

Re-read the docs, do exactly as suggested there, then post again if you have set the gallery up as suggested there.

[hillyh]

i did. actually the second debug has the gallery set to 1 and 0.

[Joachim Müller]

The debug_output is not relevant in this case. Anyway, you have made the needed changes. Uploads by http works as expected, see http://www.princesswatson.net/visuals/displayimage.php?pos=-142
Post a deep link to one of the files that you're trying to batch-add that doesn't work as expected.

[hillyh]

yep...the http upload worked before...
here is the link to one of the pictures:
i hope that is what you meant by deep link...

http://www.princesswatson.net/visuals/albums/uploads/001.jpg

[Joachim Müller]

i then get this message that says: Critical Error: There was an error while processing a database query 

What erro rmessage do you get with debug mode turned on (only the error message, not the debug_output)?

When trying to http-uplad the file you report to have issues with, I get the error message

Disk quota exceeded

You have a space quota of 1024K, your files currently use 88K, adding this file would make you exceed your quota.

File: /home/princess/public_html/visuals/include/picmgmt.inc.php - Line: 90

This error message should be pretty obvious: you have disallowed to have files added that are larger than 1024 k. The file you're trying to add is actually larger in terms of file size, it has 1074 kb instead of the allowed 1024 kb, so this is to be expected. Change your config accordingly.

[hillyh]

while trying to delete i got this message with debug turned on:


While executing query "DELETE FROM  WHERE picture_id='32'" on 0

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE picture_id='32'' at line 1


I have no idea what this means....or what to do with it...i am no good with mySQL databases....

oh and I have changed the Max size for uploaded files (KB)--its set at 4000 and it still doesn't work. I am having a problem with all files I try to batch add...not just the one....

[Joachim Müller]

There is something fishy with your core files. Get a fresh package and perform an upgrade.