User galleries missing User galleries missing
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

User galleries missing

Started by Joachim Müller, August 24, 2006, 05:58:16 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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:
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.

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 :)