SMF COPPERMINE help SMF COPPERMINE help
 

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

SMF COPPERMINE help

Started by Master-D, June 29, 2006, 01:52:56 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Master-D

i want to remove the 'user galleries' as i get this
QuoteWhile executing query "SELECT ID_MEMBER as user_id,memberName as user_name,COUNT(DISTINCT a.aid) as alb_count,COUNT(DISTINCT pid) as pic_count,MAX(pid) as thumb_pid, MAX(galleryicon) as gallery_pid FROM cpg_albums AS a INNER JOIN `zgbcpbiv_smf1`.smf_members as u on u.ID_MEMBER+10000=a.category LEFT JOIN cpg_pictures AS p ON p.aid = a.aid WHERE ((isnull(approved) or approved='YES') AND category > 10000)  GROUP BY category ORDER BY category LIMIT 0, 12 " on 0

mySQL error:
Quote
the bridging works fine from the forum, but i need to disable the link it puts in for user galleries, as that feature switches off as soon as i bridge it over.
PLEASE HELP ???

File: /home/*******/public_html/gallery/include/functions.inc.php - Line: 248







        if (!$CONFIG['debug_mode']) {
            cpg_die(CRITICAL_ERROR, $lang_errors['database_query'], __FILE__, __LINE__);
        } else {

                $the_error .= "\n\nmySQL error: ".mysql_error()."\n";

                $out = "<br />".$lang_errors['database_query'].".<br /><br/>
                    <form name=\"mysql\"><textarea rows=\"8\" cols=\"60\">".htmlspecialchars($the_error)."</textarea></form>";

            cpg_die(CRITICAL_ERROR, $out, __FILE__, __LINE__);
        }
}

// Fetch all rows in an array

/**
* cpg_db_fetch_rowset()
*
* Fetch all rows in an array
*

these are lines 239 - 258

Nibbler

You can remove user galleries by deleting all albums in user galleries and then disabling creation of new user galleries. Make sure you are using the latest version of Coppermine and refer to the manual and the forums.