Troubleshooting

Why is Nucleus setting my member id variable so high?

Scenario:
"I have experienced some problems with adding a new member in my blog where Nucleus creates a member with an id of 2147483647 (or similar very, very, very big number!). It's safe to say I don't have that many members! Any new members will be dropped, since they get the same id. I have to go into the database manualy and change the id to a lower number. What process is creating this ID? And what can I do to make it work properly again?"

Solution:
Nucleus has set the member_id field to "autoincrement", meaning Nucleus will automatically take whatever the last value was set to that field and add one to get the next value.

To reset the autoincrement, you will need to run the following query on your MySQL database (using phpmyadmin or similar tools):

ALTER TABLE nucleus_member AUTO_INCREMENT=n;

where "n" is the number you want Nucleus to start autoincrementing from.

Original forum thread (thanks, Smithers!):
http://forum.nucleuscms.org/viewtopic.php?t=12122