Dont appear "add" to basket


https://forum.kartris.com/Topic2514.aspx 		Print Topic | Close Window

By Nirvas - Tue 22 Oct 2013
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)
==================================================
By Paul - Tue 22 Oct 2013
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.
By Neil - Wed 23 Oct 2013
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.


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