First time here? Check out the FAQ!
2

Deploying to Heroku
 

I am trying to deploy askbot to Heroku and I am getting the following error when I run ./manage.py migrate:

Running migrations for askbot: - Migrating forwards to 0051proxifyqarevmodels.

askbot:0022initpostgresqlfulltext_search Traceback (most recent call last): django.db.utils.DatabaseError: must be owner of database qkdxugtyqz

When I contacted Heroku support they said this:

"Hi, it looks like you app is running

CREATE LANGUAGE plpgsql

which is restricted to superusers on the database - you will need to remove this from your migration."

Is there any way around this, or is deploying askbot to heroku not possible?

To enter a block of code:

  • enter empty line after your previous text
  • paste or type the code
  • select the code and press the button above
Preview: (hide)
rnschmidt's avatar
21
rnschmidt
asked 13 years ago

Comments

see more comments

2 Answers

1

Hello, that means you cannot use postgresql on heroku with askbot, try MySQL, but make sure to use MyISAM tables.

You can also use sqlite3 for the database.

To enter a block of code:

  • enter empty line after your previous text
  • paste or type the code
  • select the code and press the button above
Preview: (hide)
Evgeny's avatar
13.2k
Evgeny
answered 13 years ago
link

Comments

see more comments
1

It did work for me, but I had to comment the logging that goes into askbot.log

To enter a block of code:

  • enter empty line after your previous text
  • paste or type the code
  • select the code and press the button above
Preview: (hide)
ignacio_parada's avatar
11
ignacio_parada
answered 12 years ago
link

Comments

1

can you please create a separate post for - A step by step procedure for installing askbot(any issues if any) in Heroku? It will be very helpful for others. Thanks. :)

pajju's avatar pajju (12 years ago)
see more comments