I recently installed v7.97 for SQL Server 2000, and most things are working but I've run into a few strange issues.
When displaying user information, either on the register.asp page, or the pop_up_profile.asp page, it seems its not retrieving/displaying the correct data from the database.
Let me give an example:
On the register.asp page, when updating a members information - I would set "Always show signature" to True, then save the record, but going back to it, it would still show False. Checking the database shows that indeed it is set to true.
Same issues are showing up on the pop_up_profile. The page seems to think that it's not getting an "Active" value, and is saying they are "Not Active". It's also not getting a Joined date, so it's detaulting to year 1899.
What's strange is that much of the other information is displayed ok, such as name, avatar, last access date etc.
I am confused as to what's causing this! It's as if ASP is not handling the recordset data properly once retrieved?!