API:Add Client returns both success and [clientid] => 0

[sentient]

I am running the addclient api with the below details. I get a result = success however, the clientid = 0? How can I get a success when the client doesn’t get created? I also tried submitting the exact example code on page http://docs.whmcs.com/API:Add_Client and I got the same thing? When I run the getclientsdetails API, I have no issues so I know the call itself is ok. Does anyone have any ideas on what I'm missing?

 

$postfields :

 

Array

(

[username] => rearle

[password] => 5f4dcc3b5aa765d61d8327deb882cf99

[action] => addclient

[responsetype] => json

[firstname] => FistNameTest

[lastname] => LastNameTest

[companyname] => CompanyName

=> email@gmail.com

[address1] => Address1

[address2] => Address2

[city] => City

[state] => County

[postcode] => 0000

[country] => ie

[phonenumber] => 0876921727

[password2] => password

[currency] => 3

[groupid] => 1

[cctype] => Laser

[cardnum] => **************************

[expdate] => ****

[startdate] => ****

[issuenumber] =>

[noemail] => 1

[skipvalidation] => 0

)

 

Response :

 

stdClass Object

(

[result] => success

[clientid] => 0

)

 

Thanks

[sentient]

Solved it by :

SET @@global.sql_mode= '';