User galleries missing

[Joachim Müller]

Users reported missing user galleries. Nibbler posted a fix 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:

Edit bridge/udb_base.inc.php

find

Code Select Expand

$sql .= "WHERE ((isnull(approved) or approved='YES') AND category > " . FIRST_USER_CAT . ") $forbidden_with_icon GROUP BY category ";

change to

Code Select Expand

$sql .= "WHERE ((isnull(approved) or approved='YES') AND category > " . FIRST_USER_CAT . ") $forbidden_with_icon GROUP BY user_id ";

twice.

[Nibbler]

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.

[Joachim Müller]

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.

[nissehud]

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.

[Joachim Müller]

1) This is not a support thread
2) A link to your gallery might help

[SherryG]

This fix worked perfectly for me.

Thanks