User Upload error with Coppermine 1.4.4 linked to phpBB 2.0.20 User Upload error with Coppermine 1.4.4 linked to phpBB 2.0.20
 

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

User Upload error with Coppermine 1.4.4 linked to phpBB 2.0.20

Started by gdanen, April 09, 2006, 06:39:13 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

gdanen

I was writing instructions for a user to upload files (Coppermine 1.4.4 linked to phpBB 2.0.20) as follows:

QuoteGreat.

Go back to http://photo.danen.org/discuss/ and login.

Now, in the forum list, you will see "Go to the Photo Gallery" under the "Photos" category. Click that link.

You should now come to a darker looking page with photo albums. At the top left of the screen is a menu button that says "My Gallery" and when you click on that you are viewing your own galleries. There should be nothing yet.

The first thing you need to do is create an album. Find a button that says "Create / order my albums". It should be below a row of menu buttons that begins with "Discussion Forum". Click to start creating albums. You can create several, but for now we will just create one.

The Album Manager will now be displayed with an empty box. Click on the "New" button and "New album" shows in both the list and the text line below it. Click on the text line and replace "New album" with something more appropriate, like "Problem Photos". Click Apply Modifications, and OK to confirm. Now, when you click "My Gallery" your album will be listed. You may click on "Properties" and add a description of this album.

Now we can upload some files. Click the "Upload files" menu button next to "My Gallery". You will see several boxes with a "Browse" button. Click the first "Browse" button and find the file on your computer. Let's just do one for now, and click "Continue".

It should say that your upload was successful. Click "Continue" again.

And that is where it blew up... Just a blank upload.php screen. View source showed no output.

I have linked Coppermine to phpBB 2.0.20 and noticed no folder was created under albums/userpics for this user.

ls -l in the albums folder shows all permissions are set:
drwxrwxrwx  16 root root  432 Apr  9 01:43 birds
drwxrwxrwx   3 root root  264 Apr  9 09:48 edit
-rwxrwxrwx   1 root root 1376 Apr  8 18:21 index.php
drwxrwxrwx   3 root root   80 Jul  5  2005 npark
drwxrwxrwx   3 root root 9192 Apr  9 01:43 rfl2005
drwxrwxrwx   4 root root  176 Apr  9 01:46 userpics
drwxrwxrwx   2 root root  112 Apr  9 01:44 _vti_cnf


I run PHP Version 5.0.4 and MySQL - 4.1.16.

Debug Notices:
/upload.php

    * Notice line 1968: Undefined variable: file_failure_array
    * Notice line 1969: Undefined variable: URI_failure_array
    * Notice line 1970: Undefined variable: zip_failure_array


Debug info shows:
USER:
------------------
Array
(
    [ID] => 010235bbb8a780c03d16680dc289bf03
    [am] => 1
    [lang] => english
    [liv] => Array
        (
        )

    [sort] => pa
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 3
    [user_name] => CecileDanen
    [groups] => Array
        (
            [0] => 2
        )

    [disk_max] => 10240
    [disk_min] => 10240
    [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] => 0
    [pub_upl_need_approval] => 1
    [priv_upl_need_approval] => 0
    [group_name] => Registered
    [upload_form_config] => 3
    [group_quota] => 10240
    [can_see_all_albums] => 0
    [group_id] => 2
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM gal_filetypes; (0s)
    [1] => select * from gal_plugins order by priority asc; (0s)
    [2] => SELECT * FROM gal_bridge (0s)
    [3] => SELECT u.user_id AS user_id, u.user_password AS password, u.user_level FROM `danen_photos`.dis_users AS u, `danen_photos`.dis_sessions AS s WHERE u.user_id=s.session_user_id AND s.session_id = '2924f11fe772b868fe53bdff7f04eec9' AND u.user_id > 0 (0s)
    [4] => SELECT u.user_id AS id, u.username AS username, u.user_password AS password, ug.group_id AS group_id FROM `danen_photos`.dis_users AS u, `danen_photos`.dis_user_group AS ug WHERE u.user_id=ug.user_id AND u.user_id='3' (0s)
    [5] => SELECT ug.group_id+100 AS group_id FROM `danen_photos`.dis_users AS u, `danen_photos`.dis_user_group AS ug, `danen_photos`.dis_groups as g WHERE u.user_id=ug.user_id AND u.user_id='3' AND g.group_id = ug.group_id AND  group_single_user = 0 (0s)
    [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 gal_usergroups WHERE group_id in (2) (0s)
    [7] => SELECT group_name FROM  gal_usergroups WHERE group_id= 2 (0s)
    [8] => SELECT user_favpics FROM gal_favpics WHERE user_id = 3 (0s)
    [9] => DELETE FROM gal_banned WHERE expiry < '2006-04-09 10:24:07' (0s)
    [10] => SELECT * FROM gal_banned WHERE (ip_addr='216.123.202.72' OR ip_addr='216.123.202.72' OR user_id=3) AND brute_force=0 (0s)
    [11] => SELECT aid, title FROM gal_albums WHERE category < 10000 AND uploads='YES' AND (visibility = '0' OR visibility IN (2)) ORDER BY title (0s)
    [12] => SELECT aid, title FROM gal_albums WHERE category='10003' ORDER BY title (0s)
    [13] => SELECT unique_ID FROM gal_temp_data (0s)
    [14] => INSERT INTO gal_temp_data VALUES ('caa97031', 'YToxOntpOjA7YToyOntzOjExOiJhY3R1YWxfbmFtZSI7czoyNToiY2RfamF5ZGVuXzAzMDYxNV8yMzE1LkpQRyI7czoxNDoidGVtcG9yYXJ5X25hbWUiO3M6MjM6Im1IVFRQX3RlbXBfYzhkZjY4ZGEuSlBHIjt9fQ==', '1144599847') (0s)
)

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

==========================
POST :
------------------
Array
(
    [URI_array] => Array
        (
            [0] =>
            [1] =>
            [2] =>
        )

    [control] => phase_1
)

==========================
Page generated in 0.074 seconds - 15 queries in 0 seconds - Album set : ; Meta set: ;

I have read the FAQ and the install docs, but I'm obviously missing something. Can you help, please?

Thanks

Gerry


gdanen

Quote from: Nibbler on April 09, 2006, 06:59:40 PM
http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#upload_trouble

Created user test (pw testing) at http://photo.danen.org/gal/

php.ini has register_long_arrays = on

Set upload boxes to 1.

Uploading a single file, outputs a blank db_input.php file.

Before I click upload, this is the debug info:

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

    [sort] => pa
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 5
    [user_name] => test
    [groups] => Array
        (
            [0] => 2
        )

    [disk_max] => 10240
    [disk_min] => 10240
    [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] => 0
    [pub_upl_need_approval] => 1
    [priv_upl_need_approval] => 0
    [group_name] => Registered
    [upload_form_config] => 0
    [group_quota] => 10240
    [can_see_all_albums] => 0
    [group_id] => 2
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM gal_filetypes; (0s)
    [1] => select * from gal_plugins order by priority asc; (0s)
    [2] => SELECT * FROM gal_bridge (0s)
    [3] => SELECT u.user_id AS user_id, u.user_password AS password, u.user_level FROM `danen_photos`.dis_users AS u, `danen_photos`.dis_sessions AS s WHERE u.user_id=s.session_user_id AND s.session_id = 'd527286a875e08864e391798aea37ee2' AND u.user_id > 0 (0s)
    [4] => SELECT u.user_id AS id, u.username AS username, u.user_password AS password, ug.group_id AS group_id FROM `danen_photos`.dis_users AS u, `danen_photos`.dis_user_group AS ug WHERE u.user_id=ug.user_id AND u.user_id='5' (0s)
    [5] => SELECT ug.group_id+100 AS group_id FROM `danen_photos`.dis_users AS u, `danen_photos`.dis_user_group AS ug, `danen_photos`.dis_groups as g WHERE u.user_id=ug.user_id AND u.user_id='5' AND g.group_id = ug.group_id AND  group_single_user = 0 (0s)
    [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 gal_usergroups WHERE group_id in (2) (0s)
    [7] => SELECT group_name FROM  gal_usergroups WHERE group_id= 2 (0s)
    [8] => SELECT user_favpics FROM gal_favpics WHERE user_id = 5 (0s)
    [9] => DELETE FROM gal_banned WHERE expiry < '2006-04-09 14:14:04' (0s)
    [10] => SELECT * FROM gal_banned WHERE (ip_addr='216.123.202.72' OR ip_addr='216.123.202.72' OR user_id=5) AND brute_force=0 (0s)
    [11] => SELECT aid, title FROM gal_albums WHERE category < 10000 AND uploads='YES' AND (visibility = '0' OR visibility IN (2)) ORDER BY title (0s)
    [12] => SELECT aid, title FROM gal_albums WHERE category='10005' ORDER BY title (0s)
    [13] => DELETE FROM gal_temp_data WHERE timestamp < 1144610044 (0s)
)

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

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

==========================
Page generated in 0.055 seconds - 14 queries in 0 seconds - Album set : ; Meta set: ;

Nibbler


gdanen

Quote from: Nibbler on April 09, 2006, 10:26:02 PM
Works for me, maybe your uploads are too big.

Odd, it's only 1.43 megs and I have increased the allowed upload to 5 mb. php.ini has an 8 mb upload limit. Are there other limits?

BTW, I managed to upload a small file too...

Thanks for your time.

Gerry

Nibbler

There's a list in the sticky.

http://forum.coppermine-gallery.net/index.php?topic=24088.0

1.43 megs is quite large for internet images, would be better using FTP and batch add.

gdanen

Quote from: Nibbler on April 09, 2006, 10:49:39 PM
There's a list in the sticky.

http://forum.coppermine-gallery.net/index.php?topic=24088.0

1.43 megs is quite large for internet images, would be better using FTP and batch add.

As you can see in the atteched file, I can upload a 2.4 meg file and it ends up in the userpics folder. But then something goes wrong between upload.php and db_input.php. It seems to me that the upload process works, php.ini is ok, the upload is moved correctly from tmp to userpics. I'm using GD2, btw.

Nibbler

Then you are probably hitting the memory limit, try IM.

gdanen

Quote from: Nibbler on April 09, 2006, 11:17:52 PM
Then you are probably hitting the memory limit, try IM.

I have this in php.ini. Would that not be sufficient? Batch upload works fine, but that's not available to regular users.

max_execution_time = 60      ; Maximum execution time of each script, in seconds
max_input_time = 600      ; Maximum amount of time each script may spend parsing request data
memory_limit = 24M      ; Maximum amount of memory a script may consume (was 8MB)

gdanen

I don't think IM is an option. I run FC4 and the RPM packages I find fail on dependencies. I don't have development tools to attempt to compile it. :(