AnsweredAssumed Answered

Silent Upgrade to 6.4.6 fails - too big precision 255

Question asked by Max Max on Feb 25, 2014
Latest reply on Mar 4, 2014 by Max Max
I am performing silent upgrades of CE from 5.5.
When I get to upgrade from 6.3.3 to 6.4.6 the process fails with "Database failure. Please refer to sugarcrm.log for details.". In the log I see:
  [60408][1][FATAL]  Query Failed:ALTER TABLE aaa_exclusive   modify COLUMN rental_amount decimal(255)  NULL ,  modify COLUMN currency_id char(255)  NULL ,  modify COLUMN comm_amount decimal(255)  NULL ::: MySQL error 1426: Too big precision 255 specified for column 'rental_amount'. Maximum is 65.    The aaa_exclusive is a custom module. the rental_amount field was created in the module builder as a curency field.    What is the problem here and how can I move past it?  Thank you.

Outcomes