I want to increase the allowed size for data sent to my Mysql server.
I have a line in the config.properties file :
In the application I use this code:
But I get this in the server log:
I don't understand the "20" !
I tried many other values but they all fail. I know it has to be a multiple of 1024.
Any number smaller then 1024, like 1023, produces this error:
Any advice ?
Edit: I think that although there is an error, the requested operation is done.
I have a line in the config.properties file :
B4X:
sql.setsize=SET GLOBAL max_allowed_packet=?
B4X:
cmd.Initialize
cmd.Name = "setsize"
cmd.Parameters = Array As Object(2097152)
reqManager.ExecuteCommand(cmd,"setsize")I don't understand the "20" !
I tried many other values but they all fail. I know it has to be a multiple of 1024.
Any number smaller then 1024, like 1023, produces this error:
Any advice ?
Edit: I think that although there is an error, the requested operation is done.
Last edited: