Product combination generator in admin panel not storing data in DB

[raktrri]

Product combination generator in admin panel not storing data in DB

Once submitted it showing success message but there are no combination

[Daresh]

What version? Maybe you need some update?

[musicmaster]

1. Did it work before?

2. Generating combinations can be confusing as you need to push two buttons. So it would be interesting to know what exactly you did.

[raktrri]

I did upgrade to 1.6.17

See attachment

 

[raktrri]

@musicmaster   I am trying to generate multiple combinations from admin panel but it throwing a success message with no insertion in DB

 

@Daresh Kindly help

Edited February 14, 2018 by raktrri (see edit history)

[musicmaster]

As I see it you haven't answered my two questions.

[raktrri]

@musicmaster

1. No i guess, after i upgrade it doesnt

2. I tried generating multiple combination by selecting attributes. After submit i got success message but data is not there. Please check the screenshot i shared

[musicmaster]

My guess still is that you select the combinations but that you don't press the generate button. But you are so evasive in your answers that it is hard to find out. If you want a technical problem solved you should take the time to describe every button you clicked and every field you filled or checked. I know it is boring but if you don't like to do this boring stuff you are just wasting my (and other people's) time.

[raktrri]

@musicmaster

Steps that i followed to generate multiple combination

1. Go to product edit

2. click on the combination

3. clicked product combination generator.

4. then i select 2 colors from 1 group and 2 size from another group and clicked add

5. entered 6 quantity and reference

6. After that i clicked Generate these combination

7. it redirect me to the combination tab with success message but with no data

[musicmaster]

ok, that looks better.

Next question: if I do so I see in top left corner: "Edit: productname". In your case I see "filter by ID: 809". What is happening there?

[raktrri]

@musicmaster

Yes that was showing because i filter 809 product id in product listing

[musicmaster]

5 hours ago, raktrri said:

@musicmaster

Yes that was showing because i filter 809 product id in product listing

That is not what happens on my test 1.6.1.17. when I filter on a product number. So I suggest that you try without the filter.

[raktrri]

40 minutes ago, musicmaster said:

That is not what happens on my test 1.6.1.17. when I filter on a product number. So I suggest that you try without the filter.

 

I did the same like you suggested but nothing happens. The problem remain same. Kindly help.

[musicmaster]

1 minute ago, raktrri said:

 

I did the same like you suggested but nothing happens. The problem remain same. Kindly help.

But do you then actually see the "Edit: productname" that I see?

[raktrri]

Just now, musicmaster said:

But do you then actually see the "Edit: productname" that I see?

 

Yes i can see "Edit : my product name "

[raktrri]

@musicmaster I think the issue is with the core file itself. Not sure.

Please advise

[musicmaster]

Why would it be the core file when on a fresh installation of that PS version I see now problem?

Did you try creating a new product and giving that combinations?

[raktrri]

1 minute ago, musicmaster said:

Why would it be the core file when on a fresh installation of that PS version I see now problem?

Did you try creating a new product and giving that combinations?

Nope i edited in existing product.

[musicmaster]

Maybe there is something wrong with that product. So try other products.

[raktrri]

13 minutes ago, musicmaster said:

Maybe there is something wrong with that product. So try other products.

Same thing is happening with all the products ...

[musicmaster]

-  Did you enable development mode?

 - Did you look in the error log of the server?

[raktrri]

22 minutes ago, musicmaster said:

-  Did you enable development mode?

 - Did you look in the error log of the server?

Yes i did checked by both way. No luck.

There is no error in error_log

[musicmaster]

If you understand mysql the next option might be to enable debug_profiling

define('_PS_DEBUG_PROFILING_', true);

It is just a few lines from where you set development mode.

The result is that at the bottom of each page you will see a list of all the mysql commands that have been run for that page.

[raktrri]

12 hours ago, musicmaster said:

If you understand mysql the next option might be to enable debug_profiling

define('_PS_DEBUG_PROFILING_', true);

It is just a few lines from where you set development mode.

The result is that at the bottom of each page you will see a list of all the mysql commands that have been run for that page.

I followed the instruction and sharing you some queries like insert and update ....
I can see in last 3 insert 'id_product_attribute' is coming as 0

 

Please assists

 

INSERT INTO `ps_attribute_impact` (`id_product`, `id_attribute`, `price`, `weight`)
VALUES (809, 401, 0, 0),(809, 435, 0, 0),(809, 325, 0, 0),(809, 326, 0, 0)
ON DUPLICATE KEY UPDATE `price` = VALUES(price), `weight` = VALUES(weight)

UPDATE `ps_stock_available` SET `id_stock_available` = '1906',`id_product` = '809',`id_product_attribute` = '0',`id_shop` = '1',`id_shop_group` = '0',`quantity` = '33',`depends_on_stock` = '0',`out_of_stock` = '2' WHERE `id_stock_available` = 1906

UPDATE `ps_product` SET `cache_default_attribute` = '0' WHERE id_product = 809

INSERT INTO `ps_product_attribute_combination` (`id_product_attribute`, `id_attribute`) VALUES ('1943', '401'), ('1943', '325')

INSERT INTO `ps_product_attribute` (`id_product`, `location`, `ean13`, `upc`, `quantity`, `reference`, `supplier_reference`, `wholesale_price`, `price`, `ecotax`, `weight`, `unit_price_impact`, `minimal_quantity`, `default_on`, `available_date`) VALUES ('809', '', '', '', '6', 'JS Ent Hunting Shirts', '', '0', '0', '0', '0', '0', '1', NULL, '0000-00-00')

INSERT INTO `ps_product_attribute` (`id_product`, `location`, `ean13`, `upc`, `quantity`, `reference`, `supplier_reference`, `wholesale_price`, `price`, `ecotax`, `weight`, `unit_price_impact`, `minimal_quantity`, `default_on`, `available_date`) VALUES ('809', '', '', '', '6', 'JS Ent Hunting Shirts', '', '0', '0', '0', '0', '0', '1', NULL, '0000-00-00')

INSERT INTO `ps_product_attribute` (`id_product`, `location`, `ean13`, `upc`, `quantity`, `reference`, `supplier_reference`, `wholesale_price`, `price`, `ecotax`, `weight`, `unit_price_impact`, `minimal_quantity`, `default_on`, `available_date`) VALUES ('809', '', '', '', '6', 'JS Ent Hunting Shirts', '', '0', '0', '0', '0', '0', '1', NULL, '0000-00-00')

INSERT INTO `ps_product_attribute_combination` (`id_product_attribute`, `id_attribute`) VALUES ('0', '401'), ('0', '326')

INSERT INTO `ps_product_attribute_combination` (`id_product_attribute`, `id_attribute`) VALUES ('0', '435'), ('0', '325')

INSERT INTO `ps_product_attribute_combination` (`id_product_attribute`, `id_attribute`) VALUES ('0', '435'), ('0', '326')

 

 

Edited February 16, 2018 by raktrri (see edit history)

[musicmaster]

I don't have much time at the moment. Did you try a different browser/computer?

[raktrri]

On 2/17/2018 at 2:28 AM, musicmaster said:

I don't have much time at the moment. Did you try a different browser/computer?

I did tried at different computer in different country .... Its seems a core issue after upgrade.

Never mind i will try to upgrade it to 1.7 

[musicmaster]

2 hours ago, raktrri said:

 Its seems a core issue after upgrade.

Never mind i will try to upgrade it to 1.7 

 

A core issue after upgrade? How did you arrive at that idea?

1.7 has its own problems. And the upgrade isn't easy.