emreeren / SambaPOS-3

Touch Screen Restaurant POS
sambapos.com
466 stars 412 forks source link

Upgrade from 3.0.3 to 3.0.4 or later causes crash on program launch. #370

Closed QMcKay closed 11 years ago

QMcKay commented 11 years ago

Crash details sent through the exception interface. Reinstall of 3.0.3 seems to work and all data is retained (MSSQL express R2 x64 on Windows 7).

Hopefully I don't need to re-enter all data in order to upgrade to later releases?

JohnSCS commented 11 years ago

There has been large changes to the database with the earlier versions. Maybe the gap in versions is too large. For a quick fix, update version by version until you get to 15. In fact I would update to 3.0.26.

But as alway make a backup of your database before your upgrade.

QMcKay commented 11 years ago

I tried to install v3.0.4 over v3.0.3, and it still crashes on program launch. Same error. Reinstall of v3.0.3 still works fine. Should I be uninstalling the previous version first, before install of a new version? Hasn't been necessary previously.

JohnSCS commented 11 years ago

Sounds like it's not updating the database. Which database are you using ? TX, CE or SQ

QMcKay commented 11 years ago

As mentioned in the original post, SQ (MS SQL Express 2008 R2 x64 on Windows 7 x64). Is there a possibility of an access/rights issue? Should I be checking the box to install sample data? I haven't bothered, since my DB is already set up and populated, and previous upgrades worked... I seem to be stuck using 3.0.3, but I really want to move on!

JohnSCS commented 11 years ago

And yes, try uninstalling 3.0.3 first.

JohnSCS commented 11 years ago

You don't need to install sample data. What version of .NET are you using?

emreeren commented 11 years ago

Can you post error message here?

QMcKay commented 11 years ago

@JohnSCS :: .NET Framework 4 Client Profile (4.0.30319)

@emreeren :: Below is the full error description. I click "Send" when I see this - does this reporting not work?

Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.

[General Info]

Application: SambaPOS Version: 3.04 BETA Region: en DB: SQ Machine: JVSERVER User: JVadmin Date: 2013-09-15 Time: 11:03 PM

User Explanation:

JVadmin said ""

[Exception Info 1]

Top-level Exception Type: System.Reflection.ReflectionTypeLoadException Message: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information. Source: mscorlib Stack Trace: at System.Reflection.RuntimeModule.GetTypes(RuntimeModule module) at System.Reflection.RuntimeModule.GetTypes() at System.Reflection.Assembly.GetTypes() at System.ComponentModel.Composition.Hosting.AssemblyCatalog.get_InnerCatalog() at System.ComponentModel.Composition.Hosting.AssemblyCatalog.get_Parts() at lambda_method(Closure , ComposablePartCatalog ) at System.Linq.Enumerable.d14`2.MoveNext() at System.Linq.Enumerable.d14`2.MoveNext() at Microsoft.Practices.Prism.MefExtensions.DefaultPrismServiceRegistrar.GetRequiredPrismPartsToRegister(AggregateCatalog aggregateCatalog) at Microsoft.Practices.Prism.MefExtensions.DefaultPrismServiceRegistrar.RegisterRequiredPrismServicesIfMissing(AggregateCatalog aggregateCatalog) at Microsoft.Practices.Prism.MefExtensions.MefBootstrapper.RegisterDefaultTypesIfMissing() at Microsoft.Practices.Prism.MefExtensions.MefBootstrapper.Run(Boolean runWithDefaultConfiguration) at Samba.Presentation.App.RunInReleaseMode()


[Assembly Info]

PresentationCore, Version=4.0.0.0 Microsoft.Practices.Prism, Version=4.0.0.0 WindowsBase, Version=4.0.0.0 mscorlib, Version=4.0.0.0 Samba.Infrastructure.Data, Version=1.0.0.0 PresentationFramework, Version=4.0.0.0 System.Xaml, Version=4.0.0.0 Samba.Presentation.Services, Version=1.0.0.0 Samba.Infrastructure, Version=1.0.0.0 FluentValidation, Version=3.4.0.0 Samba.Domain, Version=1.0.0.0 Samba.Services, Version=1.0.0.0 System, Version=4.0.0.0 Stateless, Version=1.0.0.0 System.Core, Version=4.0.0.0 System.Drawing, Version=4.0.0.0 System.Windows.Forms, Version=4.0.0.0 Samba.Localization, Version=1.0.0.0 Microsoft.Practices.ServiceLocation, Version=1.0.0.0 Samba.Persistance, Version=1.0.0.0 Microsoft.Practices.Prism.MefExtensions, Version=4.0.0.0 System.ComponentModel.Composition, Version=4.0.0.0 PropertyTools, Version=2012.4.14.1


[System Info]

Operating System -Microsoft Windows 7 Enterprise --CodeSet = 1252 --CSDVersion = Service Pack 1 --CurrentTimeZone = -360 --FreePhysicalMemory = 6670860 --OSArchitecture = 64-bit --OSLanguage = 1033 --ServicePackMajorVersion = 1 --ServicePackMinorVersion = 0 --Version = 6.1.7601

Machine -JVSERVER --Manufacturer = INTEL_ --Model = DH61WW__ --TotalPhysicalMemory = 8558923776 --UserName = JVserver\JVadmin


emreeren commented 11 years ago

Uninstall previous version and if any dll file remains in installation directory delete them.

QMcKay commented 11 years ago

Uninstalled 3.0.3 Installed 3.0.26b

Now I'm having trouble connecting to the DB. I should have save the config file I think. Where is the config file for the connection string?

"Can't connect to database with current setting. You can check and modify the connection string shown below. Error Message: An exception occurred while initializing the database. See the InnerException for details."

data source-localhost\SQLEXPRESS

"Please restart application. Current problem saved to the log file." where is the log file located?

Where is the config file for the connection string? Also, what is the syntax for connection string username/password?

emreeren commented 11 years ago

You can't directly upgrade from 3.03 to 3.0.26. Please try upgrading to 3.0.19 first and 3.0.26. 3.03 is a very old release so I can't remember if there is another needed upgrade between these. So If you receive an error please post it here.

Log file located in [MyDocuments]/SambaPOS3 folder.

JohnSCS commented 11 years ago

The SambaSettings.txt file could be in one of two locations. C:\ProgramData\Ozgu Tech\SambaPOS3 C:\Users{user profile}\AppData\Roaming\Ozgu Tech\SambaPOS3

data source=localhost\SQLEXPRESS; User Id=sa; Password=password Password is whatever you set when installing the SQL Database.

QMcKay commented 11 years ago

I installed/uninstalled every version I could find, until I reached 3.0.26b. I would launch/login/logout/exit with each version. No crashes so far. Happy to be running the latest!

Thank you both very much for your help!