forum.coppermine-gallery.net

Dev Board => cpg1.4 Testing/Bugs => cpg1.4 Testing/Bugs: FIXED/CLOSED => Topic started by: Joachim Müller on August 24, 2006, 05:58:16 am

Title: User galleries missing
Post by: Joachim Müller on August 24, 2006, 05:58:16 am
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:
Edit bridge/udb_base.inc.php

find

Code: [Select]
$sql .= "WHERE ((isnull(approved) or approved='YES') AND category > " . FIRST_USER_CAT . ") $forbidden_with_icon GROUP BY category ";
change to

Code: [Select]
$sql .= "WHERE ((isnull(approved) or approved='YES') AND category > " . FIRST_USER_CAT . ") $forbidden_with_icon GROUP BY user_id ";
twice.
Title: Re: User galleries missing
Post by: Nibbler on August 24, 2006, 06:51:01 pm
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.
Title: Re: User galleries missing
Post by: Joachim Müller on August 24, 2006, 07:11:31 pm
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.
Title: Re: User galleries missing
Post by: nissehud on August 27, 2006, 02:51:22 pm
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.
Title: Re: User galleries missing
Post by: Joachim Müller on August 27, 2006, 11:45:11 pm
1) This is not a support thread
2) A link to your gallery might help
Title: Re: User galleries missing
Post by: SherryG on August 29, 2006, 03:39:28 pm
This fix worked perfectly for me.

Thanks :)