BV Commerce Forum
»
BV Commerce Support
»
General Support
»
I get this error when opening the store.. Cannot find table 0
Rank: Member
Joined: 3/16/2007(UTC)
Posts: 3
|
Originally Posted by: "Somebody"  Cannot find table 0 I get the above error when I open the store url. There was no error at all when installation. The process finished smoothly but when I went to open the store url it showed the above error.
|
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
I had that after initial install too -- the application could not find the database -- make sure your database string is correct |
|
|
|
|
|
|
Rank: Member
Joined: 9/5/2006(UTC)
Posts: 10
|
I had to rebuild my web server and re install BV 5 and it's just like you said. The install went well with no errors and after I login I get the same error as you. Cannot find table 0. If someone has found a fix for this please let us know.
|
|
|
|
|
|
Rank: Member
Joined: 11/6/2003(UTC)
Posts: 1,903
|
If the pre-requisites are installed on the machine, there should be no rebuilding needed.
The error from above is usually permissions in the DB or problem with the connection string. |
Noah |
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
This is usually caused when your SQL user account does not have the correct permissions to execute stored procedures. In most cases this can be fixed by removing the SQL user account from the BVC 5 database and then assigning it again using the "User Mapping" property panel in SQL Management Studio. The easiest way to test is to assign the SQL user to the db_owner permission which quickly gives that user account full control of the database. Then restart your BV site and see if the error is gone.
You should consult with a SQL database admin about the best permissions for your user account once you're ready to go live. In most cases db_owner is overkill and fewer permissions should be used.
|
|
|
|
|
|
Rank: Member
Joined: 3/16/2007(UTC)
Posts: 3
|
Thanks for all your answers
Marcus was correct
I created the first store (the store which showed the error) using windows authentication and so I guess that user did not have the necessary permissions
I created the second store using sql authentication namely the user "sa" and everything worked perfect. But "sa" is overkill and I need to create a new user with reduced permissions.
|
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
Are you on localhost? I installed my store locally and had to do the same thing -- user "sa" -- but I'm assuming I can change that when I go live |
|
|
|
|
|
|
Rank: Member
Joined: 9/5/2006(UTC)
Posts: 10
|
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Verdana">You are correct! I found the SQL connection string and it had my original SA password. I had to rebuild a new web server and copy over my web site directory from a backup and restore the SQL backup copy. The connection string had the original password. I simply typed in the new password and it worked. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Verdana"> <o:p></o:p>
<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Verdana">PS. if anyone else has to rebuild their web server, you will have to re install your SSL Certificates. <o:p></o:p>
|
|
|
|
|
|
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.