I just noticed that uploads appear to be occurring, but are not being recorded in the WPPA database tables
What is exactly the problem? Do you have more photofiles than db entries? DB entries are created before the files are copied/created, so i doubt this.
Remake re-creates the files from sources only for entries in the db table.
Do you have the filesystem in tree mode? ( I think you have, because of the existence of folder …/wppa/27/ ) Look at Table VIII-A10, if it reads: Convert to flat, you have it in tree mode. There is a lost and found procedure that can create db entries fot files that have no db entry, but this works only on flat filesystems. Convering to flat will not covert these files, so if you have it in tree mode, you can not use the lost and found proc.
How many photos are there in the system (db entries)?
If you save sourcefiles, you can import them on the Import screen, to re-create db entries.
Background: Used WPPA successfully to upload multiple from MacOSX, iOS, Chrome, Safari since 2014. In February 2017, two months after updating to PHP 7 WPPA stopped successfully uploading multiple images and completing the album load.
Problem: from all the platforms and browsers listed, and including Windows 7 and IE, multiple upload (the a-option) accepts choosing twenty images, and seems to cycle through the upload. However, the count of images does not show up in Admin Albums and the chosen images do not appear in any view of the target album, backend or front-end. On File System inspection I notice multiple sets of the same images in the same subfolder. I can successfully upload one image at a time using the backend interface and have it appear in the album. One at a time for forty images multiple times per month is not an option.
The file system is in Tree Mode. I can’t figure out your data model. And, it appears to me as though it has changed several times since 2014. Plus, it looks like false starts and no clean up. That’s why I am thinking, if your tree mode is better, and stable, and the operation not working correctly, let’s combine the clean up effort with the rebuild and do the work once.
Personally, with BINAY content in the file system, on UNIX, and database entries mapping said image binaries to their logical albums, I don’t care for the Tree Mode. too many folders and the mess I have is unsettling.
What about going to Flat Mode? What is the intent of Flat Mode conversion? Do you have any sort of white paper that describes either method of BLOB storage?
I do have most of the images offline from the web server, but not all. I have so many albums I don’t want to download all of there images keeping them straight on my filesystem, and then remake each one without serious consideration of the design.
A few things worth to know for everybody:
The tree structure has been invented to overcome the problem that certain server os filesystems have a maximum number of files in a folder.
This is problem for large systems having more photos than the allowed fs max.
Wppa tries to accommodate up to 1 million photos.
Converting to tree structure assures that there are no more than 210 entries in any folder (max 110 photos and 100 albums).
It is as simple as this: e.g.:
In …/uploads/wppa/ and in …/uploads/wppa/thumbs/:
Flat -> Tree
1.jpg -> 1.jpg
10.jpg -> 10.jpg
100.jpg -> 10/0.jpg
1234.jpg -> 12/34.jpg
12345678.jpg -> 12/34/56/78.jpg
123456789.jpg -> 12/34/56/78/9.jpg
etc.
The conversion can be done in Table VIII-A10. If the system is tree, you can convert there to flat and vice versa.
Only the photo ids that exist in the db table WPPA_PHOTOS are converted. If you convert to flat, and make sure the procedure finished correctly, then you can remove all folders with names 00 up to 99 in the wppa/folder and the wppa/thumbs/ folder, to get rid of any unwanted files. You will loose ‘lost’ photos this way, and your servers filesystem must allow for so many directory entries as your photo count is. So, before converting back to flat, make sure your filsystem can handle this, and make sure you can live without the ‘lost’ photos.
I got your mail, we will discuss your problem further offline.
