Only admin and new users can login after a migration from MySQL v4 to v5

[scassar]

Hi,

My Gallery was hosted by Free (www.free.fr) and worked perfectely since they upgrade from MySQL v4 to v5.
Admin can login without problems, but "users list" list only admin and new users (created after MySQL migration)... No error just :

Code Select Expand

Remarques
/include/functions.inc.php
Warning line 476: sprintf(): Too few arguments
/usermgr.php
Notice line 497: Undefined variable: user_data

Old users (created in MySQL v4) can login, but after a few seconds, they get the login screen. It's not a client problem (cookies) because I've tried with other computers.
When the login screen is back, I can notice :

Code Select Expand

Remarques
/login.php
Notice line 29: Undefined index: referer

Here is debug info :

Code Select Expand

USER:
------------------
Array
(
    [ID] => 78568c2f26d66a2f3054ad0c354fce6e
    [am] => 1
    [lang] => french
)

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

    [group_quota] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 0
    [can_post_comments] => 0
    [can_upload_pictures] => 0
    [can_create_albums] => 0
    [pub_upl_need_approval] => 1
    [priv_upl_need_approval] => 1
    [upload_form_config] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [custom_user_upload] => 0
    [disk_max] => 0
    [disk_min] => 0
    [ufc_max] => 0
    [ufc_min] => 0
    [has_admin_access] => 0
    [group_name] => Anonymous
    [can_see_all_albums] => 0
    [group_id] => 3
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg_filetypes; (0.001s)
    [1] => select * from cpg_plugins order by priority asc; (0.001s)
    [2] => delete from `scassar`.cpg_sessions where time<1143712197 and remember=0; (0.001s)
    [3] => delete from `scassar`.cpg_sessions where time<1142506197; (0s)
    [4] => select user_id from `scassar`.cpg_sessions where session_id=md5("45728bbf0e6a4cd671a5d8ebe6a8f5efc0f6121246417de5732e22669b682675"); (0.001s)
    [5] => select user_id as id, user_password as password from `scassar`.cpg_users where user_id=8 (0.001s)
    [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `scassar`.cpg_users AS u INNER JOIN `scassar`.cpg_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='8' (0.001s)
    [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 cpg_usergroups WHERE group_id in (3) (0.003s)
    [8] => SELECT group_name FROM  cpg_usergroups WHERE group_id= 3 (0s)
    [9] => update `scassar`.cpg_sessions set time='1143715797' where session_id=md5('45728bbf0e6a4cd671a5d8ebe6a8f5efc0f6121246417de5732e22669b682675'); (0s)
    [10] => DELETE FROM cpg_banned WHERE expiry < '2006-03-30 11:49:58' (0.11s)
    [11] => SELECT * FROM cpg_banned WHERE (ip_addr='82.235.93.207' OR ip_addr='82.235.93.207' OR user_id=0) AND brute_force=0 (0.001s)
    [12] => SELECT aid FROM cpg_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (3) (0.001s)
)

==========================
GET :
------------------
Array
(
)

==========================
POST :
------------------
Array
(
)

==========================
Page generated in 1.314 seconds - 13 queries in 0.121 seconds - Album set : AND aid NOT IN (15,13,14,12,11,10,16,17,18,19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,43) ; Meta set: ;

Thanx for any suggestion.

[scassar]

Sorry,

`cpg_usergroups`was set do default one... don't know why... solved by backing-it up.

Can be closed.

Thanx