Advertisement:

Author Topic: Phantom member waiting approval  (Read 226 times)

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 8,910
Phantom member waiting approval
« on: April 25, 2019, 04:17:30 PM »
Did a 1.1.21 -> 2.0.15 upgrade last night, database was a bit dodgy but upgrade ran without errors on my server.  Imported back to production forum, clean 2.0.15 files, everything works fine except there's one member waiting approval in admin user info.  Link goes to correct page, but there's no member waiting approval, same if you get there via Admin -> Members.  Ran 'Recount all forum totals and statistics' last night, alert disappeared, but it's back again today.  Ran task again, it's gone again.  Phantom member does not show up on my server running same db in clean install.

   

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 70,992
    • StoryBB/StoryBB on GitHub
Re: Phantom member waiting approval
« Reply #1 on: April 26, 2019, 01:26:35 AM »
SELECT * FROM smf_members WHERE is_activated IN (0, 2, 3, 5, 10, 12, 13, 15) might give you something relevant if I got the column name correct (iPads are not conducive to coding hah)
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 8,910
Re: Phantom member waiting approval
« Reply #2 on: April 26, 2019, 12:35:31 PM »
I'll check if I still have access.  Am no longer admin, so can't see if it's come back.  Odd that it doesn't happen on my server with same database.
« Last Edit: April 26, 2019, 12:55:43 PM by Sir Osis of Liver »