Comment 3 by johan.ni...@gmail.com, Oct 21, 2009
It was a matter of SQL syntax differences. Solved it by setting the variables
instead of * in the sql SELECT query in the file hmail_autoresponder.php
I also removed the spaces and `´ between variable and = and %v originally: `variable
´ = %v.
private $sql_select = 'SELECT accountlastlogontime, accountvacationmessageon,
accountvacationsubject, accountvacationmessage, accountvacationexpires,
accountvacationexpiredate FROM hm_accounts WHERE accountaddress=%u;';
private $sql_update = 'UPDATE hm_accounts SET accountlastlogontime=%t,
accountvacationmessageon=%o, accountvacationsubject=%s, accountvacationmessage=%m,
accountvacationexpires=%e, accountvacationexpiredate=%d WHERE accountaddress=%u;';
It's true that mssql and mysql have the different "sql query ", the existing plugin is using the mysql query for the selete update purpose, so if you want to use mssql for the database method , you have to change all the "sql query " of the plugin , no matter which plugin it is . of course I mean hmail plugins.
I believe all the configuration is right for us ,see anyone could help and provide us the correct php file for mssql.