Bugs

Topic for reporting any MS SQL Provider problems and Bugs.

IMPORTANT NOTE: There is a known issues with installing new plugins in nopCommerce.
Please read this post for more information.

Hi! I use nopCommerce 3.50.
Subcategory is not show in topmenu after enable this plugin.
Only show first depth.

We'll verify.

Yes. It was a bug.
We have fixed it.
Thank you.

Download the new version, replace plugin folder (all files) and restart your site.

Thank you for fix!!!

Using nop 3.6 default theme. If "Compare Products" is disabled. Enabling the Nopmssqlprovider plugin enables the compare products on the category and product pages. I'm testing using the trial plugin.

Thank you. I'll verify it.

Thank you.
I was a bug. We have fixed it.

Version 4.24 - July 24, 2015
- fixed bug with compare products button (link) (NopCommerce 3.60).

Issue resolved! Thanks for the quick fix. The plugin works great and certainly increases page load time for us even with a small catalog.

Any update on the reported issue when using Smart SEO plugin? The MSSQLProvider plugin messes up the meta information for category and manufacturer pages. I basically renders smart SEO inoperable on the mentioned. With the popularity of smart seo it may be a good idea to resolve this. I have since had to remove the MSSQL plugin as it negatively affects our SEO. Thank you!

I remember about it...
But I see only one way to read information from SEO plugin into stored procedure...
It will fix your problem... I wanted to find elegant solution.
I'll try to send you a new version at the end of the next week.

You ever find a solution to this smart SEO issue?

I did the special fix for you, but I can't include it in public release. I'll send new dll at the end of the week.

Hi I have a question about a section in your sproc "FNS_CatalogModelFactory_ProductLoadAllPaged".

if @LanguageId>0
begin  
  declare @countLanguage int
  set @countLanguage=0
  select @countLanguage=count(*)
  from Language L WITH (NOLOCK)
  where L.Published=1
      and (@StoreId=0 or L.LimitedToStores=0 or Exists(select Top 1 Id from StoreMapping sm   WITH (NOLOCK)
        where sm.EntityName = 'Language' and sm.StoreId=@StoreId and sm.EntityId=L.Id))
  if @countLanguage=1
  begin
    set @LanguageId=0
  end
end

My site it using your plugin, and i noticed that this sporc returns Name of category with languageId = 0.
So the sproc always gets into this if

if @countLanguage=1
  begin
    set @LanguageId=0
  end

My problem is solved just by removing this, or set set @LanguageId=@LanguageId.

Is there any particular reason to have this check, when do i want to set LanguageId to 0?

We added this code for stores with ONE language.
If store has one language this store doesn't use localization values from external table.
You can comment and change the code from stored procedure.

Will do, is that check even necessary or could i just remove that whole section -->

if @LanguageId>0
begin  
  declare @countLanguage int
  set @countLanguage=0
  select @countLanguage=count(*)
  from Language L WITH (NOLOCK)
  where L.Published=1
      and (@StoreId=0 or L.LimitedToStores=0 or Exists(select Top 1 Id from StoreMapping sm   WITH (NOLOCK)
        where sm.EntityName = 'Language' and sm.StoreId=@StoreId and sm.EntityId=L.Id))
  if @countLanguage=1
  begin
    set @LanguageId=@LanguageId
  end
end

This code uses for performance optimization.
Example.
By default plugin tries to read localized value for name parameter.
If plugin can't find localized value plugin will use standard value.
If your store has ONLY one language it's not resonable to read localuzed value.
Plugin will read standard value.
You can remove this code. It's not a problem.
I can't understand why yiur store with ONE language has localuzwd value...

Do you have multistore and one of your store has ONLY one language? But another stores have several languages?

I have several stores, where each store has it's own language. So for instance i have a swedish site where the laguage is Swedish, Norwegian site where language is Norwegian and so on.
When i was on my Norwegian store the subCategories and Breadcrumb on the category site was not the LocaleValue it were the standard value. This was because the LanguageId was set to zero.

Yes. You should comment this code. It eas a bug and I'll fix it in the nwxt release. Thank you.