diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2014-07-17 06:45:20 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2014-07-17 06:45:20 -0700 |
| commit | 85fbf4faf43f7c8d38973304c2a0940275160a73 (patch) | |
| tree | 5c0ff92c6c74c25f7e52ee55e078df7b085d9d9f /FS | |
| parent | 8c39dadbacacbceec1bc0b6c5fbf1468b0d3cf32 (diff) | |
| parent | be06add541bd150db591bf5712beaa3225c005b9 (diff) | |
Merge branch 'master' of git.freeside.biz:/home/git/freeside
Diffstat (limited to 'FS')
| -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 1044e436e..153390b59 100644 --- a/FS/FS/cust_pay.pm +++ b/FS/FS/cust_pay.pm @@ -1052,7 +1052,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); |