Fixing Bugs in Elgg Live Site

Sometimes you will need to fix or delete things in the elgg live site. Going into the database and fixing or inserting new records is a big pita. The database is very normalized and the records are spread across various rows in many tables. Your best best is to try to login as an admin user and perform the edit/delete action you want.

If being an admin doesn't work, you can try logging in as the user that created the records. In order to do this you will want to set your onid username as the user for the user that you want to login as. For example:

• You need to login as Don Heer
• Then you go and find the guid of Don in the elgg_users_entity table
• Then you update the username of that row with your own onid username
• Don't forget to set your old account to use a different onid account

If you need to update attributes you will need to look for records in the elgg_annotations table.