Attention: These forums serve as read only archive of the original and may not be modified. All user accounts and logins have been disabled. Attempting to register, login or view a users profile, which requires a login, will result in your request being blocked.

Database updates

Relevant news about Creature Handlers and SWGCreatures
Juntao
Site Admin
Site Admin
Posts: 440
Joined: Sun Sep 28, 2003 8:17 pm
Location: Austin, TX
Contact:

Database updates

Postby Juntao » Thu Aug 26, 2004 10:25 pm

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!
Juntao Ta'kor
Master Creature Handler
Ahazi Galaxy
blackfoot
Posts: 18
Joined: Thu Aug 05, 2004 12:53 pm

Postby blackfoot » Fri Aug 27, 2004 2:32 am

Edit: Never mind... it seems to have sorted itself out :wink:
[size=10:1752ac7af1]Corona Blackfoot, Kauri MCH[/size:1752ac7af1]
sam-skill
Posts: 4
Joined: Sun Aug 08, 2004 12:51 am

what is this

Postby sam-skill » Sat Aug 28, 2004 2:25 am

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\" :?:
blackfoot
Posts: 18
Joined: Thu Aug 05, 2004 12:53 pm

Postby blackfoot » Sat Aug 28, 2004 6:12 am

^ Got that too
[size=10:1752ac7af1]Corona Blackfoot, Kauri MCH[/size:1752ac7af1]
Juntao
Site Admin
Site Admin
Posts: 440
Joined: Sun Sep 28, 2003 8:17 pm
Location: Austin, TX
Contact:

Postby Juntao » Sat Aug 28, 2004 6:25 pm

That should be fixed now
Juntao Ta'kor

Master Creature Handler

Ahazi Galaxy
blackfoot
Posts: 18
Joined: Thu Aug 05, 2004 12:53 pm

Postby blackfoot » Sun Aug 29, 2004 4:36 pm

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]
[size=10:1752ac7af1]Corona Blackfoot, Kauri MCH[/size:1752ac7af1]
neowind
Posts: 2
Joined: Tue Jul 20, 2004 8:00 am

Postby neowind » Tue Aug 31, 2004 2:07 pm

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!
Juntao
Site Admin
Site Admin
Posts: 440
Joined: Sun Sep 28, 2003 8:17 pm
Location: Austin, TX
Contact:

Postby Juntao » Tue Aug 31, 2004 3:58 pm

Both of those are now fixed! Thanks for letting me know!
Juntao Ta'kor

Master Creature Handler

Ahazi Galaxy
Eltheria
Posts: 49
Joined: Tue Aug 03, 2004 3:21 pm
Location: Ahazi

Postby Eltheria » Wed Sep 01, 2004 12:40 pm

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.
Eltheria
Posts: 49
Joined: Tue Aug 03, 2004 3:21 pm
Location: Ahazi

Postby Eltheria » Thu Sep 02, 2004 11:30 am

Its working good again this morning thx!

Return to “News”

Who is online

Users browsing this forum: No registered users and 37 guests