I was having a problem with the UID not getting set right when a new user signs up. I am using the current CVS stuff. When I checked the code, the code in user.php3 I found the problem to be in:
$uid = mysql_insert_id($result);
in the finishNewUser function.
For mysql to return the insert_id the $result needs to be taken out. At least on the version of mysql they are running at my host. In a couple of MySql books I have, they show the function in examples without any arguments. Could somebody who has CVS access please change this.
PS. I was also looking at the admin code for adding a new user from the admin.php3. Is it just me or does it seem that uid for new users there is going to not set the uid in any of the other users_* tables correctly.