Recalculating Message count

[Edrondol]

I know this is probably easy for someone out there, but I want to recalculate the message counts.

I assume that all that really needs to be done is a simple SQL command that counts posts and increments that person's message count, but I'm not good with SQL and would not trust myself to try it out.

Any ideas or is this harder than I'm thinking it is?

 

[Edrondol]

You misunderstand. The duplication happened when testing the software before I made the official move from vB to XF. I did the data transfer several times testing before the switch. So each time I did it it brought the same messages in, gave them a unique ID and said, "There ya go!"

No bug. Just me not thinking things through during my testing.

 

[Paul B]

Aha, gotcha.
So you need to prune the database of the duplicate posts and then run the queries again to set the correct post counts.

If you need help compiling the script let me know; I'll just need the (updated) csv output again.

 

[Edrondol]

I assume all you did was port the csv into Excel, add the command and then export to another txt file.

 

[Paul B]

Yes, I just used Excel to convert text to columns and then used the concatenate function to create the query string.

 

[Edrondol]

Yup. I may not know SQL but I can kick the living crap out of Excel.