Results 1 to 5 of 5

Thread: Date modified / entered NULL

  1. 2010-04-12, 09:34 AM #1
    klra67
    klra67 is offline Senior Member
    Send a message via Skype™ to klra67
    Join Date
    Mar 2009
    Location
    Frankfurt
    Posts
    25

    Default Date modified / entered NULL

    Hello,

    we experience a weird problem with our sugar install: About 6000 of our 70000 contacts have no date modified / date entered. Its set to null in the database. We suspect its an import gone wrong, but I cannot reproduce it by aborting an import eg. Has anybody experienced similar problems?
    Reply With Quote Reply With Quote
  2. 2010-04-12, 09:54 AM #2
    salesagility's Avatar
    salesagility
    salesagility is offline Sugar Community Member
    Send a message via Skype™ to salesagility
    Join Date
    Aug 2006
    Location
    UK
    Posts
    2,379

    Default Re: Date modified / entered NULL

    Are you using sugar to import or using custom sql queries?
    Apache/2.2.3 (Debian) PHP/5.2.0-8+etch11 MySQL 5.0.32

    SalesAgility.com - SugarCRM Experts (UK)

    Authors of Advanced OpenSales - Open Source Quotations, Invoices, Products and Contracts modules for SugarCRM Community Edition - Download here
    Reply With Quote Reply With Quote
  3. 2010-04-12, 10:59 AM #3
    klra67
    klra67 is offline Senior Member
    Send a message via Skype™ to klra67
    Join Date
    Mar 2009
    Location
    Frankfurt
    Posts
    25

    Default Re: Date modified / entered NULL

    We imported about 4000 Contacts by custom SQL query, so that does not match. The rest of the contacts was imported by sugar.
    Reply With Quote Reply With Quote
  4. 2010-04-12, 02:19 PM #4
    AlexAv's Avatar
    AlexAv
    AlexAv is offline Sugar Community Member
    Send a message via Skype™ to AlexAv
    Join Date
    Oct 2009
    Location
    Ukraine
    Posts
    922

    Default Re: Date modified / entered NULL

    Quote Originally Posted by klra67 View Post
    We imported about 4000 Contacts by custom SQL query, so that does not match. The rest of the contacts was imported by sugar.
    Problem with your custom SQL query. Can you show part of it?
    Letrium ltd. - Only high quality service
    http://letrium.com
    Reply With Quote Reply With Quote
  5. 2010-04-12, 02:38 PM #5
    klra67
    klra67 is offline Senior Member
    Send a message via Skype™ to klra67
    Join Date
    Mar 2009
    Location
    Frankfurt
    Posts
    25

    Default Re: Date modified / entered NULL

    You are correct. We found it. Thanks to everybody!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. 5.0 CE - Modified date to show subpanel modified date
    By tmamayek in forum Help
    Replies: 3
    Last Post: 2008-07-30, 12:54 PM
  2. Mass Update without changing Date Modified and Modified By?
    By mgardb in forum Developer Help
    Replies: 0
    Last Post: 2008-07-17, 11:57 PM
  3. Date Entered and Date Modifies Fields Doesnt Work
    By cagatay in forum Help
    Replies: 6
    Last Post: 2008-04-21, 02:34 PM
  4. Lost User Names from Date Modified & Date Created Fields - Studio Issue
    By jjwdesign in forum Help
    Replies: 2
    Last Post: 2008-01-31, 02:24 AM
  5. Date entered in Edit dialog - Date conversion inccorect
    By malcolmh in forum Help
    Replies: 1
    Last Post: 2006-07-28, 02:18 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules