FrontAccounting forum — Asset Extension Reports

Re: Asset Extension Reports

2013-03-15T14:27:53Z

The URL:
http://website/accounts/reporting/reports_main.php?Class=2&REP_ID=_assets_list
is malformed.

It should be ending in an integer like say:
http://website/accounts/reporting/reports_main.php?Class=2&REP_ID=609

Hence trace where in the extension, the "_asset_list " string occurs and see if a "$" prefixed php variable is missing in the context.

All your errors are a consequence of the URL PARAMETER type being violated.

Re: Asset Extension Reports

2013-03-15T11:06:21Z

Hi Apmuthu

Thanks for your quick reply, please find a link to the screen shot http://www.bsacadelaide.com/tmp/Asset%20issue.jpg

Im sorry but i don't understand what you were asking in regards to the REP_ID=integer value.I am not a seasoned programmer although can read code.

Any help would be most appreciated.

Regards
Dave

Re: Asset Extension Reports

2013-03-14T15:45:09Z

Please study the url format for any other working report and you will find that the REP_ID=integer value which is not the case above.

File upload rights are controlled by the forum moderator.

Upload the screenshot to your public website and place the link here.

The following sites among others make a living by advertising on the public's need for free image hosting:

http://troll.ws/
http://beta.photobucket.com/images/pastebin/
http://derp.co.uk/
http://inky.ws/

Re: Asset Extension Reports

2013-03-14T10:47:07Z

Hi Apmuthu

Sorry for the delay in replying.

I changed the code to read $sql = "SELECT ".TB_PREF."assets.asset_id,

I have a screen shot of the debug but cant figure out how to attach it to the post.

With debug enabled i get the following errors when trying to print inventory reports / asset list
http://website/accounts/reporting/reports_main.php?Class=2&REP_ID=_assets_list

#Undefined index: PARAM_2 in file: /public_html/website/accounts/modules/asset_register/reporting/rep_assets_list.php at line 56
#accounts/modules/asset_register/reporting/rep_assets_list.php:30: print_assets_list()
#/accounts/reporting/prn_redirect.php:71:
#/accounts/reporting/includes/reports_classes.inc:53:
#accounts/reporting/reports_main.php:480:
#accounts/modules/asset_register/reporting/rep_assets_list.php'#accounts/reporting/prn_redirect.php')
#(BoxReports Object)->getDisplay()

and the same again but starting with
Undefined index: PARAM_3 in file: /public_html/website/accounts/modules/asset_register/reporting/rep_assets_list.php at line 57

your help would be most appreciated

Regards

Dave

Re: Asset Extension Reports

2013-02-14T08:41:20Z

You will need to clear any browser cache left over.

I only looked into one report listing the assets. Can you list the assets correctly as a report? This extension uses functions and triggers and hence your MySQL database user must have the necessary privileges.

List each issue and what file / url shows up on the browser for each issue and what menu click sequence brought up the issue. This will help replicate and resolve the issue.

Since the extensions are not in a repo for public to refine it over time and are just packed up into pkgs with magic glue it is a little difficult for the community to contribute and appears designed to help only coders.

I am planning a git repo for the extensions from where users can manually upload extensions outside of the magic web interface - any takers? Maintaining a repo over time is time consuming and requires great commitment - the folks at FA are already doing the best they can under the circumstances and it will not be fair to burden them any more.

Whilst Charts of Accounts, Languages and Themes get updated fast, extensions take longer to get updated when they do.

Re: Asset Extension Reports

2013-02-13T12:43:06Z

I really appreciate your help, although i don't believe this has resolved the issues.

Starting by adding assets to an asset type - you are unable to then go back and update the asset to change it to a different asset type.

When running the report multiple assets per asset type are still not displayed in the PDF report.

If you could help i would really appreciate it. Please feel free to PM me if needed.

Regards

Dave

Re: Asset Extension Reports

2013-02-13T11:01:29Z

It appears that the SELECT field assets.id was erroneously made same as the GROUP BY field.

Edit Line 34 of modules/asset_register-2.3.3-9/reporting/rep_assets_list.php:

            $sql = "SELECT ".TB_PREF."asset_types.asset_type_id,

            $sql = "SELECT ".TB_PREF."assets.asset_id,

Re: Asset Extension Reports

2013-02-13T08:15:15Z

Look up the sql used. It will be missing a GROUP BY clause and possibly a SUM/COUNT aggregate function as well.

Re: Asset Extension Reports

2013-02-06T19:06:19Z

This extension was developed by Dennis Gichangi (dennis AT dennis DOT me DOT ke) so maybe if you contact him he can help you? I'm not a developer so I can't be all that helpful, but I would suggest setting one or more of these variables in config.php and see if you get any error messages:

       $debug                  = 1;    // show sql on database errors

        $show_sql               = 1;    // show all sql queries in page footer for debugging purposes
        $go_debug               = 1;    // set to 1 for basic debugging, or 2 to see also backtrace after failure.
        $pdf_debug              = 1;    // display pdf source instead reports for debugging when $go_debug!=0

Btw, don't leave these variable set for long as they can generate a lot of clutter!

Another thing to check is that all of your assets are setup correctly. Sometimes, if certain fields are missing or incorrect it can mess things up.

I hope some of this is helpful to you. Sorry that I can't be of further help.

Good luck!

Regards,

Chris

Re: Asset Extension Reports

2013-02-06T11:20:49Z

David Keene wrote:

Hi All
I have started using the asset extension but have noticed a problem when running a report. If i have multiple assets for each asset type when the report only included the first asset entered. I assume this is not the intended functionality.
Any help would be appreciated.
regards
Dave

Hi all, i wonder if someone can help me with this issue. I need to start tracking assets but can use this module as teh report doesnt function correct.

Any help would be appreciated

Regards

Dave

Re: Asset Extension Reports

2013-01-22T11:57:45Z

Hi All
I have just upgraded to 2.3.14 and still am experiencing the same issue.

Any help would be appreciated.

Regards
Dave

Re: Asset Extension Reports

2013-01-21T12:27:56Z

Hi All - Just wondered if anyone had come across this same issue as me.

Regards

Dave

Asset Extension Reports

2013-01-18T12:00:37Z

Hi All

I have started using the asset extension but have noticed a problem when running a report. If i have multiple assets for each asset type when the report only included the first asset entered. I assume this is not the intended functionality.

Any help would be appreciated.

regards
Dave