I am testing openLCA v1.2. Upon opening connecting my local database, I was prompted to update an existing database to the new format. I initiated the update but it stopped and closed the popup window halfway through the process. Now this database cannot be opened in openLCA v1.1 or openLCA v1.2. Repeating the update process is not effective.
Attached is a screenshot of the files in \OpenLCA\openlca_bin_15Jan2010\workspace\data\myLCAdatabase after several attempts to update. It seems that the update process does not reach certain files in that data folder, as evidenced by some files being modified at the time of update and others being ignored during the last update attempt at 3.47pm.
I have a backup of the database in question, but cannot work in openLCA v1.2 until I am able to import it.
Any thoughts?
Database Update Problems
Database Update Problems
- Attachments
-
- openlca database update failure
- openlcaupdatefail.JPG (112.7 KiB) Viewed 14968 times
Re: Database Update Problems
Hi, this is indeed missing in the release candidate so far. It will be included in the next version. As workaround, you can update the database version with the sql script that I attach here. You will need the MySQL query browser to execute the sql script:
0 rename the attached txt file to sql (the board does not allow posting sql scripts)
1 start openLCA and the MySQL database (I used version openLCA 1.1 for this)
2 connect to the MySQL database with the MySQL query browser (same connection parameters as you usually use, so root / no passwd as default) 3 select "open sql script" from the file menu ...
4 select the database that you want to convert
5 ... and execute the script
0 rename the attached txt file to sql (the board does not allow posting sql scripts)
1 start openLCA and the MySQL database (I used version openLCA 1.1 for this)
2 connect to the MySQL database with the MySQL query browser (same connection parameters as you usually use, so root / no passwd as default) 3 select "open sql script" from the file menu ...
4 select the database that you want to convert
5 ... and execute the script
- Attachments
-
- updatev1.1.1-v1.2.txt
- rename to .sql and load in MySQL query browser
- (38.1 KiB) Downloaded 1012 times
Who is online
Users browsing this forum: No registered users and 39 guests