You have no items in your shopping cart.

Saturday, July 20, 2019 5:18:28 PM

Bugs

Avatar

Posted: 6 years ago

#64 Quote

Support

Posted: 6 years ago

#64 Quote
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.
Avatar

Posted: 4 years ago

#361 Quote

subicura@subicura.com

Posted: 4 years ago

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

Avatar

Posted: 4 years ago

#362 Quote

Support

Posted: 4 years ago

#362 Quote
We'll verify.
Avatar

Posted: 4 years ago

#363 Quote

Support

Posted: 4 years ago

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

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

Posted: 4 years ago

#364 Quote

subicura@subicura.com

Posted: 4 years ago

#364 Quote
Thank you for fix!!!
Avatar

Posted: 3 years ago

#556 Quote

shinybars

Posted: 3 years ago

#556 Quote
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.
Avatar

Posted: 3 years ago

#558 Quote

Support

Posted: 3 years ago

#558 Quote
Thank you. I'll verify it.
Avatar

Posted: 3 years ago

#561 Quote

Support

Posted: 3 years ago

#561 Quote
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).
Avatar

Posted: 3 years ago

#563 Quote

shinybars

Posted: 3 years ago

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

Posted: 3 years ago

#1654 Quote

shinybars

Posted: 3 years ago

#1654 Quote
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!
Avatar

Posted: 3 years ago

#1655 Quote

Support

Posted: 3 years ago

#1655 Quote
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.

Avatar

Posted: 3 years ago

#1677 Quote

shinybars

Posted: 3 years ago

#1677 Quote
You ever find a solution to this smart SEO issue?
Avatar

Posted: 3 years ago

#1682 Quote

Support

Posted: 3 years ago

#1682 Quote
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.
Avatar

Posted: one year ago

#6680 Quote

rrogne

Posted: one year ago

#6680 Quote
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?
Avatar

Posted: one year ago

#6681 Quote

Support

Posted: one year ago

#6681 Quote
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.
Avatar

Posted: one year ago

#6682 Quote

rrogne

Posted: one year ago

#6682 Quote
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


Avatar

Posted: one year ago

#6683 Quote

Support

Posted: one year ago

#6683 Quote
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...
Avatar

Posted: one year ago

#6684 Quote

Support

Posted: one year ago

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

Posted: one year ago

#6685 Quote

rrogne

Posted: one year ago

#6685 Quote
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.
Avatar

Posted: one year ago

#6686 Quote

Support

Posted: one year ago

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

Powered by nopCommerce

Copyright © 2019 FoxNetSoft. All rights reserved