SQL query failed INSERT INTO script_library (script_id,script_name,script_code)

Started by moranlan, November 20, 2010, 10:13:42 AM

Previous topic - Next topic

moranlan

When trying to install 1.07 server on a fresh installation of Windows Server 2003 Standard and SQL Server 2005 Standard (x86) I am getting the following error:

SQL query failed:
INSERT INTO script_library (script_id,script_name,script_code)
VALUES (1,'Filter::SNMP','sub_main()' + chr(13)+chr(10) + '{' + chr(13)+chr(10) + '  return #1->isSNMP;' + chr(13)+chr(10) + '}'  + chr(13)+chr(10))

I hope I copied it all correctly by looking at the error.  couldn't find the installation log file to get it from there.

I also tried to install this on a fresh installation of Windows Server 2008 R2 Standard + SQL Server 2008 Standard (x64).  Same error....

The database is being successfully created with many tables, stored procedures, views etc...
Appreciate any help you can offer.

<ML>

Victor Kirhenshtein

Hi!

Please replace file dbinit_mssql.sql with attached one and run nxconfig.exe again. It should initialize database properly.

Best regards,
Victor