Databases
StackOverflow2013
Postsdbo
PO500 error; not specific enough
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO500 error; not specific enough
    primarykey
    data
    text
    <p>I'm using Microsoft Visual Web Express 2012 for Web and had been testing through Firefox the entire time.</p> <p>When I finally got it working, I then proceeded to try Chrome and IE, but on both browsers it reports back 500 internal server error in a little window. The html loads fine. I believe this is due to the fact that my website loads the database info in a tab widget. Rechecked Firefox; seems fine. Rechecked Chrome and IE; same error.</p> <p>It's probably obvious by now, but I've commented out the ajax code and IE and Chrome doesn't report the 500 issue.</p> <p>I wouldn't know how to find more details on this generic error. I've tried </p> <pre><code> &lt;system.webServer&gt; &lt;httpErrors errorMode="Detailed" /&gt; &lt;asp scriptErrorSentToBrowser="true"/&gt; &lt;/system.webServer&gt; &lt;system.web&gt; &lt;compilation debug="true" targetFramework="4.5" /&gt; &lt;httpRuntime targetFramework="4.5" /&gt; &lt;/system.web&gt; </code></pre> <p>in my web.config, but that window doesn't show much else than the 500. I've also tried unchecking "Show Friendly HTTP error messages" and "Disable script debugging (IE) and (Other)". I'm not sure what's supposed to happen, but the 500 message doesn't change.</p> <p>I do notice that Firefox does show a bizarre delay on loading from the database, but all the data in there is fine after loading.</p> <p>This is the code in question.</p> <pre><code>using System; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; using System.Data.SqlClient; using System.Text; using System.Web.Script.Services; /// &lt;summary&gt; /// Summary description for serverAttempt2 /// &lt;/summary&gt; [WebService(Namespace = "http://idontcare.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. [ScriptService] public class serverAttempt2 : WebService { [WebMethod] public string GetCustomer(string CustomerID) { string response = "&lt;p&gt;No customer selected&lt;/p&gt;"; string connect = @"Data Source=localhost\SQLEXPRESS;Initial Catalog=personnet;Integrated Security=Yes;"; string query = "SELECT TOP 200 * FROM personnet.dbo.accordionTest"; if (CustomerID != null &amp;&amp; CustomerID.Length == 8) { StringBuilder sb = new StringBuilder(); using (SqlConnection conn = new SqlConnection(connect)) { using (SqlCommand cmd = new SqlCommand(query, conn)) { cmd.Parameters.AddWithValue("CustomerID", CustomerID); conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { sb.Append("Hi."); response = sb.ToString(); /* sb.Append("&lt;table style='width:100%;'&gt;&lt;tr&gt;&lt;td style='width:180px;'&gt;"); sb.Append(rdr["pro"].ToString() + "&lt;/td&gt;&lt;td style='width:20%;'&gt;"); sb.Append(rdr["sn"].ToString() + "&lt;/td&gt;&lt;td style='width:10%;'&gt;"); sb.Append(rdr["po"].ToString() + "&lt;/td&gt;&lt;td style='width:20%;' align='center'&gt;"); sb.Append(rdr["qty"].ToString() + "&lt;/td&gt;&lt;td style='width:10%;' align='center'&gt;"); sb.Append(rdr["status"].ToString() + "&lt;/td&gt;&lt;td style='width:20%;' align='center'&gt;"); sb.Append("&lt;input type='image' src='images/temporaryStar.png' /&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;&lt;div&gt;&lt;p&gt;&lt;/p&gt;&lt;/div&gt;"); response = sb.ToString();*/ } } } } } return response; } } </code></pre> <p>I've heard of IE's rude compatibility surprises, but I don't think it's the case here.</p> <p>EDIT: Well, I've found something, but I'm not sure what to make of it.</p> <pre><code>'iexplore.exe' (Script): Loaded 'Script Code (Windows Internet Explorer)'. Exception was thrown at line 4, column 13743 in http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js 0x800a139e - JavaScript runtime error: SyntaxError Exception was thrown at line 4, column 13957 in http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js 0x800a139e - JavaScript runtime error: SyntaxError Exception was thrown at line 4, column 10598 in http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js 0x800a139e - JavaScript runtime error: SyntaxError Exception was thrown at line 4, column 10598 in http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js 0x800a139e - JavaScript runtime error: SyntaxError Exception was thrown at line 4, column 10598 in http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js 0x800a139e - JavaScript runtime error: SyntaxError Exception was thrown at line 4, column 10598 in http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js 0x800a139e - JavaScript runtime error: SyntaxError Exception was thrown at line 4, column 10598 in http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js 0x800a139e - JavaScript runtime error: SyntaxError Exception was thrown at line 4, column 10598 in http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js 0x800a139e - JavaScript runtime error: SyntaxError Exception was thrown at line 4, column 10598 in http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js 0x800a139e - JavaScript runtime error: SyntaxError Exception was thrown at line 4, column 10598 in http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js 0x800a139e - JavaScript runtime error: SyntaxError Exception was thrown at line 4, column 10598 in http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js 0x800a139e - JavaScript runtime error: SyntaxError Exception was thrown at line 4, column 10598 in http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js 0x800a139e - JavaScript runtime error: SyntaxError Exception was thrown at line 4, column 4377 in http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js 0x800a03f6 - JavaScript runtime error: Invalid character </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USEmwat
    1. USEmwat
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COTry running Fiddler whilst using IE to see exactly where it's failing.
      singulars
      1. PO500 error; not specific enough
      1. USmattytommo
    2. COA 500 internal server error often means that there's an exception being thrown in the server-side code. I can't help but notice you're not catching or logging exceptions in your code. Maybe there's an informative error that you're ignoring?
      singulars
      1. PO500 error; not specific enough
      1. USDavid
    3. COHave you tried to attach to the ASP.NET process? You can attach the debugger to w3wp.exe (Debug > Attach to Process...), and turn on catching of thrown exceptions.
      singulars
      1. PO500 error; not specific enough
      1. USChris Mantle
 

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