We used to use the Decimal field to store a numerical monetary value. Last week, we realized that for values over $999,99, the last digit was being rounded. (Apparently the values were still in the database, but were not displaying correctly in either the record or Views.)

I installed the Money module (and Currency), and in SQL I copied the values from the old decimal field (*100) to the new field_amount1_amount field, and then set field_amount1_currency to "USD" for all records.

Everything looks normal in Views, and everything works properly in records created since then, but when we click an entry to view an individual record, the new Amount1 value is not displaying, and when we try to edit that record, the Amount1 value is being set to USD 0.00. I looked in the CCK content_type_... table for this content type and I can't see any difference between new (working) records and old (weird behavior) records.

Does anyone have any further suggestions? Where else does this module store info?

Comments

wim leers’s picture

wim leers
Location Ghent 🇧🇪🇪🇺
commented
Status: Active » Closed (won't fix)

The module isn't aware of how the data is stored. CCK handles that. What you have done, is one big hack… you probably have to add entries in some other, mysterious table.

You should ask some CCK guru (KarenS, yched, …), or ask in the CCK issue queue how to "transform" one CCK field into another.

Sorry!