Hello Josh, Thank you for your response! I have to follow my university's change control process before I can implement the blockRequest table change to our VCL system. I inherited our VCL system and I have been told that BA on it has never worked. So later and after I implement the change if other BA work flow issues come up, I would like to continue to reach out to you on this email thread. Again, thank you.
Emerio -----Original Message----- From: Josh Thompson <[email protected]> Sent: Wednesday, August 28, 2019 9:46 AM To: [email protected] Subject: Re: Block Allocation Request is Failing -----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-----
