I am receiving Database Error which results failed sign up.I remember the last thing I did was changing profiles field inside the Join Form. A couple of hours im receiving Database error. I tried putting back all the inactive fields and as I go along testing refresh etc.. I noticed the NickName field something went wrong. It should be the field name of UserName. Im not sure if this was the cause but now it should be a not mandatory field so it can bypass the duplicate entry and can submit a new profile entry.I need more ideas from experts and this will be a big help to Dolphin Users.
Database error in XXXXX Community
Query:
INSERT INTO `Profiles` SET
`NickName` = '',
`Password` = '12345',
`Email` = 'desfaa@hotmail.com',
`DateReg` = '2012-05-01 15:42:19',
`DateLastEdit` = '0000-00-00',
`Status` = 'Unconfirmed',
`DateLastLogin` = '0000-00-00',
`Featured` = 0,
`Sex` = 'male',
`LookingFor` = '',
`DescriptionMe` = '<p>failures are just part of life</p>',
`DateOfBirth` = '1990-05-07',
`Headline` = '',
`Country` = 'TH',
`City` = 'bangkok',
`Couple` = 0,
`Tags` = '',
`zip` = '10140',
`EmailNotify` = 1,
`Height` = '',
`Weight` = '',
`Income` = '',
`Occupation` = '',
`Religion` = '',
`Education` = '',
`RelationshipStatus` = '',
`Hobbies` = '',
`Interests` = '',
`Ethnicity` = '',
`FavoriteSites` = '',
`FavoriteMusic` = '',
`FavoriteFilms` = '',
`FavoriteBooks` = '',
`FirstName` = 'ariel',
`LastName` = 'viloria',
`Kasarian` = 'Male',
`UserName` = 'uiyuy'
Mysql error: Duplicate entry '' for key 2
Found error in the file '/home/hari/public_html/community/inc/classes/BxDolProfilesController.php' at line 116.
Called 'db_res' function with erroneous argument #0.
