[Help] failed with error code 5 SQL

please someone help me
------------------------------------------

Quote:

---

---

Quote:

---

--- Log started at Sun Aug 31 17:50:47 2014000000.000| Input Devices enabled: Mouse, Keyboard
000000.042| VMEM As seen through DDRaw: 978
000000.042| VMEM As seen through WMI: 0
000000.061| We have 3790 MB texture memory
000000.061| r3dFont: Creating Verdana 10pt
000000.062| r3dFont: Finished creating Verdana 10pt
000000.062| r3dFont: Creating Tahoma 12pt
000000.063| r3dFont: Finished creating Tahoma 12pt
000000.063| r3dFont: Creating Tahoma 10pt
000000.063| r3dFont: Finished creating Tahoma 10pt
000000.063| r3dFont: Creating Tahoma 9pt
000000.063| r3dFont: Finished creating Tahoma 9pt
000000.342| Starting updater, v:1.0.0, cmd:
000000.343| Checking for new updater
000000.654| Checking for new updater - finished
000032.833| WO_API: failed with error code 5 SQL Select Failed: Procedure or function 'WZ_ACCOUNT_CREATE' expects parameter '@in_ReferralID', which was not supplied.
000035.158| Requested to stop, 0 files in queue
000035.158| CUpdater::Stop()

---

check sql user name and passwords are right

not SQL and I already guessed what it was, was in api

Quote:

---

using System;using System.Collections.Generic;
using System.Collections.Specialized;
using System.Data;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;


public partial class api_AccRegister : WOApiWebPage
{
protected override void Execute()
{
SqlCommand sqcmd = new SqlCommand();
sqcmd.CommandType = CommandType.StoredProcedure;
sqcmd.CommandText = "WZ_ACCOUNT_CREATE";
sqcmd.Parameters.AddWithValue("@in_IP", LastIP);
sqcmd.Parameters.AddWithValue("@in_EMail", web.Param("username")); // login name from updater
sqcmd.Parameters.AddWithValue("@in_Password", web.Param("password"));
sqcmd.Parameters.AddWithValue("@in_SerialKey", web.Param("serial"));
sqcmd.Parameters.AddWithValue("@in_SerialEmail", web.Param("email")); // email used in serial key purchase


if (!CallWOApi(sqcmd))
return;


reader.Read();
int CustomerID = getInt("CustomerID");


Response.Write("WO_0");
Response.Write(string.Format("{0}", CustomerID));
}
}

---

was missing this aki

Quote:

---

using System;
using System.Collections.Generic;
using System.Collections.Specialized;
using System.Data;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;


public partial class api_AccRegister : WOApiWebPage
{
protected override void Execute()
{
SqlCommand sqcmd = new SqlCommand();
sqcmd.CommandType = CommandType.StoredProcedure;
sqcmd.CommandText = "WZ_ACCOUNT_CREATE";
sqcmd.Parameters.AddWithValue("@in_IP", LastIP);
sqcmd.Parameters.AddWithValue("@in_EMail", web.Param("username")); // login name from updater
sqcmd.Parameters.AddWithValue("@in_Password", web.Param("password"));
sqcmd.Parameters.AddWithValue("@in_ReferralID", 0);
sqcmd.Parameters.AddWithValue("@in_SerialKey", web.Param("serial"));
sqcmd.Parameters.AddWithValue("@in_SerialEmail", web.Param("email")); // email used in serial key purchase


if (!CallWOApi(sqcmd))
return;


reader.Read();
int CustomerID = getInt("CustomerID");


Response.Write("WO_0");
Response.Write(string.Format("{0}", CustomerID));
}
}

---

thank you

- - - Updated - - -

Now is giving this error

Quote:

---

--- Log started at Sun Aug 31 18:01:19 2014

000000.000| Input Devices enabled: Mouse, Keyboard
000000.040| VMEM As seen through DDRaw: 978
000000.040| VMEM As seen through WMI: 0
000000.058| We have 3790 MB texture memory
000000.059| r3dFont: Creating Verdana 10pt
000000.060| r3dFont: Finished creating Verdana 10pt
000000.060| r3dFont: Creating Tahoma 12pt
000000.060| r3dFont: Finished creating Tahoma 12pt
000000.060| r3dFont: Creating Tahoma 10pt
000000.061| r3dFont: Finished creating Tahoma 10pt
000000.061| r3dFont: Creating Tahoma 9pt
000000.061| r3dFont: Finished creating Tahoma 9pt
000000.334| Starting updater, v:1.0.0, cmd:
000000.335| Checking for new updater
000000.646| Checking for new updater - finished
000019.081| WO_API: failed with error code 5 System.Data.SqlClient.SqlException: Procedure or function WZ_ACCOUNT_LOGIN_EXEC has too many arguments specified.


em System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)


em System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)


em System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)


em System.Data.SqlClient.SqlDataReader.HasMoreRows()


em System.Data.SqlClient.SqlDataReader.HasMoreResults()


em System.Data.SqlClient.SqlDataReader.NextResult()


em WOApiWebPage.CallWOApi(SqlCommand sqcmd)


em api_Login.Execute()


em WOApiWebPage.Page_Load(Object sender, EventArgs _e)
000019.081| Login FAILED, code: 5
000021.516| Requested to stop, 0 files in queue
000021.517| CUpdater::Stop()

---

well good to see u got it sorted :)

Look on this: http://forum.ragezone.com/f792/help-...9/#post8199656

I will try to fix it all, but maybe someone will be faster and release fixes for us.

Quote:

---

Originally Posted by jacubb

Look on this: http://forum.ragezone.com/f792/help-...9/#post8199656

I will try to fix it all, but maybe someone will be faster and release fixes for us.

---

had already solved thank you

Quote:

---

Originally Posted by zombiezinho

had already solved thank you

---

How u solved that? :O

Sorry my english, but can someone help me in this error aki, I'm new so I do not know where to post this, please help me. Thank you


WO_API: failed with error code 5 in ComputerID parameter