Whats the score with mailing lists?

Is there two different, but almost the same modules for mailing lists? Maillist manager etc etc?

Anyhow I am getting a handful of errors when I try to edit my mailing lists and it seems I need some help:

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 = 'jon@resinmonkey.com' LIMIT 1' at line 2 query: SELECT 1 FROM WHERE address = 'jon@resinmonkey.com' LIMIT 1 in /home/httpd/vhosts/labcraftaustralia.com/httpdocs/monkey/includes/database.mysql.inc on line 172.

I am getting better at deciphering the errors but my SQL skills arent great.

I'd appreciate any help anyone can give.

Thanks in advance.

Comments

fighella’s picture

fighella commented

These errors are recieved when I go to change any mailing list settings:

* 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 = 'jon@resinmonkey.com' LIMIT 1' at line 2 query: SELECT 1 FROM WHERE address = 'jon@resinmonkey.com' LIMIT 1 in /home/httpd/vhosts/labcraftaustralia.com/httpdocs/monkey/includes/database.mysql.inc on line 172.
* 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 = 'jon@resinmonkey.com' LIMIT 1' at line 2 query: SELECT 1 FROM WHERE address = 'jon@resinmonkey.com' LIMIT 1 in /home/httpd/vhosts/labcraftaustralia.com/httpdocs/monkey/includes/database.mysql.inc on line 172.
* 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 = 'jon@resinmonkey.com'' at line 1 query: SELECT 1 FROM WHERE address = 'jon@resinmonkey.com' in /home/httpd/vhosts/labcraftaustralia.com/httpdocs/monkey/includes/database.mysql.inc on line 172.
* 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 '( hash, address ) VALUES ( '7', 'jon@resinmonkey.com' )' at line 1 query: INSERT INTO ( hash, address ) VALUES ( '7', 'jon@resinmonkey.com' ) in /home/httpd/vhosts/labcraftaustralia.com/httpdocs/monkey/includes/database.mysql.inc on line 172.
* user warning: Table 'monkey._slog' doesn't exist query: INSERT INTO _slog ( tai, address, fromline, edir) VALUES ( '2007-04-17 18:36:26', 'jon@resinmonkey.com', 'jon@resinmonkey.com', '+') in /home/httpd/vhosts/labcraftaustralia.com/httpdocs/monkey/includes/database.mysql.inc on line 172.
* warning: preg_match() expects parameter 2 to be string, array given in /home/httpd/vhosts/labcraftaustralia.com/httpdocs/monkey/modules/mimemail/mimemail.inc on line 103.