Cause: 

This issue will occur if you already attempted to migrate your Sqlite database to Maria DB before (upgrading 2.2.1~2 to 2.3) and then you tried to upgrade your database again. 



Symptom: 

No data is migrated when you upgrade to BioStar 2.3 

table.PNG



Solution: 

You will have to manually delete a row and a table in the database. 


1. Open your biostar2 database with a database management tool like SQLite Expert

- database is located in C:\Program Files (x86)\BioStar 2\db


2. Run the query below 

DELETE FROM T_SYSCFG WHERE SYSCFGUID = 999999


3. In the same Windows explorer directory, open biostar2.db.log.bk

- change file type to All files 


4. Run the query below

DROP TABLE T_SYSCFG_LOG;

bk_drop.PNG


5. Upgrade to BioStar 2.3