Profile: steveembry66@gmail.com

OK, problem solved.

Thank you!
Steve

I logged onto server tonight and looked at the data in  the FNS_SmartCampaigns table.
There was only one campaign, and no NULL values in any column, so setting the StoreId column to True

I executed both scripts again tonight, but there was still no change.

I added a new campaign from the admin area, and when saving, got the generic page error and nothing in log.
But...when I look in the table using SSMS, I see the new record.
I then try to load smartcampaigns list in admin area and same error as before:

The 'StoreId' property on 'SmartCampaign' could not be set to a 'System.Boolean' value. You must set this property to a non-null value of type 'System.Int32'.

I already tried that...both SQL scripts executed successfully. Still have same error.

Based on error, I think maybe in the FNS campaigns table, the storeID column is empty/null in the record. I will try putting a 1 into that field and see if it solves my problem.

Thanks,
Steve

Hello-

I just updated from 3.3 to 3.4 and have a problem with the Smart Campaigns plugin:

/Admin/SmartCampaign/List  - throws error in nop log:

The 'StoreId' property on 'SmartCampaign' could not be set to a 'System.Boolean' value. You must set this property to a non-null value of type 'System.Int32'.
The details for the log entry.Full message:  System.InvalidOperationException: The 'StoreId' property on 'SmartCampaign' could not be set to a 'System.Boolean' value. You must set this property to a non-null value of type 'System.Int32'. at System.Data.Entity.Core.Common.Internal.Materialization.Shaper.ErrorHandlingValueReader`1.GetValue(DbDataReader reader, Int32 ordinal) at System.Data.Entity.Core.Common.Internal.Materialization.Shaper.GetPropertyValueWithErrorHandling[TProperty](Int32 ordinal, String propertyName, String typeName) at lambda_method(Closure , Shaper ) at System.Data.Entity.Core.Common.Internal.Materialization.Shaper.HandleEntityAppendOnly[TEntity](Func`2 constructEntityDelegate, EntityKey entityKey, EntitySet entitySet) at lambda_method(Closure , Shaper ) at System.Data.Entity.Core.Common.Internal.Materialization.Coordinator`1.ReadNextElement(Shaper shaper) at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.SimpleEnumerator.MoveNext() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at Nop.Core.PagedList`1..ctor(IQueryable`1 source, In..............

Can you help?

Thanks,
Steve

Thank you again!
I feel stupid for not noticing that...I made the correction, and now it is working perfectly!
Thank you for the information and link about how to check if a string exists in a list. A very useful tool.

Then FOXNETSOFT said:

1. ShortBody  has html decoded text. ex.
Body
<p><img src="/Content/Images/uploaded/Anatomy/Spacial_Orientation/dp_foot_mod_labeled.jpg" width="419" height="424" /></p>

ShortBody will be empty.

2. You wrote bad code. Please change it. from
if (s.Length>13) to if (s.Length<12)

  if (s.Length<12)
      {
    thestrbody = strbody;
            }
      else
      {
           string sLess = s.Remove(0, 12);
           int index = sLess.IndexOf("Summary");
           if (index!=-1)
    {        
      thestrbody = (sLess.Substring(index + 8));
          }
  }

second block, you should think about condition

   @thestrbody

       @if (s.Length<12) ???????????
  {

read this link about your error
http://www.codeproject.com/Questions/163948/Index-and-count-must-refer-to-a-location-within-th


3. About List
ex.
List<string> groups=new List<string>();
groups.Add("test1");
groups.Add("test2");
groups.Add("test3");
...
groups.Add("test100");
//or List<string> groups=new List<string>("test1", "test2",..., "test100");

string groupname="test1";
if (groups.Any(x=>string.Compare(x,groupname,StringComparison.OrdinalIgnoreCase)==0))

http://stackoverflow.com/questions/19676557/checking-if-string-exists-in-list-c-sharp

I wrote the code in notepad (please verify in Visual Studio)

I would like to simply the conditional clause, but I could not find an easier way because the model does not include the article's parent group name. If it did, I could easily change my condition to this:
    
    string group = Model.ArticleParentGroupName;

    

    if (group.Contains("Anatomy"))
The problem is this:
All of our articles which are in the Anatomy parent group have no text in the article description field..only an image reference, so I need for my string manipulation code to be "skipped" for all articles in that parent group because the string.Remove method will have exception if there is no text to manipulate.
I can't understand what is different about 3.4 that makes my working code now fail.

I am open to any suggestions...

It is me again.....

Yesterday, in my nopcommerce general settings screen, I tried enabling "minify CSS"  and "minify Javascript".
When I apply, immediately in log file I start seeing errors:

The URL '/Plugins/FoxNetSoft.Articles/Styles/styles.css' is not valid. Only application relative URLs (~/url) are allowed. Parameter name: virtualPath

System.ArgumentException: The URL '/Plugins/FoxNetSoft.Articles/Styles/styles.css' is not valid. Only application relative URLs (~/url) are allowed. Parameter name: virtualPath at System.Web.Optimization.Bundle.Include(String virtualPath, IItemTransform[] transforms) at Nop.Web.Framework.UI.PageHeadBuilder.GenerateCssFiles(UrlHelper urlHelper, ResourceLocation location, Nullable`1 bundleFiles) at Nop.Web.Framework.UI.LayoutExtensions.NopCssFiles(HtmlHelper html, UrlHelper urlHelper, ResourceLocation location, Nullable`1 bundleFiles) at ASP._Page_Themes_Alfresco_Views_Shared__Root_Head_cshtml.Execute() in c:\inetpub\wwwroot\THIS_IS_IT\Themes\Alfresco\Views\Shared\_Root.Head.cshtml:line 37 at System.Web.WebPages.WebPageBase.ExecutePageHierarchy() at System.Web.Mvc.WebViewPage.ExecutePageHierarchy() at System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) at System.Web.WebPages.WebPageBase.Rend................

I disabled "minify CSS" and no more errors...Javascript minify works with no errors..

Do I need to fix reference to the Articles stylesheet somewhere for Articles to also be "minified" ..or ignored?

Thanks!

Support wrote:

Hello again-

We just recently noticed a small bug with the Articles plugin that I want to make you aware of.

When viewed in a mobile device, the left navigation of groups collapses as it should, but the only header that expands to show articles in the group is the first group header...

For example:

Knowledgebase
  article1
  article2
  article3

Anatomy
  article1
  article2
  article3

Surgeries
  article1
  article2
  article3

when in mobile device, looks like this:

Knowledgebase
Anatomy
Surgeries


...and when you click on the knowledgebase header, it expands to show it's articles

...but when you click on other headers, like anatomy or surgeries, still the only group that expands is the first one....knowledgebase...

You can see it on my site at:

http://www.myfootshop.com/articles

Thanks,
Steve