Results 1 to 3 of 3

Thread: Have created new fields -> not shown in DB ?!

  1. #1
    dekleinemedia is offline A Prolific Poster
    Join Date
    May 2009
    Location
    Netherlands
    Posts
    241

    Default Have created new fields -> not shown in DB ?!

    Hi, i have then following issue;

    I have customized the standard "Project" module and created some newfields.
    But when i go to my DB (phpMyAdmin 2.11.2.2) the new created fields are not added to my DB..

    Can someone please can to fix this?

    * I have added 2 screenshots *

    Much appreciate, thanks.
    Attached Images Attached Images   
    Kind regards,

    De Kleine Media


    SugarCRM CE v.5.2.0h
    Windows platform
    MySQL v.5.1
    phpMyAdmin - 2.11.2.2
    Apache Server v.2.0

  2. #2
    eNick is offline Sugar Community Member
    Join Date
    Apr 2008
    Location
    UK
    Posts
    282

    Default Re: Have created new fields -> not shown in DB ?!

    Hi dekleinemedia,

    You'll find your new fields in the table "project_cstm".

    Whenever you add fields, sugar creates a "*_cstm" table, related to the standard sugar table by id. It then creates the new fields in there.

    In addition, all of the definition for the new fields is stored in the table fields_meta_data.


    Nick
    T H E S U G A R R E F I N E R Y
    : : : SugarCrm Customisation and Integration Services : : :

    SugarCRM Systems Integration Partner
    Trusted with SugarCRM
    http://www.theSugarRefinery.com ::: sales@{removethis}theSugarRefinery.com

  3. #3
    dekleinemedia is offline A Prolific Poster
    Join Date
    May 2009
    Location
    Netherlands
    Posts
    241

    Thumbs up Re: Have created new fields -> not shown in DB ?!

    Quote Originally Posted by eNick View Post
    Hi dekleinemedia,

    You'll find your new fields in the table "project_cstm".

    Whenever you add fields, sugar creates a "*_cstm" table, related to the standard sugar table by id. It then creates the new fields in there.

    In addition, all of the definition for the new fields is stored in the table fields_meta_data.


    Nick
    Hi Nick,

    You helped me with this one, thanks a lot !
    Kind regards,

    De Kleine Media


    SugarCRM CE v.5.2.0h
    Windows platform
    MySQL v.5.1
    phpMyAdmin - 2.11.2.2
    Apache Server v.2.0

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Don't save new fields created by studio
    By cleartic in forum Developer Help
    Replies: 0
    Last Post: 2008-06-25, 03:02 PM
  2. Custom Fields not being created in db
    By eggsurplus in forum Developer Help
    Replies: 1
    Last Post: 2007-05-24, 12:59 AM
  3. How to see created custom fields in tabs ?
    By abaydar in forum General Discussion
    Replies: 0
    Last Post: 2007-03-07, 11:31 AM
  4. Replies: 0
    Last Post: 2006-12-20, 11:39 PM
  5. Module not shown in head tab list, but shown in SubPanel
    By Superman in forum General Discussion
    Replies: 0
    Last Post: 2005-11-14, 06:30 AM

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
  •