blog documentation FAQ followers forum marketplace services youtube

solved ACP User Account problem under data browser

The Jamroom Network » Forum » Installation and Configuration » Page » ACP User Account problem under data browser
MAD
MAD
@madc
10 years ago
600 posts
I have attached an image of what I am seeing
The top part shows the problem of a user with no image, no ID, no Username etc
Click the modify button and the address bar in my browser shows the link
myjrsite . com/user/account/user_id=
No id is in the address bar??
Also the account shown is id=1 ( Punk Band Promotions )
Any idea why this has happened and How I remove it?
user-error.jpg
user-error.jpg  •  70KB




--
~ https://punkbandpromotions.com ~
Check us out for all your Punk/Alternative Music!
Check us out on Facebook:- https://facebook.com/PunkBandPromotion
updated by @madc: 02/18/14 08:33:00AM
brian
@brian
10 years ago
10,148 posts
Look in the jr_jruser_item_key table, and see if there are entries in there for _item_id "1". That looks like _item_id 1 is missing (or maybe corrupted)?


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
MAD
MAD
@madc
10 years ago
600 posts
The attached image is what I have for id1
phpmyad.jpg
phpmyad.jpg  •  83KB




--
~ https://punkbandpromotions.com ~
Check us out for all your Punk/Alternative Music!
Check us out on Facebook:- https://facebook.com/PunkBandPromotion
updated by @madc: 01/16/14 05:17:31PM
brian
@brian
10 years ago
10,148 posts
That looks fine, although I do see a weird "user_id" key in there (without a leading underscore). There error you are getting however indicates the item does not exist, which doesn't make sense if that is correct.

I'm not sure what to tell you at this point without access to the system, as I've never come across or heard of this before.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
MAD
MAD
@madc
10 years ago
600 posts
Ok i removed the user_id row and left the _user_id one.
Still no change.
I can give you full access if you want a look?
Send it to the email address I already have @brian?


--
~ https://punkbandpromotions.com ~
Check us out for all your Punk/Alternative Music!
Check us out on Facebook:- https://facebook.com/PunkBandPromotion
brian
@brian
10 years ago
10,148 posts
ba9801:
Ok i removed the user_id row and left the _user_id one.
Still no change.
I can give you full access if you want a look?
Send it to the email address I already have @brian?

Yep - I'd appreciate that :)

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
MAD
MAD
@madc
10 years ago
600 posts
Ok Sent!


--
~ https://punkbandpromotions.com ~
Check us out for all your Punk/Alternative Music!
Check us out on Facebook:- https://facebook.com/PunkBandPromotion
brian
@brian
10 years ago
10,148 posts
I've got this fixed - the issue wasn't actually with user_id 1 - in your jr_jruser_item_key table there was a "stray" key for user_id 76, which didn't exist - I removed that single key and it's good now.

I'm not sure why the _updated key was still present in the key table - the only thing I can think of is that during a user delete there was a "hiccup" that kept that single key from being removed.

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
MAD
MAD
@madc
10 years ago
600 posts
So that row I removed ( user_id ) should have been there?


--
~ https://punkbandpromotions.com ~
Check us out for all your Punk/Alternative Music!
Check us out on Facebook:- https://facebook.com/PunkBandPromotion
brian
@brian
10 years ago
10,148 posts
ba9801:
So that row I removed ( user_id ) should have been there?

No - not sure what is adding that - I did see it on a couple other records as well, but it shouldn't hurt anything. I saw you had some custom modules - double check that they are not doing a jrCore_db_update_item for the "jrUser" module with "user_id" set in the data array.

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Tags