HomeHome Product Discus... Product Discus...Payment Registr...Payment Registr...Module not working after re-installModule not working after re-install
Previous
 
Next
New Post
3/4/2012 12:09 AM
 
brett
No Ranking

Joined: 1/30/2012
Posts: 19

I attempted to uninstall everything in order to try again from a clean start.

When installiing the module I get

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'InvoiceNo' in table 'dbo.Smith_RegPayhist' is specified more than once. 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) ALTER TABLE dbo.Smith_RegPayhist ADD InvoiceNo varchar(20) Default('') Null

And its still DNN 5.07.07 and Smith Reg Pro 4.34.

 

 

 
 
New Post
3/5/2012 2:02 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0

Hi Brett,

The reason the install failed was because all of the remaining tables had not been completely uninstalled from your site.

Please do the following to get the RegPro module up and running again:

1. From the dnn->host menu uninstall all Smith modules. Make sure you check the delete files box when you uninstall.

2. Confirm the following tables and stored procs with a prefix of Smith in your database are deleted:

  • Smith_AuthorizeNetLog
  • Smith_Country
  • Smith_EmailTemplate
  • Smith_PageTemplate
  • Smith_RegCoupons
  • Smith_RegCustomer
  • Smith_RegPayHist
  • Smith_RegProducts
  • Smith_RegSerialNumbers
  • Smith_RegSettings
  • Smith_RegTheme
  • Smith_State
  • Smith_Subscription
  • etc.



3. Confirm that all Smith folders in /desktopmodules are deleted and the folder is removed

4. Install the latest module

5. Configure the settings and test

Thanks,
 
New Post
3/5/2012 6:09 PM
 
brett
No Ranking

Joined: 1/30/2012
Posts: 19

My site is in a shared environment and I dont know SQL well enough to discover the syntax for discovering the names of all your tables and store procedures and then deleting them.
 
New Post
3/5/2012 6:57 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0

Hi Brett,

If you have SQL Mgmt Studio its pretty easy to delete all the tables and sprocs without a script. 

Steps as follows:

  1. From the view menu in SQL Mgmt Studio select "Object Explorer Details"
  2. Select the "tables" folder
  3. All the Smith tables and sprocs have a prefix of "Smith" so if you click on the table name column heading it will sort all the Smith objects together.
  4. Scroll down to the first table with a prefix of "Smith" and click once on the table
  5. Scoll down to the last table with a prefix of "Smith" and "shift-click".  All the tables will now be highlighted.
  6. Press the delete key to delete all the tables
  7. Repeat steps above for the sprocs

Its the same concept as file explorer in windows if you need to delete a group of files.
 
New Post
3/5/2012 7:00 PM
 
brett
No Ranking

Joined: 1/30/2012
Posts: 19

Yeah, it's a shared environment, so SQL Managment Studio cant be installed on it.
If I had a stand alone box, or VM, it would be different, but that's not the case.
 
New Post
3/5/2012 8:01 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0
Hi Brett,

Here are some scripts to remove all smith tables and stored procedures, so you don't have to do it manually:

Remove all tables

DECLARE @SQL VARCHAR(1000)
DECLARE @tempName VARCHAR(1000)
DECLARE @count VARCHAR(1000)
select @count = COUNT(*) from dbo.sysobjects where type = 'U' and name like 'smith%'
while @count > 0
Begin
Select @tempName = name from dbo.sysobjects where type = 'U' and name like 'smith%'
exec('drop table ' + @tempName)
set @count = @count - 1
END

Remove all Stored Procs

DECLARE @SQL VARCHAR(1000)
DECLARE @tempName VARCHAR(1000)
DECLARE @count VARCHAR(1000)
select @count = COUNT(*) from dbo.sysobjects where type = 'p' and name like 'smith%'
while @count > 0
Begin
Select @tempName = name from dbo.sysobjects where type = 'p' and name like 'smith%'
exec('drop procedure ' + @tempName)
set @count = @count - 1
END

Thanks,
 
New Post
3/6/2012 1:30 AM
 
brett
No Ranking

Joined: 1/30/2012
Posts: 19

That was really helpful!

And it fixed the problem

Thanks
 
New Post
3/8/2012 12:44 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0
Hi Brett,

Glad I could help!
 
 Page 1 of 1
Previous
 
Next
HomeHome Product Discus... Product Discus...Payment Registr...Payment Registr...Module not working after re-installModule not working after re-install




Questions? Contact us for answers!

Contact Us!