Asset Extension Reports

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

Any help would be appreciated.

Regards
Dave

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

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,

to

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

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.

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/