No data saving in Opportunities

[Deland01]

Can anyone shed any light on why all my custom fields don't work in the opportunities module?

I've added all different types of custom fields to just about every module in sugar but for some reason none of the data saves in any I've added into the opportunities section.

The custom fields are there in myphpadmin but they never write any data into the opportunities_cstm table.

Any suggestions?

[Deland01]

Ok so I installed a fresh sugar 4.5.0h and made the same changes & it works fine so I was thinking I should just be able to copy or at least compare the php files which look after the Opportunities module & all the custome settings.

Can anyone point me in the right direction as to where the files for the opportunities module might be kept?

Ok so Im guessing they might be in:

\modules\Opportunities

but are there any hidden anywhere else?



.

[Deland01]

After a load of testing I figured out a fix:



1. Set up a brand new install of Sugar 4.5.0h into another folder within my htdocs folder (web root folder).

2. I now have my live version of sugar, a development system & a brand new clean install.

3. Using My SQL Administrator I exported the following tables from the new install of sugar:

> opportunities_audit
> opportunities_contacts
> opportunities_cstm

4. I then imported these tables into my dev version.

5. Ran a backup of the dev version using My SQL Admin before any data was added.

5. Re-added all the custom fields into the dev version.

6. Tested the new fields worked.

7. I then imported the tried and tested opportunities tables listed above into my live sugar site.

NOTE: Make sure you only export & import the database structure if you have data in your live site or it will be overwritten with nothing.



.