Database query error

Dear sir,

I installed the Dolphin 6.1 at my domain

its working fine but when i try to register a new  user it shows the following error please let me know how to resolve it.

Error
Database query error


Warning: mail() [function.mail]: SMTP server response: 530 SMTP authentication is required. in C:\inetpub\vhosts\shujarizvi.com\httpdocs\dolp\inc\utils.inc.php on line 436

Thanks in anticipation

Regards

Quote · 1 Feb 2010

Hello!


Reason of MySQL error u may find in ur BUG report mail box. But if u have problems like "SMTP server response: 530 SMTP authentication is required." jut go to inc/db.inc.php file and change value of constant DB_FULL_DEBUG_MODE to true. Then u will have possibility to see error directly in ur site.

Regard

Quote · 1 Feb 2010

Dear Sir,

I did the same you mentioned in last message... Now i found the following error..

Database query error
Query:
INSERT INTO `Profiles` SET `NickName` = 'alicruse', `Sex` = 'male', `Country` = 'PK', `City` = 'karachi', `zip` = '', `DateOfBirth` = '1992-01-01', `Tags` = 'as, a, ', `Headline` = 'itz me', `DescriptionMe` = 'asdfasdfas asdf asdf asdf ', `Email` = 'ali_cruse@yahoo.com', `EmailFlag` = '', `EmailNotify` = '', `Password` = '6a204bd89f3c8348afd5c77c717a097a', `LastReg` = NOW()
Mysql error:
Data truncated for column 'EmailFlag' at row 1

Found error in file C:\inetpub\vhosts\shujarizvi.com\httpdocs\dolp\join_form.php
at line 335. Called db_res function with erroneous argument #0

Debug backtrace:
Array
(
    [1] => Array
        (
            [file] => C:\inetpub\vhosts\shujarizvi.com\httpdocs\dolp\join_form.php
            [line] => 335
            [function] => db_res
            [args] => Array
                (
                    [0] => INSERT INTO `Profiles` SET  `NickName` = 'alicruse',  `Sex` = 'male',  `Country` = 'PK',  `City` = 'karachi',  `zip` = '',  `DateOfBirth` = '1992-01-01',  `Tags` = 'as, a, ',  `Headline` = 'itz me',  `DescriptionMe` = 'asdfasdfas asdf asdf asdf ',  `Email` = 'ali_cruse@yahoo.com',  `EmailFlag` = '',  `EmailNotify` = '',  `Password` = '6a204bd89f3c8348afd5c77c717a097a',  `LastReg` = NOW()
                )

        )

    [2] => Array
        (
            [file] => C:\inetpub\vhosts\shujarizvi.com\httpdocs\dolp\join_form.php
            [line] => 77
            [function] => PageCompPageMainCode
            [args] => Array
                (
                )

        )

)
Called script: /dolp/join_form.php
Request parameters:
Array
(
    [page] => 1
    [ID] => 
    [NickName] => alicruse
    [Email] => ali_cruse@yahoo.com
    [Password] => asdfasdf
    [Password2] => asdfasdf
    [DateOfBirth_month] => 01
    [DateOfBirth_day] => 1
    [DateOfBirth_year] => 1992
    [Sex] => male
    [Country] => PK
    [City] => karachi
    [Tags] => as, a, 
    [Headline] => itz me
    [DescriptionMe] => asdfasdfas asdf asdf asdf 
    [DescriptionMecounter] => 26
    [securityImageValue] => w5392s
    [i_agree] => on
    [PHPSESSID] => 9d3f03a4d4c76c3ea089a894f4752dc8
)

Warning: mail() [function.mail]: SMTP server response: 530 SMTP authentication is required. in C:\inetpub\vhosts\shujarizvi.com\httpdocs\dolp\inc\utils.inc.phpon line 436

Can you please guide me how can i set the smtp email with it... because at the time of installation it didn't ask for any email to set for admin or sending mail or asked for smtp information.. 

Regards. 

Quote · 2 Feb 2010
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.