JUser::_load: Unable to load user with id:

Need help with the Administration of your Joomla! 1.5 site? This is the spot for you.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
joomz
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Fri Apr 11, 2008 3:05 pm

JUser::_load: Unable to load user with id: 2147483647

Post by joomz » Fri Apr 11, 2008 3:26 pm

I am having troubles with the new joomla 1.5.2. I suspect this is as a result of a recent update to joomla because I did install a trial about 2 -3 weeks ago which seemed fine but now I seem to be have problems.

I download the tar.gz version from http://joomlacode.org/gf/project/joomla ... ge_id=3466 and installed it but after a colleague said he couldn't create a new menu I decided to take a look and ended up spotting a different problem all together Whenever I try to edit user information by clicking on a username in the backend including the administrator I get the error message "JUser::_load: Unable to load user with id: 2147483647"

I have tried uninstalling and installing Joomla and downloading a new version from the site but nothings seems to fix the problem

I am attaching a screen grab of the error message

Help please. Cheers.
You do not have the required permissions to view the files attached to this post.

User avatar
DJMoomla
Joomla! Apprentice
Joomla! Apprentice
Posts: 42
Joined: Mon Sep 17, 2007 9:53 pm

Re: JUser::_load: Unable to load user with id:

Post by DJMoomla » Tue Apr 15, 2008 10:42 am

Is the user an actual record in the database? Check jos_users to make sure. Do you have that many users on the website? It strikes me as a bit odd that the user id is that high already...unless you did an import or somehow set your autoincrement really high or to random.
PPP > Joomla > PHP > CSS > HTML > TXT.
Promote Positive Posts...Don't be a snarky Joomler Poster
http://www.danmelton.net

joomz
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Fri Apr 11, 2008 3:05 pm

Re: JUser::_load: Unable to load user with id:

Post by joomz » Tue Apr 15, 2008 11:17 am

Hey thanks for the response.

There is only one user in the table jos_users which is the Administrator with an id of 62.

I should mention that we were using PHP 4.3.9 and just upgraded to PHP 5.2.5 but are still having the same issue. We have also tried installing Joomla 1.5.2 on the local server which uses Windows SBS, IIS and PHP 5 that seems to work fine but not on the remote server which uses Linux, Apache and PHP 5.2.5.

Another thing I noticed was that directory permissions under system info->directory permissions appear to be flagged as unwritable unless you chmod to 777 which I thought was unusual. I don't know if this is related to the problems I am having but I have chmod to 777 and that hasn't fix the problem either.

User avatar
DJMoomla
Joomla! Apprentice
Joomla! Apprentice
Posts: 42
Joined: Mon Sep 17, 2007 9:53 pm

Re: JUser::_load: Unable to load user with id:

Post by DJMoomla » Wed Apr 16, 2008 11:50 am

Turn on Debug including the language option (for db queries) and paste the output here. You can do that in the global configuration. That would help. I doubt very much that this is a permission issue.
PPP > Joomla > PHP > CSS > HTML > TXT.
Promote Positive Posts...Don't be a snarky Joomler Poster
http://www.danmelton.net

joomz
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Fri Apr 11, 2008 3:05 pm

Re: JUser::_load: Unable to load user with id:

Post by joomz » Wed Apr 16, 2008 12:10 pm

out with debug turned on:

•Profile Information•
Application afterLoad: 0.004 seconds, 0.32 MB
Application afterInitialise: 0.069 seconds, 2.37 MB
Application afterRoute: 0.069 seconds, 2.37 MB
Application afterDispatch: 0.180 seconds, 4.54 MB
Application afterRender: 0.211 seconds, 5.07 MB
•Memory Usage•
5353976
•19 queries logged•

1.
SELECT *
FROM jos_session
WHERE session_id = '1103f8edfbe9f4ab7c28d4277c16465a'
2.
DELETE
FROM jos_session
WHERE ( time < '1208346524' )
3.
SELECT *
FROM jos_session
WHERE session_id = '1103f8edfbe9f4ab7c28d4277c16465a'
4.
UPDATE jos_session
SET `time`='1208347424',`userid`='62',`usertype`='Super Administrator',`username`='admin',`gid`='25',`guest`='0',`client_id`='1',`data`='__default|a:8:{s:15:\"session.counter\";i:14;s:19:\"session.timer.start\";i:1208347276;s:18:\"session.timer.last\";i:1208347379;s:17:\"session.timer.now\";i:1208347384;s:22:\"session.client.browser\";s:92:\"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.13) Gecko/20080311 Firefox/2.0.0.13\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:2:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:11:\"application\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";s:2:\"62\";s:4:\"name\";s:13:\"Administrator\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:22:\"[email protected]\";s:8:\"password\";s:65:\"0eb396218a2277cdb6dd8a8145e09e73:57x342jNkBNmOBY3PyenaVthltpHr22k\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:3:\"gid\";s:2:\"25\";s:12:\"registerDate\";s:19:\"2008-04-11 15:56:19\";s:13:\"lastvisitDate\";s:19:\"2008-04-15 11:14:24\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:0:\"\";s:3:\"aid\";i:2;s:5:\"guest\";i:0;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:87:\"/var/www/vhosts/selectdigital.co.uk/httpdocs/v2/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"a0f75144757b03b737d6922d07f5cc71\";}'
WHERE session_id='1103f8edfbe9f4ab7c28d4277c16465a'
5.
SELECT *
FROM jos_components
WHERE parent = 0
6.
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 2
ORDER BY ordering
7.
SELECT template
FROM jos_templates_menu
WHERE client_id = 1
AND menuid = 0
8.
SELECT *
FROM jos_users
WHERE id = '2147483647'
9.
SELECT id
FROM jos_core_acl_aro_groups
WHERE value='Registered'
10.
SELECT id
FROM jos_core_acl_aro
WHERE section_value='users'
AND value=''
11.
SELECT id
FROM jos_core_acl_aro
WHERE section_value='users'
AND value='62'
12.
SELECT gm.group_id

FROM jos_core_acl_groups_aro_map gm

WHERE gm.aro_id=10
13.
SELECT id, parent_id, value, name, lft, rgt
FROM jos_core_acl_aro_groups
WHERE id=25
14.
SELECT lft, rgt
FROM jos_core_acl_aro_groups
WHERE name = 'USERS'
15.
SELECT g1.id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2
ON g1.lft BETWEEN g2.lft
AND g2.rgt
WHERE g1.lft BETWEEN 3
AND 22
GROUP BY g1.name
ORDER BY g1.lft
16.
SELECT element AS value, name AS text
FROM jos_plugins
WHERE folder = "editors"
AND published = 1
ORDER BY ordering, name
17.
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 2
AND m.client_id = 1
ORDER BY position, ordering
18.
SELECT COUNT(*)
FROM jos_messages
WHERE state = 0
AND user_id_to = 62
19.
SELECT COUNT( session_id )
FROM jos_session
WHERE guest <> 1

•Language Files Loaded•

* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.ini 1
* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.plg_system_debug.ini 1
* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.com_users.ini 1
* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.tpl_khepri.ini 1
* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.mod_title.ini 1
* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.mod_toolbar.ini 1
* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.mod_menu.ini 1
* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.mod_status.ini 1

•Untranslated strings•

•None•

User avatar
DJMoomla
Joomla! Apprentice
Joomla! Apprentice
Posts: 42
Joined: Mon Sep 17, 2007 9:53 pm

Re: JUser::_load: Unable to load user with id:

Post by DJMoomla » Wed Apr 16, 2008 12:32 pm

Try adding a couple of new users. After you add them, click on them to see if you get the same error. If so, I'll try to replicate the problem on my machine.

The debug queries look fine with the exception of the jos_users query.
PPP > Joomla > PHP > CSS > HTML > TXT.
Promote Positive Posts...Don't be a snarky Joomler Poster
http://www.danmelton.net

User avatar
DJMoomla
Joomla! Apprentice
Joomla! Apprentice
Posts: 42
Joined: Mon Sep 17, 2007 9:53 pm

Re: JUser::_load: Unable to load user with id:

Post by DJMoomla » Wed Apr 16, 2008 12:57 pm

Ok, repost what you sent to me here please.

Next thing, check jos_users and make sure that the test user has an id of 63, 64, 65 etc. If so, then paste this after the index.php?
option=com_users&view=user&task=edit&cid[]=63

alter 63 to be whatever that id is for the new user.

the url should look something like:

http://www.url.com/administrator/index. ... t&cid[]=63

Also, paste the url before you do this, I'd like to see if it is calling that long number where 63 should be.

I'm trying to narrow it down to where it is getting that long number from.
PPP > Joomla > PHP > CSS > HTML > TXT.
Promote Positive Posts...Don't be a snarky Joomler Poster
http://www.danmelton.net

joomz
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Fri Apr 11, 2008 3:05 pm

Re: JUser::_load: Unable to load user with id:

Post by joomz » Wed Apr 16, 2008 1:49 pm

After adding a new user called Test and trying to edit this user I still get the same error message with the debug script below. I can confirm that the new user was added successfully to the table jos_user

•Profile Information•
Application afterLoad: 0.004 seconds, 0.32 MB
Application afterInitialise: 0.070 seconds, 2.37 MB
Application afterRoute: 0.070 seconds, 2.37 MB
Application afterDispatch: 0.185 seconds, 4.54 MB
Application afterRender: 0.216 seconds, 5.07 MB
•Memory Usage•
5353864
•19 queries logged•

1.
SELECT *
FROM jos_session
WHERE session_id = '47956cfee7c9cf9d7d85d0ec706343a5'
2.
DELETE
FROM jos_session
WHERE ( time < '1208352904' )
3.
SELECT *
FROM jos_session
WHERE session_id = '47956cfee7c9cf9d7d85d0ec706343a5'
4.
UPDATE jos_session
SET `time`='1208353804',`userid`='62',`usertype`='Super Administrator',`username`='admin',`gid`='25',`guest`='0',`client_id`='1',`data`='__default|a:8:{s:22:\"session.client.browser\";s:92:\"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.13) Gecko/20080311 Firefox/2.0.0.13\";s:15:\"session.counter\";i:8;s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:2:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:11:\"application\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";s:2:\"62\";s:4:\"name\";s:13:\"Administrator\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:22:\"[email protected]\";s:8:\"password\";s:65:\"0eb396218a2277cdb6dd8a8145e09e73:57x342jNkBNmOBY3PyenaVthltpHr22k\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:3:\"gid\";s:2:\"25\";s:12:\"registerDate\";s:19:\"2008-04-11 15:56:19\";s:13:\"lastvisitDate\";s:19:\"2008-04-16 12:43:09\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:0:\"\";s:3:\"aid\";i:2;s:5:\"guest\";i:0;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:87:\"/var/www/vhosts/selectdigital.co.uk/httpdocs/v2/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"c996265b9418f2eef236030001c49757\";s:19:\"session.timer.start\";i:1208353509;s:18:\"session.timer.last\";i:1208353749;s:17:\"session.timer.now\";i:1208353754;}'
WHERE session_id='47956cfee7c9cf9d7d85d0ec706343a5'
5.
SELECT *
FROM jos_components
WHERE parent = 0
6.
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 2
ORDER BY ordering
7.
SELECT template
FROM jos_templates_menu
WHERE client_id = 1
AND menuid = 0
8.
SELECT *
FROM jos_users
WHERE id = '2147483647'
9.
SELECT id
FROM jos_core_acl_aro_groups
WHERE value='Registered'
10.
SELECT id
FROM jos_core_acl_aro
WHERE section_value='users'
AND value=''
11.
SELECT id
FROM jos_core_acl_aro
WHERE section_value='users'
AND value='62'
12.
SELECT gm.group_id

FROM jos_core_acl_groups_aro_map gm

WHERE gm.aro_id=10
13.
SELECT id, parent_id, value, name, lft, rgt
FROM jos_core_acl_aro_groups
WHERE id=25
14.
SELECT lft, rgt
FROM jos_core_acl_aro_groups
WHERE name = 'USERS'
15.
SELECT g1.id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2
ON g1.lft BETWEEN g2.lft
AND g2.rgt
WHERE g1.lft BETWEEN 3
AND 22
GROUP BY g1.name
ORDER BY g1.lft
16.
SELECT element AS value, name AS text
FROM jos_plugins
WHERE folder = "editors"
AND published = 1
ORDER BY ordering, name
17.
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 2
AND m.client_id = 1
ORDER BY position, ordering
18.
SELECT COUNT(*)
FROM jos_messages
WHERE state = 0
AND user_id_to = 62
19.
SELECT COUNT( session_id )
FROM jos_session
WHERE guest <> 1

•Language Files Loaded•

* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.ini 1
* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.plg_system_debug.ini 1
* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.com_users.ini 1
* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.tpl_khepri.ini 1
* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.mod_title.ini 1
* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.mod_toolbar.ini 1
* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.mod_menu.ini 1
* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.mod_status.ini 1

•Untranslated strings•

•None•

joomz
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Fri Apr 11, 2008 3:05 pm

Re: JUser::_load: Unable to load user with id:

Post by joomz » Wed Apr 16, 2008 1:58 pm

The user Test has the id 63 and using the url below gives exactly the same error as joomla http://www.selectdigital.co.uk/v2/admin ... t&cid[]=63

debug output of the above url is:

•Profile Information•
Application afterLoad: 0.004 seconds, 0.32 MB
Application afterInitialise: 0.124 seconds, 2.37 MB
Application afterRoute: 0.124 seconds, 2.37 MB
Application afterDispatch: 0.316 seconds, 4.54 MB
Application afterRender: 0.393 seconds, 5.07 MB
•Memory Usage•
5353864
•19 queries logged•

1.
SELECT *
FROM jos_session
WHERE session_id = '47956cfee7c9cf9d7d85d0ec706343a5'
2.
DELETE
FROM jos_session
WHERE ( time < '1208352981' )
3.
SELECT *
FROM jos_session
WHERE session_id = '47956cfee7c9cf9d7d85d0ec706343a5'
4.
UPDATE jos_session
SET `time`='1208353881',`userid`='62',`usertype`='Super Administrator',`username`='admin',`gid`='25',`guest`='0',`client_id`='1',`data`='__default|a:8:{s:22:\"session.client.browser\";s:92:\"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.13) Gecko/20080311 Firefox/2.0.0.13\";s:15:\"session.counter\";i:9;s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:2:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:11:\"application\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";s:2:\"62\";s:4:\"name\";s:13:\"Administrator\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:22:\"[email protected]\";s:8:\"password\";s:65:\"0eb396218a2277cdb6dd8a8145e09e73:57x342jNkBNmOBY3PyenaVthltpHr22k\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:3:\"gid\";s:2:\"25\";s:12:\"registerDate\";s:19:\"2008-04-11 15:56:19\";s:13:\"lastvisitDate\";s:19:\"2008-04-16 12:43:09\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:0:\"\";s:3:\"aid\";i:2;s:5:\"guest\";i:0;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:87:\"/var/www/vhosts/selectdigital.co.uk/httpdocs/v2/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"c996265b9418f2eef236030001c49757\";s:19:\"session.timer.start\";i:1208353509;s:18:\"session.timer.last\";i:1208353754;s:17:\"session.timer.now\";i:1208353804;}'
WHERE session_id='47956cfee7c9cf9d7d85d0ec706343a5'
5.
SELECT *
FROM jos_components
WHERE parent = 0
6.
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 2
ORDER BY ordering
7.
SELECT template
FROM jos_templates_menu
WHERE client_id = 1
AND menuid = 0
8.
SELECT *
FROM jos_users
WHERE id = '2147483647'
9.
SELECT id
FROM jos_core_acl_aro_groups
WHERE value='Registered'
10.
SELECT id
FROM jos_core_acl_aro
WHERE section_value='users'
AND value=''
11.
SELECT id
FROM jos_core_acl_aro
WHERE section_value='users'
AND value='62'
12.
SELECT gm.group_id

FROM jos_core_acl_groups_aro_map gm

WHERE gm.aro_id=10
13.
SELECT id, parent_id, value, name, lft, rgt
FROM jos_core_acl_aro_groups
WHERE id=25
14.
SELECT lft, rgt
FROM jos_core_acl_aro_groups
WHERE name = 'USERS'
15.
SELECT g1.id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2
ON g1.lft BETWEEN g2.lft
AND g2.rgt
WHERE g1.lft BETWEEN 3
AND 22
GROUP BY g1.name
ORDER BY g1.lft
16.
SELECT element AS value, name AS text
FROM jos_plugins
WHERE folder = "editors"
AND published = 1
ORDER BY ordering, name
17.
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 2
AND m.client_id = 1
ORDER BY position, ordering
18.
SELECT COUNT(*)
FROM jos_messages
WHERE state = 0
AND user_id_to = 62
19.
SELECT COUNT( session_id )
FROM jos_session
WHERE guest <> 1

•Language Files Loaded•

* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.ini 1
* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.plg_system_debug.ini 1
* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.com_users.ini 1
* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.tpl_khepri.ini 1
* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.mod_title.ini 1
* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.mod_toolbar.ini 1
* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.mod_menu.ini 1
* /var/www/vhosts/selectdigital.co.uk/httpdocs/v2/administrator/language/en-GB/en-GB.mod_status.ini 1

•Untranslated strings•

•None•

joomz
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Fri Apr 11, 2008 3:05 pm

Re: JUser::_load: Unable to load user with id:

Post by joomz » Thu Apr 17, 2008 3:42 pm

Update:

I have notice that this issue does not appear to happen in IE but in Firefox. Haven said that it appears to be fine even in Firefox when running Joomla on a windows platform using IIS instead of Apache.

I also noticed that clicking on any article/content does not load the content into the edit area and simply loads a nothing i.e. you can not edit content even though the content shows on the front end.

Also the error generated when you try to edit a user always says JUser::_load: Unable to load user with id: 2147483647 with the same number 2147483647 A quick search of the source code has reveled this number under plugins/editors/tinymce/jscripts/tiny_mce/tiny_mce_src.js on line 5158

I hope this helps to identify the problem and fix it.

joomz
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Fri Apr 11, 2008 3:05 pm

Joomla Doesn't Apear to work in Firefox!!

Post by joomz » Thu Apr 17, 2008 4:23 pm

I need to get someone's attention to this ssue because I think its quite important. I started a post about issues I was having editing users but it soon became clear the issue might be bigger than previously thought tand might have something to do with Firefox. Please view my original post for details

http://forum.joomla.org/viewtopic.php?f=428&t=284356

User avatar
humvee
Joomla! Master
Joomla! Master
Posts: 14704
Joined: Wed Aug 17, 2005 10:27 pm
Location: Kent, England

Re: Joomla Doesn't Apear to work in Firefox!!

Post by humvee » Thu Apr 17, 2008 4:58 pm

Joomla! works fine with Firefox, IE6.5 +, Opera and Safari browsers for the majority of users. Occasionally IE6 will throw a wobbly with certain template settings. I personally use Firefox and IE 7 on Joomla! a regular basis and run testing in Opera.

The issue is more likely to be the installation of Joomla! on the server or more correctly the configuration of the server or your particular installation of Firefox.

Andy

User avatar
dhuelsmann
Joomla! Master
Joomla! Master
Posts: 19659
Joined: Sun Oct 02, 2005 12:50 am
Location: Omaha, NE
Contact:

Re: JUser::_load: Unable to load user with id:

Post by dhuelsmann » Thu Apr 17, 2008 5:54 pm

Please don't post a new topic in another forum and point to another topic to try to get feedback. Topics merged and moved to general questions.
Regards, Dave
Past Treasurer Open Source Matters, Inc.
Past Global Moderator
http://www.kiwaniswest.org

User avatar
DJMoomla
Joomla! Apprentice
Joomla! Apprentice
Posts: 42
Joined: Mon Sep 17, 2007 9:53 pm

Re: JUser::_load: Unable to load user with id:

Post by DJMoomla » Fri Apr 18, 2008 1:34 pm

Ok, perhaps there is a problem with TinyMCE. If that number is found in the tinymcs js sccript, lets try installing a different wysiwyg editor. Grab the JCE editor and install it. I like that one more anyway.
PPP > Joomla > PHP > CSS > HTML > TXT.
Promote Positive Posts...Don't be a snarky Joomler Poster
http://www.danmelton.net

joomz
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Fri Apr 11, 2008 3:05 pm

Re: JUser::_load: Unable to load user with id:

Post by joomz » Fri Apr 18, 2008 2:26 pm

just tried to download the JCE but the link goes to a dead site cant seem to find it anywhere else.. you dont happen to have it do you?

User avatar
DJMoomla
Joomla! Apprentice
Joomla! Apprentice
Posts: 42
Joined: Mon Sep 17, 2007 9:53 pm

Re: JUser::_load: Unable to load user with id:

Post by DJMoomla » Fri Apr 18, 2008 3:05 pm

Not sure what happened, this must be recent. Try deleting that id out of tinymce in .js file. (Save a copy in case it screws everything up.)
PPP > Joomla > PHP > CSS > HTML > TXT.
Promote Positive Posts...Don't be a snarky Joomler Poster
http://www.danmelton.net

stephanb
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Sat May 03, 2008 5:53 am

Re: JUser::_load: Unable to load user with id:

Post by stephanb » Sat May 03, 2008 6:22 am

Code: Select all

SELECT *
FROM jos_users
WHERE id = '2147483647'
Looking at your debugging code, it looks like the id shouldn't have single quotes around 2147483647. Furthermore, since you're expecting the integer 62 or 63, and not this long number, I'll bet that this two-digit number got accidentally converted to its ascii/unicode/hexadecimal numerical representation.

Thought, I'm relatively new to this joomla/php/mysql environment. I come from a different programming/database background. So I can't guarantee that my hunch is going to be right in this case.

- Stephan

User avatar
abossola
Joomla! Intern
Joomla! Intern
Posts: 82
Joined: Tue Apr 11, 2006 3:57 pm

Re: JUser::_load: Unable to load user with id:

Post by abossola » Tue Jun 03, 2008 9:28 pm

Are you using a mac to upload files?

joomz
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Fri Apr 11, 2008 3:05 pm

Re: JUser::_load: Unable to load user with id:

Post by joomz » Wed Jun 04, 2008 8:42 am

nope using pc windows.

User avatar
abossola
Joomla! Intern
Joomla! Intern
Posts: 82
Joined: Tue Apr 11, 2006 3:57 pm

Re: JUser::_load: Unable to load user with id:

Post by abossola » Wed Jun 04, 2008 12:24 pm

I'm having the same problem. Maybe upgrade to 1.5.3? I'll let you know how it goes.

mumra
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Sat Jan 24, 2009 10:59 pm

Re: JUser::_load: Unable to load user with id:

Post by mumra » Sat Jan 24, 2009 11:04 pm

DJMoomla wrote:Turn on Debug including the language option (for db queries) and paste the output here. You can do that in the global configuration. That would help. I doubt very much that this is a permission issue.
I've been going through a similar problem. Now my site won't come back on at all and i cannot get access to my site completely.

How do i turn off the debug mode???

User avatar
ShannonMcG
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Sun Jun 01, 2008 8:36 pm
Location: San Diego, California
Contact:

Re: JUser::_load: Unable to load user with id:

Post by ShannonMcG » Wed Apr 29, 2009 4:11 am

This might be because you deleted a user in Joomla that is being referenced by a component. Some components have a DB table for users that relates to the Joomla DB user table.

You might need to go into the DB and edit the users table. I saw a similar problem after I deleted a user in joomla that was set up as an author in a component. I had to go into mySQL via phpMyAdmin and manually sync the users between from Joomla to the component based on the user ID.

As usual do a complete site backup before you do any DB editing.
---
Shannon McGlathery
Principal, Vivimedia
http://shannonmcglathery.com
http://rad-dad.com

dataphage
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Thu Oct 22, 2009 1:17 am

Re: JUser::_load: Unable to load user with id:

Post by dataphage » Tue Feb 02, 2010 11:18 pm

Hi Folks

For me this was a clash with RokNewsPager - disabled the module and the error went away

shrey
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Wed Apr 07, 2010 12:05 pm

Re: JUser::_load: Unable to load user with id:

Post by shrey » Mon Apr 12, 2010 3:01 am

try to reinstall the modules associated with the deleted users..
my problem of JUser was solved by applying this method :D

User avatar
columbusgeek
Joomla! Apprentice
Joomla! Apprentice
Posts: 47
Joined: Mon Jun 04, 2007 1:53 pm
Location: columbus ohio
Contact:

Re: JUser::_load: Unable to load user with id:

Post by columbusgeek » Tue Apr 13, 2010 1:01 am

Why not just create a new user, go into your DB and change the id to the one that is throwing the error? literally a 2 minute fix.

augustuk
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Tue Jul 06, 2010 12:52 am

Re: JUser::_load: Unable to load user with id:

Post by augustuk » Tue Jul 06, 2010 1:16 pm

Why not just create a new user, go into your DB and change the id to the one that is throwing the error? literally a 2 minute fix.
This worked perfectly for me, took 30 seconds, just inserted some new data in phpmyadmin, set the ID to 64 and it solved the issue!

wellis321
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Wed Apr 29, 2009 11:27 pm
Location: Glasgow
Contact:

Re: JUser::_load: Unable to load user with id:

Post by wellis321 » Wed Sep 08, 2010 2:48 pm

Hello All
I only encountered this issue today. The problem only occurred under a particular menu which was a k2 Category. I have other k2 Categories which were not affected. At first I uninstalled project fork as the user id was associated with it but that didn't work. I should state that I had only just deleted the user account that the id was generated from.
Then I created a new fictional user- went into jos_users in the database through Cpanel and changed the fictional users id to the one generating the problem.
Voila! problem gone.
Thanks for the help.
Warm Regards
William

nsvr6
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Fri Apr 11, 2008 12:49 am

Re: JUser::_load: Unable to load user with id:

Post by nsvr6 » Tue Oct 26, 2010 2:15 am

After reading and thinking and you may know this, the "JUser::_load: Unable to load user with id:" error is simply an article that was written by some whose id has been deleted. Simply recreate the article under your name or another that is present in the User Manager. Possibly you can simply hide the author of the article, which might do the trick. Otherwise, all this going into the database and changing jos-stuff is way beyond me..

dbensonnj
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Tue Feb 03, 2009 10:47 pm

Re: JUser::_load: Unable to load user with id:

Post by dbensonnj » Mon Apr 11, 2011 6:07 am

Quote:
Why not just create a new user, go into your DB and change the id to the one that is throwing the error? literally a 2 minute fix.

This worked perfectly for me, took 30 seconds, just inserted some new data in phpmyadmin, set the ID to 64 and it solved the issue!
That is the answer!!!
thanks

om1985
Joomla! Apprentice
Joomla! Apprentice
Posts: 48
Joined: Tue Jun 08, 2010 1:54 am
Location: New Zealand
Contact:

Re: JUser::_load: Unable to load user with id:

Post by om1985 » Thu May 26, 2011 3:43 am

columbusgeek wrote:Why not just create a new user, go into your DB and change the id to the one that is throwing the error? literally a 2 minute fix.
Yes this is the solution. It is because there are no registered users apart from the super administrator account. So just create a user account and "HEY PRESTO"


Locked

Return to “Administration 1.5”