RISC OS Open
Safeguarding the past, present and future of RISC OS for everyone
ROOL
Home | News | Downloads | Bugs | Bounties | Forum | Documents | Photos | Contact us
Account

Previous|Next

  • Tickets
  • » Ticket #82

Ticket #82 (WontFix)Sat Oct 28 22:09:31 UTC 2006

RForum shadow User database sweeper

Reported by: Andrew Hodgkinson (6) Severity: Enhancement
Part: Web site: Beast (forum engine; forum pages) Release: 2nd public site release
Milestone: 2nd public site release completed Status WontFix

Details by Andrew Hodgkinson (6):

RForum maintains its internal User database automatically now, adding entries when new Hub users visit the forum for the first time while logged in. If a Hub user deletes their account, though, the RForum account persists because Hub doesn’t know about RForum (and shouldn’t have to either). If the user made any forum posts there are two options:

(1) Delete their posts (discussions could become inconsistent)
(2) Orphan the account by clearing the e-mail field, as when a Hub user with a duplicate e-mail address but new ID logs in.

For users without forum posts, consider deleting their User record in RForum to keep the database size to a minimum. An external sweeper program with access to both Hub and RForum databases would be required. This operation would not need to be done frequently – on the order of months or even per-year, in all probability.

Changelog:

Modified by Andrew Hodgkinson (6) Mon, March 12 2007 - 00:40:18 GMT

RForum has been replaced by Beast, but the same problem – such as it is – exists. While migrating data to the new database, I did see examples of stubbed out user accounts where individuals had changed Hub account details with the same e-mail address. These entries were still being used in relation to posts. The number of dead entries with no associated posts was tiny, so while there still ought to be some kind of cleanup mechanism added sooner or later, it doesn’t seem to be needed too urgently.

Modified by Andrew Hodgkinson (6) Thu, October 09 2008 - 18:49:05 GMT

  • Part changed from RForum (old forum engine, no longer used) to Beast (forum engine; forum pages)

Modified by Andrew Hodgkinson (6) Mon, March 14 2011 - 23:39:49 GMT

  • Status changed from Open to WontFix

This just isn’t an issue in practice. New user accounts number in the hundreds a year on the ROOL site at most; in comparison, the Wiki has over 8,500 revisions stored in it. The storage space for the User objects isn’t a big issue and the database is designed to perform well with orders of magnitude more records. Closing this with “WontFix”.

  • Comment on, or change status of, this ticket

Previous|Next

Search tickets

Social

Follow us on and

ROOL Store

Buy RISC OS Open merchandise here, including SD cards for Raspberry Pi and more.

Donate! Why?

Help ROOL make things happen – please consider donating!

RISC OS IPR

RISC OS is an Open Source operating system owned by RISC OS Developments Ltd and licensed primarily under the Apache 2.0 license.

Options

  • Tickets
  • New ticket
  • Milestones
  • Subversion: Changesets
  • Subversion: Browse
  • CVS: Revisions
  • CVS: Browse
  • Search

RSS feeds Rss

  • Tickets
  • Everything!
  • More feeds...
Site design © RISC OS Open Limited 2018 except where indicated
The RISC OS Open Collaboa theme is distantly based on the Collaboa default layout

Valid XHTML 1.0  |  Valid CSS

Powered by Collaboa
This site runs on Rails

Hosted by Arachsys