By number3 on

I've installed this module and the Mime Mail requirement. However, I'm getting the following warning when I subscribe

user warning: 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 'WHERE address = 'admin@admin.com' LIMIT 1' at line 2 query: SELECT 1 FROM WHERE address = 'admin@admin.com' LIMIT 1 in /var/www/html/sloan51/sloan51/includes/database.mysql.inc on line 172."

The error with the statement above is that there is not table name after 'FROM'. I've looked at the code to see what table it's trying to query.

function _ezmlm_table($list, $type) {
  $troot = $list->mlm_ezmlm_idx->troot;
  switch ( $type ) {
   
    case 'subscriber':
      return $troot;
   
    case 'moderator':
      return $troot.'_mod';
   
    case 'allow':
      return $troot.'_allow';
   
    case 'deny':
      return $troot.'_deny';
     
    case 'slog':
      return $troot.'_slog';

    case 'post':
      return $troot.'_post';
...

For the 'subscribe' case, "$troot = $list->mlm_ezmlm_idx->troot" tries to get the table prefix" gets the table prefix, if any, then returns just the prefix and no table name. I not entirely understand why. In addition I check to see if I had any of the other tables in the switch in my db _post, _slog, _deny, _allow, _mod and none of there existed. I also looked for any tables that had a column named 'address' and didn't find any.

Do I need another required module or is there a data dictionary for the table that I need to create to get rid of these warnings?

Thanks,

⋅ Categories: Drupal 5.x