Go Ahead, Manage - All Comments

re: From users to fans

skowronek — Fri, 21 Mar 2008 06:36:14 GMT

Andre,

You are correct. The purpose of my script is to move the comments to an "archive" user account, thereby maintaining the comments but really not the user ID that made them.

As with any direct DB management, experienced DBA or developers only.

However, I still think there should be an "archive" feature or something that at least lets us delete a user ID w/o having to clear out all related records. =)

re: From users to fans

Andre — Thu, 20 Mar 2008 19:21:16 GMT

It’s very interesting to see that some of our clients create tools to fit their needs.

However, I would like to bring a nuance to Karine’s post: you should be careful with the database integrity. This script can make the database “lie” to you about who make the comments, the task creator, etc. Also, some USER_ID references seem to be missing for some table, for example PROJECT_CREATOR_ID.

I don’t recommend using such a script, since there is no rollback possible. This is for advanced users only…

re: From users to fans

Karine — Wed, 19 Mar 2008 11:14:00 GMT

Jason,

Most of our users will simply upgrade their licenses when they run out of users.

re: From users to fans

skowronek — Tue, 18 Mar 2008 21:13:02 GMT

I'm flattered to have you discuss my feeble sql script. I wonder if there are any other core users such as I that have similar issues.

Thanks.