• From: UK
  • Registered: 10/02/2012
  • Posts: 146

Topic: Asset module

I am getting this error when posting amortisation

DATABASE ERROR :
At file C:\Frontaccounting\modules\asset_register\includes\db\amortisation_post_db.inc:32:
could not post amortise
error code : 1366
error message : Incorrect decimal value: '' for column '' at row -1
sql that failed was : SELECT 0_amortise_post(2013)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,094

Re: Asset module

asset_register module uses MySQL Functions apart from tables and indexes. Hence the database user for the FA database should be privileged to create, alter, drop and use them.

You will have to uninstall the asset_register, delete any tables associated with it and then re-install the module only after enabling the user privileges and flushing privileges (or restarting MySQL server).

apmuthu's Website