Installing ConceptNet

Asked by Charbel

Hello,
I tried to install ConceptNet by downloading ConceptNet-4.0b5.tar.gz and
http://conceptnet.media.mit.edu/dist/ConceptNet-sqlite.tar.gz
but when I run it I am getting this error about a missing column in the database
no such column: assertions.best_raw_id.

Both download links were obtained from the Installation Documenation on the csc.media.mit.edu/docs/conceptnet

Where can I find a compatible database with ConceptNet-4.0b5?

Thanks,
Charbel

Question information

Language:
English Edit question
Status:
Solved
For:
ConceptNet Edit question
Assignee:
No assignee Edit question
Solved by:
Rob Speer
Solved:
Last query:
Last reply:
Revision history for this message
Best Rob Speer (rspeer) said :
#1

Unfortunately, 4.0b5 depends on a couple of changes in the database, which don't appear in the sqlite database. Making a new sqlite export takes a while (though we hope to have one by the beginning of next week).

If you want to make the PostgreSQL version work, you can get it from http://conceptnet.media.mit.edu/dist/ConceptNet-2009-08-26.psql.gz.

With the SQLite version, assuming you don't need the caching data that appears in best_raw_id, best_surface1_id, best_surface2_id, and best_frame_id, you can simply delete those columns from the code (lines 789-792 of csc/conceptnet4/models.py).

Revision history for this message
Charbel (charbel-k) said :
#2

Thanks Rob Speer, that solved my question.