an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > Installation > Another install problem
Last Post 3/3/2008 4:48:01 PM By Dan. 7 replies.
3/3/2008 1:06:09 PM
Dan
Posts: 8
Joined: 4/23/2008
Another install problem

I too had an installation problem similar to the previous thread that was caused by me manually creating the database before running InstDSC.exe.

I got past that problem but it failed again when trying to load demo data because CreateDemoStore.sql could not be found.I was able to start the site but it acts a little strangely--sometimes I can enable the page editor, other times I cannot (even though I am logged in as admin).  The home page has no content at all on it.  Is this normal or was that a result of the installation problems?

3/3/2008 1:21:03 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Another install problem

I guess you guys didn't read readme.txt file. The beta doesn't have the demo data. Try using "/nodemo" when launching InstDSC.exe.

2) Go to "Install" sub-directory of the unzipped directory and run "InstDSC.exe <database server name> <database name> <database data file path> <encryption key path> [<smtp email server>] [<system email address>]"
For example, "InstDSC.exe <font style="background-color: #ffff00">/nodemo .\SQLExpress dotshoppingcart c:\dbdata c:\key mail.yourserver.com system@yourdomain.com"

DotShoppingCart Staff
3/3/2008 1:57:42 PM
Dan
Posts: 8
Joined: 4/23/2008
Re: Another install problem

I sure did and it says absolutely nothing about demo data not being included.  It says "For example", not "Required".

Here is the entire Readme file.  Where exactly does it say "no demo data"?

<font style="background-color: #ccffff">Installation

<font style="background-color: #ccffff">Prerequistes:
1) Install Windows 2003 Server with IIS 6.0 enabled
Running XP with IIS5 doesn't work for all the features. Suggest use Visual Studio and its native web server on XP or Vista.

<font style="background-color: #ccffff">2) Install Microsft SQL Server 2005
You could get the free version "Microsoft SQL Server 2005 Express Edition with Advanced Services". Download from <font style="background-color: #ccffff">http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en<font style="background-color: #ccffff"> .
Make sure you install the all the features including Full-Text Search and Client Components.

<font style="background-color: #ccffff">3) Install ASP.Net 3.5
<font style="background-color: #ccffff">http://www.microsoft.com/downloads/details.aspx?FamilyID=333325FD-AE52-4E35-B531-508D977D32A6&displaylang=en

<font style="background-color: #ccffff">Installation:
1) Unzip files into a local directory on your server

<font style="background-color: #ccffff">2) Go to "Install" sub-directory of the unzipped directory and run "InstDSC.exe <database server name> <database name> <database data file path> <encryption key path> [<smtp email server>] [<system email address>]"
<font style="background-color: #00ff00">For example, "InstDSC.exe /nodemo .\SQLExpress dotshoppingcart c:\dbdata c:\key mail.yourserver.com <font style="background-color: #ccffff">system@yourdomain.com<font style="background-color: #ccffff">"

<font style="background-color: #ccffff">3) Configure IIS and point the site or virtual directory to Web subdirectory

<font style="background-color: #ccffff">4) Grant the write permission of Web\DSC.config to "NT AUTHORITY\NETWORK SERVICE".

<font style="background-color: #ccffff">Our website is at <font style="background-color: #ccffff">http://www.dotshoppingcart.com<font style="background-color: #ccffff"> and you can find more information such as features, demo, documents etc. Our support forums are at <font style="background-color: #ccffff">http://support.dotshoppingcart.com/forums

3/3/2008 2:22:01 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Another install problem

Ah, maybe you are right. I guess it's the bad words.<img alt="" src="/Forums/Providers/HtmlEditorProviders/Fck/FCKeditor/editor/images/smiley/msn/regular_smile.gif" />

Did you get your problem solved if using "/nodemo"?

DotShoppingCart Staff
3/3/2008 2:46:25 PM
Dan
Posts: 8
Joined: 4/23/2008
Re: Another install problem

I haven't tried /nodemo yet but I can hit the site...I just get the quirky behavior I described earlier.  I manually edited the web.config after the database was created and it appears to work.

 

I will reinstall using /nodemo and see if anything changes.

3/3/2008 3:28:21 PM
Dan
Posts: 8
Joined: 4/23/2008
Re: Another install problem

The install went well but when I hit the site I get this error:

<font style="background-color: #ffff99">The SELECT permission was denied on the object 'DSC_Block_Type_lkp', database 'dsc3', schema 'dbo'.

3/3/2008 3:37:26 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Another install problem

Ah, the CREATEDB.SQL is missing the following lines. Try running this manually.

GRANT DELETE, INSERT, SELECT, UPDATE ON dbo.DSC_Block TO [DSC_Public]
GRANT DELETE, INSERT, SELECT, UPDATE ON dbo.DSC_Block_Type_Group TO [DSC_Public]
GRANT DELETE, INSERT, SELECT, UPDATE ON dbo.DSC_Block_Type_Group_Block_Type_Map TO [DSC_Public]
GRANT DELETE, INSERT, SELECT, UPDATE ON dbo.DSC_Block_Type_lkp TO [DSC_Public]
GRANT DELETE, INSERT, SELECT, UPDATE ON dbo.DSC_BlockContainer_Template TO [DSC_Public]
GRANT DELETE, INSERT, SELECT, UPDATE ON dbo.DSC_Block_Reference TO [DSC_Public]
GRANT DELETE, INSERT, SELECT, UPDATE ON dbo.DSC_Page TO [DSC_Public]

DotShoppingCart Staff
3/3/2008 4:48:01 PM
Dan
Posts: 8
Joined: 4/23/2008
Re: Another install problem

Thanks Luke, that does the trick.

So far things look okay.  I haven't had time to add any content yet but I'll start another thread if I run into anything.