projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
74cccaa
)
mysql compat fix for cust_pay.paybatch upgrade, #28895
author
Mark Wells
<mark@freeside.biz>
Thu, 17 Jul 2014 03:41:49 +0000
(20:41 -0700)
committer
Mark Wells
<mark@freeside.biz>
Thu, 17 Jul 2014 03:41:49 +0000
(20:41 -0700)
FS/FS/cust_pay.pm
patch
|
blob
|
history
diff --git
a/FS/FS/cust_pay.pm
b/FS/FS/cust_pay.pm
index
3413a07
..
aa5655d
100644
(file)
--- a/
FS/FS/cust_pay.pm
+++ b/
FS/FS/cust_pay.pm
@@
-1079,7
+1079,7
@@
sub process_upgrade_paybatch {
###
my $search = FS::Cursor->new( {
'table' => 'cust_pay',
- 'addl_from' => ' JOIN pay_batch ON cust_pay.paybatch = C
AST(pay_batch.batchnum AS text
) ',
+ 'addl_from' => ' JOIN pay_batch ON cust_pay.paybatch = C
ONCAT(pay_batch.batchnum
) ',
} );
while (my $cust_pay = $search->fetch) {
$cust_pay->set('batchnum' => $cust_pay->paybatch);