Upgrading 2.2 to 2.4 (just4fashion theme)

Hi guys,

I have a site at a staging location while I update it.

For the most part, I've noticed a huge improvement in performance between the live on at http://www.shamargiftware.com and the one currently in staging http://www.gardencaredirect.com:8000/

Its all going smoothly so far, I've used redgates data compare to bring in the products and categories etc.  The images are stored in the filesystem, so I've manually copied the contents of the /contents/images folder across.

The images against a category are huge for some reason, yet not so on the front page.  Anybody got any idea to what is going on.  These images should be 129w x 115h.
http://www.gardencaredirect.com:8000/c/34

Thanks

HairyMike wrote:

You need to make sure you upload images with right size. http://www.gardencaredirect.com:8000/content/images/thumbs/0000347_sterling_silver_pendants.jpeg this image is too big. Normally there is option in media settings where you set the image size for category but since you have upgraded from 2.2 I don't know you might be missing that. The image width should be 125 and height proportionate to width.

Regards,
Atiq

Hi!

in the changes.txt file for the 2.4 release it says:
create PictureId as int in below tables

SpecificationAttributeOption
Product_SpecificationAttribute_Mapping

I have done that.. I've also added it to the SpecificationAttributeOption class as well as the ProductSpecificationAttribute

now when i try and access my catalogue pages I'm getting:
Server Error in '/' Application.

Invalid column name 'PictureId'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid column name 'PictureId'.

Source Error:

Line 431:
Line 432:            var result = new List<SpecificationAttributeOptionFilter>();
Line 433:            var items = query.ToList();
Line 434:            foreach (var item in items)
Line 435:                result.Add(new SpecificationAttributeOptionFilter()

Source File: C:\tomdev\MinorMagic\Nop\just4fashion2.4source\Libraries\Nop.Services\Catalog\SpecificationAttributeService.cs    Line: 433

Stack Trace:

[SqlException (0x80131904): Invalid column name 'PictureId'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2073550
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5064508
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
   System.Data.SqlClient.SqlDataReader.get_MetaData() +86
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
   System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) +443

[EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details.]
   System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) +479
   System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute(ObjectContext context, ObjectParameterCollection parameterValues) +736
   System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) +149
   System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() +44
   System.Data.Entity.Internal.Linq.InternalQuery`1.GetEnumerator() +40
   System.Data.Entity.Infrastructure.DbQuery`1.System.Collections.Generic.IEnumerable<TResult>.GetEnumerator() +40
   System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +315
   System.Linq.Enumerable.ToList(IEnumerable`1 source) +58
   Nop.Services.Catalog.SpecificationAttributeService.GetSpecificationAttributeOptionFilter(Int32 categoryId, IWorkContext workContext) in C:\tomdev\MinorMagic\Nop\just4fashion2.4source\Libraries\Nop.Services\Catalog\SpecificationAttributeService.cs:433

just wondering if you knew what the heck is going on.. usually id refresh and ed diagram but i can't find one in the nop solution?
Cheers,
Tom