Rebuilding Wikibase ID counters, see https://wikibase.consulting/transferring-wikibase-data-between-wikis/

rebuildWikibaseIdCounters.sql

-- By Jeroen De Dauw / https://Professional.Wiki
-- License: GPL-2.0-or-later

SELECT * FROM /*_*/wb_id_counters;

REPLACE INTO /*_*/wb_id_counters VALUE((SELECT COALESCE(MAX(CAST(SUBSTRING(`page_title`, 2) AS UNSIGNED)), 0) FROM `page` WHERE `page_namespace` = 120), 'wikibase-item');

REPLACE INTO /*_*/wb_id_counters VALUE((SELECT COALESCE(MAX(CAST(SUBSTRING(`page_title`, 2) AS UNSIGNED)), 0) FROM `page` WHERE `page_namespace` = 122), 'wikibase-property');

SELECT * FROM /*_*/wb_id_counters;

Are you available for some troubleshooting?

We at WikiTide tries to ran the script but it fails and give us this:

MariaDB [lhmndatawikitide]> SELECT * FROM /*_*/wb_id_counters;
+-------------------+----------+
| id_type           | id_value |
+-------------------+----------+
| wikibase-item     |       14 |
| wikibase-property |       21 |
+-------------------+----------+
2 rows in set (0.000 sec)

MariaDB [lhmndatawikitide]> REPLACE INTO /*_*/wb_id_counters VALUE((SELECT COALESCE(MAX(CAST(SUBSTRING(`page_title`, 2) AS UNSIGNED)), 0) FROM `page` WHERE `page_namespace` = 860), 'wikibase-item');
ERROR 1366 (22007): Incorrect integer value: 'wikibase-item' for column `lhmndatawikitide`.`wb_id_counters`.`id_value` at row 157