I recently ported my data from one nopCommerce3.5 database to another by using SQL Server export/import tools on selected tables. I believe I have ported all the tables I need.
However, I noticed I cannot go into categories and product details page after this. Everything else seems okay. I can solved it by opening the category/product from Admin console and save it again. I cannot go into thousands of products I have migrated and click save on all of them. Please help.
From generated html <a href> part is missing. Does anyone know why this is not generated after I migrated my data? I can't find anything in database that is related to this.
Here is example of generated html from a fixed category
<div class="title">
<strong>
<a href="/finished-chain" title="Finished Chain">Finished Chain</a>
</strong>
</div>
<div class="picture">
<a href="/finished-chain" title="Show products in category Finished Chain">
<img class="lazy" alt="Picture for category Finished Chain" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" data-original="http://mystore.com/content/images/thumbs/0004223_finished-chain_150.jpeg" />
</a>
</div>
Here is example of generated html from a bad category
<div class="title">
<strong>
<a title="Bails">Bails</a>
</strong>
</div>
<div class="picture">
<a title="Show products in category Bails">
<img class="lazy" alt="Picture for category Bails" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" data-original="http://mystore.com/content/images/thumbs/0001311_bails_150.jpeg" />
</a>
</div>