We just completed a move from one server to another, and an upgrade from old 2.6.1 to the latest 3.1.9 Somehow in the process we have a batch of "free" members. Admin screen should show about 11 free, but shows more than 30. Its a pay to view website so I hate giving it away free to anybody. Looking through the membership, browsing, page after page, shows sales amount of "00.00" for the correct 11, but no others. Running the cron, deleting and rebuilding, etc. Nothing seems to help me find these extra "free" members. Anybody know a way to search them out so they can be deleted?
First try to reruild DB this will fix possible issues with user's status. Also there is a bug in that report. It count users who should expire today as free users. Contact me in helpdesk I will give updated template that will fix this issue.