Page 1 of 1

No records stored into mshop_index_supplier

Posted: 20 Sep 2019, 11:37
by alberto
Hi,

I recently installed Aimeos version 2019.07, with Laravel version 6.0 on a Windows machine (PHP 7.2.13 ). Everything went well,
but when I add a supplier (with products) the supplier's name is being shown on the filter section (suppliers) but with no products. I noticed that no record was stored into table mshop_index_supplier.
Is this a known error or do you know how to solve it?
Indexes unq_msindsup_p_sid_supid_lt_po and idx_msindsup_sid_supid_lt_po where created during installation. All
tables are of type InnoDB.

Kind regards,
Albert Oxener (Holland)

Re: No records stored into mshop_index_supplier

Posted: 21 Sep 2019, 07:57
by aimeos
The mshop_index_supplier table isn't updated automatically if you assign a product in the supplier panel. You have to run the "index/rebuild" job to update the table.

In the next versions, we will add the possibility to assign suppliers in the product detail panel, so the index will be updated automatically on product save.

Re: No records stored into mshop_index_supplier

Posted: 23 Sep 2019, 09:25
by alberto
Hi Aimeos,

Thanks for the quick reaction. I followed your instructions and (of course) it worked out well.

Kr.,
Albert Oxener