Ticket #669 (closed Defekt: fixed)

Opened 10 years ago

Last modified 10 years ago

Går inte att ändra uppgifter i Pirateweb

Reported by: TOQig Owned by: Todi
Priority: blocker Milestone:
Component: PirateWeb Keywords: passwordHash
Cc:

Description

När jag försöker ändra medlemsuppgifter i Pirateweb (denna gång mobilnumret). "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. System.ArgumentException: Parameter 'passwordHash' not found in the collection."

Det är extremt viktigt att vi har aktuella uppgifter, så vi kan sammanföra aktivister.

Change History

comment:1 Changed 10 years ago by dansve

  • Priority changed from critical to blocker

Jag har testat lite genom att ändra andra uppgifter.
Fick bara det beskrivna felet när jag ändrade telefonnumret.

Testade scenarion

  1. Ändra en siffra
  2. Lägga till en siffra
  3. Tömma fältet

comment:2 Changed 10 years ago by alexander.toresson@…

Det här felet kan kanske vara relaterat till #661?

comment:3 Changed 10 years ago by SimonB.

  • Keywords passwordHash added

comment:4 Changed 10 years ago by moppa89@…

Får databas-fel när jag försöker uppdatera pirateweb med uppgifter om att jag har flyttat. Verkar vara något fel i er update-sats.
Uppgifterna uppdaterades dock.

Unknown column 'City' 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 'City' in 'where clause'

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

  1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

<%@ Page Language="C#" Debug="true" %>

or:

2) Add the following section to the configuration file of your application:

<configuration>

<system.web>

<compilation debug="true"/>

</system.web>

</configuration>

Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace:

[MySqlException (0x80004005): Unknown column 'City' in 'where clause']

MySql.Data.MySqlClient.MySqlStream.OpenPacket() +255
MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) +55
MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() +48
MySql.Data.MySqlClient.MySqlDataReader.NextResult() +715
MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +898
MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +4
System.Data.Common.DbCommand.ExecuteReader() +9
PirateWeb.Database.PirateDb.GetCityByName(String cityName, Int32 countryId) +137
PirateWeb.Logic.Pirates.Person.ResolveGeography() +91
PirateWeb.Logic.Pirates.AuditedPerson.set_PostalCode(String value) +77
Controls_PersonBasicDetails.ButtonSaveChanges_Click(Object sender, EventArgs e) +818
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746

comment:5 Changed 10 years ago by drhex

För mig är det ännu värre, den ballar ur redan när man trycker på "view/edit". Detaljer:
Har sökt på snart utgående utgående medlemsskap och fåt upp några stycken. En ville fortsatt vara med, så jag skulle gå in och ordna det (medlem #53954). När jag trycker på view/edit säger den:

[FormatException: Input string was not in a correct format.]

System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) +2782219
System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +112
System.String.System.IConvertible.ToInt32(IFormatProvider provider) +43
System.Convert.ToInt32(Object value) +25
Controls_PersonList.Grid_RowCommand(Object sender, GridViewCommandEventArgs e) +65
System.Web.UI.WebControls.GridView.OnRowCommand(GridViewCommandEventArgs e) +105
System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +76
System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs e) +95
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e) +117
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +132
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +177
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746

comment:6 Changed 10 years ago by JorgenL

  • Status changed from new to closed
  • Resolution set to fixed

Problemen lösta. (I några omgångar, :-) det var flera olika fel...)

Nu ska det i vart fall funka.

Note: See TracTickets for help on using tickets.