vbGore Free Online RPG Engine

Revolutionizing Visual Basic ORPG Development
It is currently Sun May 19, 2013 1:22 pm

All times are UTC - 8 hours




Post new topic Reply to topic  [ 7 posts ] 
Author Message
 Post subject: Server has trouble checking that the character exists.
PostPosted: Sat Jul 17, 2010 7:36 pm 
Lucky Number 7

Joined: Tue Jun 22, 2010 8:15 am
Posts: 7
I am using a modified version of goremania. I removed the multiple character system and it worked fine. I ported it to an off site windows server (2008) and hooked it into the database. Everything worked fine. Now all of a sudden this is giving me trouble.

load_user
Code:
   

    'Retrieve the user from the database
    DB_RS.Open "SELECT * FROM users WHERE `name`='" & UserName & "'", DB_Conn, adOpenStatic, adLockOptimistic

    'Make sure the character exists
    If DB_RS.EOF Then
        DB_RS.Close
        Exit Sub
    End If


Is this a database problem or a code problem?


Top
 Profile  
 
 Post subject: Re: Server has trouble checking that the character exists.
PostPosted: Sat Jul 17, 2010 9:39 pm 
Wizard of Xor

Joined: Tue Mar 17, 2009 3:48 pm
Posts: 238
Which line is the error on, and what is the error?


Top
 Profile  
 
 Post subject: Re: Server has trouble checking that the character exists.
PostPosted: Sat Jul 17, 2010 9:58 pm 
Lucky Number 7

Joined: Tue Jun 22, 2010 8:15 am
Posts: 7
Its this line:
If DB_RS.EOF Then

It equals true when I debug it. "Data provider or other service returned an E_FAIL status."
I also get this application error from the windows server logs: "Faulting application GameServer.exe, version 1.0.0.14, time stamp 0x4c369da0, faulting module GOREsockServer.ocx, version 1.0.0.12, time stamp 0x471299dc, exception code 0xc0000005, fault offset 0x0000750b, process id 0xac0, application start time 0x01cb260d32a06c48."


Top
 Profile  
 
 Post subject: Re: Server has trouble checking that the character exists.
PostPosted: Sun Jul 18, 2010 8:49 pm 
Wizard of Xor

Joined: Tue Mar 17, 2009 3:48 pm
Posts: 238
That's not a GOREsock error. DB_RS.EOF means the loop has reached the end of the database. I'll see if I can figure it out later.


Top
 Profile  
 
 Post subject: Re: Server has trouble checking that the character exists.
PostPosted: Wed Aug 25, 2010 2:41 pm 
Site Admin

Joined: Sun Jul 30, 2006 4:00 pm
Posts: 1230
Is the database hosted on the same computer as the server?


Top
 Profile  
 
 Post subject: Re: Server has trouble checking that the character exists.
PostPosted: Wed Aug 25, 2010 4:36 pm 
Lucky Number 7

Joined: Tue Jun 22, 2010 8:15 am
Posts: 7
Thanks for your reply but I figured out the problem about a month ago. vbGORE does not like mySQL default values.


Top
 Profile  
 
 Post subject: Re: Server has trouble checking that the character exists.
PostPosted: Mon Aug 30, 2010 1:22 pm 
Site Admin

Joined: Sun Jul 30, 2006 4:00 pm
Posts: 1230
Ah ok. Sorry about the delayed posting. I was busy getting moved from one hell hole to my new place.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 

All times are UTC - 8 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group