Database Insert Throwing Exception

Hi all…!

I’ve been banging my head again with this one, I’m trying to add some user details to our MySQL db - We are using .NET to do this.

It’s all working as it should, and the records are successfully added to the db table, however, once added to the db the page is throwing an exception. It looks like a Wappler (V5) core exception and I’m having problems deciphering it - can anyone out there point me in the right direction?

Here’s the crux of the problem:

StackTraceString	"   at System.Data.Odbc.OdbcDataReader.GetSqlType(Int32 i)\r\n   at System.Data.Odbc.OdbcDataReader.GetValue(Int32 i)\r\n   at System.Data.Odbc.OdbcCommand.ExecuteScalar()\r\n   at DMXzone.ServerConnect.Database.MySql.GetIdentity(IDbConnection connection) in C:\\Development\\Server Connect\\ASPNET_Source\\DMXzone Database Connector\\Database\\MySql.cs:line 96\r\n   at DMXzone.ServerConnect.Database.Connector.Execute(SqlBuilder sql) in C:\\Development\\Server Connect\\ASPNET_Source\\DMXzone Database Connector\\Database\\Connector.cs:line 203"
RemoteStackTraceString	null
RemoteStackIndex	0
ExceptionMethod	"8\nGetSqlType\nSystem.Data, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089\nSystem.Data.Odbc.OdbcDataReader\nSystem.Data.Odbc.TypeMap GetSqlType(Int32)"
HResult	-2146233066
Source	"System.Data"

The page in question is here, feel free to try it out:

Any assistance is greatly appreciated…

Community Page
Last updated: