Print

[Master-D]

i want to remove the 'user galleries' as i get this

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

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

Code: [Select]

        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.