Clan error 11

[grimske1]

hi,

well i know this issue comes around much but I keep getting this error 11 and on the site this is also an error:


what could i do?
it is a windows server 2003 64 bit with iis6

 

[SheenBR]

There is already an answer for that error here, please use the search button!

 

[grimske1]

well i already did search for it but nothing worked :S am i overlooking something?

 

[SunnyZ]

http://forum.ragezone.com/f286/clan-error-11-tried-various-507698/

Read Gzuz's reply.

And I REALLY hope you ALSO included the SQL database login info in the "C14n/claninsert.aspx" file.

And if that fails use this claninsert.aspx file.
Seems to work for me, MPT's one is a bit buggy for me.

<%@ Page Language="VB" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">

Function GetParameter(pName as string, pType as string) as string
dim lTmp as string
lTmp = Page.Request.QueryString.item(pName)

GetParameter = lTmp
End Function

Sub Page_Load(Sender As Object, E As EventArgs)

Dim dbhost, dbuser, dbpass, dbname, userid, gserver, chname, clName, expl, chtype, lv

dbhost = "blablabla\SQLEXPRESS"
dbuser = "blablabla"
dbpass = "blablabla"
dbname = "ClanDB"

Dim strSplit As String
strSplit = Chr("&H" & "0D")

userid = GetParameter ("userid","String")
gserver = GetParameter ("gserver","String")
chname = GetParameter("chname","String")
clName = GetParameter("clName","String")
chtype = GetParameter("chtype","String")
lv = GetParameter("lv","String")

expl = "www.ptnoname.com"

if userid="" Or gserver="" Or chname="" Or clName="" Or chtype="" or lv="" Then
Response.Write("Code=100" & strSplit)
Response.End
End if

Dim objConn, objReader, objCommand, objQuery

Dim connectionString As String = "server='" & dbhost & "'; user id='" & dbuser & "'; password='" & dbpass & "'; database='" & dbname & "'"

objConn = New SqlConnection(connectionString)
objConn.Open()

objQuery = "SELECT ClanName FROM UL WHERE ChName='" & chname & "'"

objCommand = New SqlCommand(objQuery, objConn)
objReader = objCommand.ExecuteReader()

If objReader.Read()
If objReader.Item(0) = "" Then
objReader.Close()
objQuery = "DELETE FROM UL WHERE ChName='" & chname & "'"

objCommand = New SqlCommand(objQuery, objConn)
objReader = objCommand.ExecuteReader()
Else
objReader.Close()
objConn.Close()
Response.Write("Code=2" & strSplit & "CMoney=0" & strSplit)
Response.End
End if
End if
objReader.Close()

objQuery = "SELECT ClanZang FROM CL WHERE ClanName='" & clName & "'"

objCommand = New SqlCommand(objQuery, objConn)
objReader = objCommand.ExecuteReader()

If objReader.Read()
objReader.Close()
objConn.Close()
Response.Write("Code=3" & strSplit & "CMoney=0" & strSplit)
Response.End
End if
objReader.Close()

objQuery = "SELECT IMG FROM LI WHERE ID=1"

objCommand = New SqlCommand(objQuery, objConn)
objReader = objCommand.ExecuteReader()

Dim iIMG As Integer

if objReader.Read() Then
iIMG = objReader.Item(0)
Else
iIMG = 1000000000
objReader.Close()
objQuery = "INSERT INTO LI values('" & (iIMG + 1) & "','1')"
objCommand = New SqlCommand(objQuery, objConn)
objReader = objCommand.ExecuteReader()
End if
objReader.Close()

iIMG = iIMG + 1

objQuery = "UPDATE LI SET IMG='" & iIMG & "' WHERE ID=1"

objCommand = New SqlCommand(objQuery, objConn)
objReader = objCommand.ExecuteReader()
objReader.Close()

objQuery = "INSERT INTO CL ([ClanName],[UserID],[ClanZang],[MemCnt],[Note],[MIconCnt],[RegiDate],[LimitDate],[DelActive],[PFlag],[KFlag],[Flag],[NoteCnt],[Cpoint],[CWin],[CFail],[ClanMoney],[CNFlag],[SiegeMoney]) values('" & clName & "','" & userid & "','" & chname & "','1','" & expl & "','" & iIMG & "',getdate(),getdate()+3600,'0','0','0','0','1 ','0 ','0','0','0','0','0')"
objCommand = New SqlCommand(objQuery, objConn)
objReader = objCommand.ExecuteReader()
objReader.Close()

objQuery = "SELECT IDX FROM CL WHERE ClanName='" & clName & "'"
objCommand = New SqlCommand(objQuery, objConn)

Dim IDX As String
objReader = objCommand.ExecuteReader()
If objReader.Read() Then
IDX = objReader.Item(0)
End If
objReader.Close()

objQuery = "INSERT INTO UL ([IDX],[userid],[ChName],[ClanName],[ChType],[ChLv],[Permi],[JoinDate],[DelActive],[PFlag],[KFlag],[MIconCnt]) values('" & IDX & "','" & userid & "','" & chname & "','" & clName & "','" & chtype & "','" & lv & "','0',getdate(),'0','0','0','" & iIMG & "')"
objCommand = New SqlCommand(objQuery, objConn)
objReader = objCommand.ExecuteReader()
objReader.Close()

objConn.Close()

Response.Write("Code=1" & strSplit & "CMoney=500000" & strSplit)
End Sub

</script>
<html>
<head>
</head>
<body>
</body>
</html>

 

[grimske1]

sunny,

ofcourse i configured that
and i did read gzuz's reply but that did not work..

 

[SheenBR]

You need to change IIS Directory Permissions configuration, check out msdn forums, they have good info there. You'd get a better(?) answer there

 

[grimske1]

already tried that 2. is there a clan.dll that works for 64 bit? or how could i change it so it will work?

 

[SunnyZ]

Unsure on 64bit, I use windows xp 32bit

But I used Gregoos DLL generator.
Works perfect with the MPT clan files and server.

You must be registered to see links

Just fill in your SQL server name, user and password
Press generate, chuck the dlls inside your server and you are ready to go.
EG

GRIMSKE1\SQLEXPRESS
sa
grimske1pass

Exactly the same info you filled out in the website side clan files.

 

[bobsobol]

already tried that 2. is there a clan.dll that works for 64 bit? or how could i change it so it will work?

I don't think there is anything special about x64 OS for clan.dll. It's a 32bit library and will only work in 32bit mode, so it's running under the same 32bit VM that the server is.

If you run on anything newer than XP, you hit the same "HKEY_LOCAL_MACHINE" ban for user mode applications (non super) which adds another layer of virtualisation, and when you use .reg files you need to inject your keys into the 32bit VM storage, and not the host OS one as the script is originally distributed.

 

[grimske1]

the server is reinstalled and the dedi is 32 bit now but still error 11.. what could i possible do to fix it?

 

[SunnyZ]

have you enabled TCP/IP connection on the sql server manager?

1. From the Microsoft SQL Server 2005 -> Configuration Tools, open the 'Microsoft SQL Server Configuration Manager'.
2. Expand ‘SQL Server 2005 Network Configuration’, and then click ‘Protocols for <Instance Name>’.
   <Instance Name> is the name of the instance of Microsoft SQL Express being used by the GFI product.
3. Right-click ‘TCP/IP’ and then click ‘Enable’. The icon for the protocol will change to show that the protocol is enabled.

 

[grimske1]

i also did that i double checked if i did that right.

 

[Vormav]

On 64bit machine your configuration should be in:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\PristonTale\GameServer

not HKEY_LOCAL_MACHINE\SOFTWARE\PristonTale\GameServer


Btw, on first SS you showing that you can't access page, I think that's the problem here. PT need to execute it.

 

[SunnyZ]

Seemed to have fixed it somehow.

No idea how though XD

Just tried a random combination of different website clan files got it running eventually...
Mainly had something to do with the "clanInsert.aspx" for clan error 11.
And then "clanRemove.asp" for the error 26 that appeared when trying to delete clan.

Gonna try look into this, the same files that worked for me, only half worked for him, the dll generator made by gregoo did not allow access to login to the server. However it did for me. No idea why.

Anyway things seem to be alright now for this user.

 

[grimske1]

@SunnyZ thanks for helping me so much