Affiliates Error

[dumb_question]

Hello Guys..I just installed afiliates mod...now I am getting this error when someone tries to sign up as an affiliates.

 

1044 - Access denied for user: 'database-name@localhost' to database

 

LOCK TABLES affiliate_affiliate WRITE

Thanks for your help

[Lourens]

So that makes two of us now!

 

Does anyone have an idea how to fix this?

 

Thanks

[Lourens]

I have found a solution, use phpMyAdmin and edit the global administration privileges to include LOCK TABLES for the database-name@localhost

[dumb_question]

Ok...thats great but how do i do that.

 

I did go into cpanel but couldnt find anything relevant.

Appreciate your help

[Lourens]

I do not believe that you will have the ability to change these privileges yourself in cpanel and you will have to ask your host to change these permissions for you.

 

Anyway, if you do have access to phpMyAdmin 2.5.3 with this function available then you may follow the instructions below.

 

In cpanel click on the MySQL database icon and at the bottom of the MySQL Account Maintenance page you will find a link to phpMyAdmin - click on it.

 

On the main page you will see the link to [Privileges] to reveal all the users, click on edit, select Lock Tables and click on [Go] and that is it!

[pfaustino]

My hosting company recently upgraded mysql and deemed that this was a security issue and therefore revoked this privilege to all users. Rather than allowing the privileges described in the previous posts, they have asked us to comment out the code that locks the table.

 

That seems to work BUT I don't know if it has any repercussions yet.

 

Here's how to do it. Under /includes/functions/affiliate_functions.php, locate

 

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

 

and comment it out

 

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

 

Let me know if I missed anything. There are some UNLOCK codes in this same file but I did not touch them.

 

Patrick