CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Cannot save contact last name of "Null"
Pages: [1]

Author Topic: Cannot save contact last name of "Null"  (Read 534 times)

dschafer

  • I post occasionally
  • **
  • Posts: 93
  • Karma: 3
    • Backoffice Thinking
  • CiviCRM version: 3.2.3 - 4.4.4
  • CMS version: Drupal 6.x, 7.x, Wordpress
  • MySQL version: 5.1.x - 5.5.x
  • PHP version: 5.2.x - 5.4.x
Cannot save contact last name of "Null"
March 22, 2010, 11:23:33 am
We have a customer with several contacts whoes last name is literally "Null"

The contact record is created but the lastname is not displayed.  I was able to replicate this on the demo site.

Contact Firstname: Lastnameis  Last name: Null  Email lastnameisnull.

Any suggestions? Adding an additional character works but is not optimal.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Cannot save contact last name of "Null"
March 22, 2010, 12:20:29 pm

i dont think there is an easy solution to this in v3.2 and prior. we hope to fix this in the 4.x series if/when we move to a different database library

the main issue was older versions of DB_DataObject used the string "null" to indicate reset this column value to null. We'll need to figure out how to get around this.

If you are keen on trying to figure out and fix this issue, ping us on IRC and we can help u get started

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Cannot save contact last name of "Null"

This forum was archived on 2017-11-26.