i think i've got most of them back, but there are a few that look weird. if yours looks wrong or too low, please post in this thread so i can figure out how to fix it. i already noticed that rach's are wrong -- i'm not sure why.
please be patient with me, though; i've been wroking on the board for two soldi days now and i've got to take a break form it for a day or so because i'm getting kinda tired of messing around with files and sql code.
deb
post counts
Moderator: staff
-
sine nomine
- head llama
- Posts: 12200
- Joined: Sun Nov 18, 2001 1:00 am
- Location: seattle, wa usa
- Contact:
post counts
turn your back and run, then that is frightening. -- Krishnamurti[/blockquote]
What is the good of running away if whatever we are is always there? -- Krishnamurti[/blockquote]
-
sine nomine
- head llama
- Posts: 12200
- Joined: Sun Nov 18, 2001 1:00 am
- Location: seattle, wa usa
- Contact:
aha! it only affects people who joined after the archive backup was taken, because they had a null value in the column that had the number of posts before the archive.
what i had done was insert two new columns inot the users table -- one with the post counts taken from the archive, and one with the number of posts they'd made since the archive was made. i didn't think to set the default values of those columns to zero when i made them, so anyone with no value for one or the other has NULL instead of zero. if you add a NULL value to a number, you get 0. sucks, but it's fixable pretty easily.
deb
what i had done was insert two new columns inot the users table -- one with the post counts taken from the archive, and one with the number of posts they'd made since the archive was made. i didn't think to set the default values of those columns to zero when i made them, so anyone with no value for one or the other has NULL instead of zero. if you add a NULL value to a number, you get 0. sucks, but it's fixable pretty easily.
deb
turn your back and run, then that is frightening. -- Krishnamurti[/blockquote]
What is the good of running away if whatever we are is always there? -- Krishnamurti[/blockquote]
Who is online
Users browsing this forum: No registered users and 16 guests