| Bug #27989 | Error: Could not find specified column in results | ||
|---|---|---|---|
| Submitted: | 20 Apr 2007 18:58 | Modified: | 12 Jun 2007 14:08 |
| Reporter: | Cozta Norhalim | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | Connector / NET | Severity: | S1 (Critical) |
| Version: | 5.0.6.0 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[2 May 2007 12:49]
Tonci Grgin
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug. Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/ Thank you for your interest in MySQL. Explanation: Hi Cozta and thanks for your report. I have several problems with it. First of all, you need to submit small but complete test case exhibiting this error every time it is run. I can't go through your sources and fish out things. Next, "To view the error online, go to http://covalentia.dyndns.org:8080/Covalentia.2.2.3.MySQL and logon as: Login Id: cozta Password: 123456", site times out on me every time I try. Third thing is that stack traces are usually of almost no use without repeatable test case. If you can provide me with small, stand-alone test case, including DDL statements, which exhibits this error please attach it to report and re-open. I'll be monitoring.
[2 May 2007 16:32]
Cozta Norhalim
The exact same codes work fine with Connector/Net 1.0.9, and so that's why I thought that it's a bug. I'll see what I can do to provide you with smaller setup. At the moment, our server is down for maintenance. Will get back to you soon. Thanks.
[3 May 2007 6:16]
Tonci Grgin
Cozta, no problem. I'll be monitoring this report.
[16 May 2007 8:46]
Tonci Grgin
Changing status to more appropriate one.
[11 Jun 2007 9:01]
Tonci Grgin
Cozta, what is your character_set_results variable set to?
[12 Jun 2007 13:40]
Cozta Norhalim
Sorry for the late reply. The character_set_results is set to latin1.
[12 Jun 2007 14:08]
Tonci Grgin
Cozta, this is in fact duplicate of Bug#25385 and many others. See if you can find answer in BugsDB.
Description: This error is intermittent. After a few reloads, it works. The exception is as follows: <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.</Description> <ExceptionDetails>Could not find specified column in results</ExceptionDetails> <Source>MySql.Data</Source> <StackTrace> at MySql.Data.MySqlClient.MySqlDataReader.GetOrdinal(String name) at MySql.Data.MySqlClient.MySqlDataReader.get_Item(String name) at Covalentia.DataAccess.Objects.GetObjects(String connectionString, Int32 databaseTypeId, Type type, String queryExpression) in D:\Visual Studio Projects\Covalentia.2.2.3\Covalentia\DataAccess\Objects.cs:line 344 at Covalentia.DataAccess.Objects.GetObjects(Type type, String queryExpression) in D:\Visual Studio Projects\Covalentia.2.2.3\Covalentia\DataAccess\Objects.cs:line 304 at Covalentia.Crud.ReadCollection(Type type, String queryExpression) in D:\Visual Studio Projects\Covalentia.2.2.3\Covalentia\Crud.cs:line 294 at Covalentia.Globals.PopulateDropDownList(DropDownList ddl, String tableName, String idName, String selection1, String selection2, String queryExpression, String[] initialSelection, String initialValue) in D:\Visual Studio Projects\Covalentia.2.2.3\Covalentia\Globals.cs:line 396 at Covalentia.Controls.Profile.InitializeSkin(Control skin) in D:\Visual Studio Projects\Covalentia.2.2.3\Covalentia\Controls\Globals\Profile.cs:line 97 at Covalentia.Controls.SkinControl.CreateChildControls() in D:\Visual Studio Projects\Covalentia.2.2.3\Covalentia\Controls\Base\SkinControl.cs:line 164 at System.Web.UI.Control.EnsureChildControls() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) How to repeat: You can download the source codes at www.covalentia.net. Go to Member's Area and logon as follows: Login Id: mysql Password: 123456 Then, download Covalentia Version 2.2.3.1894 (Beta) To view the error online, go to http://covalentia.dyndns.org:8080/Covalentia.2.2.3.MySQL and logon as: Login Id: cozta Password: 123456 Go to Administration Module -> User (You may get an error here). Try again, hit the Search button. Click on Edit under the Action column (You may get an error here). Go to Administration Module -> User again, and now click on View Details instead (It might work fine here). Or click on any of the Tabs.