issue when updating a product

[ahmed31916]

Hello,

I got this error, when updating the product details:

Code: Select all

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'product-1.-download-' for key 'unq_msatt_dom_sid_type_code':
UPDATE "mshop_attribute"
SET
"key" = ?, "type" = ?, "domain" = ?, "code" = ?, "status" = ?,
"pos" = ?, "label" = ?, "mtime" = ?, "editor" = ?
WHERE "siteid" = ? AND "id" = ?
["product|download|","download","product","",1,0,"campbell-3ZUsNJhi_Ik-unsplash.jpg","2022-11-16 11:32:00","admin","1.","227"]
#0 C:\xampp\htdocs\SampleProject\vendor\aimeos\aimeos-core\src\MShop\Attribute\Manager\Standard.php(544): Aimeos\Base\DB\Statement\DBAL\Prepared->execute()
#1 C:\xampp\htdocs\SampleProject\vendor\aimeos\aimeos-core\src\MShop\Common\Manager\Base.php(119): Aimeos\MShop\Attribute\Manager\Standard->saveItem(Object(Aimeos\MShop\Attribute\Item\Standard), true)
#2 C:\xampp\htdocs\SampleProject\vendor\aimeos\aimeos-core\src\MShop\Common\Manager\Decorator\Base.php(200): Aimeos\MShop\Common\Manager\Base->save(Object(Aimeos\MShop\Attribute\Item\Standard), true)
#3 C:\xampp\htdocs\SampleProject\vendor\aimeos\aimeos-core\src\MShop\Common\Manager\Decorator\Base.php(200): Aimeos\MShop\Common\Manager\Decorator\Base->save(Object(Aimeos\MShop\Attribute\Item\Standard), true)
#4 C:\xampp\htdocs\SampleProject\vendor\aimeos\aimeos-core\src\MShop\Common\Manager\ListsRef\Traits.php(294): Aimeos\MShop\Common\Manager\Decorator\Base->save(Object(Aimeos\MShop\Attribute\Item\Standard))
#5 C:\xampp\htdocs\SampleProject\vendor\aimeos\aimeos-core\src\MShop\Product\Manager\Standard.php(711): Aimeos\MShop\Product\Manager\Standard->saveListItems(Object(Aimeos\MShop\Product\Item\Standard), 'product', true)
#6 C:\xampp\htdocs\SampleProject\vendor\aimeos\aimeos-core\src\MShop\Common\Manager\Base.php(119): Aimeos\MShop\Product\Manager\Standard->saveItem(Object(Aimeos\MShop\Product\Item\Standard), true)
#7 C:\xampp\htdocs\SampleProject\vendor\aimeos\aimeos-core\src\MShop\Common\Manager\Decorator\Base.php(200): Aimeos\MShop\Common\Manager\Base->save(Object(Aimeos\MShop\Product\Item\Standard), true)
#8 C:\xampp\htdocs\SampleProject\vendor\aimeos\aimeos-core\src\MShop\Common\Manager\Decorator\Base.php(200): Aimeos\MShop\Common\Manager\Decorator\Base->save(Object(Aimeos\MShop\Product\Item\Standard), true)
#9 C:\xampp\htdocs\SampleProject\vendor\aimeos\aimeos-core\src\MShop\Index\Manager\DBBase.php(197): Aimeos\MShop\Common\Manager\Decorator\Base->save(Object(Aimeos\MShop\Product\Item\Standard), true)
#10 C:\xampp\htdocs\SampleProject\vendor\aimeos\aimeos-core\src\MShop\Common\Manager\Decorator\Base.php(200): Aimeos\MShop\Index\Manager\DBBase->save(Object(Aimeos\MShop\Product\Item\Standard), true)
#11 C:\xampp\htdocs\SampleProject\vendor\aimeos\aimeos-core\src\MShop\Common\Manager\Decorator\Base.php(200): Aimeos\MShop\Common\Manager\Decorator\Base->save(Object(Aimeos\MShop\Product\Item\Standard), true)
#12 C:\xampp\htdocs\SampleProject\vendor\aimeos\ai-admin-jqadm\src\Admin\JQAdm\Product\Standard.php(252): Aimeos\MShop\Common\Manager\Decorator\Base->save(Object(Aimeos\MShop\Product\Item\Standard))
#13 C:\xampp\htdocs\SampleProject\vendor\aimeos\ai-admin-jqadm\src\Admin\JQAdm\Common\Decorator\Base.php(151): Aimeos\Admin\JQAdm\Product\Standard->save()
#14 C:\xampp\htdocs\SampleProject\vendor\aimeos\aimeos-laravel\src\Aimeos\Shop\Controller\JqadmController.php(214): Aimeos\Admin\JQAdm\Common\Decorator\Base->save()
#15 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Routing\Controller.php(54): Aimeos\Shop\Controller\JqadmController->saveAction('default', 'product')
#16 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction('saveAction', Array)
#17 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Routing\Route.php(261): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Aimeos\Shop\Controller\JqadmController), 'saveAction')
#18 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Routing\Route.php(204): Illuminate\Routing\Route->runController()
#19 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Routing\Router.php(725): Illuminate\Routing\Route->run()
#20 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(141): Illuminate\Routing\Router->Illuminate\Routing\closure(Object(Illuminate\Http\Request))
#21 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Routing\Middleware\SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#22 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#23 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Auth\Middleware\Authenticate.php(44): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#24 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
#25 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#26 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#27 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\View\Middleware\ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#28 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#29 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#30 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest(Object(Illuminate\Http\Request), Object(Illuminate\Session\Store), Object(Closure))
#31 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#32 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#33 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#34 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#35 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#36 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#37 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Routing\Router.php(726): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#38 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Routing\Router.php(703): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#39 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Routing\Router.php(667): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route))
#40 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Routing\Router.php(656): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#41 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(167): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#42 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(141): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\closure(Object(Illuminate\Http\Request))
#43 C:\xampp\htdocs\SampleProject\app\Http\Middleware\SetLocale.php(25): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#44 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): App\Http\Middleware\SetLocale->handle(Object(Illuminate\Http\Request), Object(Closure))
#45 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#46 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#47 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(Object(Illuminate\Http\Request), Object(Closure))
#48 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#49 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#50 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Foundation\Http\Middleware\TrimStrings->handle(Object(Illuminate\Http\Request), Object(Closure))
#51 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#52 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure))
#53 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#54 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(Object(Illuminate\Http\Request), Object(Closure))
#55 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Http\Middleware\HandleCors.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#56 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Http\Middleware\HandleCors->handle(Object(Illuminate\Http\Request), Object(Closure))
#57 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Http\Middleware\TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#58 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Http\Middleware\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#59 C:\xampp\htdocs\SampleProject\app\Http\Middleware\TrustHosts.php(24): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#60 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): App\Http\Middleware\TrustHosts->handle(Object(Illuminate\Http\Request), Object(Closure))
#61 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\closure(Object(Illuminate\Http\Request))
#62 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(142): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#63 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(111): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#64 C:\xampp\htdocs\SampleProject\public\index.php(52): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#65 C:\xampp\htdocs\SampleProject\vendor\laravel\framework\src\Illuminate\Foundation\resources\server.php(16): require_once('C:\\xampp\\htdocs...')
#66 main

The problem is from the download file, as you see in the picture, the file has been uploaded and it's details is displayed correctly. Now when I click on the save button, the file details disappeared, and the "$this->get( 'downloadData/attribute.code' )" return empty "".

[aimeos]

Which Aimeos version are you using?
In the current 2022.10 version it works without problems.

It seems like the file path isn't set in the attribute item as code somewhere here:
- https://github.com/aimeos/ai-admin-jqad ... #L308-L317
- https://github.com/aimeos/ai-admin-jqad ... #L266-L284

Can you check what exactly happens there?

[ahmed31916]

Which Aimeos version are you using?

Aimeos v2022.10

The problem is solved. By mistake, I was comment the hidden-attribute component.
Thanks.