problem setting up MSSQL for nGallery

C

clmckinley

Guppy
problem setting up MSSQL for nSurvey

I am attempting to install NSurvey (http://www.nsurvey.org/) under my Silver Windows Account and am having trouble setting up the SQL Server Database.

NSurvey comes as an actuall msi installer and during that installation (which it assumes is run locally) it sets up the database. I tried installing it on my local server and using my jodohost SQLServer but it doesn't have permissions to create a database so that failed.
Another option is that it comes with 3 .SQL files that i imagine can be run to set up the database but i don't know where/how i can run those on my database and again it doesn't have permission to create a database. When i try to run it from the ASP.Net Enterprise Manager I get "A potentially dangerous Request.Form value was detected from the client (sqlstmt="...A. /// <summary> /// Adds ...")."

I put in a support ticket (KPT-29293-914) and eventually got a response that they got a similar "Potentially dangerous" error which tells me they tried to use an ASP.NEt application to run the .SQL Files.


Any Help would be appriciated,
Logan

P.S. I have attached a zip file that contains the three .sql files
 

Attachments

  • SQLScripts.zip
    63.2 KB · Views: 77
You won't be able to create the DB via the install wizard.

I just downloaded the ZIP variant, and it should work fine for you.
 
Ok, I see they don't have anything in the docs folder.

However, the directions on installing from ZIP don't even mention the .sql files, I woudl just upload them and see if it will automatically install any SQL it needs, as many programs do just that.
 
i unzipped the files and put them up to the web but it did not install anything to the database. The original is in "http://www.redflagholdings.com/nSurvey/" and the unzipped files are in "http://www.redflagholdings.com/nSurvey2/".

I really just need the .sql files ran on the database. I can give you modified files that installs everything to the clmckinl_nSurvey. You could also turn off the check that returns the "Potentially dangerious" error.
 
OHHH, You have ngallery in the topic and nsurvey in the writing, I totally missed that, I will look into this first thing in the morning. I will download and see if there is any documentation on the installation.
 
I replied in your ticket this morning, there were some major issues with the SQL script for shared hosting, I would recommend talking to them about it in the forums.
 
They do not have a flexible DB name in the SQL, it references a DB named "nSurvey" continually, this means only one customer can have nSurvey, not shared hosting friendly, it also makes it difficult to import into an existing database.
 
You must log in or register to reply here.
Back
Top