Member_Approval_v1.7 Activation Error

[oswebjumper]

I added Member_Approval_v1.7 and followed directions explicitly and rechecked. When in admin panel / customer awaiting approval section and I select a user and click activate I get this message in panel ....

 

1064 - 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

 

select customers_language_id from customers where customers_id =

 

I have found a couple of threads which had no definative answers. Please help. Benn at this a while and its crunch time.

[oswebjumper]

I added Member_Approval_v1.7 and followed directions explicitly and rechecked. When in admin panel / customer awaiting approval section and I select a user and click activate I get this message in panel ....

 

1064 - 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

 

select customers_language_id from customers where customers_id =

 

I have found a couple of threads which had no definative answers. Please help. Benn at this a while and its crunch time.

 

12/6/09 SOLVED:

Ok. This is how it washed out. I took two entries from two threds and combined them to resolve issue. I will add their credits shortly.

First, I backed up the admin/member.php file.

Second, I found:

 

$customer_language_id_qry = tep_db_query('select customers_language_id from ' . TABLE_CUSTOMERS . ' where customers_id = ' . $cID);

 

replaced with:

 

$customer_language_id_qry = tep_db_query('select customers_language_id from ' . TABLE_CUSTOMERS . ' where customers_id = ' . $HTTP_GET_VARS['cID']);

 

Third, I found:

 

$languages_dir_qry = tep_db_query("select directory from " . TABLE_LANGUAGES . " where languages_id = " . $customer_language_id_res['customers_language_id']);

$languages_dir_res = tep_db_fetch_array($languages_dir_qry);

require(DIR_WS_LANGUAGES . $languages_dir_res['directory'] . '/' . 'members_mail.php');

 

Replaced with:

 

$languages = tep_get_languages();

for ($i=0, $n=sizeof($languages); $i<$n; $i++) {

require(DIR_WS_LANGUAGES . $languages[$i]['directory'] . '/' . 'members_mail.php');

}

 

Works now.