Server Error in '/' Application.

ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.5-10.5.23-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS sp WHERE sp.id > 0 AND sp.attivo = 1 AND sp.int_01 = 24 ORDER BY sp.zindex...' at line 1

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: System.Data.Odbc.OdbcException: ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.5-10.5.23-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS sp WHERE sp.id > 0 AND sp.attivo = 1 AND sp.int_01 = 24 ORDER BY sp.zindex...' at line 1

Source Error:


Line 655:        OdbcCommand myCommand = new OdbcCommand(SQL, myConnection);
Line 656:        OdbcDataReader Reader;
Line 657:        Reader = myCommand.ExecuteReader();
Line 658:
Line 659:        List<CategorieFullStandard> results = new List<CategorieFullStandard>();

Source File: d:\inetpub\vhosts\klftecnokimica.it.new\App_Code\std_CategorieFullStandard.cs    Line: 657

Stack Trace:


[OdbcException (0x80131937): ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.5-10.5.23-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS sp WHERE sp.id > 0 AND sp.attivo = 1 AND sp.int_01 = 24 ORDER BY sp.zindex...' at line 1]
   System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +1110242
   System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) +1059
   System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) +68
   System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) +79
   System.Data.Odbc.OdbcCommand.ExecuteReader() +12
   CategorieFullStandard.ExecuteSQL(OdbcConnection myConn, String SQL, String connessione) in d:\inetpub\vhosts\klftecnokimica.it.new\App_Code\std_CategorieFullStandard.cs:657
   CategorieFullStandard.GetCategorieFullStandard(OdbcConnection myConn, String id, String titolo, String attivo, String order, String tabella, String connessione, String top, String idcateg, String pathimg, String codice, String Int_01, String Testo50_01, String TestoFull_01, String tipo, String idcateg2, String idcateg3, String dataDoppiaDal, String dataDoppiaAl, String dataSingolaDal, String dataSingolaAl, String wherePers, String idcategMacro1, String idcategMacro2, String idcategMacro3, String campiAggiuntivi, String categoria) in d:\inetpub\vhosts\klftecnokimica.it.new\App_Code\std_CategorieFullStandard.cs:640
   CategorieFullStandardAll.GetCategorieFullStandard(OdbcConnection myConn, String id, String titolo, String attivo, String order, String tabella, String connessione, String top, String idcateg, String pathimg, String codice, String Int_01, String Testo50_01, String TestoFull_01, String tipo, String idcateg2, String idcateg3, String dataDoppiaDal, String dataDoppiaAl, String dataSingolaDal, String dataSingolaAl, String wherePersonalizzato, String idcategMacro1, String idcategMacro2, String idcategMacro3, String campiAggiuntivi, String categoria) in d:\inetpub\vhosts\klftecnokimica.it.new\App_Code\std_CategorieFullStandard.cs:801
   CategorieFullStandardAll.GetCategorieFullStandard(OdbcConnection myConn, String id, String titolo, String attivo, String order, String tabella, String connessione, String top, String idcateg, String pathimg, String codice, String Int_01, String Testo50_01, String TestoFull_01, String tipo, String idcateg2, String idcateg3, String dataDoppiaDal, String dataDoppiaAl, String dataSingolaDal, String dataSingolaAl, String wherePersonalizzato, String campiAggiuntivi, String categoria) in d:\inetpub\vhosts\klftecnokimica.it.new\App_Code\std_CategorieFullStandard.cs:789
   CategorieFullCollettoreAll.GetCategorie(OdbcConnection myConn, String categoria, String id, String titolo, String attivo, String order, String top, String idcateg, String idcateg2, String idcateg3, String dataDoppiaDal, String dataDoppiaAl, String dataSingolaAl, String dataSingolaDal, String pathimg, String codice, String Int_01, String Testo50_01, String TestoFull_01, String wherePersonalizzato, Boolean saltaPersonalizzato) in d:\inetpub\vhosts\klftecnokimica.it.new\App_Code\std_util_CategorieFullCollettore.cs:760
   CategorieFullCollettoreAll.GetCategorie(OdbcConnection myConn, String categoria, String id, String titolo, String attivo, String order, String top, String idcateg, String idcateg2, String idcateg3, String dataDoppiaDal, String dataDoppiaAl, String dataSingolaAl, String dataSingolaDal, String pathimg, String codice, String Int_01, String Testo50_01, String TestoFull_01, String wherePersonalizzato) in d:\inetpub\vhosts\klftecnokimica.it.new\App_Code\std_util_CategorieFullCollettore.cs:720
   SeoAdvancedUtil.GetMETATagHead(String pagina, String linguaCodice, CategorieFullStandard cf) in d:\inetpub\vhosts\klftecnokimica.it.new\App_Code\_Klf\seo_SeoAdvancedUtil.cs:182
   WebGestione.GetTestoTemplatePers(CategorieFullStandard ll, String tipoRis, String template) in d:\inetpub\vhosts\klftecnokimica.it.new\App_Code\_Klf\web_WebGestione.cs:27
   WebGestionePagineShapen.GetPageSTD(List`1 ll, String tipoPage, PageStdParam valPredef) in d:\inetpub\vhosts\klftecnokimica.it.new\App_Code\_02_Shapen\web_WebGestionePagineShapen.cs:499
   WebGestionePagineShapen.GetPageSTD(String id, String tipoPage, PageStdParam valPredef) in d:\inetpub\vhosts\klftecnokimica.it.new\App_Code\_02_Shapen\web_WebGestionePagineShapen.cs:459
   WebGestioneTemplate.GetPageSTD(String id, String tipoPage, PageStdParam valPredef) in d:\inetpub\vhosts\klftecnokimica.it.new\App_Code\_00_Standard\web_WebGestioneTemplate.cs:151
   WebGestionePagine.GetPageSTD(String id, String tipoPage, PageStdParam valPred) in d:\inetpub\vhosts\klftecnokimica.it.new\App_Code\_Klf\web_WebGestionePagine.cs:259
   WebGestionePagine.GetPageEventi(String id) in d:\inetpub\vhosts\klftecnokimica.it.new\App_Code\_Klf\web_WebGestionePagine.cs:166
   _Default.Page_Load(Object sender, EventArgs e) in d:\inetpub\vhosts\klftecnokimica.it.new\web\Sezione01Dett.aspx.cs:21
   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


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4331.0