Guest Posted October 8, 2007 Share Posted October 8, 2007 Ive installed the OSC-Affiliate on my shop. Everything is working great, except when i go to Admin-Affilates-Summary Then this happens ~ 1054 - Unknown column 'AFFILIATE_PAYMENT_ORDER_MIN_STATUS' in 'where clause' select count(*) as count, sum(affiliate_value) as total, sum(affiliate_payment) as payment from affiliate_sales a left join oscommerce_orders o on (a.affiliate_orders_id = o.orders_id) where o.orders_status >= AFFILIATE_PAYMENT_ORDER_MIN_STATUS [TEP STOP] Ive had a look at my tables its all there, i even re installed the mod and its still saying it! Heres a screen shot to show i have installed it Please can someone help, i really am at a dead end Link to comment Share on other sites More sharing options...
Guest Posted October 8, 2007 Share Posted October 8, 2007 please anyone? i really need a little bit of help Link to comment Share on other sites More sharing options...
spannerman Posted February 2, 2008 Share Posted February 2, 2008 I realise this is an old question but I had the same problem when installing OSC Affiliate recently so here's the answer. There is a configuration entry missing in the original SQL file. You need the "correct_affiliate_query" mod posted in the OSC_Affiliate Contribution. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.