Prices do not update when I choose combinations!

[MyFitNutrition]

Hi,

I'm having a problem with my website. i prezzi dei mii prodotti no si aggiornano quando si scelgono combines it.

I saw a link qui per test: https://www.myfitnutrition.es/inicio/23-85-namedsport-super-100-whey-proteina.html

I state that the configurations are configured well because from mobile with AMP theme everything works well!

 

Prestashop: 1.7.6.8

PHP: 7.1.33

 

Thanks 

 

Edited November 9, 2020 by MyFitNutrition (see edit history)

[MyFitNutrition]

Update: 

this is what i get from the console, there is an error with the core.js file, but i don't know where to act. can anyone help me with this? I'm practically going crazy.

Thanks

[JBW]

There is a 500 error when changing the variant - enable debug mode to see the details for this error

[MyFitNutrition]

11 minutes ago, JBW said:

There is a 500 error when changing the variant - enable debug mode to see the details for this error

is this by chance?

ps. thanks for the support

[JBW]

No, you can only see the error in the XHR request

Quote

[PrestaShopDatabaseException]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY pac.id_product_attribute ' at line 8<br /><br /><pre> SELECT pac.`id_product_attribute` FROM `ps7k_product_attribute_combination` pac INNER JOIN `ps7k_product_attribute` pa ON pa.id_product_attribute = pac.id_product_attribute WHERE pa.id_product = 21 AND pac.id_attribute IN () GROUP BY pac.id_product_attribute HAVING COUNT(pa.id_product) = 0 LIMIT 1</pre>
at line 769 in file classes/db/Db.php

Means there is something wrong with the SQL query. I think the attribute IDs are missing somehow. Thats hard to analyze further

[MyFitNutrition]

16 minutes ago, JBW said:

No, you can only see the error in the XHR request

Means there is something wrong with the SQL query. I think the attribute IDs are missing somehow. Thats hard to analyze further

What could I do then?

Update:

Edited November 10, 2020 by MyFitNutrition
Update (see edit history)

[MyFitNutrition]

1 hour ago, JBW said:

No, you can only see the error in the XHR request

Means there is something wrong with the SQL query. I think the attribute IDs are missing somehow. Thats hard to analyze further

I'm here, Can you guide me by specifying the steps in:

1:

2:

3 ... etc

I'm sorry but I'm not an expert in this.

line 769 in file classes/db/Db.php

 

Edited November 10, 2020 by MyFitNutrition
Update (see edit history)

[MyFitNutrition]

UPDATE: 

I fixed the error 500 via this guide, https://github.com/PrestaShopCorp/ps_mbo/releases/tag/v2.0.1 

but now I have another error in the log:

ERROR13:11:03appData from PrestaShop Addons is invalid, and cannot fallback on cache.

and I noticed that I can't load combinations into the product anymore or even generate them again!

 

Can anyone help me with this?
I go crazy 🥺

[MyFitNutrition]

can anyone help me? I still haven't solved it.

[JBW]

20 hours ago, MyFitNutrition said:

noticed that I can't load combinations into the product anymore or even generate them again!

Again, look for 500 errors in the XHR request in your browser console

[MyFitNutrition]

39 minutes ago, JBW said:

Again, look for 500 errors in the XHR request in your browser console

I solved the problem, you can try here.

https://www.myfitnutrition.es/productos/-23--138-namedsport-super-100-whey-.html#/48-tamano-2kg/53-sabor-tiramisu 

The 500 error was due to configuration of the core.js.map file
while the combinations did not update prices due to a conflict with the viewedprodcut plugin.

but i need that module, does anyone know how I can solve this or a module to use instead of this ??