Registratrion error

[necrosanct]

YaBB SE Version: 1.5.4
PHP Version: 4.3.2
MySQL Version: 4.0.x
Server Platform: Unix, Linux, or BSD
Link to Forum: www.necrosanct.com/yabbse

Problem Description:
Whenever someone goes to register since the other day they get a database error that is very vague to them.

When I look over the error logs I see the following:

Name : IP : Today at 08:58:56am
/yabbse/index.php?board=;action=register2
Database Error: Duplicate entry '0' for key 1
File: .../yabbse/Sources/Register.php (short form of it)
Line: 288

Tried searching for an answer but found nothing on this.

Any help on this roadblock?

[Douglas]

Do you have any mods installed on your board, anything that changes Register.php?  Also, when was the last time you did any maintenance on your database (Emptied out the click_log, and error folders, checked all tables, optimized all tables)?

[necrosanct]

No mods in it except the pre-installed ones. Nothing in there was changed.

I have done all the other things you mentioned.

[necrosanct]

Still unable to find the problem with this error anywhere at all. Many people have tried to register and it is becoming an increasing pain.

Is there anything at all I can do about this?

[[Unknown]]

Please paste the output MySQL gives you from this query:

SHOW CREATE TABLE yabbse_members;

-[Unknown]

[necrosanct]

Is that from the main db query window?

I get lost with the whole mysql thing when I need to delve into it so pretty much need a roadmap to where exactly things are.

[[Unknown]]

Just paste it in the SQL tab of phpMyAdmin.

-[Unknown]

[necrosanct]

This is what that returns going from SQL tab off the main db:


SQL-query

SQL-query : [Edit] [Create PHP Code]
SHOW CREATE TABLE yabbse_members  




 
Table  Create Table  
yabbse_members CREATE TABLE `yabbse_members` (
`ID_MEMBER` int(...



Print view

Export

---------------
Full text shows the following

yabbse_members CREATE TABLE `yabbse_members` (
`ID_MEMBER` int(10) unsigned NOT NULL default '0',
`memberName` varchar(80) NOT NULL default '',
`realName` tinytext,
`passwd` tinytext NOT NULL,
`emailAddress` tinytext,
`dateRegistered` bigint(20) default NULL,
`personalText` tinytext,
`memberGroup` tinytext,
`gender` tinytext,
`birthdate` date NOT NULL default '0000-00-00',
`websiteTitle` tinytext,
`websiteUrl` tinytext,
`location` tinytext,
`ICQ` tinytext,
`AIM` tinytext,
`YIM` tinytext,
`hideEmail` tinyint(4) default NULL,
`timeFormat` tinytext,
`signature` text,
`posts` int(11) default NULL,
`timeOffset` float default NULL,
`avatar` tinytext,
`im_ignore_list` text,
`im_email_notify` tinyint(4) NOT NULL default '0',
`lastLogin` bigint(20) default NULL,
`karmaBad` int(11) NOT NULL default '0',
`karmaGood` int(11) NOT NULL default '0',
`usertitle` tinytext,
`lngfile` tinytext,
`notifyAnnouncements` tinyint(4) NOT NULL default '1',
`notifyOnce` tinyint(4) NOT NULL default '1',
`MSN` tinytext,
`memberIP` tinytext,
`secretQuestion` tinytext NOT NULL,
`secretAnswer` tinytext NOT NULL,
PRIMARY KEY  (`ID_MEMBER`),
KEY `memberName` (`memberName`(30)),
KEY `dateRegistered` (`dateRegistered`),
KEY `memberGroup` (`memberGroup`(30)),
KEY `birthdate` (`birthdate`),
KEY `posts` (`posts`),
KEY `lastLogin` (`lastLogin`),
KEY `lngfile` (`lngfile`(30))
) TYPE=MyISAM

[[Unknown]]

`ID_MEMBER` int(10) unsigned NOT NULL default '0',

Should be:

`ID_MEMBER` int(10) unsigned NOT NULL auto_increment,

So do this:

ALTER TABLE yabbse_members
DROP PRIMARY KEY,
CHANGE ID_MEMBER ID_MEMBER int(10) unsigned auto_increment PRIMARY KEY;

UPDATE yabbse_members
SET ID_MEMBER = NULL
WHERE ID_MEMBER = 0;

I think that should work...

-[Unknown]

[necrosanct]

thanks [Unknown] yet again you saved my day