I am having a problem, I think I know somewhat how it was caused, but I can't figure out how to fix it.
I am running version 05.01.04 (3)
With NBstore version 01.02.02
To give the site the look and fill I needed, I added pages and loaded NB_Store_ProductList Module on each page. Set The default Category for each page, Templates, .... and then my mistake, I checked the "Index Module" under "Other Settings." Starting out small, I didn't have the search module loaded on the site. In time the site grew to just under 25 pages and over 500 items with many items showing on multiple categories. I installed the search module and saw my error.
The system indexed each instance of NB_Store_ProductList and did not limit it to just the default categories assigned to the page like I thought, but the entire list of products and I think under each category. There are over 600,000 items in the SearchItemWordPosition table. I have been up to the NB_Store forum and they pointed me to
I followed each step and got the error
System.Data.SqlClient.SqlException: The transaction log for database 'MyDataBase' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) delete dbo.SearchItemWordPosition delete dbo.SearchItemWord delete dbo.SearchWord delete dbo.SearchItem
I have been working with the support at my provider and they have cleared the log. Then repeat the steps to re-index only to get the same error. The size of the SearchItemWordPosition table does go down each time by a couple of thousand but this rate it will take about one year to clear this up.
Any ideas
Thanks
Tom