Database Schema Creation Failed Home » Kartris ASP.NET Ecommerce Software » Kartris technical issues https://forum.kartris.com/Topic6560.aspx

Print Topic | Close Window

By shulemj - Wed 22 Jun 2016 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. By shulemj - Wed 22 Jun 2016 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. By Vincent - Fri 24 Jun 2016 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 By shulemj - Sat 25 Jun 2016 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? By Tiggywiggler - Sat 25 Jun 2016 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.