Attributes not working (properly) after update

[CrossY]

Hi there,

 

I've updated my shop from 1.5 > 1.6 through 1-click-upgrade. However, my attributes don't work properly anymore.

 

The colors (from color picker attributes) were invisible at first. I fixed that in the database ps_attribute_group "is_color_group" were all set to 0, so I changed them to 1.

 

However when I select a different attribute from the regular one, it doesn't change. The page reloads and then it's still on the default selection. The link does change to ..product#/1-color-red/ for a second, but since the page then reloads it pops back to the default.

 

- I have copied the database to fresh 1.6.1.5 installation, but then the same problem occurs
- I've cleared/reset cache, CSS/JS/HTML minify etc.

- No visible errors in Google Dev tools
- Same problem occurs with newly created attributes and products
 

 

Edit: just installed a clean version and the demo products worked. I then copied all the attributes_x tables to the new one, and it still worked. Then I copied the whole database to that clean version and it's bugged again. So it's something in the database messing this up, but not in the attributes tables.. Any suggestions?

 

Any help would be greatly appreciated!

Edited May 6, 2016 by CrossY (see edit history)

[CrossY]

Fixed it.

 

I think there is a bug in 1-click-update, not updating the database configuration 100%.

 

It was missing "PS_ATTRIBUTE_ANCHOR_SEPARATOR" value in PS_CONFIGURATION in my database, so the link that generated was was incorrect.

 

To fix this go to your database table "ps_configuration" and see if you can find it. If it's not there, insert new and only fill out name "PS_ATTRIBUTE_ANCHOR_SEPARATOR" and value "-" (only the dash without the quotes) and click ok/go.

 

Edit: easier way to fix this is through the admin. Go to References > Products > Character for attribute-anchor separator in product link (or something like this, I have the non-English version installed) > Change to "," > Change back to "-". Database should create the entry for you now.

Edited May 9, 2016 by CrossY (see edit history)

[Nanou2301]

Thank you so much!!

 

I had the same problem for days!

 

In my database, I had two values for "PS_ATTRIBUTE_ANCHOR_SEPARATOR" but one of them was corrupted.

Indeed, values for "id_shop_group" and "id_shop" were set to NULL. I changed this to "1" and TADAAAA!

 

Thanks again.

[Nair]

Hi,

 

I have the same problem and did what was asked above however it still does not update. Very weird that there are situations where if i click "save" it does updated but very rare, most of the time it does not. In fact most of the time even if you press "save" it still comes back to the same product edit page instead of going back to the product home view.

 

Fixed it.

 

I think there is a bug in 1-click-update, not updating the database configuration 100%.

 

It was missing "PS_ATTRIBUTE_ANCHOR_SEPARATOR" value in PS_CONFIGURATION in my database, so the link that generated was was incorrect.

 

To fix this go to your database table "ps_configuration" and see if you can find it. If it's not there, insert new and only fill out name "PS_ATTRIBUTE_ANCHOR_SEPARATOR" and value "-" (only the dash without the quotes) and click ok/go.

 

Edit: easier way to fix this is through the admin. Go to References > Products > Character for attribute-anchor separator in product link (or something like this, I have the non-English version installed) > Change to "," > Change back to "-". Database should create the entry for you now.

 

I did change the setting back and forth in the preferences.

 

Thank you so much!!

 

I had the same problem for days!

 

In my database, I had two values for "PS_ATTRIBUTE_ANCHOR_SEPARATOR" but one of them was corrupted.

Indeed, values for "id_shop_group" and "id_shop" were set to NULL. I changed this to "1" and TADAAAA!

 

Thanks again.

I also had the values set to NULL and changed to 1 but it still did not, however the update happens randomly and rarely for some reason, at times duplicating the product and updating the new one works but that also is very random.....what else can be done?

 

Thanks,

Binesh

Edited November 9, 2016 by binesh (see edit history)

[mentalspot]

Fixed it.

 

I think there is a bug in 1-click-update, not updating the database configuration 100%.

 

It was missing "PS_ATTRIBUTE_ANCHOR_SEPARATOR" value in PS_CONFIGURATION in my database, so the link that generated was was incorrect.

 

To fix this go to your database table "ps_configuration" and see if you can find it. If it's not there, insert new and only fill out name "PS_ATTRIBUTE_ANCHOR_SEPARATOR" and value "-" (only the dash without the quotes) and click ok/go.

 

Edit: easier way to fix this is through the admin. Go to References > Products > Character for attribute-anchor separator in product link (or something like this, I have the non-English version installed) > Change to "," > Change back to "-". Database should create the entry for you now.

 

Help me, good job. Also an issue after 1-click update.

[Isady]

Hi guys! Sorry for getting this old topic back up but I encounter the same problem and your solutions did not help.

Indeed, I was missing the PS_ATTRIBUTE_ANCHOR_SEPARATOR so I tried to do it the "clean" way from the admin. No changes.

I went into the database and saw I had it 3 times with wrong creation dates. I manually deleted 2 of them and updated the third one to reflect my id_shop_group to 3 (my group number) and my id_shop to 1. I saved everything. Cleared the cache. Updated the page and... nothing.

On a clean install the attributes do show properly. Once I link the new website to my old database, crash.

Please help me, I am starting to get very worried. The website was working fine (or so I thought) since I upgraded 2 months ago but now I understand it might not have been the case.

This website was up and running for already 10 years being upgraded every time with the 1-click update since 1.4.

Here is an exemple page where the price does not change when we select the different attributes:
https://www.bijoux-isady.fr/fr/bracelets-gourmettes-a-graver/90903-isady-mery-gold-gourmette-bracelet-a-graver-plaque-or-18k-maille-gourmette-plusieurs-tailles.html?search_query=mery&results=2

 

Vékia, you are always of huge help. Could you help me please???

[patuga]

Hi,

the problem may be on the override files you may have. when you install the latest module versions the overrides may not get updated to the latest version as well.

that's what happened to me. and even when i disabled all overrides on the backoffice the problem wasn't solved.

 

check my answer on another thread:

https://www.prestashop.com/forums/topic/456002-problem-with-the-product-attributes-drop-down-menu-on-shop-page/?do=findComment&comment=3071745

hope this helps you get your problem solved.

 

 

 

[Himanshubishtt]

Hi guys,

I am also facing the error in product attributes. 

Like to my ticket: https://www.prestashop.com/forums/topic/997252-facing-problem-in-product-attributes/?tab=comments#comment-3138869

Please if anyone can help me solve this error.

Thanks & regards