Errore server nell'applicazione '/'.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',  Latitudine ,  Longitudine ,  Zoom ,  Stemma_IMGFILE ,  TitoloPagina ,  TagDes' at line 1

Descrizione: Eccezione non gestita durante l'esecuzione della richiesta Web corrente. Per ulteriori informazioni sull'errore e sul suo punto di origine nel codice, vedere la traccia dello stack.

Dettagli eccezione: MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',  Latitudine ,  Longitudine ,  Zoom ,  Stemma_IMGFILE ,  TitoloPagina ,  TagDes' at line 1

Errore nel codice sorgente:


Riga 1787:			if (m_UDBClient.ValidateConnection())
Riga 1788:			{
Riga 1789:				DataTable dt = m_UDBClient.GetDataTable(query);
Riga 1790:				if (dt.Rows.Count > 0)
Riga 1791:				{

File di origine: c:\Web\R\rivieraligure_it\App_Code\CCitta.cs    Riga: 1789

Traccia dello stack:


[MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',  Latitudine ,  Longitudine ,  Zoom ,  Stemma_IMGFILE ,  TitoloPagina ,  TagDes' at line 1]
   MySql.Data.MySqlClient.<ReadPacketAsync>d__30.MoveNext() +553
   System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) +102
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +64
   MySql.Data.MySqlClient.<GetResultAsync>d__45.MoveNext() +403
   System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) +102
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +64
   MySql.Data.MySqlClient.<GetResultAsync>d__85.MoveNext() +232
   System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) +102
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +64
   MySql.Data.MySqlClient.<NextResultAsync>d__84.MoveNext() +293
   System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) +102
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +64
   MySql.Data.MySqlClient.<NextResultAsync>d__97.MoveNext() +1087
   System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +27
   MySql.Data.MySqlClient.<NextResultAsync>d__97.MoveNext() +3577
   System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) +102
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +64
   System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task) +26
   MySql.Data.MySqlClient.<ExecuteReaderAsync>d__107.MoveNext() +2228
   System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +27
   MySql.Data.MySqlClient.<ExecuteReaderAsync>d__107.MoveNext() +4813
   System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +27
   MySql.Data.MySqlClient.<ExecuteReaderAsync>d__107.MoveNext() +5183
   System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) +102
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +64
   MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +57
   MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +4
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +12
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +140
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +138
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +89
   Softimax.Data.UDB.UDBClientFast.GetDataSet(String sSQL, CommandType oType, DataSet oData) +65
   Softimax.Data.UDB.UDBClient.GetDataSet(String sSQL, CommandType oType, DataSet oData) +70
   Softimax.Data.UDB.UDBClientFast.GetDataTable(String sSQL, CommandType oType, DataTable oData) +45
   Softimax.Data.UDB.UDBClient.GetDataTable(String sSQL, CommandType oType, DataTable oData) +70
   Softimax.Data.UDB.UDBClientFast.GetDataTable(String sSQL) +44
   CCittaBase.Load(Int32 IDCitta, String listOfChildToEnable) in c:\Web\R\rivieraligure_it\App_Code\CCitta.cs:1789
   CCittaBase.Load(Int32 IDCitta) in c:\Web\R\rivieraligure_it\App_Code\CCitta.cs:1767
   IT_citta.Page_Load(Object sender, EventArgs e) in c:\Web\R\rivieraligure_it\IT\citta.aspx.cs:62
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +52
   System.Web.UI.Control.OnLoad(EventArgs e) +97
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693


Informazioni di versione: Versione di Microsoft .NET Framework:4.0.30319; Versione di ASP.NET:4.8.4682.0