Rank: Member
Joined: 11/6/2003(UTC) Posts: 1,903
|
That error is from still not being able to connect to the DB. |
Noah |
|
|
|
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. |
|
|
|
|
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]
|
|
|
|
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]
|
|
|
|
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, ...). |
|
|
|
|
Rank: Member
Joined: 2/25/2008(UTC) Posts: 111
|
what resource? How do I fix it
|
|
|
|
Rank: Member
Joined: 2/25/2008(UTC) Posts: 111
|
|
|
|
|
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. |
|
|
|
|
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?
|
|
|
|
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. |
|
|
|
|
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. |
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC) Posts: 2,136
Was thanked: 1 time(s) in 1 post(s)
|
Originally Posted by: "emunah" 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! |
|
|
|
|
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 |
|
|
|
|
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?
|
|
|
|
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.
|
|
|
|
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?
|
|
|
|
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. |
|
|
|
|
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
|
|
|
|
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. |
|
|
|
|
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?
|
|
|
|
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.