Come into my elgglaxy ;-)
From:- Bill Sawyer
````````````````````````````````````````````````````````````````````````````
@Dhrup ...
and for documentation purposes,
here are the tables and the column within those tables
that I looked at to find orphaned objects.
Table Column
elgg_access_collections owner_guid
elgg_access_collections_membership user_guid
elgg_annotations owner_guid
elgg_entities owner_guid
elgg_entity_relationships guid_one and
guid_two
elgg_metadata owner_guid
elgg_river subject_guid and
object_guid (possibly)
elgg_system_log owner_guid
elgg_users_apisessions user_guid
elgg_users_entity guid
`````````````````````````````````````````````
I hope this helps with the possible cleaning script.
I checked all those tables for data related to the users I deleted.
I found nothing in them, but I still have missing data.
And, I still have 208 vs. 211 users (as documented above).
`````````````````````````````````````````````
info@elgg.org
Security issues should be reported to security@elgg.org!
©2014 the Elgg Foundation
Elgg is a registered trademark of Thematic Networks.
Cover image by RaĆ¼l Utrera is used under Creative Commons license.
Icons by Flaticon and FontAwesome.
oki ;-)
I've reviewed Bill's list - very minor tweak there.
now i've got the basics coded for a new utility "ScanORPHAN" which is intended to go and hunt for orphans - any "object" that has lost their owner ;-(
Here's a little sneak preview ==>
``````````````````````````````````````````````````````````
$POST:
scanORPHAN
@Dhrup ... will look forward to seeing this utility. I will be more than happy to test it out for you.
managed to make some progress on the code for scanORPHAN.php, but seems it will take time ;-)
**** need code/ db research assistance here ==>
SELECT
FROM `elgg_metastrings`
WHERE `string` LIKE '%file/%'
will identify metadata which points to a "file" object
there must be other unique wildcards which also identify other "objects"
can someone please volunteer to do this research ?
thx.. ;-)
I think the problem is the first "%. Just use LIKE 'file/%'. I ran this query through phpMyAdmin, and it worked:
SELECT * FROM elggmetastrings WHERE string LIKE 'file/%'
The initial wildcard throws off the search.
of course..! my dyslexia ;-( but.. might there be *other types of wildcards that will find diff objects, beyond file/ ?
Well, elgg_entities has a type and subtype. That might get you what you want.
Also, I went through my own elgg_metastrings. I can't be assured I have "every" possibility, but you might consider the following:
"file/%' points to a file
"friends::" points to a friend entry
"http://" and "https://" points to a bookmark
"image/" points to a image. There are "image/bmp", "image/jpeg", "image/pjpeg", and "image/x-png" at the very least.
Hope that helps.
thx.. getting better.... shows you how little test data i have on my xamppp ;-)
Well, given that my site is relatively new and only around 250 users or so, I wouldn't say I have every data instance either. But, those are definitely in the data.
Where does elgg store the large binary objects like files and images?
e.g. for userID "admin" ==>
but.. this will change in v1.7++
- Previous
- 1
- 2
- Next
You must log in to post replies.