Skip to content Skip to sidebar

This thread is resolved. Here is a description of the problem and solution.

Problem:
The client reported that two categories were missing in the Croatian version of their shop sidebar, even though everything was translated correctly. After inserting specific categories manually, they appeared but were not expandable like in the original version.
Solution:
We identified that the issue was due to missing term meta keys for the order in the database. We recommended running the following SQL commands to add the missing term meta:

INSERT INTO `wpnj_termmeta` (`term_id`, `meta_key`, `meta_value`)<br />VALUES ('832', 'order', '1');

and

INSERT INTO `wpnj_termmeta` (`term_id`, `meta_key`, `meta_value`)<br />VALUES<br />  ('847', 'order', '1'),<br />  ('860', 'order', '1'),<br />  ('897', 'order', '1'),<br />  ('914', 'order', '1'),<br />  ('944', 'order', '1'),<br />  ('960', 'order', '1'),<br />  ('987', 'order', '1'),<br />  ('995', 'order', '1'),<br />  ('996', 'order', '1'),<br />  ('999', 'order', '1'),<br />  ('1001', 'order', '1'),<br />  ('1002', 'order', '1');

We also advised clearing transients from WooCommerce tools after running these commands. It is crucial to create a backup before performing any database modifications.

If this solution does not resolve your issue, or if it seems outdated or irrelevant to your case, we highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If further assistance is needed, please open a new support ticket at WPML support forum.

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

This topic contains 25 replies, has 1 voice.

Last updated by Dražen 2 months, 1 week ago.

Assisted by: Dražen.

Author Posts
July 31, 2025 at 9:50 am #17284606

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hello,

you should run it inside your database as SQL query.

You can do so via PHPmyadmin from your hosting panel or via same plugin from WP repo.

Regards,
Drazen

August 3, 2025 at 11:57 am #17290867

ziga pipan

I did this to insert 2 missing categories
INSERT INTO `wpnj_termmeta` (`term_id`, `meta_key`, `meta_value`)
VALUES ('832', 'order', '2');

INSERT INTO `wpnj_termmeta` (`term_id`, `meta_key`, `meta_value`)
VALUES ('1583', 'order', '3');

I also cleared cache.

The categories are now showing, but are not expandable,
hidden link

like they should be and like they are in original verison.
hidden link

August 4, 2025 at 6:44 am #17291807

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hello,

thanks, let me update our 2nd tier to check further and I will get back to you.

Regards,
Drazen

August 4, 2025 at 8:23 am #17292196

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hello,

is it okay to install database plugin on your website, to further check the database tables?

Regards,
Drazen

August 4, 2025 at 8:53 am #17292253

ziga pipan

sure

August 4, 2025 at 9:01 am #17292260

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hello,

thanks.

Regards,
Drazen

August 6, 2025 at 6:29 am #17298525

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hello,

please run next code:

INSERT INTO `wpnj_termmeta` (`term_id`, `meta_key`, `meta_value`)
VALUES 
  ('847', 'order', '1'),
  ('860', 'order', '1'),
  ('897', 'order', '1'),
  ('914', 'order', '1'),
  ('944', 'order', '1'),
  ('960', 'order', '1'),
  ('987', 'order', '1'),
  ('995', 'order', '1'),
  ('996', 'order', '1'),
  ('999', 'order', '1'),
  ('1001', 'order', '1'),
  ('1002', 'order', '1');

The run clear transients from Wocommerce tools.

Please make sure to create a backup, before doing any actions, just in case.

Let me know how it goes.

Regards,
Drazen

August 6, 2025 at 1:48 pm #17299830

ziga pipan

I did none of this and I see it's working. Weird. Why is this happening?

August 6, 2025 at 1:58 pm #17299841

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hello,

seem sour 2nd tier run the share DB code once you have shared permission with us.

Let us know if there is anything else we can do for you, since the issue is fixed I guess we can close the ticket.

Kind regards,
Drazen

August 6, 2025 at 2:17 pm #17299986

ziga pipan

I think they had duplicated site.

it works now, but can I add categories freely now?

August 6, 2025 at 2:19 pm #17299989

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hello,

yes, feel free to continue the work on your website.

Regards,
Drazen