Migration Posts

**UkPlayer** · 05-01-2002, 04:36 PM

Minor glitch now that the number of posts per day is incorrect & irrelevant.
For instance cooler has over 300 posts per day now!!
Thought I'd report this.

***kwun*** · 05-01-2002, 05:14 PM

thanks. yes.

that'd be one of the less fixable bugs. not impossible, but it will require writing a program to go plow through the db and look for say, when cooler first posted, and make that his registration date. but... ugh. that would take a bit of hacking...

**Winex West Can** · 05-01-2002, 08:01 PM

Hey Kwun,
You should able to do something like:

UPDATE members
SET registration_date = (SELECT MIN(posting_date)
FROM posts
WHERE posts.member_id = member_id)

or something similar. Not sure of mySQL syntax as my background is in Oracle DB.

**UkPlayer** · 05-02-2002, 07:36 AM

If Winex West Can's suggestion doesn't work the what about just removing it? If it's meaningless it doesn't need to be there.

**Matt** · 05-02-2002, 01:29 PM

I don't think it's a major problem since you are not just going to look at every user's profile. Every user is affected so we may have to live with it.