an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > Installation > Create DB schema on Local and copy that on the ...
Create DB schema on Local and copy that on the DB of Shared Hosting
Last Post 3/19/2009 2:41:37 PM By lukezy. 6 replies.
3/18/2009 11:07:40 AM
kustefno
Posts: 4
Joined: 3/2/2009
Create DB schema on Local and copy that on the DB of Shared Hosting
 <span class="Apple-style-span" style="border-collapse: collapse; font-family: arial; font-size: 13px; ">USE [DB]
GO
/****** Object:  User [NT AUTHORITY\NETWORK SERVICE]    Script Date:
03/17/2009 16:39:42 ******/
CREATE USER [NT AUTHORITY\NETWORK SERVICE] FOR LOGIN [NT AUTHORITY\NETWORK
SERVICE] WITH DEFAULT_SCHEMA=[DSC_Public]
GO
/****** Object:  User [dynamicCertUser]    Script Date: 03/17/2009 16:39:42
******/
CREATE USER [dynamicCertUser] FOR CERTIFICATE [dynamicCert]
GO
/****** Object:  Schema [DSC_Public]    Script Date: 03/17/2009 16:39:42
******/
CREATE SCHEMA [DSC_Public] AUTHORIZATION [NT AUTHORITY\NETWORK SERVICE]
GO
 
Msg 15259, Level 16, State 1, Line 2
The DEFAULT_SCHEMA clause cannot be used with a Windows group or with
principals mapped to certificates or asymmetric keys.
Msg 15151, Level 16, State 1, Line 2
Cannot find the certificate 'dynamicCert', because it does not exist or you
do not have permission.
Msg 15151, Level 16, State 1, Line 2
Cannot find the user 'NT AUTHORITY\NETWORK SERVICE', because it does not
exist or you do not have permission.
Msg 2759, Level 16, State 0, Line 2
CREATE SCHEMA failed due to previous errors.
 
They never allow me to create new user on DB.
All the users I can get this shared hosting are following.
 
9654.IUSR
dbo
guest
INFORMATION_SCHEMA
sys
 
<img alt="" src="http://ikendogu.com/img/roleschema.jpg" />
 
Please advise
</span>
3/18/2009 12:21:18 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Create DB schema on Local and copy that on the DB of Shared Hosting
Then you cannot use the feature of setting permission at store procedure level. You can simply ingore these errors and grant all the Read/Update/Add/Delete permissions for all tables to the credential that is running app pool.
DotShoppingCart Staff
3/18/2009 2:31:08 PM
kustefno
Posts: 4
Joined: 3/2/2009
Re: Create DB schema on Local and copy that on the DB of Shared Hosting
 
I gave all the permission to the user that I'm able to utilize. Also I set schema owner of DSC_Public to that user.
 
But it still get the error "The given key was not present in the dictionary."
 
Following is the exception.
 
 
System.Collections.Generic.KeyNotFoundException was unhandled
  Message="The given key was not present in the dictionary."
  Source="mscorlib"
  StackTrace:
       at System.ThrowHelper.ThrowKeyNotFoundException()
       at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
       at DotShoppingCart.OpenSource.Core.OrderPipelineProcessor.GetConfiguredProcessors(String host, String orderPipeline)
       at DotShoppingCart.OpenSource.Core.OrderPipelineProcessor.GetAllConfiguredProcessors(String host)
       at DotShoppingCart.OpenSource.OrderPipeline.OrderProcessorProvider.Proccess(String host, IConfigurationSource cfgSrc)
       at DotShoppingCart.OpenSource.OrderPipeline.ProcessorProvider.Run()
       at DotShoppingCart.OpenSource.OrderPipeline.RunnableProvider.StartRun()
       at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Threading.ThreadHelper.ThreadStart()
  InnerException: 
 
3/18/2009 5:39:59 PM
kustefno
Posts: 4
Joined: 3/2/2009
Re: Create DB schema on Local and copy that on the DB of Shared Hosting
  
I found that I didn't copy all the data from those tables.
Now I copied (export and import) all the data.
I've got new error from the code line of default.aspx where it has
 
 dbPage = DbPage.GetByName(pageName);
 
the exception is "System.Data.SqlClient.SqlException was unhandled by user code"
 
Do you have any idea what happened beyond it?
 
3/19/2009 9:29:44 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Create DB schema on Local and copy that on the DB of Shared Hosting
Please post back the complete exception stack.
DotShoppingCart Staff
3/19/2009 2:20:07 PM
kustefno
Posts: 4
Joined: 3/2/2009
Re: Create DB schema on Local and copy that on the DB of Shared Hosting
 
I installed and copied the local file on the server which has testing subdirectory where application runs.
It looks it works but no images and the links are broken. It works on the local but not on the server.
 
Could you check this url out?
 
http://ikendogu.com/dash
 
 
3/19/2009 2:41:37 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Create DB schema on Local and copy that on the DB of Shared Hosting
Looks like the dynamic image http handler doesn't work properly. Check if you have http handler configured in web.config.
DotShoppingCart Staff
Project hosted at CodePlex.com
Copyright © 2013 DotShoppingCart. All rights reserved.