Web Wiz Forums - SOME Data not being read from SQL

SOME Data not being read from SQL

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=18629
Printed Date: 13 April 2026 at 3:36am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SOME Data not being read from SQL

Posted By: dunpeal
Subject: SOME Data not being read from SQL
Date Posted: 06 March 2006 at 4:59pm

i downloaded and installed v7.97 on a test box box yesterday and while configuring and playing around with all the features i noticed that some of data was either not being pulled from the SQL DB or was mysteriously disapearing.

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

Replies:

Posted By: michael
Date Posted: 07 March 2006 at 12:12am

Did you simply try to re-run the database script, especially the Stored Procedures? I have not seen this problem before myself so I could only assume that either some scripts are messed up or as it appears to be pertaining to dates, your computer clock is "off".

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: dunpeal
Date Posted: 07 March 2006 at 1:21am

no i havent tried re-running the script, i will give it a try.

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.