Database Schema Creation Failed

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.

Author	Message
shulemj	Posted Wed 22 Jun 2016
Supreme Being Group: Forum Members Last Active: Thu 11 Jul 2019 Posts: 115, Visits: 565 51,415	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. Tags Connection String, database, setup
	REPLY QUOTE LIKE 290
shulemj	Posted Wed 22 Jun 2016
Supreme Being Group: Forum Members Last Active: Thu 11 Jul 2019 Posts: 115, Visits: 565 51,415	I tried again with "CREATE SAMPLE DATA" checked, and got the following: Error: Database Sample Creation Failed - Invalid object name 'tblKartrisLanguageElements'. Meanwhile the database is still completely empty. Then, I tried again with the aforementioned option unchecked, and got this: Error: Database Schema Creation Failed - Object reference not set to an instance of an object. Tags database, setup
	REPLY QUOTE LIKE 266
Vincent	Posted Fri 24 Jun 2016
Supreme Being Group: Forum Members Last Active: Thu 13 Oct 2016 Posts: 14, Visits: 116 7,134	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 Edited Fri 24 Jun 2016 by Vincent
	REPLY QUOTE LIKE 286
shulemj	Posted Sat 25 Jun 2016
Supreme Being Group: Forum Members Last Active: Thu 11 Jul 2019 Posts: 115, Visits: 565 51,415	Thank you so much, Vincent. That helped. However, now I have new issues... First the wizard told me to paste another web.config file onto the server due to permission issues. I did. Now, where ever I browse, the error shows: Error: Kartris is already installed. I found Topic 2033, but and find <globalization resourceProviderFactoryType="SqlResourceProviderFactory" /> in my web.config, but removing it didn't help. Any suggestions? Tags Setup Routine, web.config
	REPLY QUOTE LIKE 271
Tiggywiggler	Posted Sat 25 Jun 2016
Supreme Being Group: Forum Members Last Active: Mon 6 Dec 2021 Posts: 235, Visits: 750 105,152	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. Edited Sat 25 Jun 2016 by Tiggywiggler
	REPLY QUOTE LIKE 288

Database Schema Creation Failed

Database Schema Creation Failed

Similar Topics

Reading This Topic