# I am unable to update s\_srticles\_attributes table through shopware. can someone help?

**URL:** <https://forum.shopware.com/t/i-am-unable-to-update-s-srticles-attributes-table-through-shopware-can-someone-help/36780>\
**Category:** Plugins\
**Created:** [17. Mai 2016 um 08:38 UTC](https://forum.shopware.com/t/i-am-unable-to-update-s-srticles-attributes-table-through-shopware-can-someone-help/36780 "2016-05-17T08:38:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![alirizvi](https://avatars.discourse-cdn.com/v4/letter/a/96bed5/32.png) [@alirizvi](https://forum.shopware.com/u/alirizvi)\
**Post date:** [17. Mai 2016 um 08:38 UTC](https://forum.shopware.com/t/i-am-unable-to-update-s-srticles-attributes-table-through-shopware-can-someone-help/36780/1 "2016-05-17T08:38:00Z")

</div>

i am using sql query in my controller to update s\_articles\_attributes table

$sql= “Update s\_articles\_attributes SET attr1=’”.$attr1."’ where articleID=’".$articleId."";  
Shopware()-\>Db()-\>executeQuery($sql);

but unable to execute it through shopware and when i execute it via phpmyadmin it works.

Any help?

---

<div class="post-metadata">

**Author:** ![Michael\_Telgmann](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/michael_telgmann/32/20289_2.png) [@Michael\_Telgmann](https://forum.shopware.com/u/Michael_Telgmann)\
**Post date:** [17. Mai 2016 um 09:22 UTC](https://forum.shopware.com/t/i-am-unable-to-update-s-srticles-attributes-table-through-shopware-can-someone-help/36780/2 "2016-05-17T09:22:10Z")

</div>

Hi alirizvi,

is there any error message?&nbsp;&nbsp;

Just read your query again. The attribute fields are in the table ‘s\_articles\_attributes’. So you have to change the table in your query&nbsp; ![Wink](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/1X/b3785da0cbf2c8566cb535dcf55b2730b5224899.png "Wink")

Best regards from Schöppingen

&nbsp;Michael Telgmann

---

<div class="post-metadata">

**Author:** ![alirizvi](https://avatars.discourse-cdn.com/v4/letter/a/96bed5/32.png) [@alirizvi](https://forum.shopware.com/u/alirizvi)\
**Post date:** [17. Mai 2016 um 09:51 UTC](https://forum.shopware.com/t/i-am-unable-to-update-s-srticles-attributes-table-through-shopware-can-someone-help/36780/3 "2016-05-17T09:51:01Z")

</div>

hi michael, thanks for correction in my question

even this is not working

$sql= “Update s\_articles\_attributes SET attr1=’”.$attr1."’ where articleID=’".$articleId."";  
Shopware()-\>Db()-\>executeQuery($sql);

---

<div class="post-metadata">

**Author:** ![Michael\_Telgmann](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/michael_telgmann/32/20289_2.png) [@Michael\_Telgmann](https://forum.shopware.com/u/Michael_Telgmann)\
**Post date:** [17. Mai 2016 um 09:57 UTC](https://forum.shopware.com/t/i-am-unable-to-update-s-srticles-attributes-table-through-shopware-can-someone-help/36780/4 "2016-05-17T09:57:38Z")

</div>

is there any error message?

---

<div class="post-metadata">

**Author:** ![alirizvi](https://avatars.discourse-cdn.com/v4/letter/a/96bed5/32.png) [@alirizvi](https://forum.shopware.com/u/alirizvi)\
**Post date:** [17. Mai 2016 um 10:12 UTC](https://forum.shopware.com/t/i-am-unable-to-update-s-srticles-attributes-table-through-shopware-can-someone-help/36780/5 "2016-05-17T10:12:05Z")

</div>

no and as i said query is working fine in phpmyadmin not in shopware as shown below:

ajax response i am getting

```
{"success":true,"1":"Update s_articles_attributes SET attr1='VZ435890' where articleID='166' and articledetailsID='730'"}

```

&nbsp;

`phpmyadmin success`

 ![](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/2X/d/d8a8ed08099fdc2d8678288c2d7ea50802dce677.png)

data row:

 ![](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/2X/4/4b013c21463d020dc6b7d58373a82a16fc9895b6.png)