Asset Register (Page 1 of 2)

Wow! Looks promissing .
I have tried to install your module, without success so far, due to MySQL compatibility problems. Nevermind. If you would like to make your work available via central FrontAccounitng modules repository, there will be also some other fixes necessary. I will send you a patch with most important fixes.

Anyway thank you very much for your contribution to FA community .

Janusz

Ok, thank you. Current FrontAccounting version requires MySQL>=4.1, but this is not big deal - extension modules can have additional requirements.

Thank you in advance.
Janusz

To make the tables be created by the system, got to Active/Install Extensions then selected on the drop down activated for {company}.
Then make the module inactive then active again.

If you want to look at the SQL you can go to modules/asset_register/sql/updatesql

Hi Dennis,

Thank for your usefull Asset Register Modules.

But i think I have problem here, There are no assets list appear in amortisasion posting page.

Do you have any idea for what should I do?

Hi,

I try to install Asset Register but I found the problem. The sql error show bellow:
DATABASE ERROR : could not get all asset types
error code : 1146
error message : Table 'ptsk.0_asset_types' doesn't exist
sql that failed was : SELECT * FROM 0_asset_types WHERE !inactive

How I fix this error?

Thanks

Hi Joe,

Actually I don't understand with your suggest. but last night I try to inactive and active  asset register in FA in Install / activate extensions > Extensions > activated for

When I am cheking what files we can download directly from FA installation and from module author website - then functions.sql file is missing in FA installation.
But when I want to execute this SQL command, then I am getting fallowing error:
SQL query:

delimiter;

DROP TRIGGER IF EXISTS ins_asset_valuations;

MySQL said: Documentation
#1227 - Access denied; you need the SUPER privilege for this operation

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

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?

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

Joe

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.

@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