1044 Error on New Affiliate Signup

[Guest]

I installed oscommerce MS 2 and installed OscAffiliate 1.09. I kept getting a 1044 Error on New Affiliate Signup---1044 Error No Access to User:

Lock Table Affiliate_Affiliate Write

 

How do you correct this problem? I have installed it several times.

 

Thanks

[fets]

I installed oscommerce MS 2 and installed OscAffiliate 1.09. I kept getting a 1044 Error on New Affiliate Signup---1044 Error No Access to User:

Lock Table Affiliate_Affiliate Write

How do you correct this problem? I have installed it several times.

Thanks

 

same problem any ideas please ?

[Guest]

same problem any ideas please ?

HOLY CRAP! that sucks because I have this issue and there was no resolution. man. bummer. does anyone have it working? can you please zip all your affiliate files your catalog so that i can compare mine and maybe figure out this issue? thats assuming someone not only has it working somewhere...but also kind enough to share the working files. Thanks in advance if it happens to be you, you make osc a brighter place. :P

[Guest]

the issue is this, if your db user doesnt have full permissions... like drop, create, lock, unlock permissions you will get this error. to fix this particular issue do this:

 

in includes/functions/affiliate_functions.php

find tep_db_query("LOCK TABLES " . TABLE_AFFILIATE . " WRITE");

and comment it out like this:

// tep_db_query("LOCK TABLES " . TABLE_AFFILIATE . " WRITE");

 

and the same for:

tep_db_query("UNLOCK TABLES");

comment it out like this:

//tep_db_query("UNLOCK TABLES");

 

worked for me.