search

Murali-group / GraphSpace

The interactive graph sharing website.
http://graphspace.org
GNU General Public License v2.0
30 stars 41 forks source link

Error on trying to start the GraphSpace server #333

Closed bruce-wayne99 closed 6 years ago

bruce-wayne99 commented 6 years ago

When I am trying to start the GraphSpace server sqlalchemy.exc.ProgrammingError occurred. Please Help. Screen shots of the error: hosting_error hosting_error2

jlaw9 commented 6 years ago

I also get this error when setting up the GraphSpace server locally. Try running this psql command to setup the extension, where username should be whatever username you setup the database with (in graphspace/settings/local.py)

sudo -u username psql -c "CREATE EXTENSION pg_trgm;"

Then if you get the error sqlalchemy data type character varying has no default operator class for access method "gin", like I did, the suggestion from here fixed it for me. You should be able to run their suggestion with something like this:

sudo -u username psql -c 'CREATE EXTENSION btree_gin;'
bruce-wayne99 commented 6 years ago

@jlaw9 Thanks for the help!! :)

tmmurali commented 6 years ago

@adbharadwaj @jlaw9 Shouldn't these commands be part of the installation instructions? Can an install script run these commands automatically?

adbharadwaj commented 6 years ago

@tmmurali it's hard to include these commands in a script because we username varies from user to user.

These commands are already documented as part of PostgreSQL Installation steps. This page is hyperlinked in the requirements section in README doc.

adbharadwaj commented 6 years ago

@bruce-wayne99 can you close the issue, if you were able to successfully install Graphspace locally.