• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

3 Pages<123>
Noah
#21 Posted : Tuesday, March 4, 2008 8:37:55 PM(UTC)
Noah

Rank: Member

Joined: 11/6/2003(UTC)
Posts: 1,903

That error is from still not being able to connect to the DB.
Noah
Andy Miller
#22 Posted : Tuesday, March 4, 2008 11:12:37 PM(UTC)
Andy Miller

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 2,136

Was thanked: 1 time(s) in 1 post(s)
...or something is missing from the db like a stored procedure.
Andy Miller
Structured Solutions

Shipper 3 - High Velocity Shipment Processing
emunah
#23 Posted : Wednesday, March 5, 2008 5:13:57 PM(UTC)
emunah

Rank: Member

Joined: 2/25/2008(UTC)
Posts: 111

This is my web config file can anyone determine if there is something wrong here?
<?xml version="1.0"?>
<configuration>
<configSections>
<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net" />
</configSections>
<log4net>
<root>
<priority value="ALL" />
<appender-ref ref="TraceAppender" />
<appender-ref ref="ConsoleAppender" />
<!-- <appender-ref ref="FileAppender" /> -->
</root>

<appender name="TraceAppender" type="log4net.Appender.TraceAppender">
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" />
</layout>
</appender>

<appender name="ConsoleAppender" type="log4net.Appender.ConsoleAppender">
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" />
</layout>
</appender>

<!-- <appender name="FileAppender" type="log4net.Appender.FileAppender">
<file value="c:\\Log\\log-file.txt" />
<appendToFile value="true" />
<lockingModel type="log4net.Appender.FileAppender+MinimalLock" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" />
</layout>
</appender> -->
</log4net>
<connectionStrings>
<add name="Bvc5Database" connectionString="SWD13=.\SQLEXPRESS;database=Bvc5;uid=****************;pwd=***************;
Moderator: Do not post your database connection strings in the forum. It's a really bad idea.
</connectionStrings>
<system.web>
<!--
Set compilation debug="true" to insert debugging
symbols into the compiled page. Because this
affects performance, set this value to true only
during development.

Visual Basic options:
Set strict="true" to disallow all data type conversions
where data loss can occur.
Set explicit="true" to force declaration of all variables.
-->
<compilation debug="false" strict="true" explicit="true">
<assemblies>
<add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
</assemblies>
</compilation>

<pages theme="StoreWideSettings">
<namespaces>
<clear/>
<add namespace="System"/>
<add namespace="System.Collections"/>
<add namespace="System.Collections.Specialized"/>
<add namespace="System.Configuration"/>
<add namespace="System.Text"/>
<add namespace="System.Text.RegularExpressions"/>
<add namespace="System.Web"/>
<add namespace="System.Web.Caching"/>
<add namespace="System.Web.SessionState"/>
<add namespace="System.Web.Security"/>
<add namespace="System.Web.Profile"/>
<add namespace="System.Web.UI"/>
<add namespace="System.Web.UI.WebControls"/>
<add namespace="System.Web.UI.WebControls.WebParts"/>
<add namespace="System.Web.UI.HtmlControls"/>
</namespaces>
<controls>
<add namespace="BVSoftware.Bvc5.Core.Controls" tagPrefix="bvc5" assembly="BVSoftware.Bvc5.Core" />
</controls>
</pages>
<authentication mode="Windows"/>
<!--
The <customErrors> section enables configuration
of what to do if/when an unhandled error occurs
during the execution of a request. Specifically,
it enables developers to configure html error pages
to be displayed in place of a error stack trace .

<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>
-->
<httpModules>
<add type="BVSoftware.Bvc5.Core.Utilities.LoginPersister, BVSoftware.Bvc5.Core" name="LoginPersister"/>
<add type="BVSoftware.Bvc5.Core.Utilities.UrlRewriter, BVSoftware.Bvc5.Core" name="UrlRewriter" />
</httpModules>
</system.web>
</configuration>[b]
emunah
#24 Posted : Monday, March 10, 2008 12:49:05 PM(UTC)
emunah

Rank: Member

Joined: 2/25/2008(UTC)
Posts: 111

Now I get this message



<H1>Server Error in '/bvc5' Application.
<HR width="100%" color=silver SIZE=1>
</H1>
<H2>Cannot find table 0. </H2>
[color=#ffffcc>

[tr ][td ]<CODE>
Line]Line 50: ' Find Categories to Display in Menu
<FONT color=red>Line 51: Dim categories As Collection(Of Catalog.Category) = Catalog.Category.FindMenuCategories()
[/color]Line 52:
Line 53: ' Limit number of links</PRE>[/code][/td][/tr]</TABLE>
<B>[color=#ffffcc>

[tr ][td ]<CODE>
[IndexOutOfRangeException:] System.Data.DataTableCollection.get_Item(Int32 index) +60
BVSoftware.Bvc5.Core.Catalog.Mapper.FindMenuCategories() +134
BVSoftware.Bvc5.Core.Catalog.Category.FindMenuCategories() +5
BVModules_Controls_MainMenu.LoadMenu() in c:\inetpub\wwwroot\BV Commerce 5\BVModules\Controls\MainMenu.ascx.vb:51
BVModules_Controls_MainMenu.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\BV Commerce 5\BVModules\Controls\MainMenu.ascx.vb:44
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
</PRE>[/code][/td][/tr]</TABLE>
[/color]
Andy Miller
#25 Posted : Monday, March 10, 2008 2:47:33 PM(UTC)
Andy Miller

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 2,136

Was thanked: 1 time(s) in 1 post(s)
This is a database error. Either BVC5 cannot connect to the database or the database is missing a resource (table, sproc, ...).
Andy Miller
Structured Solutions

Shipper 3 - High Velocity Shipment Processing
emunah
#26 Posted : Monday, March 10, 2008 3:51:17 PM(UTC)
emunah

Rank: Member

Joined: 2/25/2008(UTC)
Posts: 111

what resource? How do I fix it
emunah
#27 Posted : Monday, March 10, 2008 4:28:20 PM(UTC)
emunah

Rank: Member

Joined: 2/25/2008(UTC)
Posts: 111

how do I fix that?
Andy Miller
#28 Posted : Monday, March 10, 2008 4:33:53 PM(UTC)
Andy Miller

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 2,136

Was thanked: 1 time(s) in 1 post(s)
I'm sorry I wasn't clear. When I wrote, "missing a resource (table, sproc, ...)", I meant that a table, stored procedure or some other part of the database is missing.

I don't think you can fix it. For some reason BV Manager did not create a working configuration for you--or it did and you changed it. Either way you don't appear to know enough about databases and ASP.NET to solve the problems. I think you should hire someone to come install it for you.

For a point of reference, I have used BV Manager to install a couple dozen websites. I only had a problem one time and that was because I entered the wrong database credentials. Every other time, it has worked flawlessly and the site is up and running in less than 1 minute. I don't know what other people have experienced, but it is probably similar.
Andy Miller
Structured Solutions

Shipper 3 - High Velocity Shipment Processing
emunah
#29 Posted : Monday, March 10, 2008 4:46:35 PM(UTC)
emunah

Rank: Member

Joined: 2/25/2008(UTC)
Posts: 111

I know alot about databases, I guess my question is this. Should we stop trying to install a test site on the pc and just put it on the server. It seems there are too many problems with a local site and noone has any problems when running it on the server, is that correct?
Cliff
#30 Posted : Monday, March 10, 2008 7:53:28 PM(UTC)
Cliff

Rank: Member

Joined: 5/24/2004(UTC)
Posts: 4,147

I wouldn't say that's correct, no. There will be just as many problems if your server environment is set up as incorrectly as your local environment.

I still haven't seen how your local environment is set up. Without that information, exactly as you have it set up, I don't think you'll be able to get much help.

1. What version of Windows?
2. What version of IIS?
3. You're using either SQL 2005 Express or SQL Server 2005?
4. You can log into SQL Express with a user/pass using SQL Server Authentication (not Windows Authentication) via SQL Server Management Studio?
5. You can see tables and stored procs in the database you've created?

That might be a start.
birdsafe
#31 Posted : Monday, March 10, 2008 8:00:35 PM(UTC)
birdsafe

Rank: Member

Joined: 2/21/2007(UTC)
Posts: 1,113

Part of the issue may be that if you are trying to set up on your local PC, if I remember correctly, you must set up SQL Server (or Server Express) FIRST before installing BV. I do'nt think you can run BV Manager and then install SQL Server Express to manage the database. So you may want to delete everything and start in that order.
Andy Miller
#32 Posted : Monday, March 10, 2008 8:00:58 PM(UTC)
Andy Miller

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 2,136

Was thanked: 1 time(s) in 1 post(s)
Originally Posted by: "emunah" Go to Quoted Post

Should we stop trying to install a test site on the pc and just put it on the server. It seems there are too many problems with a local site and noone has any problems when running it on the server, is that correct?

I agree there are problems with your local site. But that appears to be an isolated issue. I've never had an issue with a local site.

That aside, you may have better luck with a new install in a new environment. Go for it!
Andy Miller
Structured Solutions

Shipper 3 - High Velocity Shipment Processing
[email protected]
#33 Posted : Monday, March 10, 2008 8:51:34 PM(UTC)
sales@rudystoys.com

Rank: Member

Joined: 11/13/2004(UTC)
Posts: 189

Suggestion $.02:
At this point I think you have some of the most helpful and most knowledgeable BV Forums contributors helping you...
ie: Cliff, Andy,Joe Arbogast and more..
Suggest you contact a BV provider to help you get set up so you "Sit back and Sell"
I use Resposio.com to do this for me so I can "Sell"
They work for you!
my $.02
emunah
#34 Posted : Tuesday, March 11, 2008 8:26:38 AM(UTC)
emunah

Rank: Member

Joined: 2/25/2008(UTC)
Posts: 111

One important aspect I did not bring up, First I can view all of the tables in sql express 2005. The problem is this, when I run bv commerce and try to create a new site and pick sql login, I put in my user id and password and hit start nothing happens, nothing is generated, the only way I can generate a new store is through integrated security, that is why I have to change the web config file. That is also probably why there is something missing from the database. IIS is configured correctly running asp 2.0, sql is configured correctly, why won't it start when i use sql login?
Marcus
#35 Posted : Tuesday, March 11, 2008 9:40:41 AM(UTC)
Marcus

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 1,786

At this point we've sent you step by step instructions on how to setup everything including "click here, then here, etc." Since you are unable to get things working I would highly recommend following Andy's advice and hiring someone to setup the site for you.
emunah
#36 Posted : Tuesday, March 11, 2008 9:47:29 AM(UTC)
emunah

Rank: Member

Joined: 2/25/2008(UTC)
Posts: 111

Why won't it start in sql mode marcus? Should wee just install express on the server and forget about the pc site? We are not going to hire someone to create a site what about an engineer looking at it?
Andy Miller
#37 Posted : Tuesday, March 11, 2008 9:48:32 AM(UTC)
Andy Miller

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 2,136

Was thanked: 1 time(s) in 1 post(s)
When you create an SQL Server instance (such as when you install SQL Express), you can pick the supported authentication methods. You can choose between Windows Integrated Security, SQL Login, or both. The SQL Express installer defaults to Windows Integrated Security only. Try re-installing SQL Express with support for SQL Login or both SQL Login and Windows Integrated Security.

Note that I'm talking about SQL Server (Express) here, not BVC5.

After you re-install SQL with the SQL Login feature enabled, you should be able to use your SQL login credentials when you create a site using BV Manager.
Andy Miller
Structured Solutions

Shipper 3 - High Velocity Shipment Processing
emunah
#38 Posted : Tuesday, March 11, 2008 9:58:43 AM(UTC)
emunah

Rank: Member

Joined: 2/25/2008(UTC)
Posts: 111

Andy thanks, I will try that, I configured express for sql and windows already but i will uninstall it and give it a try
Andy Miller
#39 Posted : Tuesday, March 11, 2008 10:01:43 AM(UTC)
Andy Miller

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 2,136

Was thanked: 1 time(s) in 1 post(s)
If it still does not work, then write your own small ASP.NET site that connects to the database, retrieves some data, and displays it on a page. I find it much easier to troubleshoot my own code, since I know the assumptions that I'm making. Perhaps you will too.
Andy Miller
Structured Solutions

Shipper 3 - High Velocity Shipment Processing
emunah
#40 Posted : Tuesday, March 11, 2008 11:43:33 AM(UTC)
emunah

Rank: Member

Joined: 2/25/2008(UTC)
Posts: 111

Now when I hit start I get the message "unable to create database contact your sql administrator for assistance"

Any suggestions?
3 Pages<123>
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

©2024 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012