diff options
| author | Mark Wells <mark@freeside.biz> | 2014-07-16 20:41:49 -0700 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2014-07-16 20:41:49 -0700 |
| commit | 6e004ea979eeb1059173781d2870bf410fa1e1ac (patch) | |
| tree | 2e3a70fc77b3cd8e5d987140712298395216dade | |
| parent | 74cccaa265fa81e493cec8701b18bc453d95e29c (diff) | |
mysql compat fix for cust_pay.paybatch upgrade, #28895
| -rw-r--r-- | FS/FS/cust_pay.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/FS/FS/cust_pay.pm b/FS/FS/cust_pay.pm index 3413a077a..aa5655d99 100644 --- 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 = CAST(pay_batch.batchnum AS text) ', + 'addl_from' => ' JOIN pay_batch ON cust_pay.paybatch = CONCAT(pay_batch.batchnum) ', } ); while (my $cust_pay = $search->fetch) { $cust_pay->set('batchnum' => $cust_pay->paybatch); |