errorin database affiliate pro 1.3

[Andrew]

I was trying to delete a Special member commision category and was presented with this error?

It did not delete the category

Please advise
Andrew

Version 1.3 post affiliate pro



###########################

SQL error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1; SQL:update pa_campaigncategories set deleted=1 where campcategoryid=16 and campaignid=; File: /var/www/html/affiliate/merchants/CampCategoriesManager.class.php; Line: 65


DB error!


Warning: Missing argument 1 for showcategories() in /var/www/html/affiliate/merchants/CampCategoriesManager.class.php on line 274

SQL error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and ac.deleted=0 and c.deleted=0 order by campcategoryid asc' a; SQL:select ac.campcategoryid,ac.name, c.commtype,ac.clickcommission, ac.salecommission,ac.salecommtype, ac.stsalecommtype from pa_campaigncategories ac, pa_campaigns c where ac.campaignid=c.campaignid and ac.campaignid= and ac.deleted=0 and c.deleted=0 order by campcategoryid asc; File: /var/www/html/affiliate/merchants/CampCategoriesManager.class.php; Line: 279


DB error!

################################

[mark]

hello,

this bug was solved in one of the newer versions. I recommend you to upgrade to version 1.4.

If it is a problem, let me know and I'll send you separate patch for your version.

regards,

mark

[error in 1.3]

Yes it is a problem to upgrade.

Please send me the pach to correct the error I have in 1.3

Thank you for your help

Please post the pach here and I will copy&paste

Regards
Andrew.

[mark]

Hello,

you should edit file /merchants/CampCategoriesManager.class.php and replace

$sql = "update pa_campaigncategories set deleted=1 where campcategoryid=$CategoryID and campaignid=".$this->CampaignID;



with

$sql = "update pa_campaigncategories set deleted=1 where campcategoryid=$CategoryID";


It should be on line 64.
But anyway, consider the update. There were few bugfixes.

regards,

mark

Thank you for the pach - this function now works without the error.
However, you say there are more errors in 1.3 that have been found and fixed.

Would you please send me all the fixes to get my programme 1.3 working without errors as I did purchase it on good faith that it had been tested and was fully functional.

I have found another problem on the php intergration URL - where it links not to my script ?

if($_GET['a_aid'] != '')
print "http://127.0.0.1/webra/dev/PostAffiliate2/www_13/scripts/t2.php?a_aid=".$_GET[";


Thank you once again.

When the 1.3 is error free - I will be more that happy to consider upgrading.

Andrew.