|
Tiggywiggler
|
Posted Thu 19 May 2016
|
|
Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235,
Visits: 750
|
Hello,
Yes, you would have added the "USE ..." bit into the text. Glad you found the solution to your problems though mate.
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.
|
|
|
|
|
Vincent
|
Posted Thu 19 May 2016
|
|
Group: Forum Members
Last Active: Thu 13 Oct 2016
Posts: 14,
Visits: 116
|
Never mind. Apparently I ran the script on the wrong database... /banghead.. Thanks! appreciate your help.
|
|
|
|
|
Vincent
|
Posted Thu 19 May 2016
|
|
Group: Forum Members
Last Active: Thu 13 Oct 2016
Posts: 14,
Visits: 116
|
I went ahead and looked at my MainData.sql and I don't see USE [database name]. Should I just add that to it?
|
|
|
|
|
Tiggywiggler
|
Posted Wed 18 May 2016
|
|
Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235,
Visits: 750
|
That should run just fine mate.
So, this is what I would do just to make sure everything is good:
1. Delete the database that you have now. No sense in messing around if it appears broken as something may be wrong that we will spend hours trying to find.
2. Create a new database from scratch.
2.5. Setup the user accounts etc. as described in the instruction manuals that you have already been using.
3. Open up the kartrisSQL_MainData.sql file from inside Microsoft SQL Server Management Studio (SSMS).
4. At the top of the script that appears type in:
USE [database name]
GO
so if you just create a database called "MyDatabase" you would type in
USE MyDatabase
GO
5. Press the 'Execute' button at the top of the screen in SSMS.
6. Report back if you get any errors.
7. If you do not get any errors, run the Kartris installation again and select "Use Existing Database".
8. It should now work.
I am off to bed now (the other half will kill me if I stay in front of this computer any longer) but if you have another issue I will pick it up in the morning.
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.
|
|
|
|
|
Vincent
|
Posted Wed 18 May 2016
|
|
Group: Forum Members
Last Active: Thu 13 Oct 2016
Posts: 14,
Visits: 116
|
Yes, it already has MS SQL Server Management Studio on a Windows Server 2012 R2 Server. I ran the code on there. Is that why it takes forever?
|
|
|
|
|
Tiggywiggler
|
Posted Wed 18 May 2016
|
|
Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235,
Visits: 750
|
You want to install the SQL Server database on whatever machine is going to host the website.
The reason I ask is that if the SQL Server database is on a remote server (Say a website at a website hosting company) and you are trying to debug the code there, it will take an ice age getting that to kick off.
So...
You have a website on a Windows Server 2012 R2 server, and you are trying to install SQL Server there?
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.
|
|
|
|
|
Vincent
|
Posted Wed 18 May 2016
|
|
Group: Forum Members
Last Active: Thu 13 Oct 2016
Posts: 14,
Visits: 116
|
ah yes, I am hosting the website on Window Server 2012 R2 and I just thought I would create a local website on there too. Are you suggesting that I should do it on my local machine?
|
|
|
|
Tiggywiggler
|
Posted Wed 18 May 2016
|
|
Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235,
Visits: 750
|
The script is normally very fast. Are you running this on a local development machine or a remote system?
If it is remote you could have all sorts of trouble.
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.
|
|
|
|
|
Vincent
|
Posted Wed 18 May 2016
|
|
Group: Forum Members
Last Active: Thu 13 Oct 2016
Posts: 14,
Visits: 116
|
Not sure if I did it correctly. I created a new query and pasted the code in there then started debugging. It has been debugging query for the past 5 minutes so I don't think it works and it could possibly cause a time out.
|
|
|
|
|
Paul
|
Posted Tue 17 May 2016
|
|
Group: Administrators
Last Active: Tue 10 Sep 2024
Posts: 807,
Visits: 2,748
|
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.
--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.
If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
|
|
|
|