forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 modpack by Stramm => Topic started by: bitcloud on September 24, 2008, 12:18:40 pm
-
Hi Stramm... others...
I have a lot of deleted users on my gallery. This means that there are some users who were "buddies" with others, but are now deleted.
In buddy_manage.php it shows up no username, just the text "offline" for where these users used to be.
I'm not sure if this bug has been addressed, but it should be a matter of changing a CPG db query somewhere to check if a user exists before returning a buddy result. (and potentially the delete user file should be updated for this mod)
Thanks in advance for any help on what to change to correct this
-
hmm.. yes, the buddy table needs an update when a user gets deleted.
-
Thanks for the quick response...
in the mean time, can you think of which queries I should look toward modifying so that buddies only get called up if they're existing users?
-
That's not the way I'm going to fix it. To clean the buddy table you either nedd to check each entry manually or write a lil script that'll do that for you.
-
ok... I might do a hacky edit on the delete user file, and do what you say.. write a script to clean the buddy list..
Cheers for the advice :)
-
Strangely enough I found these lines:
//Delete Notifications
//Cleanup buddy tables
In delete.php. Not sure if they are your mods or mine (probably yours)
I can't duplicate the orphaned buddy entries when deleting anymore, so I'm not sure how all these orphaned/deleted buddies came about.
Anyway, to clean up the buddy table (if anyone else experiences this), I plugged this into phpmyadmin:
DELETE FROM `cpg1410_buddy` where user_id not in (select user_id from `cpg1410_users`)
and:
DELETE FROM `cpg1410_buddy` where buddy_id not in (select user_id from `cpg1410_users`)(replacing cpg1410 with whatever your version)