→ 🚀Are you a Lansweeper Champion?! Join our Contributor Program Sign up here!

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
mali
Engaged Sweeper
Followed the 3.5 upgrade instructions, but now the web console doesnt work.
The following error is displayed :
Exception Details: System.ArgumentException: Column 'nonactive' does not belong to table theTable

The errorlog.txt is attached.
8 REPLIES 8
mali
Engaged Sweeper
Yes. the web console now comes up OK.
Thanks for your help.

Hemoco
Lansweeper Alumni
Ok, were you able to browse the website afterwards?
mali
Engaged Sweeper
OK, ran upgradedatabase32to35.sql from the native SQL console
The output messages are in the attached.
mali
Engaged Sweeper
I had already done this, but I stopped the Lansweeper service and executed it agian.
it returned "There is already an object named 'TsysConfig' in the database"
and the web console still doesnt work.

BTW, do I need to reenter the premium reg code after upgrading ?
Hemoco
Lansweeper Alumni
mali wrote:
I had already done this, but I stopped the Lansweeper service and executed it agian.
it returned "There is already an object named 'TsysConfig' in the database"
and the web console still doesnt work.
BTW, do I need to reenter the premium reg code after upgrading ?


Did you do this from the console that came with SQLserver.
Please use this one instead of the one used by lansweeper.

Send me a screenshot of the output afterwards.
Hemoco
Lansweeper Alumni
Sorry mail, you need to run the script : upgradedatabase32to35.sql found in the upgrade35.zip file
mali
Engaged Sweeper
C:\Program Files\Microsoft SQL Server\MSSQL\Install\Upgrade.sql attached
Hemoco
Lansweeper Alumni
Hi,

Could you please try to rerun the sql upgradescript from the sql management console please (the one that came with sqlserver)

There were similar problems when the upgradescript timed out in the sqlconsole that came with Lansweeper