Albums of album_type = 1 not displaying content about koken-app

[modufolio]

Hi Guy Montagu-Pollock,

Thank you for your kinds words!

I'm sorry, I can't reproduce the issue. Please first make a database backup and try to update the portfolio album type from 1 to 2.

UPDATE koken_albums SET album_type = '2' WHERE album_type = '1';

[GuyMP]

Dear Maarten,

Thank you for such a quick reply. I'm sorry you couldn't replicate the issue. I have changed the album types from 1 to 2 as you suggested. This changed their icon to the "set" icon in Library view but did not cure or improve the fault I am experiencing.

I suppose it is possible that my data has become corrupt in some way. I'm checking and trying to understand the tables now. If worst comes to the worst, I shall try rebuilding the site again — which I would have to do anyway if I switched from Koken to something else. I'd much rather keep Koken!

Yours,
Guy.

[GuyMP]

Further to this, and having backed up the database, I went to clear the empty test set and album I had created above. I had trouble emptying the trash, left it spinning for an hour with no change. Tried another browser: same thing. I checked the database, deleted lines in koken_trash manually, and checked koken_albums where deleted = 1. There were approximately a dozen entries with deleted = 1. After deleting all of them manually koken/admin and the site started behaving normally.

I am at a loss to explain this but I'll take this stroke of luck!

Guy.

[GuyMP]

As an experiment, returned those collections to album_type = 1 and the fault came back exactly. Changed them to album_type = 2 (and flushed the caches) and the problem went away. So:

• album_type = 1 not displaying content.
• incomplete emptying of trash (perhaps a legacy of aborting lengthy emptying of trash) can introduce glitches.

Guy.