2
I apologize for replying myself,
I have been checking the users database table and found something very odd.
First of all, I migrated that table from MySQL 3.23 in my local server to the 4.1 that I'm using in my remote server.
When I go into the myadmin and browse the users table, if I go to the very end of it with the >> button, I find that the last user added is de 1484 but, if I sort the table by uid, I find that the last added is 1511.
Ok, this is not impossible to happen, but what I do think that is impossible to happen is that when I add a new user, and is added with the 1512 id, and then go and browse the users table, I find that the new user was not added in the last record but somewhere in the middle of the table.
I think that this is causing the "Could not register new user" problem. But this is very odd, I mean, if the new record is inserted somewhere in the middle of the table, it would be overriding some other record; but as far as I know that's impossible for the difference of the INSERT and UPDATE MySQL sentences.
Does anybody have an idea of what is going on in my database?
Thank you very much.
Sorry for my bad english... :)
I love to learn, feel free to tell me when I misspell something.
Using Xoops 2.0.16, FC4, PHP 5.0.4-10.5, Apache 2.0.54-10.4, mysql-4.1.20-1.FC4.1.