FrontAccounting forum — Asset Register

Re: Asset Register

null@example.com (bonmaklad) — Wed, 19 Sep 2012 21:06:49 +0000

ok just ran the SQL from inside the module in the SQL manager

Re: Asset Register

null@example.com (bonmaklad) — Wed, 19 Sep 2012 03:31:29 +0000

DATABASE ERROR : could not get all assets
error code : 1146
error message : Table 'easyacco_bizit.0_asset_types' doesn't exist
sql that failed was : SELECT *, 0_get_asset_value(a.asset_id, YEAR(now())) as current_value FROM 0_asset_types at INNER JOIN 0_assets a ON at.asset_type_id = a.asset_type_id WHERE !a.inactive

____________

DATABASE ERROR : could not get all asset types
error code : 1146
error message : Table 'easyacco_bizit.0_asset_types' doesn't exist
sql that failed was : SELECT * FROM 0_asset_types WHERE !inactive

_____________

Re: Asset Register

null@example.com (bonmaklad) — Wed, 19 Sep 2012 03:30:03 +0000

so step by step:

add the module

add your access

get the errors? So how did we all agree we would fix the errors?

Re: Asset Register

null@example.com (erwindebruin) — Mon, 27 Aug 2012 04:50:51 +0000

nice module!

How can i merge the translation file with the general FA translation file? I see in the asset register module a seperate translation file with 70 lines of translation is added.

In POedit i cannot enter these lines in the regular FA translation file (menu function update from pot will erease the regular lines).

Re: Asset Register

null@example.com (thorbjornw) — Sun, 26 Aug 2012 22:43:22 +0000

It is probably my lack of experience with MySQL. My System Administrator in FA is the default 'admin'. I can make the grant all statement on the database in MySQL to this user, but I don't know how the FA-name 'admin' translates into mysql. I have tried to grant the rights to 'admin'@'localhost', but that did not work. I also tried to create myself as System Administrator in FA, but to no avail. Any suggestions regarding who I should grant the rights to in MySQL to make the asset module to install correctly?

Re: Asset Register

null@example.com (thorbjornw) — Sun, 26 Aug 2012 21:54:47 +0000

OK. I shall try to create the trigger and report back.

Re: Asset Register

null@example.com (itronics) — Sun, 26 Aug 2012 21:38:19 +0000

@thorbjornw
Probably the database user defined for your installation does not have enough rights to properly install the module. This is the only extension module which requires extended access rights on mysql database. You must have TRIGGER rights granted to properly install the module. Check the dbuser rights, then uninstall and install the module again.
@surreyhills
Yes, you are right. There was a bug in install sql script which could fire this error. This has been fixed in new package version already available in repo. I guess you will have to uninstall/install module if you have not fixed the issue manually yet.
Janusz

Re: Asset Register

null@example.com (surreyhills) — Mon, 20 Aug 2012 17:09:53 +0000

I have just installed this module and tried to amortise an asset and got the error:
DATABASE ERROR : could not add asset valuation
error code : 1305
error message : FUNCTION surreyhills.get_asset_value does not exist
sql that failed was : INSERT INTO 0_asset_valuations (asset_id, valuation_year, asset_value) VALUES ('1','2013','289.92')

Looking at the error and the install SQL there seems to be an error in the SQL. When it creates the trigger it uses get_asset_value rather than 0_get_asset_value which is the routine defined.

I will correct the SQL and start again to see if this works.

Re: Asset Register

null@example.com (thorbjornw) — Mon, 20 Aug 2012 16:07:09 +0000

Well, I had already set the access. But I still get the error message: DATABASE ERROR :
At file /var/www/frontaccounting/modules/asset_register/includes/db/assets_db.inc:30:
could not get all assets
error code : 1146
error message : Table 'WyM.0_asset_types' doesn't exist
sql that failed was : SELECT *, 0_get_asset_value(a.asset_id, YEAR(now())) as current_value FROM 0_asset_types at INNER JOIN 0_assets a ON at.asset_type_id = a.asset_type_id WHERE !a.inactive
To manually create the asset table in MySQL I would need to know the structure.

Re: Asset Register

null@example.com (surreyhills) — Mon, 20 Aug 2012 15:33:39 +0000

Thanks, so simple when you know how.
Regards
Mike

Re: Asset Register

null@example.com (joe) — Mon, 20 Aug 2012 15:26:48 +0000

You shouldd go into access setup in setup tab. And then give access to the role.

Joe

Re: Asset Register

null@example.com (surreyhills) — Mon, 20 Aug 2012 15:19:20 +0000

This might be through ignorance. I have just installed the Asset Register and I have three new menu options:

Items and Inventory - Asset Type Entries & Asset Entries
Banking and General Ledger - Amortisation Posting

All are greyed out. I could not find any description of how to use it. Is there any intro to the module?

Re: Asset Register

null@example.com (thorbjornw) — Mon, 06 Aug 2012 01:54:27 +0000

I have tried the asset module also. It installs OK and reportedly it is installed and active. But when I try to register an asset type, I get the following error:
DATABASE ERROR : could not get all asset types
error code : 1146
error message : Table 'WyM.0_asset_types' doesn't exist
sql that failed was : SELECT * FROM 0_asset_types WHERE !inactive
Looks as if I should create a new table manually in Mysql. Would that solve it?

Re: Asset Register

null@example.com (joe) — Sat, 03 Mar 2012 09:56:17 +0000

For now this a an extension. So let us handle it as a such. We have plans to implement in core in the future, but not in release 2.4.

/Joe

Re: Asset Register

null@example.com (spott) — Sat, 03 Mar 2012 09:06:51 +0000

But is there some plans to add asset register to core FA?