SREVO BAD LUCK ERROR! XD

03/07/2011 23:15 wicked09#1
Hey dear *epvper members!
I got a error which one i dun know how to solve xD.
This one error is write in Loginserver .
The error looks like this :
Quote:
[Loginserver: User: w1cked has logged in
Connection Error: System.Data.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be calles on Null values.
at System.Data.SqlClient.SqlBuffer.get_byte<>
at System.Data.SqlClient.SqlDataReader.GetByte<Int32 i>
at <Object , Int32 >
at A.cf2b028b13e227811fb1af3a13d3144a2.cbdbd53c40ff3a 36bf322cdf2a1ca5402<Object cbc9221c0ebe61e9c7fdc8c80254b8
at Data.System.Connect<>
So.. can someone help me to solve the problem?

#EDIT : I NEED HELP FASTER.. IF SOMEONE CAN POST THE SOLVING THING HERE I WILL BE HAPPY XD
03/08/2011 18:02 HaGsTeR#2
you left something "(null)" in the database, Accounts or Server
put something in all fields / columns
03/09/2011 20:51 ¬Methalelf#3
db.server
You leaved "Type" Null, put it 1.
03/11/2011 15:11 wicked09#4
It's DONE.
Now.. i have server when someone log into my server .
I create the char . Press Start , it works and than the image is "blocked".
the quickbar don't load. WHat's the problem?
03/12/2011 18:03 ¬Methalelf#5
Your database does not have guild_unions in it. You have to redo the database and make sure that guild_unions is added.

Put this code under guild_storage if you don't want to redo it.

/****** Object: Table [dbo].[guild_unions] Script Date: 02/08/2011 23:14:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[guild_unions](
[id] [int] IDENTITY(1,1) NOT NULL,
[union_leader] [varchar](50) NULL,
[union_guildname] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
03/22/2011 22:29 wicked09#6
Fixed , Almost everything works.
I have a little problem at Appache , at Register PAGE.

It says :

Quote:
Warning: mssql_connect(): message: Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (severity 14) in c:\appserv\www\reg.php on line 115

Warning: mssql_connect(): Unable to connect to server: WICKED\SQLEXPRESS in c:\appserv\www\reg.php on line 115

Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in c:\appserv\www\reg.php on line 116

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in c:\appserv\www\reg.php on line 117
I editet php document and it still says that. Why?
03/22/2011 23:09 melkorz123#7
Quote:
Originally Posted by wicked09 View Post
Fixed , Almost everything works.
I have a little problem at Appache , at Register PAGE.

It says :


I editet php document and it still says that. Why?
That usually means your server connection is wrong, I mean the authority. Check that your host/id/pw (sql server) is right, that might be the issue...
03/22/2011 23:09 IncredibleOnez#8
change the settings for 'SA'
Do this by:
Opening properties
select status tab
check enable.
03/23/2011 14:14 wicked09#9
Another problem=]
LOL-.-"

Idk why , everytime i install the server it says that dbo.guild_unions don't exist , but when i click on dbo.guild_unions from [Server Database Folder] , and i press execute on msql.. it says that dbo.guild_unions exist.

Text error :
Quote:
[3/23/2011 6:30:50 AM] [MESSAGE]: Object reference not set to an instance of an object. [TRACE]: at (Object )
at A.c546bf704c22f38545bcba2977860b9ee.c78bd748968365 023d6b090219ec4d499(Object )
at Game.Systems.PlayerDataLoad()
[3/23/2011 6:30:51 AM] [MESSAGE]: Could not find file 'C:\Documents and Settings\RAUL\Desktop\SREVO\Srevolution Gameserver\player\info\quickbar\Vanity.dat'. [TRACE]: at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
at System.IO.File.ReadAllBytes(String path)
at A.c866e85a5efd3f5c22eb317f22b7c7923.c0c85d4f594c1f 696ac9119af197e10b9(String )
at Game.Packet.Load(character c)
at A.c7edeb78e919eeadd75f6c12426db48cd.c0c85d4f594c1f 696ac9119af197e10b9(character )
at Game.Systems.LoginScreen()
03/23/2011 14:59 kevin_owner#10
lolz read the error xD

it's not about the guild_unions it's about some failure with the quickslot it can't find the .dat file. so creating a new user will solve it or you could try to rename a .txt file to .dat
btw the name has to be the name of that character in your case Vanity.dat
03/23/2011 15:07 wicked09#11
The problem isn't that. They can't connect to server . I mean , the QUICKBAR don't LOAD..
[The Loading Quickbar]
And i tryied to create dbo.guild_unions and it says that it exist in database. but i don't see in on table list.
-.-" Anything else what i should try?
03/23/2011 16:01 kevin_owner#12
jezus just do what I said. I know what your problem is...
create a new char and it'll work