Custom fields don't save any data

[eringuet]

Hello,

I am running SugarCRM 5.0b on debian etch. Im using PHP Version 5.2.0-8+etch10, Apache 2.2.3.

My problem is the following:

Admin -> studio -> account -> field -> add field

Create a new field, text field, i called it ID and checked "audit".

Go to account, edit an existing account, fill the ID field, save.

The ID field is empty.

View change log returns:
Field it old = (null) new hello changed by admin (date).

if I change it again is see:
Field it old = (null) new hello changed by admin (date).
Field it old = (null) new hello2 changed by admin (date).

Other non-custom fields are properly saved.

The problem is present with new account too.

I've been reading around for hours, I can't find a way to solve the problem.

beanfiles.html reports this (orange):

NO! --- DynamicField is not an index in $beanFiles
NO! --- CustomFields is not an index in $beanFiles
NO! --- Audit is not an index in $beanFiles

I don't know if it's pertinent.

I've seen here that it can be an issue with strict mode in MySQL. I'm no MySQL guru but i don't seem to use strict mode on my installation (debian default).

mysql> SELECT @@global.sql_mode;
+-------------------+
| @@global.sql_mode |
+-------------------+
|                   |
+-------------------+
1 row in set (0.00 sec)

mysql> SELECT @@session.sql_mode;
+--------------------+
| @@session.sql_mode |
+--------------------+
|                    |
+--------------------+
1 row in set (0.00 sec)

Any help would be really appreciated,

ER

[andopes]

Hi, ER.

I suppose the problem is the name of the field: 'id'.
ID is a reserved field name in sugarcrm.

Try to change its name.

Cheers


--
André Lopes
Lâmpada Global Services
Rua Bela Cintra, 299 conjunto. 51
São Paulo, SP 01415-000
tel1. 55 11 3237-3110
e-mail: info@lampadaglobal.com

[eringuet]

Hi André,

I tried with other names as well.

Sugar renames all custom fields name_c (afaik) i guess its to prevent problems.

Can you reproduce the problem on your setup?

Thanks,

ER

[andopes]

No, eringuet.

This way you are making sugar conflicts your custom field id_c with the unique identifier of custom table id_c.

You really need to rename this field.

Cheers

--
André Lopes
Lâmpada Global Services
Rua Bela Cintra, 299 conjunto. 51
São Paulo, SP 01415-000
tel1. 55 11 3237-3110
e-mail: info@lampadaglobal.com

[eringuet]

Hello,

I also have the following custom fields which do not work:

sales_c
support_c
market_c
region_c

Is there a list of sugarcrm's own fields somewhere?

Thank you,

ER

[DragonflyMaster]

Hello,

I also have the following custom fields which do not work:

sales_c
support_c
market_c
region_c

Is there a list of sugarcrm's own fields somewhere?

Thank you,

ER

Look at mySQL tables: there is one called Accounts that contains all default fields for Accounts module; a separate table named Accounts_cstm contains the user defined fields (yours).
As soon as you add a custom field through studio to accounts module, this table is created with id_c a primary key. This id is created automatically through a php script. That is why you shouldn't use an id_c field. Try to rename that to My_Id or something, you'll see it works.
I think this issue causes the other custom fields' bad behaviour.

[eringuet]

So I screwed up my database when deleting all the custom fields i had done.

I reinstalled everything on a new vm using this guide : http://www.howtoforge.com/debian_etch_sugarcrm

Right after I finished the installation, I went to Admin, studio, account, fields, i created a custom field called NEW_TEST_FIELD. Sugar called it new_custom_field_c.

I then went to layouts, I added a row to editview and listview and added the custom field.

If I go to Accounts and i edit/add an account, the custom field is there but it won't save the text.

????

thanks for the help.

ER

[DragonflyMaster]

Right after I finished the installation, I went to Admin, studio, account, fields, i created a custom field called NEW_TEST_FIELD. Sugar called it new_custom_field_c.

This is strange. If you create a custom field and name it NEW_TEST_FIELD, Sugar should just add the suffix _c, ie NEW_TEST_FIELD_c.
This makes me think there stil is something not working...
What language are you logged-in with?

I then went to layouts, I added a row to editview and listview and added the custom field.

If I go to Accounts and i edit/add an account, the custom field is there but it won't save the text.

????

thanks for the help.

ER

Since you have a fresh install, I suggest you to update it to 5.0.0C.
This patch resolves some bugs in studio.

[eringuet]

Sorry my typo, it was <my name>_c.

It's the english version and I run 5.0c now


ER

[DragonflyMaster]

Sorry my typo, it was <my name>_c.

It's the english version and I run 5.0c now


ER

Are you having the same issue now with 5.0.0C ?