[Help] failed with error code 5 SQL
please someone help me
------------------------------------------
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()
Re: [Help] failed with error code 5 SQL
check sql user name and passwords are right
Re: [Help] failed with error code 5 SQL
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()
Re: [Help] failed with error code 5 SQL
well good to see u got it sorted :)
Re: [Help] failed with error code 5 SQL
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.
Re: [Help] failed with error code 5 SQL
Quote:
Originally Posted by
jacubb
had already solved thank you
Re: [Help] failed with error code 5 SQL
Quote:
Originally Posted by
zombiezinho
had already solved thank you
How u solved that? :O
Re: [Help] failed with error code 5 SQL
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