Multiple File Upload Shows file in Some Tables and not Others

[macmiller]

I am having a problem doing a Multiple Files upload.  The environment is bridged to a phpbb3 forum and up until now all of the galleries have been user galleries.  Now I have gone logged on as admin and created a album called test which is placed  under a category TOPLEVELCATEGORY.   

1.)  Select Multiple files Upload. 
2.)  Select Album test.
3.)  Browse and select pict.
4.)  get message '1 files uploaded' and click continue.
5.)  Title = test and description = test/hit apply changes, message 'Changes successfully saved'.
at this point check in the folder userpics/10002/ and picture is there.
If I click Home at this point it shows album 'test' with 0 files.
If I click properties (Album properties - Update album) it shows 'Album is empty'.
If I click Edit files it shows me the picture and allows changes or deletion.

NOW, if I delete the said picture and repeat the exact same test with the Single File Upload,  everything  seems to work as it should.  That is the pic is uploaded and it shows when I click Home (TOPLEVELCATEGORY/test/pic uploaded).  If I click Properties the image can be selected under 'Album thumbnail'.

I've done this test a few times, the only difference is the upload method used, one works as expects (single file upload) and the other doesn't (Multiple Files).

Any clues as to what might be going on would be appreciated.   I do have this scenario re creatable in a test environment but it does require admin so I would prefer to communicate the path/passwords via PM if someone wants to take a look.   

[macmiller]

Here are some screen shots:
step1MultipleFileUpload:  shows upload
(at this point comments entered and updated OK)
step2PicDoesntShow: album shows 0 files
step2aPicDoesntShow: album properties/album is empty
step3PicShowsUnderEdit: shows up under the Edit files dialog
setp3aPicUploaded: the image uploaded OK

[Αndré]

Does it only happen in a bridged environment or also in an unbridged one? You can send me the login data via PM (I assume you can do that as contributor).

[macmiller]

I just tried it in another CPG 1.5.12 production environment that is not bridged and it worked OK. 

I sent you the info via PM, can you let me know if you get it as when sent it wasn't showing in my outbox. 

[Αndré]

I got both PMs

[Αndré]

The pictures need to be approved. The reason is probably that you don't use post based groups. If you'd use them, you'll have the ability to set the permissions in Coppermine's group manager.

[macmiller]

That sounds a bit strange that the admin's pictures would need to be approved.  In any event it doesn't seem like the process should do a partial update, uploading the file and updating some of the database tables but not others.

[Αndré]

updating some of the database tables but not others.

That's not the case, as the information if a picture is approved or not is stored in the same row as the rest of the picture's information. I'm no bridging expert (I never used it in a production environment), but afaik using post based groups will solve your problem, as you will be able to set the admin's permissions. I haven't checked that, as I currently have no bridged gallery.

[macmiller]

I did some more testing with the user settings that require approval and those that don't.  They are set in the Group manager config option under personal gallery.  This is with the bridge setup as has been working in production (use_post_based_groups = 0 and use_standard_groups = 1).  The first attachment jpg shows the set up where no approval is required, eg. Personal Gallery/Allowed = Yes/Approval = No.  Note the second jpg is as we have been getting after upload, a success message but the image forced to the upload approval queue.

In the second test case I set the Approval flag YES which then requires approval.  Upon upload a message is displayed 'Your file was uploaded successfully.  It will be visible after admin approval'.  This second case is working correctly, it is the first case that is in error. 

Note that the simple upload method works correctly. 

[Αndré]

I have an assumption. We have a known issue that guests cannot enter file details with the flash uploader, as it isn't possible to identify the user without fail, as Flash uses a different cookie than your browser.

I just created a personal album with your admin user and uploaded some pictures to it. I had not to approve them. So I guess the flash uploader is recognized as 'regular' user. I have a quite poor connection to your website, so maybe you want to play a little bit with the 'Registered' group permission to verify that those permissions apply to the flash uploader.

The next step would be to check if it also happens in bridged galleries (with similar settings) of other users or even in unbridged galleries (I don't think so, as I haven't noticed that behavior yet).

[macmiller]

Does not seem to happen in unbridged albums.

As far as registered users, when they are set up properly to upload into admin galleries:
ie
Group manager/Group=Registered/Public albums upload/Allowed=Yes
Group manager/Group=Registered/Public albums upload/Approval=No
Album Manager/Album=test/Album properties/Visitor can upload files=Yes

The flash uploader worked fine and did not require approval for the uploads.

[Αndré]

So you confirmed my assumption, that the flash uploader is detected as registered user.