 |
|
Registration Problems
|
|
Date: 2005/12/24 02:09
|
By: rick
|
Status: User
|
|
|
Karma: 42
|
|
Gold Joomlapolitan
| Posts: 290 |   |
|
|
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: |
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\'
|
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
|
|
The topic has been locked. |
|
 |
|
Re:Registration Problems
|
|
Date: 2005/12/24 02:33
|
By: pointri
|
Status: User
|
|
|
Karma: 26
|
|
Gold Joomlapolitan
| Posts: 211 | |
|
|
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.
|
|
|
The topic has been locked. |
|
|
|
|
Re:Registration Problems
|
|
Date: 2005/12/24 02:41
|
By: rick
|
Status: User
|
|
|
Karma: 42
|
|
Gold Joomlapolitan
| Posts: 290 | |
|
|
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
|
|
|
The topic has been locked. |
|
 |
|
Re:Registration Problems
|
|
Date: 2005/12/25 11:57
|
By: kawika
|
Status: User
|
|
|
Karma: 1
|
|
Fresh Joomlapolitan
| Posts: 10 | |
|
|
|
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.
|
|
|
The topic has been locked. |
|
 |
|
Re:Registration Problems
|
|
Date: 2006/02/22 18:17
|
By: twincascos
|
Status: User
|
|
|
Karma: 0
|
|
Fresh Joomlapolitan
| Posts: 2 | |
|
|
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.
Rick, did you solve this? I do not want to do a reinstall!
|
|
|
The topic has been locked. |
|
|
|
|
Re:Registration Problems
|
|
Date: 2006/02/22 18:38
|
By: twincascos
|
Status: User
|
|
|
Karma: 0
|
|
Fresh Joomlapolitan
| Posts: 2 | |
|
|
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.
|
|
|
The topic has been locked. |
|
|
