SOME Data not being read from SQL

 

i browsed these forums, but was not able to find anything relevant, thus this post.

 

if i was to pull up someones profile it would say that the join date is 1899, but the last visit was the current date. the database shows the join date as yesterday (that when i created these tests accounts)

 

it shows the number of posts as 0...for everyone, even for those that do have posts.

 

it seems also any field that is a boolean is disapearing as well, which is causing problems.

 

it always shows the account status as Not Active

 

on the profile settings, where it asks if you want to display the signature.  it always defaults to no, even after selecting yes and typing something in the signature field and clicking update, it still defaults to no, but does save the signature itself.  if i look at the database the show signature field is set to true, so it should be showing the signature in posts and defaulting to yes in settins.

 

i though maybe it was a problem with the database, so i just wrote a simple test file which queries the author databse and displays the information, and it was all coming through and coming through correctly.  i dought its the forum code, since so many people are using it and i havent been able to find another post related to this, so i am stuck and hope someone can help.

 

has anyone seen these problems, any solutions?

 

Thanks

 

 

when i query the db in enterprise manager it shows the correct information, so the db seems to be storing the info properly, i checked the computer clock locally and thats fine as well.

 

not trying ot modify anything, just doing testing.

if i your popup_profile.asp file and before the info is stored from the recorset to the local variables i do a response.write, it wont give me an error but at the same time it wont respond with anything...but only for those items that i described in the original post.

 

but if i just create  a test asp file from scratch, create a recordset to pull that same data, it works just fine, all the data comes through.

 

ill try what you suggested and will post back.