Generate PayPal Mass Payment Error

Community Based Support for JROX Affiliate Manager Only
Post Reply
9starmedia
Posts: 1
Joined: Sat Oct 21, 2017 10:07 am

Generate PayPal Mass Payment Error

Post by 9starmedia » Tue Nov 07, 2017 10:31 pm

Im using version 3.0.38 and trying to generate a mass payment for PayPal for commissions which have been approved and are as yet unpaid. When I attempt to generate the mass payment I get this error. Could you tell me what the problem is?

Code: Select all

A Database Error Occurred
Error Number: 1064

You Have An Error In Your SQL Syntax; Check The Manual That Corresponds To Your MySQL Server Version For The Right Syntax To Use Near '' At Line 8

SELECT DISTINCT Member_id As Id, (SELECT CONCAT(Fname,' ',Lname, '|',Payment_name,'|',Paypal_id,'|',Payment_preference_amount) As Name FROM Jam_members WHERE Member_id = Id) As Payment_name, (SELECT SUM(Commission_amount) FROM Jam_commissions WHERE Member_id = Id AND Approved = '1' AND Comm_status = 'Unpaid') As Total FROM Jam_commissions WHERE Approved = '1' AND Comm_status = 'Unpaid' ORDER BY Total DESC LIMIT 0,

Filename: Application/Models/Modules/Module_affiliate_payment_paypal_mass_payment_model.php

Line Number: 0

Post Reply