There are no user galleries... but there are!

[jessondair]

I have Coppermine 1.4.8 integrated with my SMF forum and until recently everything worked just fine.  I'm not sure what's changed, because I haven't made any changes to the forum or the photo gallery since I installed it. But now, when you go into the main photos link, it shows there are 74 user galleries, containing 300+ files. But when I click on the link for user galleries, it says there are no user galleries.  Each member is still able to get into their individual gallery and put pictures there, and their user galleries can be seen with a direct link to them (for example, I have a link built into their profile pages that other users can click to see the photos that go with their profiles, and that works just fine) but if they just want to browse the user galleries they can't do it.

Any idea where I can look for a problem in the code or settings on this?

Thanks!

[Sami]

Upgrade ...

[Dave Smooth]

I am having this same problem too.  I am using CPG 1.4.10 (stable) with an SMF forum with Enigma portal and the Enigma bridge.  Everything was fine, and now it tells me there are No User Galleries.  As far as I can tell, nothing has changed, and when you click on the home page it says there are 2536 files in 59 albums, but when you click the link it gives the error.   Any help?  At least point me in the right direction?   I noticed this happened when a user recently deleted his account on my forum, and I went through and deleted that users pictures and the error went away.    I'm not sure if this is the case again, but any help would be greatly appreciated.

Can be viewed here:

http://deepprogressions.com/coppermine

[Dave Smooth]

Thought I would add the output from the debug info.

USER:
------------------
Array
(
    [ID] => 0a1a89dc162d6a41e1b2dc0a4b74ff02
    [am] => 1
    [lang] => english
    [liv] => Array
        (
        )

    [lap] => 3
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => Dave Smooth
    [groups] => Array
        (
           

• => 1
          )
  
      [disk_max] => 250000
      [disk_min] => 250000
      [can_rate_pictures] => 1
      [can_send_ecards] => 1
      [ufc_max] => 3
      [ufc_min] => 3
      [custom_user_upload] => 0
      [num_file_upload] => 5
      [num_URI_upload] => 3
      [can_post_comments] => 1
      [can_upload_pictures] => 1
      [can_create_albums] => 1
      [has_admin_access] => 1
      [pub_upl_need_approval] => 0
      [priv_upl_need_approval] => 0
      [group_name] => Administrators
      [upload_form_config] => 3
      [group_quota] => 250000
      [can_see_all_albums] => 1
      [group_id] => 1
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content, player FROM cpg_143filetypes; (0.001s)
      [1] => select * from cpg_143plugins order by priority asc; (0s)
      [2] => SELECT * FROM cpg_143bridge (0.001s)
      [3] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg_143usergroups WHERE group_id in (1) (0.001s)
      [4] => SELECT group_name FROM  cpg_143usergroups WHERE group_id= 1 (0s)
      [5] => SELECT user_favpics FROM cpg_143favpics WHERE user_id = 1 (0.001s)
      [6] => DELETE FROM cpg_143banned WHERE expiry < '2007-01-29 04:19:14' (0s)
      [7] => SELECT * FROM cpg_143banned WHERE (ip_addr='68.35.69.108' OR ip_addr='68.35.69.108' OR user_id=1) AND brute_force=0 (0s)
      [8] => SELECT aid FROM cpg_143albums as a WHERE category>=10000 (0.001s)
      [9] => SELECT cid FROM cpg_143categories WHERE parent = '1' (0s)
      [10] => SELECT name, parent FROM cpg_143categories WHERE cid = '1' (0s)
      [11] => SELECT cid, name, description, thumb FROM cpg_143categories WHERE parent = '1'  ORDER BY name (0s)
      [12] => SELECT aid FROM cpg_143albums as a WHERE category >= 10000 (0.001s)
      [13] => SELECT COUNT(*) FROM cpg_143pictures WHERE approved = 'NO' (0.001s)
      [14] => select null from cpg_143albums as p  INNER JOIN cpg_143pictures AS pics ON pics.aid = p.aid where ( category>10000 ) group by category; (0.001s)
      [15] => 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_143albums AS a INNER JOIN `user_504138`.smf_members as u on u.ID_MEMBER = a.category - 10000 INNER JOIN cpg_143pictures AS p ON p.aid = a.aid WHERE ((isnull(approved) or approved='YES') AND category > 10000)  GROUP BY user_id ORDER BY category LIMIT 24, 12  (0.021s)
      [16] => SELECT count(*) FROM cpg_143albums as a WHERE category = '1' (0.001s)
      [17] => SELECT COUNT(*) from cpg_143pictures WHERE approved = 'YES' AND aid IN (2,14,5,8,9,10,11,12,15,16,17,27,20,21,22,26,24,46,34,33,29,66,36,37,38,40,79,80,81,42,44,45,47,49,50,52,53,54,55,56,57,58,59,61,62,63,64,65,68,69,70,71,72,73,74,76,77,78)  (0s)
      [18] => SELECT * FROM cpg_143pictures WHERE approved = 'YES' AND aid IN (2,14,5,8,9,10,11,12,15,16,17,27,20,21,22,26,24,46,34,33,29,66,36,37,38,40,79,80,81,42,44,45,47,49,50,52,53,54,55,56,57,58,59,61,62,63,64,65,68,69,70,71,72,73,74,76,77,78)  ORDER BY RAND() LIMIT 8 (0.042s)
      [19] => SELECT COUNT(*) from cpg_143pictures WHERE approved = 'YES' AND aid IN (2,14,5,8,9,10,11,12,15,16,17,27,20,21,22,26,24,46,34,33,29,66,36,37,38,40,79,80,81,42,44,45,47,49,50,52,53,54,55,56,57,58,59,61,62,63,64,65,68,69,70,71,72,73,74,76,77,78)  (0.003s)
      [20] => SELECT * FROM cpg_143pictures WHERE approved = 'YES' AND aid IN (2,14,5,8,9,10,11,12,15,16,17,27,20,21,22,26,24,46,34,33,29,66,36,37,38,40,79,80,81,42,44,45,47,49,50,52,53,54,55,56,57,58,59,61,62,63,64,65,68,69,70,71,72,73,74,76,77,78)  ORDER BY pid DESC  LIMIT 0 ,8 (0.003s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
      [cat] => 1
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 4.3.11 - OK
  ------------------
  mySQL version:
  ------------------
  Coppermine version: 1.4.10(stable)
  ==========================
  Module: GD
  ------------------
  GD Version: bundled (2.0.28 compatible)
  FreeType Support: 1
  FreeType Linkage: with freetype
  T1Lib Support:
  GIF Read Support: 1
  GIF Create Support: 1
  JPG Support: 1
  PNG Support: 1
  WBMP Support: 1
  XBM Support: 1
  JIS-mapped Japanese Font Support:
  
  ==========================
  Module: mysql
  ------------------
  MySQL Supportenabled
  Active Persistent Links 0
  Active Links 1
  Client API version 3.23.49
  MYSQL_MODULE_TYPE builtin
  MYSQL_SOCKET /tmp/mysql.sock
  MYSQL_INCLUDE no value
  MYSQL_LIBS no value
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Compiled Version 1.1.4
  Linked Version 1.1.4
  ==========================
  Server restrictions (safe mode)?
  ------------------
  Directive | Local Value | Master Value
  safe_mode | Off | Off
  safe_mode_exec_dir | /usr/local/php/bin | /usr/local/php/bin
  safe_mode_gid | Off | Off
  safe_mode_include_dir | no value | no value
  safe_mode_exec_dir | /usr/local/php/bin | /usr/local/php/bin
  sql.safe_mode | Off | Off
  disable_functions | no value | no value
  file_uploads | On | On
  include_path | .:/usr/local/lib/php | .:/usr/local/lib/php
  open_basedir | no value | no value
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value
  sendmail_from | no value | no value
  sendmail_path | /usr/sbin/sendmail -t -i  | /usr/sbin/sendmail -t -i
  SMTP | relay-hosting.secureserver.net | relay-hosting.secureserver.net
  smtp_port | 25 | 25
  ==========================
  Size and Time
  ------------------
  Directive | Local Value | Master Value
  max_execution_time | 30 | 30
  max_input_time | 60 | 60
  upload_max_filesize | 2M | 2M
  post_max_size | 8M | 8M
  ==========================
  Page generated in 0.408 seconds - 21 queries in 0.078 seconds - Album set : AND aid IN (2,14,5,8,9,10,11,12,15,16,17,27,20,21,22,26,24,46,34,33,29,66,36,37,38,40,79,80,81,42,44,45,47,49,50,52,53,54,55,56,57,58,59,61,62,63,64,65,68,69,70,71,72,73,74,76,77,78) ; Meta set: AND aid IN (2,14,5,8,9,10,11,12,15,16,17,27,20,21,22,26,24,46,34,33,29,66,36,37,38,40,79,80,81,42,44,45,47,49,50,52,53,54,55,56,57,58,59,61,62,63,64,65,68,69,70,71,72,73,74,76,77,78) ;

[Sami]

This could be [custom] bridge issue , ask your question here

[Dave Smooth]

Thanks, but fixed it.  It seems a member did delete a gallery, took a bit for the database to update is all.  But I thank you for your quick reply.  Plus I deleted my cache.  Just thought I would post the fix for future user inquiries.