search

fuel9 / DisplayMonkey

Display Monkey digital signage solution
Other
126 stars 50 forks source link

Message | Invalid column name 'Type'. #81

Closed cwhitsbm closed 5 years ago

cwhitsbm commented 5 years ago

Hello,

In addition to the last error I sent, I am also receiving this error when trying to upload media.

Source Media/Upload
Message Invalid column name 'Type'.
Stack trace at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectQuery1.<>cDisplayClass7.b5() at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func1 operation) at System.Data.Entity.Core.Objects.ObjectQuery1.GetResults(Nullable1 forMergeOption) at System.Data.Entity.Core.Objects.ObjectQuery1.<System.Collections.Generic.IEnumerable.GetEnumerator>b__0() at System.Data.Entity.Internal.LazyEnumerator1.MoveNext() at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable1 source) at DisplayMonkey.Models.Setting.GetSetting(DisplayMonkeyEntities _db, Keys _id) in e:\project\DisplayMonkey\Management\Models\SettingKeys.cs:line 200 at DisplayMonkey.Controllers.MediaController.Upload() in e:\project\DisplayMo
cwhitsbm commented 5 years ago

I get this error on a lot of functions I am trying.

psined1 commented 5 years ago

Sounds like your database may be out of sync from what the application expects. It seems like you may have installed DM previously and upgraded it once or twice and, maybe, didn't follow all the upgrade SQL scripts? Can you shed a bit more light on your case please?

cwhitsbm commented 5 years ago

Yes. This is a brand new installation. I had just created the users and the database and ran the install.sql script. From there it directs you to the management page.

This was from a download I performed from the website last week.

We are running IIS and SQL Express 2014 on the same machine under Windows 10.

Thank you,

cwhitsbm commented 5 years ago

Solved... One of my emps did attempt the install before I took over. Apparently however he did not download the latest and greatest and did not save his download file. So when I took over and had to re-download the sql scripts, I downloaded the most current and that must be where the mismatch came in. Thank you for your help.

psined1 commented 5 years ago

Makes sense! Glad you'd worked it all out!