[Help Thread] Please post your questions here.

01/10/2018 01:01 ThunderNikk#6826

Are you using the right server files with the right servers...

because no Herlock does not give me SQL column errors when I start it.

01/10/2018 02:49 mariathao#6827

doing the 6.2 with guide and thats what im getting when i launch herlock. does the SQL year matter?

01/10/2018 03:43 ThunderNikk#6828

Not really if you were able to restore all of the databases.

Never really restored or worked with the 6.2 myself

So you have at least all 3 databases restored and named Arcadia Auth and Telecaster

Started Princess aurora with no errors and start captain herlock with that error.

And you are not mixing 6.2 releases you got all the databases out of the same release you got the herlock?

01/10/2018 03:56 mariathao#6829

yea, everything is form the same folder. im using SQL 2014 enterprise and everything work right up till i launched herlock.

01/10/2018 12:52 ThunderNikk#6830

I will set 6.2 up later tonight and see if I can recreate the issue and try to find out what it is, unless someone else answers before that.

01/10/2018 13:06 SilentWisdom#6831

Could get better help if you provide us the last several lines of a SQL Server Profiler capture during the gs startup.

I'm willing to be it's stemming from an smp because the gs selects data like SELECT * FROM dbo.Item, it doesn't use strongly typed column names.

01/10/2018 19:41 mariathao#6832

Quote:

Originally Posted by SilentWisdom

Could get better help if you provide us the last several lines of a SQL Server Profiler capture during the gs startup.

I'm willing to be it's stemming from an smp because the gs selects data like SELECT * FROM dbo.Item, it doesn't use strongly typed column names.

how do i do that?

01/10/2018 20:17 roller334#6833

1. open your SQL Management Studio
2. in the top menu "tools" -> "sql server profiler"
3. authenticate and run it
4. start your gameserver (wait till his done with initialising)
5. stop tracing
6. save as (select whatever you prefer)

01/12/2018 00:55 mariathao#6834

Cant seem to get it working

but i can provide this

Spoiler

01/12/2018 01:53 roller334#6835

I managed to reproduce your error, thanks to your dump text file. Just add a additional column "guild_id" (type int, allow null) to your Telecaster.dbo.Character.

01/12/2018 03:39 mariathao#6836

amazing! wish i could do that! thank you sir

01/12/2018 04:09 roller334#6837

you are welcome dude :D

01/12/2018 04:18 mariathao#6838

i still cant do it, says that i cant save and unless i re create table

01/12/2018 04:37 roller334#6839

You have to check the checkbox "Allow Nulls" and set the Data Type to int, it should be possible.
Look at the attachment.

01/12/2018 04:47 mariathao#6840

Quote:

Originally Posted by roller334

You have to check the checkbox "Allow Nulls" and set the Data Type to int, it should be possible.
Look at the attachment.

cant add guild_id or save when i allow null
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]