Page 1 of 1

New installation - Invalid object name 'ac_Stores'

Posted: Fri Jan 23, 2009 3:38 am
by europhile
Hi, checking out the software on standard Win2003 local dev machine - have got a 30 licence key (otherwise localhost:81 etc expires immediately), got over the unspecific API error from no ConnectionString, still no connection allowed (SQL Login yellow screen failure shown) so created a (full, not express) SQL2005 DB called AbleCommerce - but loading the site gives me Invalid object name 'ac_Stores' which indicates there's no tables in it, naturally.

That's not surprising, as no installation script created them - so how do I get back to that inistial config screen which after asking for the key should ask for the DB? If I can get back there (localhost:81 just gives error above), hopefully it will create all the DB objects needed (probably also creating the actual DB itself, hence the process going wrong).

Cheers, Phil.

Re: New installation - Invalid object name 'ac_Stores'

Posted: Fri Jan 23, 2009 6:42 am
by AbleMods
Welcome to the forums!

Instructions for installing the software should have been provided. If not, they are available on the AbleCommerce site from where you downloaded your software.

There are a few Microsoft extensions that will also need to be installed, so better make sure you've got those loaded up or you'll just hit another wall.

Installation can be executed by browsing to http://yourlocalhost/install/ once you've completed all the pre-installation steps.

Make sure you've got your SQL user permissions correct and Windows XP file permissions established for .Net applications. Windows XP handles inherited file permissions differently than NT-based systems - keep that in mind as you configure your local IIS web folder security.

Re: New installation - Invalid object name 'ac_Stores'

Posted: Fri Jan 23, 2009 6:44 am
by mazhar
Better try a clean re-install, Read the following installation guide
http://help.ablecommerce.com/installati ... sp.net.htm

Re: New installation - Invalid object name 'ac_Stores'

Posted: Fri Jan 23, 2009 1:15 pm
by europhile
Thanks guys! Yep, all prereqs loaded. It took me through the process, but I forgot about the /install bit, so that was the missing link, good one, will reread installation ;-) ! Good advice, best to reinstall, as it got unstuck. Have got NETWORK SERVICE granted access to SQL and physical directory too. Rerun... and all fine! Looks great!

Installed again onto dev Vista machine (Business version at least allows multiple Sites as opposed to XP Virtual Directories, so can use same localhost:81 licence on it!) and AOK - stumbled on error with System.Web.Extensions, Version=1.0.61025.0 because forgot that AJAX 1.0 wasn't installed on clean reinstall, even though .net 3.5 present, but installing that as per instruction did the trick, just remember to add /install when going through setup dialogue otherwise the base site asks for the licence but doesn't set up the DB. That's where i went wrong. Yes yes, back to RTFM...! Good it seems to work on Vista anyway.

So, glad to be here, cool looking ecommerce system so far, will give it the workout, am sure I will have more questions and experiences but hopefully not too painful! Thanks, Phil.

Re: New installation - Invalid object name 'ac_Stores'

Posted: Fri Jan 23, 2009 3:01 pm
by AbleMods
Glad to hear you've got it going.

AC7 is a great package. You'll find the code and system design are extremely well thought out. Feel free to drop a post in the forums if you run into other questions or issues.

Re: New installation - Invalid object name 'ac_Stores'

Posted: Mon Jan 26, 2009 9:21 am
by europhile
Cheers Joe! Can't see any way to mark a thread as resolved or closed so will leave it, although that must make it awkward for hardcore 'resolvers' to check open posts as opposed to active. I appreciate it's not a guaranteed answer forum though - still, certainly better than most, will be working though it! Phil.