Digital Product Passports

A Digital Product Passport (DPP) is a digital ID for products, storing key lifecycle information, such as materials, origin, repair options, and environmental impact. By 2027, DPPs will be mandatory under EU law.

The Chain
Internal Server Error
QueryException
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'factory_id' in 'SELECT' (Connection: mysql, SQL: select `id`, `name`, `sku`, `local_images`, `description`, `type`, `product_type`, `season`, `estimated_delivery_date`, `created_at`, `factory_id` from `products` where `products`.`id` in (191, 192, 193, 194, 2321, 2322, 2323, 2324, 2326, 2328, 2329, 2330, 2331, 2334, 2335, 2336, 2337, 2338, 2339, 2340, 2341, 2342, 2346, 2347, 2348, 2349, 2350, 2351, 2352, 2355, 2372, 2373, 2374, 2375, 2376, 2377, 2378, 2379, 2380, 2381, 2382, 2383, 2384, 2385, 2386, 2387, 2388, 2389, 2390, 2391, 2392, 2393, 2394, 2395, 2396, 2406, 2407))
vendor/laravel/framework/src/Illuminate/Database/Connection.php :825
vendor/laravel/framework/src/Illuminate/Database/Connection.php :779
vendor/laravel/framework/src/Illuminate/Database/Connection.php :398
vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php :3106
vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php :3091
vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php :3676
vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php :3090
vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php :811
vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php :793
vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php :213
vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php :176
vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php :859
vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php :828
vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php :794
app/Http/Controllers/Api/DPPController.php :63
vendor/laravel/framework/src/Illuminate/Routing/Controller.php :54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php :44
vendor/laravel/framework/src/Illuminate/Routing/Route.php :266
vendor/laravel/framework/src/Illuminate/Routing/Route.php :212
vendor/laravel/framework/src/Illuminate/Routing/Router.php :808
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :170
vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php :51
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :127
vendor/laravel/framework/src/Illuminate/Routing/Router.php :807
vendor/laravel/framework/src/Illuminate/Routing/Router.php :786
vendor/laravel/framework/src/Illuminate/Routing/Router.php :750
vendor/laravel/framework/src/Illuminate/Routing/Router.php :739
vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php :201
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :170
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php :21
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php :31
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php :21
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php :51
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php :27
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php :110
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php :62
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php :58
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php :22
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :127
vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php :176
vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php :145
vendor/laravel/framework/src/Illuminate/Foundation/Application.php :1220
public/index.php :17
Request
GET /api/brands/63/dpps
Headers
accept 
text/html
accept-encoding 
gzip
host 
thechainapp.io
x-forwarded-for 
2a02:4780:a:1831:0:3516:45f2:1
x-forwarded-proto 
https
x-real-ip 
2a02:4780:a:1831:0:3516:45f2:1
x-real-port 
33402
x-forwarded-port 
443
x-port 
443
x-lscache 
1
Body 
No body data
Application
Routing
controller 
App\Http\Controllers\Api\DPPController@publicDppIndex
middleware 
api
Routing Parameters 
{
    "brand_id": "63"
}
Database Queries
mysql 
select `id`, `name` from `users` where `users`.`id` = '63' limit 1
mysql 
select * from `dpp` where `brand_id` = '63' order by `created_at` desc
mysql 
select `id` from `factories` where `factories`.`id` in (60, 61, 63, 67, 68, 69, 70, 73, 75, 76, 78, 79, 122, 124, 125)