Database Schema Creation Failed

Posted By shulemj Wed 22 Jun 2016
Add to Favorites1
Author Message
shulemj
 Posted Wed 22 Jun 2016
Supreme Being

Supreme Being - (58,863 reputation)Supreme Being - (58,863 reputation)Supreme Being - (58,863 reputation)Supreme Being - (58,863 reputation)Supreme Being - (58,863 reputation)Supreme Being - (58,863 reputation)Supreme Being - (58,863 reputation)Supreme Being - (58,863 reputation)Supreme Being - (58,863 reputation)

Group: Forum Members
Last Active: Thu 11 Jul 2019
Posts: 115, Visits: 565
I'm in the process of creating a new Kartris site. I'm getting the following error in step 3 (Connection String) on Install.aspx:
Error: Database Schema Creation Failed - Incorrect syntax near 'GO'.
I'm using the "USE AN EXISTING DATABASE" option (in appose to creating a new database), and the database is created.

I'm using a manual username and password (in appose to "Use Windows Authentication").

Where do I go from here? Any help would be greatly appreciated.
Vincent Marked As Answer
 Posted Fri 24 Jun 2016
Supreme Being

Supreme Being - (8,132 reputation)Supreme Being - (8,132 reputation)Supreme Being - (8,132 reputation)Supreme Being - (8,132 reputation)Supreme Being - (8,132 reputation)Supreme Being - (8,132 reputation)Supreme Being - (8,132 reputation)Supreme Being - (8,132 reputation)Supreme Being - (8,132 reputation)

Group: Forum Members
Last Active: Thu 13 Oct 2016
Posts: 14, Visits: 116
I had that problem before and I posted it in other thread. Here is what tech support said:

Possibly a timeout - could try opening the SQL maindata script (Uploads/Resources/) and then copying to a new query window in SQL Management Studio and running... see if that works. If it does, when you run the install and enter that db, it should find that the db already has the required data.

It works for me. You can find my post under Kartris suggestions -> Kartris Installation. I know it is in wrong place. I thought I posted it here... #newbie
Fri 24 Jun 2016 by Vincent
Tiggywiggler Marked As Answer
 Posted Sat 25 Jun 2016
Supreme Being

Supreme Being - (120,540 reputation)Supreme Being - (120,540 reputation)Supreme Being - (120,540 reputation)Supreme Being - (120,540 reputation)Supreme Being - (120,540 reputation)Supreme Being - (120,540 reputation)Supreme Being - (120,540 reputation)Supreme Being - (120,540 reputation)Supreme Being - (120,540 reputation)

Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235, Visits: 750
Shulemj,

Your first few posts point to an authentication error on SQL Server.

The error you are getting (Kartris is already installed.) occurs because the database has an admin login account for you. This means that you have already made it to the final step of the setup and have created an account to login in to the shop's backend.

you can check this by opening up the table "tblKartrisLogins" and seeing what values are in there at present. You will see a record in there.

If you have forgotten the password of think this is a mistake the best solution is to simply delete this database and create it from fresh using the guidance from Vincent. This way you can be sure that the data is clean.


We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either
1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx.
2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx.

Have fun and good luck coding.
Sat 25 Jun 2016 by Tiggywiggler

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top