Batch add files stopped working-blank page

[mike909]

Ok, I searched for about an hour and I have solved many problems from other posts on this board, but I seriously couldn't find an answer to this question, so I registered. Ok, basically I'm having same problem as this guy except of course, I'm not a rude jackass and I appreciate any help. Here it is: Been using the gallery fine for about a month now without problems, and I have not changed anything, but now the 'batch add files' doesn't work. It just brings me to a blank page. No error message. It sais in the bottom task bar "waiting for mikealbano.com" and nothing ever happens. After about a minute the 'waiting for...' message goes away from the bottom of the browswer window, and page is blank (changes to "done"). Things I have tried include the following:
-tried it on different computer (w/ different ip address)
-tried it on IE and Firefox...same result.
-uploaded a fresh 'searchnew.php' file
-created new administrator user and tried it with him
edit:-forgot to mention, also tried switching from browsable to the other interface.
I did see a thread about changing a timeout in php.ini but it explained that it cures something to do with an error message (and i'm not getting an error message), so I have not tried that...also, I don't see any php.ini.
I am using the latest stable 1.4.8 and have checked permisions (all are ok...like I said, it was working fine, just stopped out of the blue). Far as I can tell, my web-host hasn't changed anything, but who knows. Since Coppermine was working perfect, and all of a sudden isn't...they probably did change something related to timeout's or something...that's what i'm trying to figure out.
link to my website
I have debug output, but this page sais not to post untill requested. Again, I am a decent forum searcher in both this problem and many others, so I hope this hasn't been addressed. (I allways feel guilty starting new threads...I should see someone about that)
edit:Just noticed that when on browsable interface, the bottom browser bar doesn't sit there saying "waiting for mikealbano.com" it just sais done immediately (with the blank page)

[mike909]

Don't all answer at once now. Just kidding, I love this photo gallery and the forum support here is awesome. Since I couldn't really add any more albums easily, I looked into that xp_publish method, and it totally rocks. Super easy...even easier than the batch add. So I guess it's not a total emergency for me anymore, though I would still like to figure it out. Only thing i don't like about the xp_publish is the folders it creates...kind of messes up my organization on the web server, but I'm gonna do some searching on that (seperate issue).

[Joachim Müller]

http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#upload_trouble

[mike909]

Thanks for the link, but not sure what you are pointing at. If it was just to let me know how to set it up...I figured that out allready (not much to figure out, it's super easy). The only issue I have with xp_publish is described in this thread. It went unanswered, so I guess it wasn't as easy of a question as I thought.
So noone knows about the 'blank page' mystery? So odd that it was working fine for that long..got like 30 albums in there or so, then it just stopped for no reason.

[bybinhabr]

I have the same problem... it is a mystery! Maybe a server problem? Why in 2005 works? searchnew.php = 'blank page' or (if I put new searchnew.php file in server), didn't show any folder to open and see files...

tks!

[Joachim Müller]

Re-read the upload troubleshooting section of the docs that I refered to and do exactly as suggested there.

[Abbas Ali]

@mike909: how many files are you trying to batch add? and on what step of batch addition does it hangs?

[will]

@Abbas Ali: I have this problem too, 1 click on batch-add in the admin cpanel and it loads a blank page, I'm uploading 50 files at a time. Does it matter if I have over 10,000 files uploaded by batch-add already?

Any help will be great

Regards, will

[kvnband]

It's because your webhost is too restrictive, PLUS PHP isn't reporting errors.

My advice:  See if you can increase PHP's memory usage and execution time via htaccess

If not, look for another host or go the VPS/dedicated route.
Kevin

[mike909]

@mike909: how many files are you trying to batch add? and on what step of batch addition does it hangs?

I can try to add 1 file or 50 files, doesn't matter, just loads the blank page when I click 'batc add'.

It's because your webhost is too restrictive, PLUS PHP isn't reporting errors.

My advice:  See if you can increase PHP's memory usage and execution time via htaccess

If not, look for another host or go the VPS/dedicated route.
Kevin

Not sure how to increase the memory usage...but if it's the webhost that is too restrictive (netfirms.com), then I guess I will have to use the xp_publish method.

Re-read the upload troubleshooting section of the docs that I refered to and do exactly as suggested there.

Will do.

[mike909]

Ok, re-read it and followd the directions. As I said before, the page sais not to post dubug output unless specifically requested, but I think GauGau is asking for it since he pointed to the page...so here it is. A test user account has also been created. The username is: testuser and the password is: test

Code Select Expand

USER:
------------------
Array
(
    [ID] => 54920aeddf8e74ff65ad15520c46b83b
    [am] => 1
    [lang] => english
    [liv] => Array
        (
            [0] => 230
            [1] => 690
            [2] => 1777
            [3] => 1838
            [4] => 1830
        )

    [sort] => dd
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => ****
    [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 cpg148_filetypes; (0.022s)
    [1] => select * from cpg148_plugins order by priority asc; (0.018s)
    [2] => delete from `d60241746`.cpg148_sessions where time<1153850128 and remember=0; (0.086s)
    [3] => delete from `d60241746`.cpg148_sessions where time<1152644128; (0.004s)
    [4] => select user_id from `d60241746`.cpg148_sessions where session_id=md5("930df798331b5559081e0ffc20f2152383139a9106da8a61c17f967fb3db5392"); (0.008s)
    [5] => select user_id as id, user_password as password from `d60241746`.cpg148_users where user_id=1 (0.003s)
    [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 `d60241746`.cpg148_users AS u INNER JOIN `d60241746`.cpg148_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.003s)
    [7] => SELECT user_group_list FROM `d60241746`.cpg148_users AS u WHERE user_id='1' and user_group_list <> ''; (0.003s)
    [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 cpg148_usergroups WHERE group_id in (1) (0.003s)
    [9] => SELECT group_name FROM  cpg148_usergroups WHERE group_id= 1 (0.003s)
    [10] => update `d60241746`.cpg148_sessions set time='1153853728' where session_id=md5('930df798331b5559081e0ffc20f2152383139a9106da8a61c17f967fb3db5392'); (0.003s)
    [11] => SELECT user_favpics FROM cpg148_favpics WHERE user_id = 1 (0.034s)
    [12] => DELETE FROM cpg148_banned WHERE expiry < '2006-07-25 11:55:29' (0.003s)
    [13] => SELECT * FROM cpg148_banned WHERE (ip_addr='131.216.7.169' OR ip_addr='131.216.7.169' OR user_id=1) AND brute_force=0 (0.003s)
    [14] => SELECT aid from cpg148_pictures WHERE pid='1842'  LIMIT 1 (0.005s)
    [15] => SELECT title,keyword from cpg148_albums WHERE aid='21' (0.069s)
    [16] => SELECT COUNT(*) from cpg148_pictures WHERE ((aid='21'  ) )   (0.019s)
    [17] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, keywords, title, caption,hits,owner_id,owner_name from cpg148_pictures WHERE ((aid='21'  ) )   ORDER BY pid DESC  (0.043s)
    [18] => SELECT title,keyword from cpg148_albums WHERE aid='21' (0.004s)
    [19] => SELECT COUNT(*) from cpg148_pictures WHERE ((aid='21'  ) )   (0.003s)
    [20] => SELECT * from cpg148_pictures WHERE ((aid='21'  ) )   ORDER BY pid DESC  LIMIT 0 ,1 (0.019s)
    [21] => SELECT title, comments, votes, category, aid FROM cpg148_albums WHERE aid='21' LIMIT 1 (0.005s)
    [22] => SELECT name, parent FROM cpg148_categories WHERE cid = '3' (0.002s)
    [23] => SELECT * FROM cpg148_exif WHERE filename = "albums/userpics/10001/107_0788.JPG" (0.074s)
    [24] => INSERT INTO cpg148_exif VALUES ('albums/userpics/10001/107_0788.JPG', 'a:19:{s:13:\"VerboseOutput\";i:0;s:6:\"Errors\";i:0;s:9:\"ValidJpeg\";i:1;s:13:\"ValidIPTCData\";i:0;s:13:\"ValidJFIFData\";i:0;s:13:\"ValidEXIFData\";i:1;s:13:\"ValidAPP2Data\";i:0;s:12:\"ValidCOMData\";i:0;s:8:\"APP1Size\";i:10657;s:6:\"Endien\";s:5:\"Intel\";s:11:\"IFD0NumTags\";i:9;s:4:\"IFD0\";a:9:{s:4:\"Make\";s:6:\"Canon\0\";s:5:\"Model\";s:32:\"Canon PowerShot A510\0\0\0\0\0\0\0\0\0\0\0\0\";s:11:\"Orientation\";s:14:\"Normal (O deg)\";s:11:\"xResolution\";s:27:\"180 dots per ResolutionUnit\";s:11:\"yResolution\";s:27:\"180 dots per ResolutionUnit\";s:14:\"ResolutionUnit\";s:4:\"Inch\";s:8:\"DateTime\";s:20:\"2006:06:17 09:12:28\0\";s:16:\"YCbCrPositioning\";s:21:\"Center of Pixel Array\";s:10:\"ExifOffset\";i:196;}s:10:\"IFD1Offset\";i:1396;s:13:\"SubIFDNumTags\";i:26;s:6:\"SubIFD\";a:27:{s:12:\"ExposureTime\";s:8:\"1/60 sec\";s:7:\"FNumber\";s:3:\"f 4\";s:11:\"ExifVersion\";s:11:\"version 2.2\";s:16:\"DateTimeOriginal\";s:20:\"2006:06:17 09:12:28\0\";s:17:\"DateTimedigitized\";s:20:\"2006:06:17 09:12:28\0\";s:23:\"ComponentsConfiguration\";s:5:\"YCbCr\";s:17:\"ShutterSpeedValue\";s:8:\"1/59 sec\";s:13:\"ApertureValue\";s:3:\"f 4\";s:17:\"ExposureBiasValue\";s:4:\"0 EV\";s:5:\"Flash\";s:18:\"Red Eye, Auto-Mode\";s:11:\"FocalLength\";s:10:\"13.8125 mm\";s:9:\"MakerNote\";a:11:{s:16:\"MakerNoteNumTags\";i:10;s:10:\"Settings 1\";a:25:{s:7:\"RAWDATA\";s:184:\"5c000200000005800500000000000400ffffffff0000000000000000000000000f000300010000000000ffffffffe602ba0020008100c000ffff08200000000000000000ffff0000000800080000ffff00000000ff7fff7fffffffff\";s:5:\"Bytes\";i:92;s:5:\"Macro\";s:6:\"Normal\";s:9:\"SelfTimer\";s:3:\"Off\";s:7:\"Quality\";i:32773;s:5:\"Flash\";s:24:\"Auto + Red Eye Reduction\";s:9:\"DriveMode\";s:12:\"Single/Timer\";s:7:\"Unknown\";i:0;s:9:\"FocusMode\";i:0;s:9:\"ImageSize\";s:5:\"Large\";s:12:\"EasyShooting\";s:9:\"Full Auto\";s:11:\"DigitalZoom\";s:15:\"No Digital Zoom\";s:8:\"Contrast\";s:6:\"Normal\";s:10:\"Saturation\";s:6:\"Normal\";s:9:\"Sharpness\";s:6:\"Normal\";s:3:\"ISO\";s:4:\"Auto\";s:12:\"MeteringMode\";s:10:\"Evaluative\";s:9:\"FocusType\";s:4:\"Auto\";s:15:\"AFPointSelected\";i:0;s:12:\"ExposureMode\";s:9:\"EasyShoot\";s:15:\"LongFocalLength\";i:742;s:16:\"ShortFocalLength\";i:186;s:10:\"FocalUnits\";i:32;s:13:\"FlashActivity\";i:65535;s:12:\"FlashDetails\";s:30:\"Internal Flash,1st curtin sync\";}s:12:\"unknown:0002\";a:1:{s:7:\"RAWDATA\";s:16:\"0200ba01e500ac00\";}s:10:\"Settings 4\";a:8:{s:7:\"RAWDATA\";s:132:\"42000000000000008000bd000000000000000000080008000000cc000000000000000000000000000000000000000000000000000000ffffffffffff000000000000\";s:5:\"Bytes\";i:66;s:7:\"Unknown\";i:0;s:12:\"WhiteBalance\";s:4:\"Auto\";s:14:\"SequenceNumber\";i:0;s:11:\"AFPointUsed\";i:0;s:9:\"FlashBias\";s:3:\"0EV\";s:15:\"SubjectDistance\";i:0;}s:9:\"ImageType\";s:32:\"IMG:PowerShot A510 JPEG\0\0\0\0\0\0\0\0\0\";s:15:\"FirmwareVersion\";s:32:\"Firmware Version 00.00\0\0\0\0\0\0\0\0\0\0\";s:11:\"ImageNumber\";s:8:\"1071-788\";s:9:\"OwnerName\";s:32:\"\0R\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\";s:12:\"unknown:0010\";a:1:{s:7:\"RAWDATA\";s:8:\"00005701\";}s:12:\"unknown:0012\";a:1:{s:7:\"RAWDATA\";s:112:\"09000900000800060008000171012e008efe000072018efe000072018efe00007201cfffcfffcfff00000000000031003100310002000100\";}s:12:\"unknown:0013\";a:1:{s:7:\"RAWDATA\";s:16:\"0000000000000000\";}}s:10:\"KnownMaker\";i:1;s:14:\"UserCommentOld\";s:264:\"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\";s:15:\"FlashPixVersion\";s:9:\"version 1\";s:10:\"ColorSpace\";s:4:\"sRGB\";s:14:\"ExifImageWidth\";s:10:\"614 pixels\";s:15:\"ExifImageHeight\";s:10:\"460 pixels\";s:26:\"ExifInteroperabilityOffset\";i:1318;s:21:\"FocalPlaneXResolution\";d:9142.857142857143116998486220836639404296875;s:21:\"FocalPlaneYResolution\";d:9142.857142857143116998486220836639404296875;s:24:\"FocalPlaneResolutionUnit\";s:4:\"Inch\";s:14:\"CustomerRender\";i:0;s:12:\"ExposureMode\";i:0;s:12:\"WhiteBalance\";i:0;s:16:\"DigitalZoomRatio\";i:1;s:16:\"SceneCaptureMode\";i:0;}s:11:\"IFD1NumTags\";i:6;s:4:\"IFD1\";a:6:{s:11:\"Compression\";s:16:\"Jpeg Compression\";s:11:\"xResolution\";s:27:\"180 dots per ResolutionUnit\";s:11:\"yResolution\";s:27:\"180 dots per ResolutionUnit\";s:14:\"ResolutionUnit\";s:4:\"Inch\";s:12:\"JpegIFOffset\";i:1490;s:15:\"JpegIFByteCount\";i:9157;}s:26:\"InteroperabilityIFDNumTags\";i:4;s:19:\"InteroperabilityIFD\";a:4:{s:21:\"InteroperabilityIndex\";s:4:\"R98\0\";s:23:\"InteroperabilityVersion\";s:9:\"version 1\";s:17:\"RelatedImageWidth\";i:614;s:18:\"RelatedImageLength\";i:460;}}') (0.214s)
    [25] => SELECT msg_id, msg_author, msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, author_id, author_md5_id, msg_raw_ip, msg_hdr_ip, pid FROM cpg148_comments WHERE pid='1842' ORDER BY msg_id ASC (0.029s)
    [26] => SELECT COUNT(*) FROM cpg148_pictures WHERE approved = 'NO' (0.046s)
    [27] => SELECT title,keyword from cpg148_albums WHERE aid='21' (0.065s)
    [28] => SELECT COUNT(*) from cpg148_pictures WHERE ((aid='21'  ) )   (0.036s)
    [29] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, keywords, title, caption,hits,owner_id,owner_name from cpg148_pictures WHERE ((aid='21'  ) )   ORDER BY pid DESC  LIMIT 0 ,10 (0.007s)
)

==========================
GET :
------------------
Array
(
    [pos] => -1842
)

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

==========================
VERSION INFO :
------------------
PHP version: 4.3.10 - OK
------------------
mySQL version: 4.1.12-log
------------------
Coppermine version: 1.4.8(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 3.23.55
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE -I/usr/local/nf/include/mysql
MYSQL_LIBS -L/usr/local/nf/lib/mysql -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.1.3
Linked Version 1.1.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/nf/lib/php | .:/usr/local/nf/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 | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | -1 | -1
upload_max_filesize | 20000000 | 20000000
post_max_size | 8M | 8M
==========================
Page generated in 3.007 seconds - 30 queries in 0.836 seconds - Album set : ; Meta set: ;


[Joachim Müller]

As I said before, the page sais not to post dubug output unless specifically requested, but I think GauGau is asking for it since he pointed to the page...so here it is.

No, I'm not. I asked you to do as suggested on the upload troubleshooting section (apply the needed settings and post test user account). I didn't ask you to post debug_output.
This thread is leading nowhere, I'm out of it.

[mike909]

A test user account has also been created. The username is: testuser and the password is: test

Not sure if you saw that or not, but it sounds like youve been pissed off. Sorry for that...Ive just been trying to interpret your request's. It seems like you want to help, and it also seems that others are having this problem. Anyway, ive apparently driven you off. Have a nice day.

[mike909]

Ok, well apparently I will recieve no help on this and I don't want to leave the gallery in debug mode for no reason. If anyone feels like spending time on this issue I would be glad to re-enable both debug mode and the test user account, and do whatever sort of testing anyone wants.

P.S.
Please don't mistake this for a complaint...it's not. I love the software, it's free and I've gotten worse support from Cisco who my company pays thousands of dollars for.

[Abbas Ali]

@mike909: If you are happy to give me the ftp and cpg admin access via PM then i can look into it.

[mike909]

@mike909: If you are happy to give me the ftp and cpg admin access via PM then i can look into it.

done.

[Abbas Ali]

I didn't got time to look into the issue in great details. I think it has something to do with output buffer or cache.

I have inserted two echo(s) in searchnew.php and now the batchadd page is coming fine...But if i remove those two echo statements then the page doesn't loads. Please check now whether you can use batchadd or not.

[mike909]

Please check now whether you can use batchadd or not.

Yes, it appears to be functioning properly now. I was able to batch add a new album. (July-2006, under 'Tyler' category)

[mike909]

Abbas,
I batch-added a bunch of new albums...thank you very much for your help. I really appreciate it. I am however experiencing a new problem and I want to make sure it's unrelated to what you are doing. My CPG is now very very slow and randomly does not work (blank page/page cannot be displayed either on index.php or when browsing through CPG). I don't think it's the host because my main page works fine, and I will be seeking help on it. Before I do though, I just wanted to make sure it's not because of something your experimenting on in my CPG or something like that. Once again, thanks for your help.

[Abbas Ali]

No, it doesn't have anything to do with it. I just put two statements in searchnew.php file and both statements just prints "HERE". The original file was backed up as searchnew.php.org . If you wish you can revert the changes by renaming the backed up file. I didn't touched/edited any other file.