PAP3 Upgrade: DB error

[walter_ps2]

I have upgraded my PAP2 to PAP3 without any problems.
But I have only one problem when I click on : Affiliates in campaigns

I recevie a PAP3 messagge for a DB error !!!

Please help me !

[tigerincanada]

I've just upgraded and have been bug-hunting before going live, but I have not encountered this one yet... what it in your URL after /affiliate/merchants/index.php?md= when this occurs?

That will identify which script PAP is trying to run when it happens.

Do you have the "affiliates must join campaigns" option turned on?

[walter_ps2]

/merchants/index.php?md=Affiliate_Merchants_Views_AppliedAffi liate

SQL error: Unknown column 'c.campaignid' in 'on clause' SQL:select count(*) as count from wd_g_users a, wd_pa_campaigns c, wd_pa_affiliatescampaigns ac left join wd_g_settings s on s.id1=c.campaignid and s.code='Aff_camp_status' where a.accountid='default1' and a.userid=ac.affiliateid and ac.campaignid=c.campaignid

[tigerincanada]

I just tried running that query via phpmyadmin and it doesn't give an error, so I'm foxed...

Did you also submit this to QualityUnit via the support form?

[walter_ps2]

yes I did...