User Albums past page 1 not showing

[thebimmer]

My site (registration required):
http://www.flyguylive.com/modules.php?name=coppermine
is unable to see any User Albums (124 of them, total) past page 1.

When attempting to go to pages 2-4, the pages will act as if it is loading the thumbs, etc.  But, looking at the pics, they are showing 'nopic.jpg'  And, the category is always 1000, and no normal pics shows.  (And, all albums worked properly before the upgrade.)

This is an upgrade from CPG-Nuke 1.1D.

I will admit that I screwed up on the first install, which I installed standalone cpg.  I then went back and removed the changes that the standalone made.  After that, I made sure I got the cpgnuke upgrade files and upgraded from there.

As a side note, sometime today, the cpg_pictures db table was messed up.  This was noticed before I did the proper sql file (nuke upgrade version.)

Any ideas?
thanks
eric

[DJMaze]

name: test123
pass: test123

[thebimmer]

Any ideas as to why the albums on pages higher than 1 are shown as basically being unknown?

Thanks
eric

[gtroll]

We require you to send us a login via pm if you want help with registration only galleries. Upgrade to RC3 is my suggestion and let us know if your problem persists, with a URL or pm'ed password.

[thebimmer]

I updated to RC3 as suggested.

I am still experiencing the "nopic" and no albums in my user galleries.

This time, I have the "nopic"'s on the first page, and subsequent pages.  The differences between the first and subsequent pages are the links when moving the mouse over the thumbs.  While on the first page, the resulting link gives a link to a valid cat (BottomBoi, http://www.flyguylive.com/modules.php?name=coppermine&cat=15703) while the subsequent pages give links to invalid cat (Any on pages 2 and higher, http://www.flyguylive.com/modules.php?name=coppermine&cat=10000).

For the first above example, there are three pictures, the uploaded, the normal_, and the thumb_ one.  But, clicking on the link on the first page shows "0 pictures".

Any ideas?

Thanks
eric

The userid is 'test123', and the password is 'test123'.

[gtroll]

Login Incorrect! Please Try Again...

[thebimmer]

The username and password are 'test123'.  I just changed the password.

[DJMaze]

ok tried to login several times without luck so i asked for new password "guxxaser" and recieved it by mail.
Still i can't login with account :?

[thebimmer]

Evidently, another admin saw the post from DJ and thought it was a request to add the account.  There were two 'test123' accounts.

I have removed the erroneous one, and logged in via the 'test123' account DJMaze had created with 'guxxaser'.

eric

[DJMaze]

Ok working and i've seen you definately have a problem.
somehow the albums are all empty starting at page 2.

We shall try to fix, although it's hard when we don't have 30 users on local harddrive.

btw please mention you have nudity on your pages by every link you post.

[pinguish]

change your config to to 1 colum wide by 1 tall and you can replicate with just 2 albums FWIW its common with release.

[thebimmer]

I have updated all files in the RC4 distro.  I'm still seeing the errors as described above.

[DJMaze]

This problem is solved and solution will be available soon.

open index.php and replace the whole function

Code Select Expand

function list_users()
{

}

with this:

Code Select Expand

function list_users()
{
    global $CONFIG, $PAGE, $FORBIDDEN_SET, $CPG_M_DIR;
    global $lang_list_users, $lang_errors, $template_user_list_info_box;
    global $field_user_id, $field_user_name;

    $sql = "SELECT $field_user_id, " .
           "$field_user_name, " .
           "COUNT(DISTINCT a.aid) as alb_count, " .
           "COUNT(DISTINCT pid) as pic_count, " .
           "MAX(pid) as thumb_pid " .
           "FROM {$CONFIG['TABLE_USERS']} AS u " .
           "INNER JOIN {$CONFIG['TABLE_USERGROUPS']} AS g ON user_group_cp = group_id " .
           "INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON category = " . FIRST_USER_CAT . " + $field_user_id " .
           "LEFT JOIN {$CONFIG['TABLE_PICTURES']} AS p ON (p.aid = a.aid AND approved = 'YES' $FORBIDDEN_SET) " .
           "GROUP BY user_id ORDER BY $field_user_name";
    $result = db_query($sql);
    $user_count = mysql_num_rows($result);
    if (!$user_count) {
        msg_box($lang_list_users['user_list'], $lang_list_users['no_user_gal'], '', '', '100%');
        mysql_free_result($result);
        return;
    }

    $user_per_page = $CONFIG['thumbcols'] * $CONFIG['thumbrows'];
    $totalPages = ceil($user_count / $user_per_page);
    if ($PAGE > $totalPages) $PAGE = 1;
    $lower_limit = ($PAGE-1) * $user_per_page;
    $upper_limit = min($user_count, $PAGE * $user_per_page);

    $row_count = $upper_limit - $lower_limit;

    $rowset = array();
    $i = 0;
    mysql_data_seek($result, $lower_limit);
    while (($row = mysql_fetch_array($result)) && ($i++ < $row_count)) $rowset[] = $row;
    mysql_free_result($result);

    $user_list = array();

    for ($i = 0; $i < $row_count; $i++) {
        $user = &$rowset[$i];
        $user_thumb = '<img src="' . $CPG_M_DIR . '/images/nopic.jpg" class="image" border="0">';
        $user_pic_count = $user['pic_count'];
        $user_thumb_pid = $user['thumb_pid'];
        $user_album_count = $user['alb_count'];

        if ($user_pic_count) {
            $sql = "SELECT filepath, filename, url_prefix, pwidth, pheight " .
                   "FROM {$CONFIG['TABLE_PICTURES']} " .
                   "WHERE pid='$user_thumb_pid'";
            $result = db_query($sql);
            if (mysql_num_rows($result)) {
                $picture = mysql_fetch_array($result);
                mysql_free_result($result);

                $image_size = compute_img_size($picture['pwidth'], $picture['pheight'], $CONFIG['thumb_width']);
                $user_thumb = "<img src=\"" . get_pic_url($picture, 'thumb') . "\" {$image_size['geom']} alt=\"\" border=\"0\" class=\"image\">";
            }
        }

        $albums_txt = sprintf($lang_list_users['n_albums'], $user_album_count);
        $pictures_txt = sprintf($lang_list_users['n_pics'], $user_pic_count);

        $params = array('{username}' => $user[$field_user_name],
            '{USER_ID}' => $user[$field_user_id],
            '{ALBUMS}' => $albums_txt,
            '{PICTURES}' => $pictures_txt,
        );
        $caption = template_eval($template_user_list_info_box, $params);

        $user_list[] = array('cat' => FIRST_USER_CAT + $user[$field_user_id],
            'image' => $user_thumb,
            'caption' => $caption,
        );
    }
    theme_display_thumbnails($user_list, $user_count, '', '', 1, $PAGE, $totalPages, false, true, 'user');
}

[thebimmer]

I have updated my coppermine/index.php and that worked.  For the most part.

I think the ones that are not working currently are ones that were added while I was having the problem.

I will update when I know more.

But, in the meantime, that change does appear to work properly!

Thanks
eric

[thebimmer]

I was able to delete all the incorrect albums in the user gallery.

So far the albums are showing properly.

Thanks again!
eric