With sql_strict_modes turned on, if you try to create a new subscription
you will get:
Incorrect integer value: '' for column '$INT_COLUMN' at row 1
Signed-off-by: Liz Rea <wizzyrea@gmail.com>
Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Michal Denar <black23@gmail.com>
Signed-off-by: Michal Denar <black23@gmail.com>
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
(cherry picked from commit
e8e7ea352ef237555ee4d47c98feb879f3eb9e31)
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
) = @_;
my $dbh = C4::Context->dbh;
+ $_ ||= undef # Set to undef for integer values, not empty string
+ for (
+ $aqbooksellerid, $lastvalue1, $innerloop1, $lastvalue2,
+ $innerloop2, $lastvalue3, $innerloop3,
+ );
#save subscription (insert into database)
my $query = qq|
INSERT INTO subscription