Studio not saving changes

[platogroup]

Perhaps I am not doing this right but I am unable to make changes to the history module. I assume that in the studio the Notes module is the History module (if not this could be my first mistake).

Next I want to add "Date Created" to the list view since date modified is updated when you view a note or make a change. When I add Date Created to either the default or additional column it does not show up when I view the history lists.

I am on Sugar Pro v 4.5.1d

Any help would be greatly appreciated.

Steve

[lonecrow]

I am having a similiar issue. The modifications I make in the studio save and are visible in the studio, but do not show up in the actual forms. This is true for any module, edit and detail view.

Basically it does not work. using studio I add a custom field to both detail and edit, I click save and publish, get the feedback that it has been both saved and published, when I re-enter studio it shows me the custom fields, but the actual detail and edit forms show no change and no error message.

v4.5.1d MS SQL

[lonecrow]

I tried using the repair custom fields link. I get the message below, click the execute link which reports that things have been repaired, but still nothing shows and when I try the repair link again it shows the same missing field information as if repairs where not conducted.

Could this be a permissions issue in the DB?

SIMULATION MODE - NO CHANGES WILL BE MADE EXCEPT CLEARING CACHE

Scanning Contacts
2 field(s) missing from contacts_cstm
Adding Column bought_cancersmart_guide_c to contacts_cstm
Adding Column password_c to contacts_cstm


Scanning Notes
3 field(s) missing from notes_cstm
Adding Column donation_acknowledged_c to notes_cstm
Adding Column donation_amount_c to notes_cstm
Adding Column payment_method_c to notes_cstm


Scanning Tasks
2 field(s) missing from tasks_cstm
Adding Column donoation_amount_c to tasks_cstm
Adding Column payment_method_c to tasks_cstm

Done

[lonecrow]

I checked in the database and the custom fields are in fact in the _cstm tables so where else would there be a record of these fields? If the fields were not recorded in those tables how does the system know the names of the missing fields? Those names must be in another table ya?

Guess I'll have a browse around. I just finished convincing someone that SugarCRM can meet their needs now I am losing the faith ;(

[mkenigson]

I checked in the database and the custom fields are in fact in the _cstm tables so where else would there be a record of these fields? If the fields were not recorded in those tables how does the system know the names of the missing fields? Those names must be in another table ya?

Guess I'll have a browse around. I just finished convincing someone that SugarCRM can meet their needs now I am losing the faith ;(

You're probably thinking of the fields_meta_data table, which seems to populate the dynamic fields.php files (in cache/dynamic_fields/<module_name>/fields.php)

[lonecrow]

Yes thanks, I checked the table and the file and all the custom field information seems to be there. Any ideas why it would not be loading them in the actual forms?


<?php
$avail_fields=array (
'donation_acknowledged_c' =>
array (
'id' => 'Notesdonation_acknowledged_c',
'name' => 'donation_acknowledged_c',
'label' => 'donation_acknowledged_c',
'help' => NULL,
'custom_module' => 'Notes',
'data_type' => 'bool',
'max_size' => NULL,
'required_option' => 'optional',
'default_value' => NULL,
'date_modified' => '2007-05-24 16:59:05',
'deleted' => 0,
'audited' => 0,
'mass_update' => 0,
'duplicate_merge' => 0,
'ext1' => '',
'ext2' => '',
'ext3' => '',
'ext4' => '',
),
'donation_amount_c' =>
array (
'id' => 'Notesdonation_amount_c',
'name' => 'donation_amount_c',
'label' => 'Donation_Amount_c',
'help' => NULL,
'custom_module' => 'Notes',
'data_type' => 'float',
'max_size' => 11,
'required_option' => 'optional',
'default_value' => NULL,
'date_modified' => '2007-05-24 16:48:37',
'deleted' => 0,
'audited' => 0,
'mass_update' => 0,
'duplicate_merge' => 0,
'ext1' => '',
'ext2' => '',
'ext3' => '',
'ext4' => '',
),
'payment_method_c' =>
array (
'id' => 'Notespayment_method_c',
'name' => 'payment_method_c',
'label' => 'Payment_method_c',
'help' => NULL,
'custom_module' => 'Notes',
'data_type' => 'enum',
'max_size' => NULL,
'required_option' => 'optional',
'default_value' => 'Cheque',
'date_modified' => '2007-05-24 16:52:06',
'deleted' => 0,
'audited' => 0,
'mass_update' => 0,
'duplicate_merge' => 0,
'ext1' => 'Payment_method',
'ext2' => '',
'ext3' => '',
'ext4' => '',
),
)
?>

[lonecrow]

I am an ASP developer but not very familiar with PHP. Seems to be easy enough to follow along but SugarCRM has a lot of code. I was really hoping not to have to debug several miles of PHP code, but I guess thats the open source way eh?

[mkenigson]

Well, not really. The open source way is to stand on the shoulders of giants. It does mean helping debug when there is a problem, though.

In your case, though, I'm thinking there's something very odd going on. This is working just fine for me and I don't see anything obvious yet. Maybe someone else has been through this and can shed some light.

[lonecrow]

It sure seems that whatever is causing the "repair custom fields" process to NOT see that the custom fields DO exist, is probably related to why the form isn't loading them.

The fields_meta_data information agrees with the custom fields in contacts_cstm but the repair process says they are missing.

Where is layout information saved?

[lonecrow]

I ran a SQL profiler trace and no warnings or errors appeared as I walked through the various actions. So...I guess I have to keep looking.