blog documentation FAQ followers forum marketplace services youtube

solved Removing stray profile from datastore

The Jamroom Network » Forum » Installation and Configuration » Page » Removing stray profile from datastore
MAD
MAD
@madc
10 years ago
600 posts
If I go into profiles in the acp i see the below
If I try to delete it it the url in the address bar is
mysite/profile/settings/profile_id=
So it is an empty profile that has been added or not deleted properly





--
~ https://punkbandpromotions.com ~
Check us out for all your Punk/Alternative Music!
Check us out on Facebook:- https://facebook.com/PunkBandPromotion
updated by @madc: 04/08/14 12:02:05PM
brian
@brian
10 years ago
10,148 posts
Weird - yeah you can go into the jr_jrprofile_item_key table and look for a bad entry. I'm guessing the _item_id will be 0 (zero), although there are a couple valid keys used internally that use 0, so don't delete any keys that are like "counter" keys that have an _item_id of 0.

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
iLoveHouseMusic
iLoveHouseMusic
@ilovehousemusic
10 years ago
517 posts
I have seen that also in my system.
MAD
MAD
@madc
10 years ago
600 posts
These are the only two in that table
0 profile_jrSmiley_item_count 0 8
0 profile_jrTrace_item_count 0 72
Any other thoughts?


--
~ https://punkbandpromotions.com ~
Check us out for all your Punk/Alternative Music!
Check us out on Facebook:- https://facebook.com/PunkBandPromotion
MAD
MAD
@madc
10 years ago
600 posts
Ok it is still there

Link is http://jr.punkbp.com/profile/settings/profile_id=
in admin
If I click on that link ( or the modify button in ACP as it can't be deleted )
it shows me the Main admin account but url is id=

This link
http://jr.punkbp.com/profile/settings/profile_id=
and this link
http://jr.punkbp.com/profile/settings/profile_id=1
show the same account at my end

Our other admin ( BA9801 ) clicked the
link http://jr.punkbp.com/profile/settings/profile_id=
to see what he got and he got one of the bands ( id=118 ) at the same link

I know it sounds confusing but something is not right.

I got him to test it to see what I was seeing and he never saw what I was seeing but the link was the same http://jr.punkbp.com/profile/settings/profile_id=

Anyone want log ins to check?
It doesn't seem to be effecting anything so far but would like to remove it in case it does


--
~ https://punkbandpromotions.com ~
Check us out for all your Punk/Alternative Music!
Check us out on Facebook:- https://facebook.com/PunkBandPromotion
updated by @madc: 03/03/14 06:25:13PM
MAD
MAD
@madc
10 years ago
600 posts
Ok another update.
Our other admin told me he was logged in as main admin but the last profile he edited was displaying at that link
I tried another account ( Myself ) as admin then went to the link and it now showed my account at the
http://jr.punkbp.com/profile/settings/profile_id= link


--
~ 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
Since the profile_id is not set to a valid ID, it will use yours. I'd have to get access to the DB to see what's up with this and see if I can come up with an idea of why this happened. My guess is that when a profile was deleted, it was not properly "cleaned up" and there's a stray key in the DS.

If you can send your admin info to me (and have the developer tools module installed) I can check it out.

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
MAD
MAD
@madc
10 years ago
600 posts
Ok Details sent @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
I believe I found the "bad" profile key (it was for profile_id 8) - the stray key was a "search" count key, which is actually the second time I've see a search count key be the only key remaining in the DS for a profile, so I'm going to check that out and see if I can spot why that might be happening.

Hope this helps!


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


--
~ 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 figured out why this was happening with search and have pushed out an update (version 1.1.5) - let me know if you see any issues.

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
MAD
MAD
@madc
10 years ago
600 posts
Sent you an email regarding the profile and user browser.


--
~ 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
MAD©:
Sent you an email regarding the profile and user browser.

I'll follow up here as well - there was short period yesterday (maybe 20 - 30 mins) where I had packaged up a release of the core that had a bug in the datastore.php I had added in - it was fixed and I updated it, so you should be able to go to Marketplace -> Tools -> Reload modules and skins, and reload the System Core and you should be good.

Let me know if that helps.

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
MAD
MAD
@madc
10 years ago
600 posts
Yes all good now. Thanks @brian!


--
~ https://punkbandpromotions.com ~
Check us out for all your Punk/Alternative Music!
Check us out on Facebook:- https://facebook.com/PunkBandPromotion

Tags