The table in the DB with the data in, is “tabWarehouse” - maybe check it’s content to see if your table contains the right entry
Be warned…this is a very very dangerous thing to do to/with your data, and it could cause total corruption of the DB, so make backups before you try anything like this - which is not guaranteed to fix it, but might help if you are desperate.
The entry would be along the lines of this…
‘Back Office - ZZZ’,‘2017-11-09 09:48:19.568403’,‘2017-11-09 09:48:19.643324’,‘firstname.lastname@example.org’,‘email@example.com’,‘0’,‘Storeroom - ZZZ’,NULL,NULL,‘6’,NULL,NULL,‘0’,‘7’,‘Storeroom - ZZZ’,NULL,NULL,‘8’,NULL,NULL,NULL,‘Company Name’,NULL,‘0’,‘WarehouseName’,NULL,NULL,‘Storeroom - ZZZ’,NULL,NULL,NULL);
You will have to tweak the lft/rgt and indexes to suit your situation. If you are able to access the table on your working system to check its contents, that would be better (as long as both versions are matched and the table structure is the same on both).