Wappler Version: 5.0.2
Operating System: Windows 11 to develop (local) and Windows Server 2019 Standard (remote)
Server model: .NET
Database: MySQL/MariaDB
Expected behaviour
What do you think should happen?
A record should be added to the database using a simple form and no error generated as per:
https://docs.wappler.io/t/insert-database-record/2863
Actual behaviour
What actually happens?
A record is inserted into the database but a 500 error is generated immediately after
How to reproduce
Try it out on the test page here:
https://carpetshopnortheast.com/formtest.aspx
Notes:
Wappler is reporting that both database connections are working fine (one in Globals->Database Connections and the other in Database Manager-> direct connection)
In the error console, I can see the following error was created as the Inner Exception: ‘Arithmetic operation resulted in an overflow’
I’ve spent days on this, including re-installing Wappler and restarting a new project, I’ve even tested on a different domain with a fresh database - all to no avail.
The database table has the following column datatypes:
testid - INT
name VARCHAR 50
email VARCHAR 50
created DATETIME
- I’ve tried the form without that ‘DATETIME’ field included and I still get the same problem.
My API steps look like this:
My APP structure looks like this:
This should be an absolute doddle of a job but it’s clearly not working correctly. Can anyone out there let me know if it’s a bug or not…?
Last updated: