Generating Custom Report - Error

[jayavman]

Debug mode

• I have enabled debug mode
• I have read checked the Common Issues page

Describe the bug

@marcusmoore When generating Custom Asset Report. .csv Report comes out missing all assets

Reproduction steps

1. Custom Asset Report
2. tick all fields
3. Then generate
4. downloaded .csv
5. Opened .csv file (screenshot above)
6. Ran debug mode, Error log attached
   ...

Expected behavior

.csv should have all asset information

Screenshots

No response

Snipe-IT Version

v6.1.2 build 10938 (g32747cafd)

Operating System

ubuntu

Web Server

Apache

PHP Version

8.1.20

Operating System

No response

Browser

No response

Version

No response

Device

No response

Operating System

No response

Browser

No response

Version

No response

Error messages

[2023-07-12 09:50:21] production.ERROR: Error: Call to a member function belongsTo() on null in /home/server/public_html/asset/app/Models/Asset.php:393
Stack trace:
#0 /home/server/public_html/asset/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php(539): App\Models\Asset->depreciation()
#1 /home/server/public_html/asset/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php(491): Illuminate\Database\Eloquent\Model->getRelationshipFromMethod('depreciation')
#2 /home/server/public_html/asset/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php(440): Illuminate\Database\Eloquent\Model->getRelationValue('depreciation')
#3 /home/server/public_html/asset/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2029): Illuminate\Database\Eloquent\Model->getAttribute('depreciation')
#4 /home/server/public_html/asset/app/Http/Controllers/ReportsController.php(822): Illuminate\Database\Eloquent\Model->__get('depreciation')
#5 /home/server/public_html/asset/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(51): App\Http\Controllers\ReportsController->App\Http\Controllers\{closure}(Object(Illuminate\Database\Eloquent\Collection), 1)
#6 /home/server/public_html/asset/app/Http/Controllers/ReportsController.php(881): Illuminate\Database\Eloquent\Builder->chunk(20, Object(Closure))
#7 /home/server/public_html/asset/vendor/symfony/http-foundation/StreamedResponse.php(109): App\Http\Controllers\ReportsController->App\Http\Controllers\{closure}()
#8 /home/server/public_html/asset/vendor/symfony/http-foundation/Response.php(394): Symfony\Component\HttpFoundation\StreamedResponse->sendContent()
#9 /home/server/public_html/asset/vendor/laravel/framework/src/Illuminate/Support/HigherOrderTapProxy.php(34): Symfony\Component\HttpFoundation\Response->send()
#10 /home/server/public_html/asset/public/index.php(53): Illuminate\Support\HigherOrderTapProxy->__call('send', Array)
#11 {main}  
[2023-07-12 09:50:21] production.ERROR: Call to a member function belongsTo() on null {"userId":1,"exception":"[object] (Error(code: 0): Call to a member function belongsTo() on null at /home/server/public_html/asset/app/Models/Asset.php:393)
[stacktrace]
#0 /home/server/public_html/asset/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php(539): App\\Models\\Asset->depreciation()
#1 /home/server/public_html/asset/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php(491): Illuminate\\Database\\Eloquent\\Model->getRelationshipFromMethod('depreciation')
#2 /home/server/public_html/asset/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php(440): Illuminate\\Database\\Eloquent\\Model->getRelationValue('depreciation')
#3 /home/server/public_html/asset/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2029): Illuminate\\Database\\Eloquent\\Model->getAttribute('depreciation')
#4 /home/server/public_html/asset/app/Http/Controllers/ReportsController.php(822): Illuminate\\Database\\Eloquent\\Model->__get('depreciation')
#5 /home/server/public_html/asset/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(51): App\\Http\\Controllers\\ReportsController->App\\Http\\Controllers\\{closure}(Object(Illuminate\\Database\\Eloquent\\Collection), 1)
#6 /home/server/public_html/asset/app/Http/Controllers/ReportsController.php(881): Illuminate\\Database\\Eloquent\\Builder->chunk(20, Object(Closure))
#7 /home/server/public_html/asset/vendor/symfony/http-foundation/StreamedResponse.php(109): App\\Http\\Controllers\\ReportsController->App\\Http\\Controllers\\{closure}()
#8 /home/server/public_html/asset/vendor/symfony/http-foundation/Response.php(394): Symfony\\Component\\HttpFoundation\\StreamedResponse->sendContent()
#9 /home/server/public_html/asset/vendor/laravel/framework/src/Illuminate/Support/HigherOrderTapProxy.php(34): Symfony\\Component\\HttpFoundation\\Response->send()
#10 /home/server/public_html/asset/public/index.php(53): Illuminate\\Support\\HigherOrderTapProxy->__call('send', Array)
#11 {main}
"}

Additional context

No response

[jayavman]

Hi Initov,

That updated line creates errors :>

[inietov]

Hi Initov,

That updated line creates errors :>

Ugh, you're totally right. Give me a moment.

[inietov]

@jayavman thanks for your report and your patience, now the error in my branch is gone (I think). You can test it again if you like, but if not we can wait until (if?) it's merged.