Results 1 to 1 of 1

Thread: Date Created Missing after Lead Import 4.5f

  1. #1
    cyjaxusa is offline Junior Member
    Join Date
    Nov 2006
    Posts
    1

    Question Date Created Missing after Lead Import 4.5f

    Greetings,

    I need some mySQL assistance updating the date created column in the leads table.

    Configuration Details:
    lamp install running mySQL 4.1.21
    php version 4.4.2
    apache version 1.3.34
    sugar 4.5f

    Issue:
    Date created missing after importing leads.

    Analysis:
    The date created in the file I imported from was in this format mm-dd-yyyy hh:mm
    Apparently sugar is looking for (seconds) mm-dd-yyyy hh:mm:ss
    The file I imported from was generated by exporting to csv from sugar 4.2f.

    Request:
    I have the old database with the correct mm-dd-yyyy hh:mm:ss values for date created (leads table). How can I update the date created values in the new leads table? I am sure there is mySQL query to handle this. Any mySQL Demigods up for the challenge?

    -Cyjax
    Last edited by cyjaxusa; 2006-11-16 at 12:40 AM.

Thread Information

Users Browsing this Thread

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

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
  •