records are not saved in added fields but saved in the original fields.

[oualidos80]

Hi All,

I have the latest comunity edition and I am a windows user.

I did a fresh installation of sugar in my server but I needed to add fields into some modules,

When I create a new record everything saves good but when I edit the records the new record saves fine in the original fields that came with the module but no change applies in the added fields.

I can edit the original fields as many times as I want, but for the added fields I created, when I edit it doesnt save. And if when I created it the field was empty, when I press edit and fill the fields, after I save it stays empty,

The same happen with local setting like the date and time format, I change it, save but nothing happen.


Thank you for your help in advance

[DragonflyMaster]

Hi All,

I have the latest comunity edition and I am a windows user.

Hi, what exactly is your version?
"the latest comunity edition" is kinda confusing, since I might think you are using 5.1 RC or 5.0.0f...

I did a fresh installation of sugar in my server but I needed to add fields into some modules,

How did you create the new fields?
Via module builder?
Via Studio?
Via manual php code?

When I create a new record everything saves good but when I edit the records the new record saves fine in the original fields that came with the module but no change applies in the added fields.

I can edit the original fields as many times as I want, but for the added fields I created, when I edit it doesnt save. And if when I created it the field was empty, when I press edit and fill the fields, after I save it stays empty,

The same happen with local setting like the date and time format, I change it, save but nothing happen.


Thank you for your help in advance

I would try
Admin->Repair->Clear template data cache and
Admin->Repair->Rebuild relationships.

[oualidos80]

Hi,

I installed CE 5.0.0.F.

For the fields I used studio/Fields.

For some fields I just added new fields and for others I cloned existing fields and changed the names.

Thank you.

[kuske]

And... a very important information:

on which platform did you install SugarCRM?

Was it unix/linux?

Your issue sounds like the chmod 775 problem we heard so much already in this forum.

[oualidos80]

Hi,

I tried

Admin->Repair->Clear template data cache and
Admin->Repair->Rebuild relationships.

but didnt work.

My server is servage and the platform is

Linux node3.c45 2.6.17-1.2142_FC4smp #1 SMP Tue Jul 11 22:57:02 EDT 2006 i686

and while installing I made all files writable and when I forgot one of them while installing I couldnt continue untill made it writable.

Thank you

[DragonflyMaster]

Admin->Quick Repair and Rebuild.

That's what I'd try next.

[ptemplin7]

Have you turned on the debug mode in the preference file?
If not turn it on. Try saving again and go look at sugarcrm.log. (I would suggest deleting the file first before the test!)

Search the log file for an Error. This sounds exactly like an problem I ran into several weeks ago. My guess is one of those variables had a relationship and then was deleted leaving a spurious variable (ie column) in a database table. Sugar tries to write to the column and can't so it generates a mysql error and drops all the custom data.

Once you find the error, Look closely it will tell you which column it failed to write or read from. Use your myphpadmin or other SQL tool and go look for that problem. The table should also be in the error so you can go straight to the table.
I simply deleted the column that was not needed and Sugar was complaining about (It had nio relevant data so check!) and everything started working fine again.

If you did have a relationship field and deleted it this may need to be over in Bugs for the Sugar guys to fix.

Good luck, Hope some of this helps,
Paris