SREVO BAD LUCK ERROR! XD

[wicked09]

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 :

[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

[HaGsTeR]

you left something "(null)" in the database, Accounts or Server
put something in all fields / columns

[¬Methalelf]

db.server
You leaved "Type" Null, put it 1.

[wicked09]

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?

[¬Methalelf]

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

[wicked09]

Fixed , Almost everything works.
I have a little problem at Appache , at Register PAGE.

It says :

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?

[melkorz123]

Originally Posted by wicked09

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...

[IncredibleOnez]

change the settings for 'SA'
Do this by:
Opening properties
select status tab
check enable.

[wicked09]

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 :

[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()

[kevin_owner]

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

[wicked09]

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?

[kevin_owner]

jezus just do what I said. I know what your problem is...
create a new char and it'll work