MS SQL problems

[dhoechst]

I have two things going on:

I downloaded the 1.5.0 RC4 version and installed it to work with mySQL on one computer. this one is working well. I took that same downloaded file and installed it on a different computer to work with SQL Server.

the first thing that I noticed after install was that the version says 1.5.0 RC3 - I checked the ZIP file and it does say RC4 - what's going on?

Also, I am getting an error adding users in the admin area. My admin user was added during setup, but I can't get any more users added. I keep getting database error 2627. Here is my Debug info:

This is a unique key violation. When looking at the debug info, it looks like it is trying to use ID = 1 for the insert into the table, but this ID already belongs to user admin.

[dhoechst]

If you change the middle parameter of the mssql_result to 0, then it will return the correct value. 0 is the first row; 1, the second, etc. Since it is 1, it will try returning the second row which doesn't exist when you are doing the max function.

[Thorsten]

Hi,

I fixed it in CVS. Thanks a lot. Does everything work on MS SQL?

The RC4 package has a little bug because it says RC3 instead of RC4.

bye
Thorsten