Recently, I came across an issue in Invision Board, where new validating members did not appear in the Admin CP. They did appear, however, in the normal members list area, where you can see all the validating members along with the validated members. Without them appearing in the Admin CP, one had to manually enter the name of each validating member into the validation area and change their forum access mark from “validating member” to a “registered member” [the other easier way is to have all the validating members appear normally in the ACP area, where they can all be validated at the same time with one mouse click]. This trend of validating members manually one by one becomes really annoying when you have dozens of new members registering every day, waiting to be validated.

If you have setup your boards to have an admin validate all new registrations, users who submit their registration information may see the following error [example of an actual error message on one of our forums]:

mySQL query error: INSERT INTO ibf_member_extra (id) VALUES (36)

The problem lies in the database for your copy of Invision forums, as you can see from the above error message. It is related to the mysql table named “ibf_member_extra” in your Invision database [duh]. The issue is the table being full entries for members up to a certain number of members [250+ in our case for the forum in question], members which do not exist. When people registered and got that duplicate id entry error mentioned above, the database added them to the member table, but not to the validating table - the table which is used in the admin cp to show the validating members.

You can fix this problem in the database yourself [edit and delete the extra entries] or contact Invision Power Services support to have it fixed for you, or let me know if you need some help.