Conkersm98fr wrote:

but that doesn't appear to be it.

... but it is.

In view of the last reply, is there any way that I can amend any of the data in the SQL database so that it will recognise the fact that the pictures are in the albums and so I can add the thumbnails to the Album index page and the Album manager page.
I don't have the old database, I deleted it because it was corrupted somehow.
Surely when I add a new album that should register photos and thumbnails if it is a new album?

Pretty sure that all old enum fields (Yes/No) are now set to 0.

Running the installer the "old" data were suppose to be changed from Yes to 1 and from No to 0. Because of what you have done all this did not happened.

However if your database contains just and exclusively "approved" pictures, "public" albums ecc ecc so there are not restrictions at all then you could simply run an UPDATE query to change 0 to 1, otherwise you need to do that manually from phpmyadmin or any other sql browser.

Tables and fields are as following:

Code::

users => user_active_cp cpg_albums => uploads, comments, votes, stat_uptodate cpg_categories => stat_uptodate cpg_pictures => approved

Thanks for the reply Nano.
I followed your instruction as set out, however, I left the uploads and comments fields set at NO as all the photos are mine and no-one is allowed to post pics except me. (Sorry to sound like a megalomaniac).
Whilst I can still add pics and create albums, it is still showing them empty although you can get to the pics by clicking on the graphic.
The count on the album index still shows the albums as empty although on the album manager page it does show the count.
All the pics are approved.
Any other ideas?

"set at NO" ....

the point is that you shouldn't have "No" anymore .. if you do _still_ have "Yes" and/or "No" then something is totally wrong here.

As you said, you did:
1) backed up you old db
2) installed a fresh copy
3) imported you old db in to the new install

Is this all correct?

If this is correct then you should't have "No" anymore but "0" instead.
The problem comes for "Yes" values since MySQL will fail when guessing the correct value to use for the new field type (was enum, now its int) and will drop the defual value of "0".

Tecnically you should have all columns set to "0" and no more "Yes" and "No".

Ah, yes there are a few ENUM fields scattered around cpg_albums I take it these should be reset to INT and then 0?

THAT DID IT"!!!!!!!!!!!!!!!
Thanks ever so much Nano, I changed all the ENUM fields in Albums and catagoies to INT then set them either 1 or 0 depending in what I wanted and low and behold they all wortked.
Go have a look! iancharlesphotos.net


I can't thank you enough

Ian

I'm having the same issue after updating from 9.1.1 to 9.1.2.X. My photogallery shows that their are 0 pics in each album, but if u click on the album, you can see the pictures with no issue. If i try to update the albums it says "Album is empty".

I've checked the cpg_albums and cpg_category DB for ENUM but there were none. only INT settings (which were at 0). Any other ideas on how to fix this?