<![CDATA[FrontAccounting forum — Asset module]]> https://frontaccounting.com/punbb/viewtopic.php?id=4436 Fri, 11 Oct 2013 02:53:16 +0000 PunBB <![CDATA[Re: Asset module]]> https://frontaccounting.com/punbb/viewtopic.php?pid=18085#p18085 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).

]]> Fri, 11 Oct 2013 02:53:16 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=18085#p18085 <![CDATA[Asset module]]> https://frontaccounting.com/punbb/viewtopic.php?pid=18011#p18011 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)

]]> Mon, 30 Sep 2013 19:55:53 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=18011#p18011