Rank: Member
Joined: 9/13/2008(UTC)
Posts: 9
|
I've decided to use BV Commerce for a client of mine and downloaded the trail to play around with.
However I've run site manager successfully and tried to open the localhost site. error straight away.
Cannot find table 0.
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.IndexOutOfRangeException: Cannot find table 0.
Source Error:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Line 12: If Not Page.IsPostBack Then
Line 13: [blue] lnkHome.Text = Content.SiteTerms.GetTerm("Home")[/blue]
Line 14: lnkHome.ToolTip = Content.SiteTerms.GetTerm("Home")
This is not a good start and hope this is not a sign of things to come......
Any Ideas ?
Thanks
Vinny
|
|
|
|
|
|
Rank: Member
Joined: 8/1/2007(UTC)
Posts: 310
|
Hello Vinny,
Help me understand the situation better:
1. Is your site available on the internet?
2. Or is it on your local server?
3. Have you tried any other pages? Do all of them fail with the same error.
Please advise. |
Thanks,
Satya
support @ bayquel.net
Work: +1 803 883 3226 |
|
|
|
|
|
Rank: Member
Joined: 9/13/2008(UTC)
Posts: 9
|
Hi Satya,
My demo site is on my local server. I've tried http://localhost/bvc5/ and http://localhost/bvc5/BVAdmin/Login.aspx?ReturnUrl=%2fbvc5%2fbvadmin%2fdefault.aspx
both have the same error.
Don't know where to go next :-(
btw thanks for a reply.
Vinny
|
|
|
|
|
|
Rank: Member
Joined: 8/1/2007(UTC)
Posts: 310
|
Try the following admin URL: http://localhost/bvc5/cart.aspx or http://localhost/bvc5/search.aspx
Let me know if both of them fail.
It looks like a database issue. Can you please check the database connection string in the web.config file? Validate that you are able to connect you local SQL Server with the IP, username and password specified. |
Thanks,
Satya
support @ bayquel.net
Work: +1 803 883 3226 |
|
|
|
|
|
Rank: Member
Joined: 9/13/2008(UTC)
Posts: 9
|
Both Dont work :-( web.config <connectionStrings> <add name="Bvc5Database" connectionString="Data Source=VINNY-PC\SQLEXPRESS;Initial Catalog=Bvc5;Integrated Security=True"/> </connectionStrings> Can connect via sql server management to database Any more ideas? thanks for your help so far. Vinny
|
|
|
|
|
|
Rank: Member
Joined: 8/1/2007(UTC)
Posts: 310
|
Please change your connection string to use SQL Authentication mode instead of Windows Authentication. Give it a try and see if that works. In SQL Authentication mode, your connection string will look as follows: <add name="Bvc5Database" connectionString="Data Source=VINNY-PC\SQLEXPRESS;Initial Catalog=Bvc5;User ID=sa;Password=passwordhere"/> Change the username and password appropriately. Let me know if that makes any difference. |
Thanks,
Satya
support @ bayquel.net
Work: +1 803 883 3226 |
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 2,136
Was thanked: 1 time(s) in 1 post(s)
|
Vinny, Satya is right. If the connection also fails with the sa account, then it is likely that you disabled SQL Authentication when you installed SQL Server. This article shows how to enable SQL Authentication and enable the sa account, http://msdn.microsoft.com/en-us/library/ms188670(SQL.90).aspx |
|
|
|
|
|
|
Rank: Member
Joined: 9/13/2008(UTC)
Posts: 9
|
Finally some results.........
We're one step further now. Thanks Satya
Get the following error now.
Server Error in '/bvc5' Application.
Object reference not set to an instance of an object.
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.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[NullReferenceException: Object reference not set to an instance of an object.]
BVSoftware.Bvc5.Core.Utilities.UrlRewriter.RewritePath(HttpApplication& app, Uri sourceUrl) +311
BVSoftware.Bvc5.Core.Utilities.UrlRewriter.app_BeginRequest(Object sender, EventArgs e) +69
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
|
|
|
|
|
|
Rank: Member
Joined: 8/1/2007(UTC)
Posts: 310
|
Hey Vinny, You still are not able to connect to the database. Hence the problem. This knowledge base article should help: Why do I get an error when my store starts?Best way to validate would be to open up SQL Server Management Studio and specify the exact same details to make the connection as what you specified in the web.config file. |
Thanks,
Satya
support @ bayquel.net
Work: +1 803 883 3226 |
|
|
|
|
|
Rank: Member
Joined: 9/13/2008(UTC)
Posts: 9
|
Satya,
You're a star man.
Took me a while but managed to get it to work. It was the credentials as suspected by yourselve.
I tried using the connection details while loading sql server management studio and it didnt work.
Created new user, that didnt work either.
then realised it was setup for windows authentication only (Needed sql authentication set). Fixed that , rebooted machine for service to pickup new option and walaaaa it worked.
thanks for you help. No doubt I'll be on here a lot while trying to get my head around the demo.
Vinny
|
|
|
|
|
|
Rank: Member
Joined: 8/1/2007(UTC)
Posts: 310
|
Thanks Vinny. Hope all goes well. |
Thanks,
Satya
support @ bayquel.net
Work: +1 803 883 3226 |
|
|
|
|
|
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.