Re: Profil 1.52 - problème éditer un membre | Titre du sujet : Re: Profil 1.52 - problème éditer un membre par Monoroom sur 16/02/2009 09:48:33
Merci pour ta réponse, Je crois bien que mon installation se fait en utf-8.
j'ai vu aussi un sujet sur xoops.org : http://www.xoops.org/modules/newbb/vi ... =&topic_id=66775&forum=28 mais pas de solution apportée !
Voici en mode debug de mon cas
SET NAMES 'utf8'
SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM session WHERE sess_id = '316ad68d053d36d2b6c53b493102ef8a'
SELECT * FROM users WHERE uid = '3'
SELECT * FROM modules WHERE dirname = 'profile'
SELECT * FROM config WHERE (conf_modid = '40') ORDER BY conf_order ASC
DELETE FROM protector_access WHERE expire < UNIX_TIMESTAMP()
SELECT COUNT(*) FROM protector_access WHERE ip='88.121.18.116' AND request_uri='/modules/profile/edituser.php'
SELECT COUNT(*) FROM protector_access WHERE ip='88.121.18.116'
INSERT INTO protector_access SET ip='88.121.18.116',request_uri='/modules/profile/edituser.php',expire=UNIX_TIMESTAMP()+'60'
SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '2') ORDER BY conf_order ASC
SELECT COUNT(*) FROM `users` WHERE `uname` = 'XXXX' AND `uid` <> 3
SELECT COUNT(*) FROM `users` WHERE `email` = 'XXXXXX@gmail.com' AND `uid` <> 3
SELECT COUNT(*) FROM banner
SELECT * FROM banner LIMIT 0, 1
UPDATE banner SET impmade = impmade+1 WHERE bid = 19
SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2)
SELECT b.* FROM newblocks b, block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,40) AND b.bid IN (69,94,38,159,163,81,132,5,68,7,178,64,63,65,119,62,2,1,180,179,177,176,175,174,173,172,171,170,169,168,167,166,162,161,160,158,139,137,136,135,134,133,118,117,116,115,114,113,112,111,110,109,108,107,98,97,96,95,188,87,106,105,104,103,102,101,100,99,85,83,82,80,79,78,77,76,75,74,73,72,67,66,84,55,54,71,53,70,46,43,42,41,40,39,37,36,35,34,33,32,31,30,29,28,27,26,25,12,11,9,8,6,4,3,187,186,185,184,183,192,191,24,23,10,194,193,182,181,195,196) ORDER BY b.weight,m.block_id
SELECT * FROM modules WHERE dirname = 'pm'
SELECT COUNT(*) FROM priv_msgs WHERE (read_msg = '0' AND to_userid = '3')
SELECT * FROM modules WHERE dirname = 'mpmanager'
SELECT * FROM config WHERE (conf_modid = '32') ORDER BY conf_order ASC
SELECT COUNT(*) FROM online WHERE online_uid=3
UPDATE online SET online_updated=1234773639, online_module = 40 WHERE online_uid = 3
SELECT COUNT(*) FROM priv_msgs WHERE (read_msg = '0' AND to_userid = '3')
SELECT * FROM `users` WHERE (uid > '345')
SELECT COUNT(*) FROM priv_msgs WHERE (to_userid = '3')
SELECT COUNT(*) FROM multimenu01 WHERE hide = 1
SELECT id, pid, groups, link, submenu, title, target, imageurl, weight FROM multimenu01 WHERE hide = 1 ORDER BY weight ASC
SELECT * FROM smiles
SELECT COUNT(*) FROM multimenu02 WHERE hide = 1
SELECT id, pid, groups, link, submenu, title, target, imageurl, weight FROM multimenu02 WHERE hide = 1 ORDER BY weight ASC
SELECT COUNT(*) FROM online WHERE online_uid=3
UPDATE online SET online_updated=1234773640, online_module = 40 WHERE online_uid = 3
SELECT * FROM online
SELECT COUNT(*) FROM online WHERE online_module = '40'
SELECT COUNT(*) FROM multimenu05 WHERE hide = 1
SELECT id, pid, groups, link, submenu, title, target, imageurl, weight FROM multimenu05 WHERE hide = 1 ORDER BY weight ASC
SELECT * FROM modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC, mid ASC
SELECT * FROM group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2'))
SELECT * FROM modules WHERE dirname = 'news'
SELECT * FROM config WHERE (conf_modid = '7') ORDER BY conf_order ASC
SELECT gperm_itemid FROM group_permission LEFT JOIN modules m ON gperm_modid=m.mid WHERE m.dirname='myalbum' AND gperm_name='myalbum_global' AND (gperm_groupid IN (1,2))
SELECT * FROM groups
SELECT lid, cid, title, logourl, date, hits FROM x_movie WHERE status>0 ORDER BY rand() limit 4
SELECT * FROM profile_profile WHERE profile_id = '3'
SELECT * FROM `profile_field` WHERE field_id != '0' ORDER BY field_weight ASC
SELECT * FROM group_permission WHERE (gperm_name = 'profile_edit' AND gperm_modid = '40' AND (gperm_groupid = '1' OR gperm_groupid = '2'))
SELECT * FROM `profile_category`
SELECT rank_id, rank_title FROM ranks WHERE rank_special = 1
SELECT * FROM groups WHERE groupid != '3'
|
|