Join page sql error

Hello everybody Im new in Dolphin community but I enjoy this portal.

I m using the last install 6.1.1

And have problem to use the join page in the join form.

Every time I use it. It show correclty but when I submit an sql error appear. (In the dolpin doc it seems to be simple function). I also try it on the demo dolphin site in admin same error. Does anyone has the tips for it?

I really need this function before buying this software.

Thanks in advance.

Bye

Plz. post the email you received during this error

Hello praveenkv1988 

Thanks for the reply see below the error message

Hope someone will find how to solve it. I ahve the same error if I try on the boonex test Admin page.

Query:
INSERT INTO `Profiles` SET
`NickName` = '',
`Password` = 'aaaaaa',
`Email` = '',
`DateReg` = '2008-05-29 03:06:19',
`DateLastEdit` = '0000-00-00',
`Status` = 'Active',
`DateLastLogin` = '0000-00-00',
`Featured` = 0,
`Sex` = 'male',
`LookingFor` = '',
`DescriptionMe` = 'fsdgfdgreg rgergrweg ergrg ',
`DateOfBirth` = '1981-05-07',
`Headline` = '',
`Country` = 'DZ',
`City` = '',
`Couple` = 0,
`Tags` = '',
`zip` = '',
`LanguageSpoken1` = '1',
`LanguageSpoken2` = '2',
`LanguageSpoken3` = '2',
`LanguagePractice1` = '2',
`LanguagePractice2` = '3',
`LanguagePractice3` = '1',
`Mail` = '',
`NickNames` = ''

Mysql error:
Duplicate entry '' for key 2

Found error in file /home/sharel/public_html/community/inc/classes/BxDolProfilesController.php
at line 111. Called db_res function
with erroneous argument #0

Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/sharel/public_html/community/inc/classes/BxDolProfilesController.php
[line] => 111
[function] => db_res
[args] => Array
(
[0] => INSERT INTO `Profiles` SET
`NickName` = '',
`Password` = 'aaaaaa',
`Email` = '',
`DateReg` = '2008-05-29 03:06:19',
`DateLastEdit` = '0000-00-00',
`Status` = 'Active',
`DateLastLogin` = '0000-00-00',
`Featured` = 0,
`Sex` = 'male',
`LookingFor` = '',
`DescriptionMe` = 'fsdgfdgreg rgergrweg ergrg ',
`DateOfBirth` = '1981-05-07',
`Headline` = '',
`Country` = 'DZ',
`City` = '',
`Couple` = 0,
`Tags` = '',
`zip` = '',
`LanguageSpoken1` = '1',
`LanguageSpoken2` = '2',
`LanguageSpoken3` = '2',
`LanguagePractice1` = '2',
`LanguagePractice2` = '3',
`LanguagePractice3` = '1',
`Mail` = '',
`NickNames` = ''
)

)

[2] => Array
(
[file] => /home/sharel/public_html/community/join.php
[line] => 391
[function] => createprofile
[class] => bxdolprofilescontroller
[type] => ->
[args] => Array
(
[0] => Array
(
[Sex] => male
[DateOfBirth] => 1981-05-07
[Country] => DZ
[City] =>
[LanguageSpoken1] => 1
[LanguageSpoken2] => 2
[LanguageSpoken3] => 2
[LanguagePractice1] => 2
[LanguagePractice2] => 3
[LanguagePractice3] => 1
[DescriptionMe] => fsdgfdgreg rgergrweg ergrg
[Captcha] => v6nbdv
[TermsOfUse] => 1
)

)

)

[3] => Array
(
[file] => /home/sharel/public_html/community/join.php
[line] => 116
[function] => registermember
[class] => bxdoljoinprocessor
[type] => ->
[args] => Array
(
)

)

[4] => Array
(
[file] => /home/sharel/public_html/community/join.php
[line] => 63
[function] => process
[class] => bxdoljoinprocessor
[type] => ->
[args] => Array
(
)

)

)


Called script: /community/join.php

Request parameters:
Array
(
[join_page] => done
[Couple] =>
[Password_confirm] => Array
(
[0] => password
)

[Password] => Array
(
[0] => password
)

[Mail] => Array
(
[0] => toto@hotmail.com
)

[NickNames] => Array
(
[0] => toto10
)

[Sex] => Array
(
[0] => male
)

[DateOfBirth] => Array
(
[0] => 7/5/1981
[1] =>
)

[Country] => Array
(
[0] => DZ
)

[City] => Array
(
[0] =>
)

[LanguageSpoken1] => Array
(
[0] => 1
[1] =>
)

[LanguageSpoken2] => Array
(
[0] => 2
[1] =>
)

[LanguageSpoken3] => Array
(
[0] => 2
[1] =>
)

[LanguagePractice1] => Array
(
[0] => 2
[1] =>
)

[LanguagePractice2] => Array
(
[0] => 3
[1] =>
)

[LanguagePractice3] => Array
(
[0] => 1
[1] =>
)

[DescriptionMe] => Array
(
[0] => fsdgfdgreg rgergrweg ergrg
[1] =>
)

[Captcha] => v6nbdv
[TermsOfUse] => yes
[lang] => en
[strSec] => afaf7f6f11f37c55d723af9b0c82df99
)

Check whether the nick name filed is shown in the page correctly.