Report Issues - most of them run fine.
When I run Profit and Loss Report I get a message that says “Whoops, looks like something went wrong.”
When I run the task report doesn’t pull up anything but I have one task in the last day of the report. Should show at least one project.
PROFIT and LOSS Report (browser console)
Failed to load resource: the server responded with a status of 500 (Internal Server Error)
Any ideas why it is not working?
Please check for any errors in storage/logs/laravel-error.log
You may want to first delete the file then cause the error.
Okay here is what I got in the log - I deleted the old one and then just ran the report.
[2017-02-05 20:20:03] production.ERROR: exception ‘ErrorException’ with message ‘Trying to get property of non-object’ in /home/mydirectorys/app/Ninja/Reports/ProfitAndLossReport.php:58 Stack trace: #0 /home/mydirectorys/app/Ninja/Reports/ProfitAndLossReport.php(58): Illuminate\Foundation\Bootstrap\HandleExceptions->handleError(8, ‘Trying to get p…’, ‘/home/awakgnoo/…’, 58, Array)
#1 /home/mydirectorys/app/Http/Controllers/ReportController.php(98): App\Ninja\Reports\ProfitAndLossReport->run()
#2 [internal function]: App\Http\Controllers\ReportController->showReports()
#3 /home/mydirectorys/bootstrap/cache/compiled.php(9482): call_user_func_array(Array, Array)
#4 /home/mydirectorys/bootstrap/cache/compiled.php(9544): Illuminate\Routing\Controller->callAction(‘showReports’, Array)
#5 /home/mydirectorys/bootstrap/cache/compiled.php(9524): Illuminate\Routing\ControllerDispatcher->call(Object(App\Http\Controllers\ReportController), Object(Illuminate\Routing\Route), ‘showReports’)
#6 [internal function]: Illuminate\Routing\ControllerDispatcher->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#7 /home/mydirectorys/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#8 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#9 /home/mydirectorys/bootstrap/cache/compiled.php(10006): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#10 /home/mydirectorys/bootstrap/cache/compiled.php(9525): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#11 /home/mydirectorys/bootstrap/cache/compiled.php(9512): Illuminate\Routing\ControllerDispatcher->callWithinStack(Object(App\Http\Controllers\ReportController), Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), ‘showReports’)
#12 /home/mydirectorys/bootstrap/cache/compiled.php(8582): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), ‘App\Http\Contro…’, ‘showReports’)
#13 /home/mydirectorys/bootstrap/cache/compiled.php(8569): Illuminate\Routing\Route->runController(Object(Illuminate\Http\Request))
#14 /home/mydirectorys/bootstrap/cache/compiled.php(8283): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request))
#15 [internal function]: Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#16 /home/mydirectorys/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#17 /home/mydirectorys/app/Http/Middleware/PermissionsRequired.php(52): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#18 [internal function]: App\Http\Middleware\PermissionsRequired->handle(Object(Illuminate\Http\Request), Object(Closure))
#19 /home/mydirectorys/bootstrap/cache/compiled.php(10021): call_user_func_array(Array, Array)
#20 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#21 /home/mydirectorys/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#22 /home/mydirectorys/app/Http/Middleware/Authenticate.php(90): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#23 [internal function]: App\Http\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure), ‘user’)
#24 /home/mydirectorys/bootstrap/cache/compiled.php(10021): call_user_func_array(Array, Array)
#25 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#26 /home/mydirectorys/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#27 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#28 /home/mydirectorys/bootstrap/cache/compiled.php(10006): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#29 /home/mydirectorys/bootstrap/cache/compiled.php(8284): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#30 /home/mydirectorys/bootstrap/cache/compiled.php(8275): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#31 /home/mydirectorys/bootstrap/cache/compiled.php(8265): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#32 /home/mydirectorys/bootstrap/cache/compiled.php(2419): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#33 [internal function]: Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request))
#34 /home/mydirectorys/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#35 /home/mydirectorys/app/Http/Middleware/StartupCheck.php(197): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#36 [internal function]: App\Http\Middleware\StartupCheck->handle(Object(Illuminate\Http\Request), Object(Closure))
#37 /home/mydirectorys/bootstrap/cache/compiled.php(10021): call_user_func_array(Array, Array)
#38 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#39 /home/mydirectorys/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#40 /home/mydirectorys/app/Http/Middleware/QueryLogging.php(29): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#41 [internal function]: App\Http\Middleware\QueryLogging->handle(Object(Illuminate\Http\Request), Object(Closure))
#42 /home/mydirectorys/bootstrap/cache/compiled.php(10021): call_user_func_array(Array, Array)
#43 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#44 /home/mydirectorys/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#45 /home/mydirectorys/app/Http/Middleware/DuplicateSubmissionCheck.php(36): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#46 [internal function]: App\Http\Middleware\DuplicateSubmissionCheck->handle(Object(Illuminate\Http\Request), Object(Closure))
#47 /home/mydirectorys/bootstrap/cache/compiled.php(10021): call_user_func_array(Array, Array)
#48 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#49 /home/mydirectorys/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#50 /home/mydirectorys/bootstrap/cache/compiled.php(3225): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#51 /home/mydirectorys/app/Http/Middleware/VerifyCsrfToken.php(42): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#52 [internal function]: App\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#53 /home/mydirectorys/bootstrap/cache/compiled.php(10021): call_user_func_array(Array, Array)
#54 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#55 /home/mydirectorys/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#56 /home/mydirectorys/bootstrap/cache/compiled.php(13532): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#57 [internal function]: Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#58 /home/mydirectorys/bootstrap/cache/compiled.php(10021): call_user_func_array(Array, Array)
#59 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#60 /home/mydirectorys/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#61 /home/mydirectorys/bootstrap/cache/compiled.php(12022): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#62 [internal function]: Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#63 /home/mydirectorys/bootstrap/cache/compiled.php(10021): call_user_func_array(Array, Array)
#64 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#65 /home/mydirectorys/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#66 /home/mydirectorys/bootstrap/cache/compiled.php(13271): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#67 [internal function]: Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#68 /home/mydirectorys/bootstrap/cache/compiled.php(10021): call_user_func_array(Array, Array)
#69 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#70 /home/mydirectorys/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#71 /home/mydirectorys/bootstrap/cache/compiled.php(13208): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#72 [internal function]: Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#73 /home/mydirectorys/bootstrap/cache/compiled.php(10021): call_user_func_array(Array, Array)
#74 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#75 /home/mydirectorys/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#76 /home/mydirectorys/bootstrap/cache/compiled.php(3286): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#77 [internal function]: Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#78 /home/mydirectorys/bootstrap/cache/compiled.php(10021): call_user_func_array(Array, Array)
#79 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#80 /home/mydirectorys/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#81 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#82 /home/mydirectorys/bootstrap/cache/compiled.php(10006): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#83 /home/mydirectorys/bootstrap/cache/compiled.php(2366): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#84 /home/mydirectorys/bootstrap/cache/compiled.php(2350): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#85 /home/mydirectorys/public/index.php(52): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #86 {main} [] []
It looks like it’s failing to find a reference.
Have you manually deleted any data from the database?
No I have not messed with the database. I did do the upgrade to 3.0.3 version through softaculous from the previous version. Unfortunately I did not run the reports on the previous version, so I don’t know if it worked before or not.
I see the problem, we’ll include a fix with our next release.
Here’s the change if you want to patch your code.
https://github.com/invoiceninja/invoiceninja/commit/e114794f3a30e5341c04c9aaa7b90e00b197790e
That code change help make the report run.
However the report is not correct - I put in a date range of Jan 1 2016 to Dec 31 2016 and it is running 2017 expenses and such it. It is like it is ignoring my date choice.
I checked no error log or browser console errors.
Ok, we’ll try to include a fix in our next release.
Here’s the fix, it will be included with our next release.
https://github.com/invoiceninja/invoiceninja/commit/557e088c46c5b616686d630e975de1fa60b0e841