Home Search Tags Members

Home » Kartris ASP.NET Ecommerce Software » Kartris technical issues » Dont appear "add" to basket

Dont appear "add" to basket

Posted By Nirvas Tue 22 Oct 2013
Add to Favorites0

Dont appear "add" to basket

Topic View Topic View Topic Options Topic Options
Author Message
Nirvas
Posted Tue 22 Oct 2013
Supreme Being

Supreme Being - (490 reputation)Supreme Being - (490 reputation)Supreme Being - (490 reputation)Supreme Being - (490 reputation)Supreme Being - (490 reputation)Supreme Being - (490 reputation)Supreme Being - (490 reputation)Supreme Being - (490 reputation)Supreme Being - (490 reputation)

Group: Forum Members
Last Active: Wed 30 Oct 2013
Posts: 1, Visits: 9
490
when a add some product always says "Apologies, this content is currently not accessible.".

i've set 'single version' for the product.


-----------------------------------------------------------------------------
>> CarryOnShopping.Page_Load
-----------------------------------------------------------------------------
>> System.Data.SqlClient.SqlException
>> 22/10/2013 06:46:02
>> Version:2.5005
>> URL:http://teste3.vmatica.com/Product.aspx?ProductID=2&L=1
>> 77.54.196.180
>> CUSTOM MESSAGE:
Database Error: A general error has occurred.
>> NUMBER:4121
>> MESSAGE:
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fnKartrisProduct_IsReadyToLive", or the name is ambiguous.
>> STACK:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at kartrisProductsDataTableAdapters.ProductsTblAdptr.GetRelatedProducts(Nullable`1 P_ID, Nullable`1 LANG_ID, Nullable`1 CG_ID)
at ProductsBLL.GetRelatedProducts(Int32 _ProductID, Int16 _LangaugeID, Int16 _CustomerGroupID)
at CarryOnShopping.LoadRelatedProducts()
at CarryOnShopping.LoadCarryOnShopping(Int32 pProductID, Int16 pLanguageID)
at CarryOnShopping.Page_Load(Object sender, EventArgs e)
==================================================
Post Information
Paul
Posted Tue 22 Oct 2013
große Käse

große Käse - (522,932 reputation)große Käse - (522,932 reputation)große Käse - (522,932 reputation)große Käse - (522,932 reputation)große Käse - (522,932 reputation)große Käse - (522,932 reputation)große Käse - (522,932 reputation)große Käse - (522,932 reputation)große Käse - (522,932 reputation)

Group: Administrators
Last Active: Tue 10 Sep 2024
Posts: 807, Visits: 2,748
If you check your db, do you have this function:

dbo.fnKartrisProduct_IsReadyToLive

Which version of Kartris did you install (the name of the zip). I've not seen this issue, so I don't think there are any issues with the setup scripts.

--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.

If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
Post Information
Neil
Posted Wed 23 Oct 2013
Supreme Being

Supreme Being - (126,823 reputation)Supreme Being - (126,823 reputation)Supreme Being - (126,823 reputation)Supreme Being - (126,823 reputation)Supreme Being - (126,823 reputation)Supreme Being - (126,823 reputation)Supreme Being - (126,823 reputation)Supreme Being - (126,823 reputation)Supreme Being - (126,823 reputation)

Group: Forum Members
Last Active: Sat 3 Nov 2018
Posts: 192, Visits: 5,220
Not sure if directly related but I set up a new v2.5005 site last week and noticed the error logs are full of the following,


-----------------------------------------------------------------------------
>>    CarryOnShopping.Page_Load
-----------------------------------------------------------------------------
>>    System.Data.SqlClient.SqlException
>>    23/10/2013 00:00:26
>>     Version:2.5005
>>     URL:http://www.djgoldmine.co.uk/Product.aspx?ProductID=232&CategoryID=2&L=1
>>    66.249.66.134
>>    CUSTOM MESSAGE:
Database Error: A general error has occurred.
>>    NUMBER:4121
>>    MESSAGE:
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fnKartrisProduct_IsReadyToLive", or the name is ambiguous.
>>    STACK:
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at kartrisProductsDataTableAdapters.ProductsTblAdptr.GetRelatedProducts(Nullable`1 P_ID, Nullable`1 LANG_ID, Nullable`1 CG_ID)
   at ProductsBLL.GetRelatedProducts(Int32 _ProductID, Int16 _LangaugeID, Int16 _CustomerGroupID)
   at CarryOnShopping.LoadRelatedProducts()
   at CarryOnShopping.LoadCarryOnShopping(Int32 pProductID, Int16 pLanguageID)
   at CarryOnShopping.Page_Load(Object sender, EventArgs e)
==================================================


In the database this function was not named correctly and was the format

{dbusername}.fnKartrisProduct_IsReadyToLive

not

dbo.fnKartrisProduct_IsReadyToLive

I re-created this function with the correct name and no longer see this error.
Post Information

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top

Powered By InstantForum.NET 2012-1 © 2024
Execution: 0.031. 7 queries. Compression Enabled.