Users reported missing user galleries. Nibbler posted a fix (http://forum.coppermine-gallery.net/index.php?topic=35151.msg165076#msg165076) and committed it to the stable and devel branches, so the fix will be in cpg1.4.9
For those who want to apply the fix manually:
Quote from: Nibbler on August 20, 2006, 05:40:50 PM
Edit bridge/udb_base.inc.php
find
$sql .= "WHERE ((isnull(approved) or approved='YES') AND category > " . FIRST_USER_CAT . ") $forbidden_with_icon GROUP BY category ";
change to
$sql .= "WHERE ((isnull(approved) or approved='YES') AND category > " . FIRST_USER_CAT . ") $forbidden_with_icon GROUP BY user_id ";
twice.
Anyone know what caused this? The code has not changed in the last few releases. I suspect an update to MySQL that has slightly changed the behaviour of the query. Perhaps the original query was in some way ambiguous.
I have no idea why this happened - I wondered about the same thing though: this query has been working for ages, and in the past 2 weeks, several users turned up, reporting this error.
Applied this tweak by Nibbler to a fresh Coppermine install.
But, the problem persists.
Under User Galleries in the main index, 10 albums are listed
containing 26 images. On entering Home > User galleries,
just 3 are visible. They do however appear under Random
files and Latest additions.
A further look under the bonnet/hood required maybe?
Regards,
N.
1) This is not a support thread
2) A link to your gallery might help
This fix worked perfectly for me.
Thanks :)