By tmq on

Having placed the mailhandler.module in modules and added the mailhandler.mysql to my database, I get this error when navigating to system config --> modules --> mailhandler:

user error: 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 '} ORDER BY mail' at line 1
query: SELECT * FROM {mailhandler} ORDER BY mail in ../database.mysql.inc on line 75.

(btw: I've edited out the actual directory tree before "database.mysql.inc" in this post and replaced it with "..")

I'll be setting out on a roadtrip tomorrow with hopes of being able to roadblog with the mailhandler-- so if anyone can help out on this, I'd reallt appreciate a quick response. :)

My setup is:
Drupal CVS
Linux (2.4.18-24.7.xsmp)
Apache (1.3.27)
PHP 4.3.1
MySQL 4.0.13

Comments

torgeirb’s picture

torgeirb commented

I'd guess you are using a cvs checkout old enough that you need the mailhandler.module from the 4.2 branch.

Anonymous’s picture

(not verified) commented

That indeed did it.:) Strangely though, I did the update to cvs two days ago (via update.php) so I figured it would be pretty current. Any way to check the build of the cvs's?

moshe weitzman’s picture

moshe weitzman commented

see changelog