Some progress ... maybe? The new error on babetrader shows ...
Server Error in '/' Application.
Unknown column 'ViewDate' in 'where clause'
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: MySql.Data.MySqlClient.MySqlException: Unknown column 'ViewDate' in 'where clause'
Source Error:
Line 4613: GROUP BY PictureID";
Line 4614:
Line 4615: var resultsWeek = conn.Query(sql, new
Line 4616: {
Line 4617: picIds = pictureIds.Take(100), |
Source File: C:\Code\HotnessRater\HotnessRater\HotnessRaterCommon\DataAccess\PictureData.cs
Line: 4615
Stack Trace:
[MySqlException (0x80004005): Unknown column 'ViewDate' in 'where clause']
MySql.Data.MySqlClient.MySqlStream.ReadPacket() +389
MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) +467
MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) +119
MySql.Data.MySqlClient.MySqlDataReader.NextResult() +1027
MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +2309
Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior) +95
Dapper.<QueryImpl>d__138`1.MoveNext() +507
System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +453
System.Linq.Enumerable.ToList(IEnumerable`1 source) +69
Dapper.SqlMapper.Query(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType) +533
Common.DataAccess.PictureData.GetViewsWeek(MySqlConnection conn, List`1 picIds, Dictionary`2 dic) in C:\Code\HotnessRater\HotnessRater\HotnessRaterCommon\DataAccess\PictureData.cs:4615
Common.DataAccess.PictureData.GetMostViewedLast24Hours(Int32 skip, Int32 take) in C:\Code\HotnessRater\HotnessRater\HotnessRaterCommon\DataAccess\PictureData.cs:4569
BabeTrader.Controllers.HomeController.Index() in C:\Code\HotnessRater\HotnessRater\BabeTrader\Controllers\HomeController.cs:87
lambda_method(Closure , ControllerBase , Object[] ) +87
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +35
System.Web.Mvc.Async.<>c.<BeginInvokeSynchronousActionMethod>b__9_0(IAsyncResult asyncResult, ActionInvocation innerInvokeState) +39
System.Web.Mvc.Async.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult) +77
System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) +42
System.Web.Mvc.Async.<>c__DisplayClass11_0.<InvokeActionMethodFilterAsynchronouslyRecursive>b__0() +80
System.Web.Mvc.Async.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2() +396
System.Web.Mvc.Async.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2() +396
System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) +42
System.Web.Mvc.Async.<>c__DisplayClass3_6.<BeginInvokeAction>b__4() +50
System.Web.Mvc.Async.<>c__DisplayClass3_1.<BeginInvokeAction>b__1(IAsyncResult asyncResult) +188
System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +38
System.Web.Mvc.<>c.<BeginExecuteCore>b__152_1(IAsyncResult asyncResult, ExecuteCoreState innerState) +29
System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +73
System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +52
System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +39
System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +38
System.Web.Mvc.<>c.<BeginProcessRequest>b__20_1(IAsyncResult asyncResult, ProcessRequestState innerState) +43
System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +73
System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +38
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +651
System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +220
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +134 |