That's strange. If you go into phpMyAdmin -> adopts_users, is their usergroup 4 or 6? If it isn't any number between 1 and 6 (NULL for example), something went wrong in the script.
I never got this error, even with a fresh install. Did you alter anything like group names?
After searching the forum, maybe try this fix?: http://mysidiaadoptables.com/forum/showthread.php?t=4009&highlight=membercreator
(If that fix doesn't work, put it back how it was)
It seems that Mysidia had a user class called Mod in the design, but it never had an implementation. For some reason people can set it to be Mod type in ACP, resulting in errors.