Jump to content

Recommended Posts

If I click Affiliate Payments there are two options: PayPal Mass Payment and Print Affiliate Invoice

If I click Get Started for either of those, then fill in details, there is a db error:

e.g. PayPal:

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: models/modules/Module_affiliate_payment_paypal_mass_payment_model.php

Line Number: 199

The invoice error is almost the same with the error on Line number 182

In both cases the line number in question is : $query = $this->db->query($sql);

What can I do?

Edited by ross
more details
Link to post
Share on other sites
  • 3 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...