jos_users params gets larger every profile save?

Hello all,

I recently I have had an issue with a user who was unable to login - there was no error, but I could not view their profile, etc.

I checked the jos_users table and found that the params field should normally be:

However, I noticed that each time the profile is saved in the frontend, it keeps getting padded in forward slashes, for instance, this is one that had been modified several times but still works:

I only began to see this behaviour on the oldest users after adding some user fields in the backend (not sure if it is related).

Any ideas what could be going on? I am running Joomla 1.6.3 and CB 1.4 on XAMP 1.7.4. Thanks in advance.

After making a completely new install and copying file per file what I had changed, I finally figured it out, BUT it looks more like a bug of some sort to me.

/administrator/components/com_comprofiler/ue_config.php, line 68

This toggles the visibility of the default language/editor/timezone fields - when hidden, as you see above, my users params cells just get padded with useless slashes until it wrecks the profile.

Has anybody experienced this? This is happening on a brand new install of Joomla 1.6.5 and CB 1.4.

Bump, This is still a serious issue for me.

Hate to be annoying, but if the debug helps anyone help me...


32 Queries Logged

SELECT `data`
FROM `jos_test_session`
WHERE `session_id` = 'kuup87er9mjqbksqtvpujbkhl6'
DELETE
FROM `jos_test_session`
WHERE `time` < 1311015241
SELECT folder AS type, element AS name, params
FROM jos_test_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3)
ORDER BY ordering
SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_test_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component
FROM jos_test_menu AS m
LEFT JOIN jos_test_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
AND m.access IN (1,1,2,3)
ORDER BY m.lft
SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_test_extensions
WHERE `type` = 'component'
AND `element` = 'com_comprofiler'
SELECT *
FROM jos_test_languages
WHERE published=1
ORDER BY lang_id ASC
SELECT id, home, template, params
FROM jos_test_template_styles
WHERE client_id = 0
SELECT *
FROM jos_test_users AS u
LEFT JOIN jos_test_comprofiler AS c
ON c.id = u.id
WHERE u.id = 42
SHOW FIELDS
FROM jos_test_users
SELECT *
FROM jos_test_users
WHERE id = 42
SELECT g.id, g.title
FROM jos_test_usergroups AS g JOIN jos_test_user_usergroup_map AS m
ON m.group_id = g.id
WHERE m.user_id = 42
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM jos_test_comprofiler_plugin
WHERE published = 1
AND access <= 8
AND type = 'user'
ORDER BY ordering
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM jos_test_comprofiler_plugin
WHERE published = 1
AND access <= 8
AND type = 'templates'
ORDER BY ordering
SELECT `group_id`
FROM `jos_test_user_usergroup_map`
WHERE `user_id` = 42
SELECT g1.`id` AS group_id
FROM `jos_test_usergroups` AS g1
LEFT JOIN `jos_test_usergroups` AS g2
ON g2.`rgt` >= g1.`rgt`
AND g2.`lft` <= g1.`lft`
WHERE g2.`id` = 8
ORDER BY g1.`title`
SELECT g1.`id` AS group_id, g1.`title` AS name
FROM `jos_test_usergroups` AS g1
ORDER BY g1.`title`
SELECT *
FROM jos_test_comprofiler_tabs t
WHERE t.enabled=1
AND t.useraccessgroupid IN (-2,-1,1,2,3,4,5,6,7,8,10)
ORDER BY t.position, t.ordering
SELECT id
FROM jos_test_menu
WHERE link = 'index.php?option=com_comprofiler'
AND published=1
AND access <= 8
SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_test_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT a.id, a.catid, a.title, a.hits,a.created, ROUND( r.rating_sum / r.rating_count ) AS rating,r.rating_count, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug
FROM jos_test_content AS a
LEFT JOIN jos_test_content_rating AS r
ON r.content_id=a.id
LEFT JOIN jos_test_categories AS cc
ON cc.id = a.catid
WHERE a.created_by=42
AND a.state = 1
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2011-07-18 11:54:01')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2011-07-18 11:54:01')
AND a.access <= 8
ORDER BY a.created DESC
SELECT f.*
FROM jos_test_comprofiler_fields f
INNER JOIN jos_test_comprofiler_tabs AS t
ON (f.tabid = t.tabid)
WHERE f.published = 1
AND f.profile != 0
AND t.enabled = 1
AND t.useraccessgroupid IN (-2,-1,1,2,3,4,5,6,7,8,10)
ORDER BY t.position, t.ordering, f.ordering
SELECT MAX(time)
FROM jos_test_session
WHERE userid = 42
AND guest = 0
SELECT id, title, module, position, content, showtitle, params, mm.menuid
FROM jos_test_modules AS m
LEFT JOIN jos_test_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2011-07-18 19:54:01')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2011-07-18 19:54:01')
AND m.access IN (1,1,2,3)
AND m.client_id = 0
AND (mm.menuid = 111 OR mm.menuid <= 0)
ORDER BY position, ordering
SELECT banned
FROM jos_test_comprofiler
WHERE id = 42
SELECT count(*)
FROM jos_test_comprofiler
WHERE avatarapproved=0
AND approved=1
AND confirmed=1
AND banned=0
SELECT count(*)
FROM jos_test_comprofiler_userreports
WHERE reportedstatus=0
SELECT count(*)
FROM jos_test_comprofiler
WHERE banned=2
AND approved=1
AND confirmed=1
SELECT count(*)
FROM jos_test_comprofiler
WHERE approved=0
AND confirmed=1
SELECT firstname
FROM jos_test_comprofiler
WHERE id = 42
SELECT id
FROM jos_test_menu
WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
AND published=1
AND access <= 8
UPDATE `jos_test_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:19;s:19:\"session.timer.start\";i:1311018391;s:18:\"session.timer.last\";i:1311018840;s:17:\"session.timer.now\";i:1311018841;s:22:\"session.client.browser\";s:70:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:9:\"Derp Herp\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:23:\"jrenaud@compu-quote.com\";s:8:\"password\";s:65:\"65c280c1553207fa38a596f2c13665f9:vbPt6ySSWDHHtY7HEuAvJy129KIJ17jb\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:11:\"Super Users\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-06-15 16:48:25\";s:13:\"lastvisitDate\";s:19:\"2011-07-18 19:46:31\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{i:0;s:40:\"{\"0\":\"{\\\"0\\\":\\\"{\\\\\\\"0\\\\\\\":\\\\\\\"\\\\\\\"}\\\"}\"}\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:1:{s:40:\"177dbaf941dfcae818d6d6b1cf7c0605e16bf43b\";O:8:\"stdClass\":2:{s:4:\"link\";s:106:\"http://localhost:8080/joomla/16/index.php?option=com_content&view=article&id=1:homepage&catid=2&Itemid=101\";s:6:\"expiry\";i:1311018411;}}}', `time` = 1311018841
WHERE `session_id` = 'kuup87er9mjqbksqtvpujbkhl6'

26 Query Types Logged, Sorted by Occurrences.
SELECT Tables:

3 × SELECT count(*) FROM jos_test_comprofiler
3 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jos_test_extensions
2 × SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name FROM jos_test_comprofiler_plugin
2 × SELECT id FROM jos_test_menu
1 × SELECT f.* FROM jos_test_comprofiler_fields f INNER JOIN jos_test_comprofiler_tabs AS t ON (f.tabid = t.tabid)
1 × SELECT a.id, a.catid, a.title, a.hits,a.created, ROUND( r.rating_sum / r.rating_count ) AS rating,r.rating_count, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug FROM jos_test_content AS a LEFT JOIN jos_test_content_rating AS r ON r.content_id=a.id LEFT JOIN jos_test_categories AS cc ON cc.id = a.catid
1 × SELECT MAX(time) FROM jos_test_session
1 × SELECT banned FROM jos_test_comprofiler
1 × SELECT firstname FROM jos_test_comprofiler
1 × SELECT count(*) FROM jos_test_comprofiler_userreports
1 × SELECT * FROM jos_test_comprofiler_tabs t
1 × SELECT id, title, module, position, content, showtitle, params, mm.menuid FROM jos_test_modules AS m LEFT JOIN jos_test_modules_menu AS mm ON mm.moduleid = m.id
1 × SELECT g1.`id` AS group_id FROM `jos_test_usergroups` AS g1 LEFT JOIN `jos_test_usergroups` AS g2 ON g2.`rgt` >= g1.`rgt` AND g2.`lft` <= g1.`lft`
1 × SELECT id, home, template, params FROM jos_test_template_styles
1 × SELECT * FROM jos_test_languages
1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component FROM jos_test_menu AS m LEFT JOIN jos_test_extensions AS e ON m.component_id = e.extension_id
1 × SELECT folder AS type, element AS name, params FROM jos_test_extensions
1 × SELECT * FROM jos_test_users AS u LEFT JOIN jos_test_comprofiler AS c ON c.id = u.id
1 × SELECT * FROM jos_test_users
1 × SELECT `data` FROM `jos_test_session`
1 × SELECT `group_id` FROM `jos_test_user_usergroup_map`
1 × SELECT g.id, g.title FROM jos_test_usergroups AS g JOIN jos_test_user_usergroup_map AS m ON m.group_id = g.id
1 × SELECT g1.`id` AS group_id, g1.`title` AS name FROM `jos_test_usergroups` AS g1

OTHER Tables:

1 × UPDATE `jos_test_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:19;s:19:\"session.timer.start\";i:1311018391;s:18:\"session.timer.last\";i:1311018840;s:17:\"session.timer.now\";i:1311018841;s:22:\"session.client.browser\";s:70:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:9:\"Derp Herp\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:23:\"jrenaud@compu-quote.com\";s:8:\"password\";s:65:\"65c280c1553207fa38a596f2c13665f9:vbPt6ySSWDHHtY7HEuAvJy129KIJ17jb\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:11:\"Super Users\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-06-15 16:48:25\";s:13:\"lastvisitDate\";s:19:\"2011-07-18 19:46:31\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{i:0;s:40:\"{\"0\":\"{\\\"0\\\":\\\"{\\\\\\\"0\\\\\\\":\\\\\\\"\\\\\\\"}\\\"}\"}\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:1:{s:40:\"177dbaf941dfcae818d6d6b1cf7c0605e16bf43b\";O:8:\"stdClass\":2:{s:4:\"link\";s:106:\"http://localhost:8080/joomla/16/index.php?option=com_content&view=article&id=1:homepage&catid=2&Itemid=101\";s:6:\"expiry\";i:1311018411;}}}', `time` = 1311018841
1 × SHOW FIELDS FROM jos_test_user
1 × DELETE FROM `jos_test_session`

gblx wrote: Bump, This is still a serious issue for me.

Can you provide exact steps to replicate on a fresh J165/CB1.4 installation?

Thanks for replying, Nick - I am having a heckuva time trying to replicate how exactly it is recurring from a new install.

It doesn't happen immediately after an install.
It doesn't happen when I replace the modifications I have made to the core files.
It happens whenever a custom profile field is created - in this case a dropdown.

But, to be sure, I am going to trash this installation and start over.