0
Hi,
I just installed affiliate tracker and content statistics.
I am in the configuration process and when i tried to publish the module "evolution in time) i get this error
1054
Error: 1054
Unknown column 'st.user_id' in 'where clause' SQL=SELECT SUM(pa.payment_amount) AS howmuch, pa.payment_datetime AS date_event FROM y8nyp_affiliate_tracker_payments AS pa LEFT JOIN y8nyp_users AS u ON u.id = pa.user_id WHERE 1 = 1 AND pa.payment_datetime >= "2014-11-01 00:00:00" AND NOW() AND st.user_id = 685 AND u.id = 685 AND pa.payment_status = 1 GROUP BY MONTH(date_event), YEAR(date_event) ORDER BY date_event
Besides that error, I am a little lost on how to set the modules in the front end. I would like some help to setup the front end so every one of the tabs (conversions, traffic logs, and payments) have their graphics assigned as you have in the demo site..
Thanks..
Darwin
I just installed affiliate tracker and content statistics.
I am in the configuration process and when i tried to publish the module "evolution in time) i get this error
1054
Error: 1054
Unknown column 'st.user_id' in 'where clause' SQL=SELECT SUM(pa.payment_amount) AS howmuch, pa.payment_datetime AS date_event FROM y8nyp_affiliate_tracker_payments AS pa LEFT JOIN y8nyp_users AS u ON u.id = pa.user_id WHERE 1 = 1 AND pa.payment_datetime >= "2014-11-01 00:00:00" AND NOW() AND st.user_id = 685 AND u.id = 685 AND pa.payment_status = 1 GROUP BY MONTH(date_event), YEAR(date_event) ORDER BY date_event
Besides that error, I am a little lost on how to set the modules in the front end. I would like some help to setup the front end so every one of the tabs (conversions, traffic logs, and payments) have their graphics assigned as you have in the demo site..
Thanks..
Darwin
Responses (3)
-
Accepted Answer
0Hello,
the issue you get probably is related to the settings you have set in the module.
did you activate the option "filter by current user" in the module? don't do it. that's probably what's causing the issue. not your fault, the option shouldn't be selectable in this module.
in any case, this tells you how to set up the modules: http://www.joomlathat.com/documentation/affiliate-tracker/graphic-reports
besides of that, if you need more help, please don't hesitate to contact us at support@ joomlathat.com and we'll provide help -
Accepted Answer
-
Accepted Answer
0Well, the modules are working now,apparently as there was no data generated, the database tables were not created so it was generating the error.
But now i have encountered another situation... when I publish 2 modules in a position (at_conversions) for example, they are displayed one under the other, not one in the side of the other as you have them in your demo. I tried changing the module width and played with responsive layout options in the module with no luck...
how can i make it look one at the side of the other?
Thanks,
Darwin
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 »