0
Hi, I just installed Affiliate Tracker on a J3.3 installation running Emerald.
I enabled the Emerald plugin and created an affiliate account and then I tested it, but when the sale is completed, I get an error page. I disabled the Affiliate Tracker - Emerald plugin and then Emerald works fine.
Here is the message I got. I don't know if this is somehting I need to configure in Affiliate Tracker in order for it to work?
1054 - Unknown column 'plan_name' in 'field list' SQL=UPDATE init3_emerald_subscriptions SET user_id='2',plan_id='1',invoice_id='0',invoice_num='0',published='1',ctime='2015-06-24 18:11:09',extime='2016-06-24 18:11:09',created='2014-11-18 17:47:44',purchased='2014-11-18 17:48:31',lastsent='0000-00-00 00:00:00',price='35.00',access_count='0',access_count_mode='0',access_limit='0',gateway='clickbank',gateway_id='M28YE7TH1',parent='0',track_active='0',track_disactive='0',activated='1',checked_out='0',checked_out_time='0000-00-00 00:00:00',plan_name='Vivir a Colores' WHERE id='99'
No puede visitar esta página debido a:
Un marcador o favorito caducado
Un motor de búsquedas que tiene un listado caducado para este sitio
Una dirección mal escrita
Usted no tiene acceso a esta página
No se pudo encontrar el recurso solicitado.
Se ha producido un error mientras se procesaba su solicitud.
Por favor, pruebe con alguna de las páginas siguientes:
Página de inicio
Si la dificultad persiste, por favor, contacte con el administrador del sistema de este sitio y reporte el error de más abajo..
Unknown column 'plan_name' in 'field list' SQL=UPDATE init3_emerald_subscriptions SET user_id='2',plan_id='1',invoice_id='0',invoice_num='0',published='1',ctime='2015-06-24 18:11:09',extime='2016-06-24 18:11:09',created='2014-11-18 17:47:44',purchased='2014-11-18 17:48:31',lastsent='0000-00-00 00:00:00',price='35.00',access_count='0',access_count_mode='0',access_limit='0',gateway='clickbank',gateway_id='M28YE7TH1',parent='0',track_active='0',track_disactive='0',activated='1',checked_out='0',checked_out_time='0000-00-00 00:00:00',plan_name='Vivir a Colores' WHERE id='99'
I enabled the Emerald plugin and created an affiliate account and then I tested it, but when the sale is completed, I get an error page. I disabled the Affiliate Tracker - Emerald plugin and then Emerald works fine.
Here is the message I got. I don't know if this is somehting I need to configure in Affiliate Tracker in order for it to work?
1054 - Unknown column 'plan_name' in 'field list' SQL=UPDATE init3_emerald_subscriptions SET user_id='2',plan_id='1',invoice_id='0',invoice_num='0',published='1',ctime='2015-06-24 18:11:09',extime='2016-06-24 18:11:09',created='2014-11-18 17:47:44',purchased='2014-11-18 17:48:31',lastsent='0000-00-00 00:00:00',price='35.00',access_count='0',access_count_mode='0',access_limit='0',gateway='clickbank',gateway_id='M28YE7TH1',parent='0',track_active='0',track_disactive='0',activated='1',checked_out='0',checked_out_time='0000-00-00 00:00:00',plan_name='Vivir a Colores' WHERE id='99'
No puede visitar esta página debido a:
Un marcador o favorito caducado
Un motor de búsquedas que tiene un listado caducado para este sitio
Una dirección mal escrita
Usted no tiene acceso a esta página
No se pudo encontrar el recurso solicitado.
Se ha producido un error mientras se procesaba su solicitud.
Por favor, pruebe con alguna de las páginas siguientes:
Página de inicio
Si la dificultad persiste, por favor, contacte con el administrador del sistema de este sitio y reporte el error de más abajo..
Unknown column 'plan_name' in 'field list' SQL=UPDATE init3_emerald_subscriptions SET user_id='2',plan_id='1',invoice_id='0',invoice_num='0',published='1',ctime='2015-06-24 18:11:09',extime='2016-06-24 18:11:09',created='2014-11-18 17:47:44',purchased='2014-11-18 17:48:31',lastsent='0000-00-00 00:00:00',price='35.00',access_count='0',access_count_mode='0',access_limit='0',gateway='clickbank',gateway_id='M28YE7TH1',parent='0',track_active='0',track_disactive='0',activated='1',checked_out='0',checked_out_time='0000-00-00 00:00:00',plan_name='Vivir a Colores' WHERE id='99'
Responses (1)
-
Accepted Answer
0This is quite strange for the follwing reason: the error you're getting is related to a mysql query INSIDE emerald (not in our plugin), I'm really not sure how our plugin could be affecting this. the best way to find out is to take a look it myself. could you provide us access at support@ joomlathat.com?
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 »