Page 1 of 1
[SOLVED] I can no longer add filter groups
Posted: Mon Jun 17, 2024 10:05 pm
by LEINAD
Hello community,
I try to add a new group of filters, but it doesn't save anymore. Can you help me with a solution?
I am using OpenCart 4.0.2.3
Thank you very much for your support
Regards,
leinad
Re: I can no longer add filter groups
Posted: Mon Jun 17, 2024 10:13 pm
by paulfeakins
Please read the
Forum Rules.
Re: I can no longer add filter groups
Posted: Tue Jun 18, 2024 3:49 pm
by LEINAD
Hello monica345,
Thank you very much for your support.
I followed your advice exactly, but it still doesn't work. The error that is generated is the following:
2024-06-18 07:40:47 - 0: Error: Duplicate entry '157-1' for key 'oc27_filter_group_description.PRIMARY'<br/>Error No: 1062<br/>INSERT INTO `oc27_filter_group_description` SET `filter_group_id` = '157', `language_id` = '1', `name` = 'Packaging'
File: /home/leinadsh/public_html/leinadtex.ro/system/library/db/mysqli.php
Lines: 76
Re: I can no longer add filter groups
Posted: Tue Jun 18, 2024 4:11 pm
by ADD Creative
Looks like your oc_filter_group_description and oc_filter_group tables in your database are out of sync with the filter_group_id. Look at the tables in your database.
Re: I can no longer add filter groups
Posted: Tue Jun 18, 2024 10:19 pm
by LEINAD
Thank you all for your help. Thanks to your support, we have solved the problem. I don't know for what reason, a large number of filter_group_ids disappeared from the database and I had to recreate them to be able to synchronize with oc_filter_group_description.
Thank you all once again!
best regards,
Dan