|
Group: Forum Members
Last Active: Wed 10 Nov 2010
Posts: 1,
Visits: 3
|
When i try to load the home page just after installing on a shared host it shows "Error! An error occurred. The system has written a log file entry."
Here is the error log entry...
System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.spKartrisBasketValues_GetItems'.
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(TdsParserStateObject stateObj)
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 kartrisBasketDataTableAdapters.BasketValuesTblAdptr.GetItems(Nullable`1 intLanguageID, Nullable`1 intSessionID)
at BasketBLL.LoadBasketItems()
at Templates_BasketView.LoadBasket()
at Templates_BasketView.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
==============================================
|
|
Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806,
Visits: 2,737
|
That suggests that the database was not properly created.
Can you open it up with SQL Management Studio and then see if there are any tables and stored procedures inside it? Possibly the db setup script halted or timed out half way, so some parts of the db are missing.
In that case, you can create it this way.... the SQL setup script is located in the kartris zip here:
Uploads\resources\kartrisSQL_MainData.sql
Open this up in notepad and copy the entire contents to a new query in SQL Management Studio. Then run this against the database your host has provided. It will take a few seconds or up to a minute. At the end it should say that it was completed successfully.
Next, go through the setup process again. You will probably need to restore the original web.config file from the zip to get this to fire up.
When it asks for db, enter the details, but tell it to use an existing db. It should recognize that the db already contains the data required for kartris and use that rather than try to recreate it.
Make a note of the admin password, as this is created randomly during the setup.
If all goes well, at the end you should have a working kartris install.
--
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
|