Hi,
I had three people join my site and all of a sudden I am getting this error when trying to sighn up:
Database error in Spark Blogger Community
Query:
INSERT INTO `Profiles` SET
`NickName` = '',
`Password` = 'xxxxxxx',
`Email` = 'xxxxxxx@startuphughes.com',
`DateReg` = '2013-01-17 20:54:53',
`DateLastEdit` = '0000-00-00',
`Status` = 'Unconfirmed',
`DateLastLogin` = '0000-00-00',
`Featured` = 0,
`Sex` = 'male',
`LookingFor` = '',
`DescriptionMe` = '',
`DateOfBirth` = '',
`Headline` = '',
`Country` = 'US',
`City` = '',
`Couple` = 0,
`Tags` = '',
`zip` = '',
`EmailNotify` = 1,
`Height` = '',
`Weight` = '',
`Income` = '',
`Occupation` = '',
`Religion` = '',
`Education` = '',
`RelationshipStatus` = '',
`Hobbies` = '',
`Interests` = '',
`Ethnicity` = '',
`FavoriteSites` = '',
`FavoriteMusic` = '',
`FavoriteFilms` = '',
`FavoriteBooks` = '',
`FirstName` = 'xxxxxxx',
`LastName` = 'xxxxxxx',
`LangID` = 1
Mysql error: Duplicate entry '' for key 2
Found error in the file '/home/sparkcom/public_html/inc/classes/BxDolProfilesController.php' at line 124.
Called 'db_res' function with erroneous argument #0.
Please can anyone advise - urgent please
regards
Glenn
|
Hi,
It will not let more than 3 signup. 3 members can join then this error comes up.
Regards
Glenn
|
Hi,
I had three people join my site and all of a sudden I am getting this error when trying to sighn up:
Database error in Spark Blogger Community
Query:
INSERT INTO `Profiles` SET
`NickName` = '',
`Password` = 'xxxxxxx',
`Email` = 'xxxxxxx@startuphughes.com',
`DateReg` = '2013-01-17 20:54:53',
`DateLastEdit` = '0000-00-00',
`Status` = 'Unconfirmed',
`DateLastLogin` = '0000-00-00',
`Featured` = 0,
`Sex` = 'male',
`LookingFor` = '',
`DescriptionMe` = '',
`DateOfBirth` = '',
`Headline` = '',
`Country` = 'US',
`City` = '',
`Couple` = 0,
`Tags` = '',
`zip` = '',
`EmailNotify` = 1,
`Height` = '',
`Weight` = '',
`Income` = '',
`Occupation` = '',
`Religion` = '',
`Education` = '',
`RelationshipStatus` = '',
`Hobbies` = '',
`Interests` = '',
`Ethnicity` = '',
`FavoriteSites` = '',
`FavoriteMusic` = '',
`FavoriteFilms` = '',
`FavoriteBooks` = '',
`FirstName` = 'xxxxxxx',
`LastName` = 'xxxxxxx',
`LangID` = 1
Mysql error: Duplicate entry '' for key 2
Found error in the file '/home/sparkcom/public_html/inc/classes/BxDolProfilesController.php' at line 124.
Called 'db_res' function with erroneous argument #0.
Please can anyone advise - urgent please
regards
Glenn
Nickname is empty. Thats the reason for the duplicate entry error.
https://www.deanbassett.com |
Thanks a million - been pulling my hair out - great help thanks.
All working now.
Glenn
|
same problem, how to fix this problem? |
same problem, how to fix this problem?
You need to provide a bit more data. If you are getting an error, we need to know what the error is.
Geeks, making the world a better place |
New user join - Mysql error: Duplicate entry
exactly the same SQL error message from "getmethere"
when new users join my site, sometimes happens to have this SQL error :-/
|
You are having the same issue? Deano provided an answer - No nickname entered - do you have a nickname field in your join form? caredesign.net |
yes, i have a nicknamefield in join. but i can not reproduce the problem with "Mysql error: Duplicate entry"?
what can i do to not have this error message?
|
New user join - Mysql error: Duplicate entry
exactly the same SQL error message from "getmethere"
when new users join my site, sometimes happens to have this SQL error :-/
Yes, there is a duplicate entry somewhere; however, which one? It may not be the nickname field. You have not provided the actual error report.
Geeks, making the world a better place |
Error Query:
INSERT INTO `Profiles` SET
`NickName` = 'Gestrandet',
`Password` = 'xxxxxxxx',
`Email` = 'xxxxxxxx@xxxxxxxx.ch',
`DateReg` = '2014-03-13 11:52:58',
`DateLastEdit` = '0000-00-00',
`Status` = 'Active',
`DateLastLogin` = '0000-00-00',
`Featured` = 0,
`Sex` = 'female',
`LookingFor` = 'female',
`DescriptionMe` = '<p>xxxxxxxx </p>',
`DateOfBirth` = 'xxxxxxxx',
`Headline` = 'lebe deine Vorstellung',
`Country` = 'xxxxxxxx',
`City` = 'xxxxxxxx',
`Couple` = 0,
`Tags` = 'xxxxxxxx',
`zip` = '8307',
`EmailNotify` = 1,
`Height` = '',
`Weight` = '',
`Income` = '',
`Occupation` = '',
`Religion` = '',
`Education` = '',
`RelationshipStatus` = '',
`Hobbies` = '',
`Interests` = '',
`Ethnicity` = '',
`FavoriteSites` = '',
`FavoriteMusic` = '',
`FavoriteFilms` = '',
`FavoriteBooks` = '',
`FirstName` = 'xxxxxxxx',
`LastName` = 'xxxxxxxx',
`SexuelleAusrichtung` = '',
`Wichtig` = '',
`NEW_ITEM` = '',
`LangID` = 5
Mysql error: Duplicate entry 'Gestrandet' for key 'NickName'
|
Mysql error: Duplicate entry 'Gestrandet' for key 'NickName'
There's your problem
|
To be clear, the NickName field must be active, required, and also set to be unique. Dolphin requires usernames to work. Simply put, don't mess with that field. BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin |
yes, correct! how is it possible to give this error? use join.php with a registred "NickName" is not possible?
i understand the error message, but how to produce this error message?
|
To be clear, the NickName field must be active, required, and also set to be unique. Dolphin requires usernames to work. Simply put, don't mess with that field.
Bingo! :-)
|
