Asp.net 500 internal server serror

[johnny.hajjar]

500 internal server error when using asp.net (iis) and using the query builder operator CONTAINS to filter the data set… has anyone else got this issue? Database is mysql

[mimuk]

Does it work if you enter %john%
So the query reads

NOT LIKE '%john%'

[johnny.hajjar]

no it doesn’t, i tried that , doesn’t work, hopping for a solution.

[johnny.hajjar]

no it doesn’t, i tried that , doesn’t work, hopping for a solution.

[George]

Hi Johnny,

Could you enable the debug so the real error is shown, see:

Debugging Problems

You can easily debug issues related to server-side processing such as - form not sending email, record not inserting or updating, query not showing data etc. The first thing you need to do is to open the server connect settings: [image] And enable the Debug Mode: [image] Click Save: [image] In your browser, open the Developer tools. If you don’t know how to open them please refer to your browser’s documentation. Then open the Network tab(1) and select XHR(2): [image] Now with the develo…

[johnny.hajjar]

Hi George, thanks for your quick response,

i have pasted the error below: its a mysql on amazon db, for a lending platform.

“Message”: “[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.10]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 ‘LIKECONCAT(’%’, ?, ‘%’) ESCAPE ‘!’’ at line 1”,
“SQLState”: “42000”,
“NativeError”: 1064,
“Source”: “myodbc5a.dll”
}
],
“ClassName”: “System.Data.Odbc.OdbcException”,
“Message”: “ERROR [42000] [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.10]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 ‘LIKECONCAT(’%’, ?, ‘%’) ESCAPE ‘!’’ at line 1”,
“Data”: null,
“InnerException”: null,
“HelpURL”: null,
“StackTraceString”: " at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)\r\n at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)\r\n at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)\r\n at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)\r\n at DMXzone.ServerConnect.Database.Connector.Execute(SqlBuilder sql) in d:\Develop\DMXzone Server Connect\ASPNET_Source\DMXzone Database Connector\Database\Connector.cs:line 162\r\n at DMXzone.ServerConnect.Module.DbConnectorModule.Select(JObject options) in d:\Develop\DMXzone Server Connect\ASPNET_Source\DMXzone Database Connector\Module\DbConnectorModule.cs:line 69",
“RemoteStackTraceString”: null,
“RemoteStackIndex”: 0,
“ExceptionMethod”: “8\nHandleError\nSystem.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\nSystem.Data.Odbc.OdbcConnection\nVoid HandleError(System.Data.Odbc.OdbcHandle, RetCode)”,
“HResult”: -2146232009,
“Source”: “myodbc5a.dll”,

[johnny.hajjar]

i Hope its something iv done wrong on my end any ideas?

[George]

Thanks, Deens we have Some escaping issues with the mysql combination.

@patrick will check it out

[patrick]

I identified the problem, it is a bug in the extension. I’m currently working on a fix, I expect it to be ready before the next Wappler update.

[johnny.hajjar]

Hi patrick, is their a date set for this expected release? also, is their any new features or bug list you can share?

[patrick]

The Wappler update is coming today or tomorrow. I finished the fix and it will be included with the update.

[Teodor]

Fixed in version 1.5.0