need help ugrading 1.9 to 2.0

i need help upgrading because whatever i do is not working.

When i try and run the upgrade script over the database i get this error.

Setup failed: System.Data.Entity.Infrastructure.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'Rtl', table 'test2-5.dbo.Language'; column does not allow nulls. INSERT fails. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) --- End of inner exception stack trace --- at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache) at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at System.Data.Entity.Internal.InternalContext.SaveChanges() --- End of inner exception stack trace --- at System.Data.Entity.Internal.InternalContext.SaveChanges() at System.Data.Entity.Internal.LazyInternalContext.SaveChanges() at System.Data.Entity.DbContext.SaveChanges() at Nop.Data.EfRepository`1.Insert(T entity) in C:\inetpub\wwwroot\nop 2.0\Libraries\Nop.Data\EfRepository.cs:line 37 at Nop.Services.Installation.InstallationService.InstallLanguagesAndResources() in C:\inetpub\wwwroot\nop 2.0\Libraries\Nop.Services\Installation\InstallationService.cs:line 443 at Nop.Services.Installation.InstallationService.InstallData(String defaultUserEmail, String defaultUserPassword, Boolean installSampleData) in C:\inetpub\wwwroot\nop 2.0\Libraries\Nop.Services\Installation\InstallationService.cs:line 9049 at Nop.Web.Controllers.InstallController.Index(InstallModel model) in C:\inetpub\wwwroot\nop 2.0\Presentation\Nop.Web\Controllers\InstallController.cs:line 378

website works fine in 1.9 the transfer to 2.0 has been a nightmare

RE:  "...Cannot insert the value NULL into column 'Rtl', table 'test2-5.dbo.Language'; column does not allow nulls."

"Rtl" (right-to-left) was not added until upgrade from 2.10 to 2.20

If you are upgrading from 1.9 to 2.x, then you need to be sure to run ALL the upgrade scripts for each successive 2.x in sequence.  (e.g.  1.90-2.0, 2.0-2.10, etc.)

thanks for everyones help. website is nearly done.

would be happy to discuss upgrade problems if i can help