Change password

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Change Password using hMailServer and MS-SQL Server 2000

What is the expected output? What do you see instead?


What version of the product are you using? On what operating system?
Windows Server 2003, MS-SQL Server 2000

Please provide any additional information below.
bottasergio@gmail.com

Original issue reported on code.google.com by bottaser...@gmail.com on 5 Nov 2009 at 2:31

[GoogleCodeExporter]

Please add a patch or more detailed informations.

Original comment by rol...@liebl.ath.cx on 5 Nov 2009 at 7:19

• Changed state: Started

[GoogleCodeExporter]

I solved the problem deleting the last command in the SQL sentence... "LIMIT 1"

Original comment by bottaser...@gmail.com on 5 Nov 2009 at 7:34

[GoogleCodeExporter]

private $sql = 'UPDATE hm_accounts SET accountlastlogontime=%d, 
accountpassword=%
md5, accountpwencryption=%t WHERE accountaddress=%u LIMIT 1;';

So you confirm LIMIT 1 is not MSSQL compatible?

I don't have a chance to test on MSSQL, please post complete modified line.

Original comment by rol...@liebl.ath.cx on 5 Nov 2009 at 7:49

[GoogleCodeExporter]

It is working with Microsoft SQL Server 2000 this way:

file: hmail_password.php
line: 33

private $sql = 'UPDATE hm_accounts SET accountlastlogontime = %d, 
accountpassword = %
md5, accountpwencryption = %t WHERE accountaddress = %u ;';

Original comment by bottaser...@gmail.com on 5 Nov 2009 at 7:55

[GoogleCodeExporter]

Fixed in trunk-r-3101

Original comment by rol...@liebl.ath.cx on 6 Nov 2009 at 3:03