-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi Emerio,
We encountered some similar issues after our MariaDB server was upgraded.
Either a setting was changed or a newer version of MariaDB is more strict
about table definitions.
You need to modify blockRequest.processing so that it has a default value of
0. i.e.
ALTER TABLE blockRequest CHANGE processing processing TINYINT(1) UNSIGNED NOT
NULL DEFAULT '0';
Josh
On Tuesday, August 27, 2019 7:13:00 PM EDT Martinez, Emerio wrote:
> Hello VCL User Community,
>
> I am getting the following SQL error in the PHP log from my VCL 2.5
> application when I try to request a block allocation. Please advise.
>
> Call#:1 => index.php:AJblockAllocationSubmit() (line#:98)
> Arguments(none):
> -----------------------
> Call#:2 => blockallocations.php:doQuery() (line#:630)
> Arguments(2)
>
> Argument#: 1 => INSERT INTO blockRequest (name, imageid, numMachines,
> groupid, repeating, ownerid, managementnodeid, expireTime, status) VALUES
> ('Emerio testing block allocation', 11, 2, 109, 'weekly', 24, 1,
> '2019-09-30 23:59:59', 'accepted') Argument#: 2 => 101
> -----------------------
>
> [27-Aug-2019 13:24:21 America/Los_Angeles] Field 'processing' doesn't have a
> default value [27-Aug-2019 13:24:21 America/Los_Angeles] INSERT INTO
> blockRequest (name, imageid, numMachines, groupid, repeating, ownerid,
> managementnodeid, expireTime, status) VALUES ('Emerio test for block
> allocations', 11, 4, 109, 'weekly', 24, 1, '2019-09-30 23:59:59',
> 'accepted') [27-Aug-2019 13:24:21 America/Los_Angeles]
> ===========================================================================
> [27-Aug-2019 13:24:21 America/Los_Angeles] ERROR(101): General MySQL error
> [27-Aug-2019 13:24:21 America/Los_Angeles]
> Backtrace:
> =-=-=-=-=-=-=-=-=-=-=-=
> Call#:1 => index.php:AJblockAllocationSubmit() (line#:98)
> Call#:2 => blockallocations.php:doQuery() (line#:630)
>
> Backtrace with Arguments:
> =-=-=-=-=-=-=-=-=-=-=-=
> Call#:1 => index.php:AJblockAllocationSubmit() (line#:98)
> Arguments(none):
> -----------------------
> Call#:2 => blockallocations.php:doQuery() (line#:630)
> Arguments(2)
>
> Argument#: 1 => INSERT INTO blockRequest (name, imageid, numMachines,
> groupid, repeating, ownerid, managementnodeid, expireTime, status) VALUES
> ('Emerio test for block allocations', 11, 4, 109, 'weekly', 24, 1,
> '2019-09-30 23:59:59', 'accepted') Argument#: 2 => 101
> -----------------------
>
> Emerio
- --
- -------------------------------
Josh Thompson
VCL Developer
North Carolina State University
my GPG/PGP key can be found at pgp.mit.edu
All electronic mail messages in connection with State business which
are sent to or received by this account are subject to the NC Public
Records Law and may be disclosed to third parties.
-----BEGIN PGP SIGNATURE-----
iF0EARECAB0WIQRMIdRtWXideTZDK31X8tBw1209AwUCXWavygAKCRBX8tBw1209
A9ADAJ41rwKV218O0b2PPk0mxGiBcl4UFgCfYh69b9t0uRmI0CcCqWZEcVMOgyM=
=P7m9
-----END PGP SIGNATURE-----
