0
Hi there,
I just installed the component. I tried to create something on Components > Affiliate Tracker > Conversions...But after that i am getting some 1064 error and it does not go. It just comes whenever i get back to that link.
I just installed the component. I tried to create something on Components > Affiliate Tracker > Conversions...But after that i am getting some 1064 error and it does not go. It just comes whenever i get back to that link.
Responses (3)
-
Accepted Answer
-
Accepted Answer
0Hi, Thanks for the response,
Well what i did was. After installation; Just to check things i went to Components > Affiliate Tracker > Conversions and created new conversion and saved it. This error might be because of i haven't created any accounts yet. But the problem is, its not letting me to enter this link again. Even if i go to Components > Affiliate Trackers, gives me the same error. However i can access Accounts, Logs and Payments. Here is the error message.
An error has occurred.
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 'AND pa.payment_status = 1' at line 1 SQL=SELECT SUM(pa.payment_amount) AS total_paid FROM xm3o5_affiliate_tracker_payments AS pa WHERE pa.user_id = AND pa.payment_status = 1-
Germinal Campsmore than a month agook, thanks. yes, that seems to be the issue. well, the easiest way, if you have access to your MySQL database, is to just empty the table xm3o5_affiliate_tracker_conversions. let me know if you're able to do this. if you don't know how, just please send me access at support@ joomlathat.com and I'll do it for you. in any case I'm going to review the settings because it should not let you save a conversion if there's no Account yet of course.
-
Your Reply
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »