new release 3.5.2 problems with user detail pane

[lemaitrem]

Dear,

i have received your trial key and it work fine,
since that,
i updated from 3.5.0 to 3.5.1 and finaly to your beta 3.5.2

i found a litle problem when i use "user detail pane"

on the top of the windows,
i receive this error messages
System.Data.SqlClient.SqlException: EXECUTE permission denied on object 'Web30searchuserlogon', database 'lansweeperdb', owner 'dbo'.
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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable)
at DreamweaverCtrls.DataSet.DoInit()

could you help me or is it a beta error


thank you for your help
Marc

[lemaitrem]

thank's support

i'll find that table and only change the execute permission for that table to the lansweeper user and it works fine

have a good week end

[lemaitrem]

how can i correct this?
i rerun the sql request it gave me some duplicate fileds and the rest is complete and ok

other error,
the key you gave me was valid until 29/072009
but after the upgrade, it was reduce to 15/07/2009

[Hemoco]

how can i correct this?
i rerun the sql request it gave me some duplicate fileds and the rest is complete and ok

First try to delete the Web30searchuserlogon from the database and then rerun the script

the key you gave me was valid until 29/072009
but after the upgrade, it was reduce to 15/07/2009

Your end date is 15/7.

Before the beta it showed enddate + 14 days.
Now it shows the correct date (15/7) and when you reach this date it will show another 25 extra days.

[Hemoco]

This part is from 3.5.1

Most likely you upgraded the database with a different user and the user running the sql/webconsole (lansweeperuser) doesn't have the correct permissions on the newly created objects (like web30searchuserlogon)