News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Phantom member waiting approval

Started by Sir Osis of Liver, April 25, 2019, 04:17:30 PM

Previous topic - Next topic

Sir Osis of Liver

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.

   
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Arantor

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)

Sir Osis of Liver

#2
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.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Advertisement: