find in modules/Newsletter/index.php
Code:
$query = "SELECT email, uid FROM ${prefix}_users WHERE uid = '$cookie[0]'";
and replace with
Code:
$query = "SELECT user_email, user_id FROM $prefix_users WHERE user_id = '$cookie[0]'";
try that and report back
