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
Responses (3)
  • Accepted Answer

    Sunday, November 16 2014, 09:21 PM - #Permalink
    0
    Hello,

    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
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, November 16 2014, 09:29 PM - #Permalink
    0
    Hi, the option was not selected.

    Can you please take a look at the config in the backend?
    account details ask by email
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, November 16 2014, 11:26 PM - #Permalink
    0
    Well, 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
    The reply is currently minimized Show
Your Reply