Databases
StackOverflow2013
Postsdbo
POA column ID occurred more than once in the specification
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POA column ID occurred more than once in the specification
    primarykey
    data
    text
    <p>Recently i've picked up my EF 4.1 / MVC 3 project again and started building in actual frontend capabilities.</p> <p>Now i'm developing a "simple" message system but upon going to that page i get the error as stated in the title </p> <p><strong>EDIT</strong></p> <p>It creates the database just not the models.</p> <p>Stack trace:</p> <blockquote> <p>[NullReferenceException: Object reference not set to an instance of an object.] ASP._Page_Views_Inbox_Index_cshtml.Execute() in c:\Development\MVC\DOCCL\Views\Inbox\Index.cshtml:18<br> System.Web.WebPages.WebPageBase.ExecutePageHierarchy() +197<br> System.Web.Mvc.WebViewPage.ExecutePageHierarchy() +81<br> System.Web.WebPages.StartPage.RunPage() +17<br> System.Web.WebPages.StartPage.ExecutePageHierarchy() +62<br> System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +76<br> System.Web.Mvc.RazorView.RenderView(ViewContext viewContext, TextWriter writer, Object instance) +222<br> System.Web.Mvc.BuildManagerCompiledView.Render(ViewContext viewContext, TextWriter writer) +115<br> System.Web.Mvc.ViewResultBase.ExecuteResult(ControllerContext context) +295 System.Web.Mvc.ControllerActionInvoker.InvokeActionResult(ControllerContext controllerContext, ActionResult actionResult) +13<br> System.Web.Mvc.&lt;>c_<em>DisplayClass1c.b</em>_19() +23 System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilter(IResultFilter filter, ResultExecutingContext preContext, Func<code>1 continuation) +242<br> System.Web.Mvc.&lt;&gt;c__DisplayClass1e.&lt;InvokeActionResultWithFilters&gt;b__1b() +21 System.Web.Mvc.ControllerActionInvoker.InvokeActionResultWithFilters(ControllerContext controllerContext, IList</code>1 filters, ActionResult actionResult) +177<br> System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) +324<br> System.Web.Mvc.Controller.ExecuteCore() +106<br> System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) +91 System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext) +10<br> System.Web.Mvc.&lt;>c_<em>DisplayClassb.b</em>_5() +34<br> System.Web.Mvc.Async.&lt;>c_<em>DisplayClass1.b</em>_0() +19<br> System.Web.Mvc.Async.&lt;>c_<em>DisplayClass8<code>1.&lt;BeginSynchronous&gt;b__7(IAsyncResult _) +10 System.Web.Mvc.Async.WrappedAsyncResult</code>1.End() +62 System.Web.Mvc.&lt;>c</em>_DisplayClasse.b_<em>d() +48<br> System.Web.Mvc.SecurityUtil.b</em>_0(Action f) +7 System.Web.Mvc.SecurityUtil.ProcessInApplicationTrust(Action action) +22 System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +60<br> System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +9<br> System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +9478661 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously) +178</p> </blockquote> <p>InnerException : {"A column ID occurred more than once in the specification."}</p> <p>The recently added code is.</p> <p>Controller:</p> <pre><code>// // GET: /Inbox/Index/5/1 public ActionResult Index(int? Id, int Page = 1) { try { const int pageSize = 10; var messages = from m in horseTracker.Messages where m.ReceiverId.Equals(Id) select m; var paginatedMessages = new PaginatedList&lt;Message&gt;(messages, Page, pageSize); return View(paginatedMessages); } catch (Exception ex) { } return View(); } </code></pre> <p>Models</p> <pre><code>public class Message { [Key] public int Id { get; set; } [Required(ErrorMessage = "Subject is required")] [Display(Name = "Subject")] public string Subject { get; set; } [Required(ErrorMessage = "Message is required")] [Display(Name = "Message")] public string Content { get; set; } [Required] [Display(Name = "Date")] public DateTime Created { get; set; } public Boolean Read { get; set; } [Required(ErrorMessage = "Can't create a message without a user")] public int SenderId { get; set; } public virtual User Sender { get; set; } [Required(ErrorMessage = "Please pick a recipient")] public int ReceiverId { get; set; } public virtual User Receiver { get; set; } } public class User { [Key] public int Id { get; set; } [Required] [Display(Name = "Username")] public string UserName { get; set; } [Required] [Display(Name = "First Name")] public string FirstName { get; set; } [Required] [Display(Name = "Last Name")] public string LastName { get; set; } [Required] [Display(Name = "E-Mail")] public string Email { get; set; } [Required] [Display(Name = "Password")] public string Password { get; set; } [Required] [Display(Name = "Country")] public string Country { get; set; } public string EMail { get; set; } //Races public virtual ICollection&lt;Message&gt; Messages { get; set; } } modelBuilder.Entity&lt;User&gt;() .HasMany(u =&gt; u.Messages) .WithRequired(m =&gt; m.Receiver) .HasForeignKey(m =&gt; m.ReceiverId) .WillCascadeOnDelete(false); </code></pre> <p>Anyone have a clue on why i might be getting that error? Before i added these classes it was working fine.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPuzzle84
    1. USPuzzle84
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POA column ID occurred more than once in the specification
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POA column ID occurred more than once in the specification
      1. This table or related slice is empty.
      1. VTUpMod
    1. COShowing possible inner exceptions and the stack trace could help.
      singulars
      1. POA column ID occurred more than once in the specification
      1. USSlauma
    2. CODoes this help: http://stackoverflow.com/questions/5750742/a-column-id-occurred-more-than-once-in-the-specification
      singulars
      1. POA column ID occurred more than once in the specification
      1. USDavin Tryon
    3. COi posted the inner exception Slauma. As for that topic no it does not. i use the same technique in various other spots for example i have a horse class which has a dam and a sire both of type horse and they don't complain about the Id's at all. it just seems very strange to me.
      singulars
      1. POA column ID occurred more than once in the specification
      1. USPuzzle84
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload