BUG: Trying to pay Affiliates...

Community Based Support for JROX Affiliate Manager Only
Post Reply
techead
Posts: 5
Joined: Thu Mar 12, 2015 12:25 am

BUG: Trying to pay Affiliates...

Post by techead » Thu Sep 15, 2016 6:16 pm

Hello,

When attempting to run "any" of the Affiliate Payment modules, (by date or otherwise), we keep getting the following error...

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,'|',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_print_invoice_model.php

Line Number: 0
We're unable to troubleshoot this ourselves due to the code being encrypted; (which is fine); so can you address this ASAP?

thanks!

techead
Posts: 5
Joined: Thu Mar 12, 2015 12:25 am

Re: BUG: Trying to pay Affiliates...

Post by techead » Thu Sep 15, 2016 10:39 pm

OH.. forgot to say... I'm using v3.0.48 (although it still reports 3.0.38 on the dashboard)

techead
Posts: 5
Joined: Thu Mar 12, 2015 12:25 am

Re: BUG: Trying to pay Affiliates...

Post by techead » Wed Sep 21, 2016 1:55 am

Hello?

Is this forum even being monitored anymore??

This query has been here a WEEK, now with no response whatsoever from anyone at jRox....???

what's up??

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest