Paper2 Library Sharing problem.

-

When you share Paper2's database folders, you may get following error message.



This is happened by accessing database file at the same time from several computers. I fixed this problem using "sqllite" to create a new database file.

Follow instructions shows how to create new paper database from the corrupted database file.



1. Download SQLLITE binary file. 
(http://www.sqlite.org/download.html)


2. Run terminal

3. Run following command in the terminal
     teminal > sqlite3 Database.papersdb
    //next command is check your database, if your database has a problem, errors occur.
    sqllite3 > pragma integrity_check;
     // If you get no error message, Paper2 running problem is not the database problem.
     //Next command is create new database.
    terminal >  echo .dump | sqlite3 Database.papersdb >  DatabaseNew.papersdb.sql 
    terminal >  sqlite3.exe -init DatabaseNew.papersdb.sql  DatabaseNew.papersdb
    //change DatabaseNew.papersdb to Database.papersdb, Before changing, backup your original Database.papersdb. Because there are possibly to loss some records.
    terminal > cp  Database.papersdb DatabaseBackup.papersdb
    terminal > cp  DatabaseNew.papersdb Database.papersdb
    


댓글

댓글 쓰기

이 블로그의 인기 게시물

Install NS2.35 to Mac OS(Lion)

-
You have experienced otcl compile failures when you install all-in-one package to your mac. (Like this :  Undefined symbols for architecture x86_64) I find a way to install ns-2.35 version to mac OS (Lion 64bit). You needs tcl8.5.11, tk8.5.11, tclcl-1.20, otcl-1.14, and ns-2.35. You can get files via "http://www.isi.edu/nsnam/ns/ns-build.html" I assume that your folder locate in /Users/kwangjo/Documents/ns Open terminal and goto the folder. ! You should install Xcode before doing follow instruction. 1. Change superuser mode sudo su tar xvfz "PACKAGES" 2. compile tcl8.5.11 cd /Users/kwangjo/Documents/ns/tcl8.5.11 cd unix ./configure --enable-framework --enable-64bit make make test ## you should pass all test. make install 3. compile tk8.5.11 cd /Users/kwangjo/Documents/ns/tk8.5.11 ./configure --enable-framework --enable-64bit make make install 4. compile otcl-1.14 ! Before compile, you should make library link and include link. l...
자세한 내용 보기

New power saving mode in android M.

-
Android M adds powerful battery managing modes. One is doze and the other is app stand by. Today google Korea campus, there is conference about these two modes. I write summary about the conference meeting. Mr yang and many other company people are participated in. Because M source code is not released yet, we just talk and sharing testing results about these two modes. So following question (other company people) and answer (Mr yang from google) may have wrong informations. So, testing your application using adb commend. Some pending events will occurs malfunction to your applications. Q&A 1. What is doze mode?  - Doze mode aim is for saving battery when user does not move their device for a long time. For example, if user forget to charging the phone, and slept. The phone turn to doze mode until wake up at the morning.  In the doze mode, whole app does not working at all. (some hardware interrupt and google play service can working even it is doze mode.) ...
자세한 내용 보기

Test DHT11 and SEN0018 raspberry

-
이미지
Actually I am not familiar with hardware, so I bought sensors which are already output the digital signal. Follow pictures are DHT11 and SEN0018. The first one DHT11 can collect humanity and degree information. The second one SEN0018 can collect movement human body using ultra ray. <Front of SEN0018> <Back of SEN0018> <Front of DHT11>  <Back of DHT11> I connect these sensor's signal line to GPIO G04 (DHT11) and G18(SEN0018).  DHT11 needs 3V input and SEN0017 needs 5V input. The connection is done like following pictures. <Raspberry PI> <Connection Setup> Following is DHT11 test code which can easily getting from web site. For example "http://www.uugear.com/portfolio/dht11-humidity-temperature-sensor-module/". And Following code for SEN0018 codes which is made by me. I cannot find any open source code for SEN0018. So I make the code. Each of codes are works fine. Data not good...
자세한 내용 보기