Installation...

Hi all,

I'm trying to install Nopcommerce 1.9 for the first time; but lots of problems happening. I'm using Microsoft Webmatrix which automatically deploys V1.9.

everything is going well excep I received the message :
----------
Upgrade script from your version is not available
----------
when installing database. I add a connectionstring to connection.strings file.

<add name="NopSqlConnection" connectionString="Data Source=XXX;Initial Catalog=XXX;Integrated Security=False;Persist Security Info=False;User ID=nopcommerce1;Password='XXX';Connect Timeout=120"/>
then I get following error:
----------
Invalid object name 'dbo.Nop_Setting'.

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'dbo.Nop_Setting'.

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:


[SqlException (0x80131904): Invalid object name 'dbo.Nop_Setting'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2062078
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5050204
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
   System.Data.SqlClient.SqlDataReader.get_MetaData() +86
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
   System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) +443




----------

I searched nopcommerce forums for error, but it seems posts are from long ago, besides these two problems are reviewed separately, regardless of the fact that one generates other in my case.

Please help me overcome this.Thanks,

I've got the same error too when trying to install this product for the first time.

This exception occur when the system tries to insert sample record in the table. Unfortunately, for me, the tables are not created at all during setup process.

After this error occur the first time, I manuelly created the Setting table.
Then relaunch the install process.

The error was then going on MeasureDimension table ...

Don't know why tables are not created , and I'm still looking for ...
I think it would be great to have a create database script included in the installation package.

Regards