SQL database does not contain all the tables- Invalid object

dyoder · Post by **dyoder** » Wed Oct 03, 2007 12:51 pm

i am getting an error: Invalid object name 'ac_AuditEvents'.

[SqlException (0x80131904): Invalid object name 'ac_AuditEvents'.]

looking at the database i do not see a table with this name.

I installed on SQL 2000. i did not use the sql express MDF.

Post by **Shopping Cart Admin** » Wed Oct 03, 2007 1:59 pm

Hello,

You will need to do a new install. Is there anything else you can report about how this happened. This is the first I've seen of this issue.

dyoder · Post by **dyoder** » Wed Oct 03, 2007 2:22 pm

i created the database in SQL first
setup the user
when the database was initilizing there where x and o accross the screen
it seems maybe those were passed/failed?

I loaded the 2005 mdf and changed the confing string manually and have the site running now.

also what is the default admin login?

Post by **Shopping Cart Admin** » Wed Oct 03, 2007 2:26 pm

Hello,

Glad you got it up and running. The username and password were set by you during the installation process.

Post by **Logan Rhodehamel** » Wed Oct 03, 2007 3:59 pm

Yes, "x" means something went wrong. I realize this is not enough information to troubleshoot, so for Beta 2 I have amended the installation process. If there are errors during the database creation, it will display them. That will allow us to solve and / or work around them when they arise in the future.

Unfortunately this doesn't help the install that you have. Common troubles are if you select the wrong database type from the drop down, or if you provided a user without permission to create tables.