Page 1 of 2
Database updates
Posted: Thu Aug 26, 2004 10:25 pm
by Juntao
As some folks emailed me to point out, there was a database problem today that prevented people from using the forums. This could also have impacted some of the creature data access and updates.
I made some changes today to how the database works so if you see anything flakey, please let me know!
Posted: Fri Aug 27, 2004 2:32 am
by blackfoot
Edit: Never mind... it seems to have sorted itself out :wink:
what is this
Posted: Sat Aug 28, 2004 2:25 am
by sam-skill
if i try to put in like the baby rate thing i get this what is it? \"Cannot insert the value NULL into column 'VoteDate', table 'spadmin_swgcbackup.spadmin_swgcbackup.swgc_RatingVoteTable'; column does not allow nulls. INSERT fails.
Response object error 'ASP 0156 : 80004005'
Header Error
/ratevote.asp, line 117
The HTTP headers are already written to the client browser. Any HTTP header modifications must be made before writing page content\" :?:
Posted: Sat Aug 28, 2004 6:12 am
by blackfoot
^ Got that too
Posted: Sat Aug 28, 2004 6:25 pm
by Juntao
That should be fixed now
Posted: Sun Aug 29, 2004 4:36 pm
by blackfoot
I get this when trying to vote now.
[quote:6abe13bdaf]Cannot insert the value NULL into column 'RatingVoteID', table 'spadmin_swgcbackup.spadmin_swgcbackup.swgc_RatingVoteTable'; column does not allow nulls. INSERT fails.
Response object error 'ASP 0156 : 80004005'
Header Error
/ratevote.asp, line 117
The HTTP headers are already written to the client browser. Any HTTP header modifications must be made before writing page content. [/quote:6abe13bdaf]
Posted: Tue Aug 31, 2004 2:07 pm
by neowind
When trying to view profiles I am getting this error.
Tried obtaining data for a non-existent user
DEBUG MODE
SQL Error : Invalid object name 'dbo.swgc_RatingVoteTable'.
SELECT COUNT(Vote) AS VoteCount, AVG(Vote) AS VoteAvg FROM dbo.swgc_RatingVoteTable WHERE (VoteType='Worth') AND UserID = 2590 AND UserID <> -1
Line : 177
File : d:\\html\\users\\swgcreaturescom\\html\\forums\\phpbb2\\includes\\functions.php
Please email Juntao at
[email protected] with this error condition so that he can track down this bug!
Posted: Tue Aug 31, 2004 3:58 pm
by Juntao
Both of those are now fixed! Thanks for letting me know!
Posted: Wed Sep 01, 2004 12:40 pm
by Eltheria
Hi
I have just tried to view some creatures and I get the url
http://www.swgcreatures.com/null
This happened on all the creatures I tried to look at, which varied from Dappled Gualama to Giant Flit to Savage Quenker.
Posted: Thu Sep 02, 2004 11:30 am
by Eltheria
Its working good again this morning thx!