This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Community FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Website SQL error

dsch
Engaged Sweeper

‎04-20-2010 11:08 AM

I just updated lansweeper to version 4, and in the setup i was only able to chose update database + config or something like this. I definitly wasn't able to check "website". And this looks like to be my problem at this point.
When i open the website i get this:

System.Data.SqlClient.SqlException: Invalid column name 'version'. 
bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) 
bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) 
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 
bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) 
bei System.Data.SqlClient.SqlDataReader.ConsumeMetaData() 
bei System.Data.SqlClient.SqlDataReader.get_MetaData() 
bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) 
bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) 
bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) 
bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 
bei System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 
bei System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) 
bei System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 
bei System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 
bei System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 
bei System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable) 
bei DreamweaverCtrls.DataSet.DoInit()
--------------------------------------------------------------------------------
System.Data.SqlClient.SqlException: Invalid column name 'version'. 
bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) 
bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) 
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 
bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) 
bei System.Data.SqlClient.SqlDataReader.ConsumeMetaData() 
bei System.Data.SqlClient.SqlDataReader.get_MetaData() 
bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) 
bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) 
bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) 
bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 
bei System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 
bei System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) 
bei System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 
bei System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 
bei System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 
bei System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable) 
bei DreamweaverCtrls.DataSet.DoInit()
--------------------------------------------------------------------------------
System.Exception: The DefaultView was requested but no tables yet exist. 
bei DreamweaverCtrls.DataSet.get_DefaultView()
--------------------------------------------------------------------------------
System.Data.SqlClient.SqlException: Invalid column name 'version'. 
bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) 
bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) 
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 
bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) 
bei System.Data.SqlClient.SqlDataReader.ConsumeMetaData() 
bei System.Data.SqlClient.SqlDataReader.get_MetaData() 
bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) 
bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) 
bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) 
bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 
bei System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 
bei System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) 
bei System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 
bei System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 
bei System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 
bei System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable) 
bei DreamweaverCtrls.DataSet.DoInit()
--------------------------------------------------------------------------------
System.Exception: The DefaultView was requested but no tables yet exist. 
bei DreamweaverCtrls.DataSet.get_DefaultView()


Any ideas ? FYI - i moved the lansweeper website to another folder (months ago), is there a way to update it manually (if this is the problem) ?
Labels:
0 Kudos
2 REPLIES 2
dsch
Engaged Sweeper

‎04-20-2010 01:45 PM

great, thank you. everything is finally working 🙂
0 Kudos
Hemoco
Lansweeper Alumni

‎04-20-2010 01:20 PM

dsch wrote:
Any ideas ? FYI - i moved the lansweeper website to another folder (months ago), is there a way to update it manually (if this is the problem)

The setup can't find the website.
If the database and service are upgraded ok you can run the setup again, choose "new installation" and only install the website.
0 Kudos

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now