login problem :(

[NaRvA]

hi all

i did upgrade on my server (as explained in docs) and after that both users and me as admin can't login anymore to the gallery (endless loop back to index page)

coppermine script was updated from 1.4.9 to 1.4.10 and mysql from 4.0.22 to 5.0.34

i searched thru forums, but can't find solution - i tried all tips with cookies and checked file/dir permissions

link to my site: http://www.narvanet.com

test account: test/t3st3r

greetings
Adam

[Sami]

check this:
http://forum.coppermine-gallery.net/index.php?topic=39922.0

[NaRvA]

i didn't use fantastico or anything like that

[vici]

nor do I, my host upgraded mysql only from MySQL 4.0 to MySQL 4.1.22. I thought that it would be a minor change, but unfortunately, no-one is able to login now...

[Sami]

Post a link to your gallery

[vici]

ok I set a debug mode, I hope I won't break any rules by posting it - I have already xxx-ed tables' names
in my gallery, guests are unable to view any albums. it seems to me that after the attempt of logging in, the coppermine redirects EVERY user to the guest mode and that's why no-one is able to browse through the pics

additional question: how to let guests view all albums by changing the settings via mysql? I have no access to the coppermine admin panel right now =[

USER:
------------------
Array
(
    [ID] => d19c68b71367a0092c5449a4a68397e6
    [am] => 1
    [lang] => polish
    [liv] => Array
        (
        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 0
    [user_name] => Guest
    [groups] => Array
        (
           

• => 3
          )
  
      [group_quota] => 0
      [can_rate_pictures] => 0
      [can_send_ecards] => 0
      [can_post_comments] => 0
      [can_upload_pictures] => 0
      [can_create_albums] => 0
      [pub_upl_need_approval] => 0
      [priv_upl_need_approval] => 0
      [upload_form_config] => 0
      [num_file_upload] => 0
      [num_URI_upload] => 0
      [custom_user_upload] => 0
      [disk_max] => 0
      [disk_min] => 0
      [ufc_max] => 0
      [ufc_min] => 0
      [has_admin_access] => 0
      [group_name] => Guests
      [can_see_all_albums] => 0
      [group_id] => 3
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content, player FROM xxx_filetypes; (0.011s)
      [1] => select * from xxx_plugins order by priority asc; (0.006s)
      [2] => delete from `xxx_coppermine`.xxx_sessions where time<1192046848 and remember=0;
  
  (0.012s)
      [3] => delete from `xxx_coppermine`.xxx_sessions where time<1190840848; (0.008s)
      [4] => select user_id from `xxx_coppermine`.xxx_sessions where
  
  session_id=md5("8b52847a7baa3e04e8a80176916eb0b595d77f5469bd1128c3256c95297ff6b8"); (0.011s)
      [5] => SELECT session_id FROM `xxx_coppermine`.xxx_sessions WHERE
  
  session_id=MD5('21f2a41c0f9be9de8e977408e10dc36d95d77f5469bd1128c3256c95297ff6b8') (0.009s)
      [6] => insert into `xxx_coppermine`.xxx_sessions (session_id, user_id, time, remember)
  
  values ("d441febc1c7634618f953c75783d4603", 0, "1192050448", 0); (0.01s)
      [7] => 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
  
  xxx_usergroups WHERE group_id in (3) (0.01s)
      [8] => SELECT group_name FROM  xxx_usergroups WHERE group_id= 3 (0.003s)
      [9] => update `xxx_coppermine`.xxx_sessions set time='1192050448' where
  
  session_id=md5('21f2a41c0f9be9de8e977408e10dc36d95d77f5469bd1128c3256c95297ff6b8'); (0.007s)
      [10] => DELETE FROM xxx_banned WHERE expiry < '2007-10-10 21:07:28' (0.002s)
      [11] => SELECT * FROM xxx_banned WHERE (ip_addr='90.156.29.97' OR ip_addr='90.156.29.97'
  
  OR user_id=0) AND brute_force=0 (0.002s)
      [12] => SELECT aid FROM xxx_albums WHERE visibility != '0' AND visibility !='10000' AND
  
  visibility NOT IN (3) (0.004s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  Page generated in 0.531 seconds - 13 queries in 0.095 seconds - Album set : AND aid NOT IN
  
  (328,330,331,332,335,341,343,345,352,354,355,356,361,369,374) ; Meta set: ;

[vici]

^ edit: I mean how to let guests view all albums by changing the settings via myphpadmin?

[Sami]

I asked for a link not the debug info !

[vici]

yup, I know, but there's no need, because I've already fixed the problem. coppermine has always surprised me in how easy it could be to solve a problem but on the other hand how difficult it is to find what the problem is like and what it was caused by
I realised the problem was about some failure in login process so I decided to re-upload the login.php file. before I did so, I had uploaded the old login.php file to my HDD for some let's say security reasons (in case sth unexpected happened). then I tried to login but a fatal error occured. I almost fainted, but then uploaded the old login.php file, deleted the newly uploaded one and...coppermine started to work! that's funny   
anyway, thanks for your will of help. I didn't post my gallery link for numerous reasons. please forgive me 

[Sami]

Then it was a cookie issue
for those with same problem simply deleting cookies works fine