Registration Problems

13 years 7 months ago #2737 by rick
Well this has really got me stumped. My site has been up for a while and everything has been going fine. I noticed the last couple of days the registrations have dropped off a bit and today I got an email that someone could not register and that they got an error. I went in and tried to register a fake user to test it out and this is the error I got.

[code:1]mosuser::«»store failed
Duplicate entry \'0\' for key 1 SQL=INSERT INTO jos_users ( `id`,`name`,`username`,`email`,`password`,`gid`,`registerDate` ) VALUES ( \'0\',\'Joe Smoe\',\'joe\',\'joe@mannainfo.com\',\'7f158c1d13c88d10552594f7fb4944f7\',\'18\',\'2005-12-23T13:00:55\'[/code:1]

As stated no problems before this, have had over 150 registrations and now this. Any help would be greatly appritiated.

Rick

Running:
Joomla! 1.0.7 Stable
Community Builder 1.0 rc2
SMF 1.1 RC2
13 years 7 months ago #2740 by pointri
Hi Rick,

Maybe the id in your users table decided not to auto-increment?
Sounds like the most plausible reason why it'd keep duplicating a '0'.

Here's a walk-through thread on the Joomla! board about this issue, and a possible fix:

http://forum.joomla.org/index.php/topic,5575.html

Joomlapolitan zealot and a somewhat stealthy, rather passive CB3PD developer.
http://www.constructionlounge.com Construction Lounge: Online resource and networking portal for the construction and remodeling industries.
13 years 7 months ago #2741 by rick
pointri,

Thanks for your response. I did go look at a second site to see what the properties of that field was supposed to be.

The correct values for Table: jos_users is supposed to be:

Field id
Type INT
Length/Values 11
Attributes Blank
Null not null
Default Blank
Extra auto increment

But mine was

Field id
Type MEDIUMINT
Length/Values 8
Attributes Blank
Null not null
Default 0
Extra Blank

I have made no intentional changes to this table so have no idea why it had been altered. My guess is that something that I installed made the changes, I only wish I know what it was that did it. After changing it back all seems ok now.

Rick

Running:
Joomla! 1.0.7 Stable
Community Builder 1.0 rc2
SMF 1.1 RC2
13 years 7 months ago #2781 by kawika
I don't think the backslashes are supposed to be there. In the actual query there should only be single-quotes. It looks like an addslashes() or removeslashes() isn't working or is in the wrong spot.
13 years 5 months ago #6881 by twincascos
I've run into the same problem,
I was wondering if you found the solution.
I also found my Bd had:

Field id
Type MEDIUMINT
Length/Values 8

and changed it to:

Field id
Type INT
Length/Values 11

But I still get the same results.:blink:

Rick, did you solve this? I do not want to do a reinstall!
13 years 5 months ago #6882 by twincascos
Ok, just follow the links,,
"_users' table is set to 'auto-increment.' "
this was the culprite!

solved.

Now as to where and why it was changed...
I suspect it had something to do with..
AKReservations but I might be wrong.
Moderators: beatnantkrileon
Time to create page: 0.385 seconds
Facebook Twitter Google LinkedIn