In my site the registration is allowed with blank nickname. The code is allowing entry of blank nick name.
This allows registration for the first time. The second results an error saying, Mysql error: Duplicate entry '' for key 2
Database error in
Query:
INSERT INTO `Profiles` SET
`NickName` = '',
`Password` = 'osdfsdfl@123',
`Email` = 'email@yahoo.co.in',
`DateReg` = '2010-11-01 19:36:35',
`DateLastEdit` = '0000-00-00',
`Status` = 'Active',
`DateLastLogin` = '0000-00-00',
`Featured` = 0,
`Sex` = 'male',
`LookingFor` = 'female',
`DescriptionMe` = '<p>Hello, how are you there!</p>',
`DateOfBirth` = '1983-11-01',
`Headline` = '',
`Country` = 'US',
`City` = 'washington',
`Couple` = 0,
`Tags` = '',
`zip` = '985001',
`EmailNotify` = 1,
`Height` = '',
`Weight` = '',
`Income` = '',
`Occupation` = '',
`Religion` = '',
`Education` = '',
`RelationshipStatus` = '',
`Hobbies` = '',
`Interests` = '',
`Ethnicity` = '',
`FavoriteSites` = '',
`FavoriteMusic` = '',
`FavoriteFilms` = '',
`FavoriteBooks` = '',
`FirstName` = 'mcts',
`LastName` = 'microsoft'
Mysql error: Duplicate entry '' for key 2
This issue was not there for registration and there was no change in the code.
But how does this happen and how dolphin code is allowing blank nick to register?
Is this a known issue? If not Please fix asap.
Thanks
Ningomba
|
Login as admin and go to Builders->Profile Fields, then click "Navigation" and a dialog box will show up, click Advanced and see what's the minimum value. The default value is set to 4 but it might be set to 0 in your case.... Just change it to 4.
HTH,
Armaan
Facebook, Twitter & Instagram Combo - http://bit.ly/1h5CarP |
Hello maybe your join page have some extra changes ? PS: If possible do not write me personally, please try to ask on the forum first |
i actually think the problem is that the nickname has to be unique, so that field cannot be blank. look at the database and see if that is a unique ID, i do believe it is.
When a GIG is not enough --> Terabyte Dolphin Technical Support - Server Management and Support |
This is fixed!
In my site the registration is allowed with blank nickname. The code is allowing entry of blank nick name.
This allows registration for the first time. The second results an error saying, Mysql error: Duplicate entry '' for key 2
Database error in
Query:
INSERT INTO `Profiles` SET
`NickName` = '',
`Password` = 'osdfsdfl@123',
`Email` = 'email@yahoo.co.in',
`DateReg` = '2010-11-01 19:36:35',
`DateLastEdit` = '0000-00-00',
`Status` = 'Active',
`DateLastLogin` = '0000-00-00',
`Featured` = 0,
`Sex` = 'male',
`LookingFor` = 'female',
`DescriptionMe` = '<p>Hello, how are you there!</p>',
`DateOfBirth` = '1983-11-01',
`Headline` = '',
`Country` = 'US',
`City` = 'washington',
`Couple` = 0,
`Tags` = '',
`zip` = '985001',
`EmailNotify` = 1,
`Height` = '',
`Weight` = '',
`Income` = '',
`Occupation` = '',
`Religion` = '',
`Education` = '',
`RelationshipStatus` = '',
`Hobbies` = '',
`Interests` = '',
`Ethnicity` = '',
`FavoriteSites` = '',
`FavoriteMusic` = '',
`FavoriteFilms` = '',
`FavoriteBooks` = '',
`FirstName` = 'mcts',
`LastName` = 'microsoft'
Mysql error: Duplicate entry '' for key 2
This issue was not there for registration and there was no change in the code.
But how does this happen and how dolphin code is allowing blank nick to register?
Is this a known issue? If not Please fix asap.
Thanks
Ningomba
|
How did you fix it?
This is fixed!
In my site the registration is allowed with blank nickname. The code is allowing entry of blank nick name.
This allows registration for the first time. The second results an error saying, Mysql error: Duplicate entry '' for key 2
Database error in
Query:
INSERT INTO `Profiles` SET
`NickName` = '',
`Password` = 'osdfsdfl@123',
`Email` = 'email@yahoo.co.in',
`DateReg` = '2010-11-01 19:36:35',
`DateLastEdit` = '0000-00-00',
`Status` = 'Active',
`DateLastLogin` = '0000-00-00',
`Featured` = 0,
`Sex` = 'male',
`LookingFor` = 'female',
`DescriptionMe` = '<p>Hello, how are you there!</p>',
`DateOfBirth` = '1983-11-01',
`Headline` = '',
`Country` = 'US',
`City` = 'washington',
`Couple` = 0,
`Tags` = '',
`zip` = '985001',
`EmailNotify` = 1,
`Height` = '',
`Weight` = '',
`Income` = '',
`Occupation` = '',
`Religion` = '',
`Education` = '',
`RelationshipStatus` = '',
`Hobbies` = '',
`Interests` = '',
`Ethnicity` = '',
`FavoriteSites` = '',
`FavoriteMusic` = '',
`FavoriteFilms` = '',
`FavoriteBooks` = '',
`FirstName` = 'mcts',
`LastName` = 'microsoft'
Mysql error: Duplicate entry '' for key 2
This issue was not there for registration and there was no change in the code.
But how does this happen and how dolphin code is allowing blank nick to register?
Is this a known issue? If not Please fix asap.
Thanks
Ningomba
There are none so blind as those that will not see. |
