an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > Installation > Error with SQL server 2008
Last Post 11/3/2008 6:55:00 PM By lukezy. 9 replies.
9/27/2008 8:24:31 AM
oyoon
Posts: 8
Joined: 9/26/2008
Error with SQL server 2008
Hi,
 
I tried to install the DotShoppingcart against sql 2008 and got an error message below. I don't have any issues with SQL 2005 on xp except site not working on IIS.
 
Msg 547, Level 16, State 1, Server WIN2K3, Line 569
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_DSC_Att
ribute_DSC_Selection_Type_DisplayControl_Map". The conflict occurred in database
 "dotshoppingcart", table "dbo.DSC_Selection_Type_DisplayControl_Map", column 's
electionTypeDisplayControlId'.
 
Did I miss any steps to install the product?
 
Thanks
 
 
9/27/2008 10:01:07 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Error with SQL server 2008
I don't see any reaosn it works in SQL server 2005 but not in SQL server 2008. Try it again from scratch. If it happens again, please post back what's in line 569.
DotShoppingCart Staff
9/28/2008 6:40:03 PM
oyoon
Posts: 8
Joined: 9/26/2008
Re: Error with SQL server 2008
Hi ,
 
I removed the demo data and it was installed successfully. but I got an another error below.
 
-----------------------------------
Server Error in '/' Application.
--------------------------------------------------------------------------------
Sequence contains no elements
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: Sequence contains no elements
Source Error:

Line 65:                 DbDataReader reader = (DbDataReader)db.ExecuteReader(cmd);
Line 66:                 IEnumerable<Block> blocks = DBController.GetDataContext().Translate<Block>(reader);
Line 67:                 block = blocks.Single();
Line 68:                 Utils.Cache.Insert(cacheKey, block, dep);
Line 69:             } else {
 
Source File: C:\DotShoppingCartOpenSourceV2\Core\DBO\Block.cs    Line: 67
Stack Trace:

[InvalidOperationException: Sequence contains no elements]
   System.Linq.Enumerable.Single(IEnumerable`1 source) +315
   DotShoppingCart.OpenSource.Core.Block.GetByName(String name) in C:\DotShoppingCartOpenSourceV2\Core\DBO\Block.cs:67
   site.Page_Load(Object sender, EventArgs e) in c:\DotShoppingCartOpenSourceV2\web\site.master.cs:55
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
 
 
---------------------------------=--
 
Could you help me to install the web program work?
 
Ta
 
 
9/28/2008 6:57:53 PM
oyoon
Posts: 8
Joined: 9/26/2008
Re: Error with SQL server 2008
During running instDSC.exe I got an error as well below in Command window.
 
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Unspecified error.
 
Thanks
9/28/2008 7:46:18 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Error with SQL server 2008
It's probably the root cause of your issue. InstDSC.exe calls sqlcmd to create the database. Try running the sqlcmd in your command window directly and check what error message you get.
 
DotShoppingCart Staff
9/28/2008 9:10:31 PM
oyoon
Posts: 8
Joined: 9/26/2008
Re: Error with SQL server 2008
Hi,
 
I don't have any error message with SQL2k5 but I've got a new error message.
 
Current systems
win2k
sql2k5 (instanace name: {machine name} \sql2005)
.framework 2
.framework 3
.framework 3.5
all framework has latest service packs installed.
 
dotshoppingcart installed with demo data without any problem.
the web site doesn't have its own virtual folder but it is on port 80 root.
 
if I browse the site, I got
'internet browser cannot display the web page and If I debug it with vs2008, I've got key not found exception error. Key is installed in c:\key folder and its entry exists in web.config file.
 
thanks
 
9/28/2008 9:31:05 PM
oyoon
Posts: 8
Joined: 9/26/2008
Re: Error with SQL server 2008
Finally figured out the problem.
 
I installed the web application with a fresh copy against SQL 2005 and it is up and running fine.
 
Ta
10/20/2008 7:36:26 PM
demagogue
Posts: 2
Joined: 5/27/2008
Re: Error with SQL server 2008
So what I see is several people tried to install DotShoppingCart using SQL 2008 as a back end, they all failed, and the final solution is to not use SQL 2008?  I would expect a different answer, say for example, how to configure SQL 2008 in a way that allows DotShoppingCart to install.  I too have the same failures during a plain Jane install, which complain about foreign key violations.  Is there an answer for SQL 2008 installations?
10/20/2008 10:02:10 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Error with SQL server 2008
Ok, it seems that SQL server 2008 is an issue. We will investigate this.
DotShoppingCart Staff
11/3/2008 6:55:00 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Error with SQL server 2008
Ok, the issue has been fixed. Please go ahead and download the new zip file.
DotShoppingCart Staff